SAP Table TBP1C

Budget/Plan Profile

TBP1C (Budget/Plan Profile) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TBP1C to other SAP tables.

TBP1C table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PROFIL Profile BP_PROFIL CHAR 6 0
APPLIK Application BP_APPLIK CHAR 1 0
A Cash budget management
B Event management
C Cost centers
F CO production order
I Investment Programs
M Funds Management
O CO orders
P Project
Q Appropriation requests
WRTTP Value Type CO_WRTTP CHAR 2 0
01 Plan
02 Plan: Splitting Among Activity Types
03 Actual: Splitting Among Activity Types
04 Actual
05 Target
06 Target (WIP)
07 Target: Splitting Among Activity Types
08 Plan: Correction for Internal Bus.Vol Between Cost Centers
09 Actual: Correction for IBV Between Cost Centers
10 Statistical Plan
11 Statistical Actual
12 Down Payment as Operating Expense
13 Statistical Down Payments as Expense
19 Order Receipt/Orders Balance
21 Commitments from Purchase Requisition
22 Purchase Order Commitment
23 Reservation Commitment
24 Funds Commitment
25 Remainder from Apportioned Orders/Networks (Order Commitmts)
26 Commitments from Transfer Price Agreement
28 Value from Customer Quotation
29 Value from Sales Order
2A Funds Reservation
2B Funds Precommitment
30 Scrap
31 Variances
32 Results Analysis and WIP Calculation
33 Results Analysis: Credit Side/Debit Side
34 Results Analysis: Cost of Sales from Resource-Rel. Billing
35 Plan for True Investments
36 Budget for True Investments
37 Program Budget for True Investments
38 Program Plan for True Investments
39 Request Plan
40 Request Plan for True Investments
41 Budget
42 Assigned Budget
43 Payment Budget
44 Payment Budget: Assigned Funds
45 Payment budget: Releases
46 Cash Release
47 Program Budget
48 Program Plan
49 Planned Accrual Calculations: Results Analysis, WIP Calc.
4A Payment Budget: Statistical
4B Budget Balance
4C Payment Budget: Clear on Revenue Item
50 Purchase Requisitions
5A Payment Obligations from Purchasing Down Payments
51 Purchase Orders
52 Business Trip Commitments
53 User-Defined Payment Commitment (Financial Transaction 50)
54 Invoices
55 Bank clearings
56 User-Defined Payment Obligation (Financial Transaction 70)
57 Payments
58 Down Payment Requests
59 Down Payments for Bank Clearing
60 Parked Document
61 Down Payments
62 Planned Payments
6A Planned Down Payments
6B Clarification Worklist FI-CA
63 Down Payment Clearings
64 Funds Transfers
65 Funds Commitment
66 Profit Transfer Postings
67 Other Statistical Documents
68 Other Non-Statistical Document
69 Commitment Budget: Funds Reservations
70 Commitment Budget
71 Commitment Budget - Assigned Funds
72 Commitment Budget: Releases
73 Purchase Order: Cycle Counting Blocking Amount
74 Funds Reservation: Cycle Counting Blocking Amount
75 Commitment Budget: Funds Reservation Cycle Cntg Blckng Amt
76 Commitment Budget: Purchase Orders, Cycle Counting Blckg Amt
77 Commitment Budget: Purchase Orders
7C Commitment Budget: Expense Type Budget for Revenue Item
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation
85 Payment Budget: Reservations
86 Payment Budget: Earmarked Funds
87 Payment Budget: Reserved Releases
88 Payment Budget: Earmarked Releases
89 Commitment Budget: Reservations
90 Commitment Budget: Earmarked Funds
91 Commitment Budget: Reserved Releases
92 Commitment Budget: Earmarked Releases
93 Financial Budget
94 Payment Budget: Adjustment Field
95 Actual CO Postings
96 Purchase Order Overhead
97 Purchase Requisition Overhead
98 Funds Reservation (CO)
99 Financial Result
9A Financial Result: Statistical
9B Financial Budget: Statistical
9C Financial Budget Plan Balance
9D Funds Management: HR Integration
9E Approved Total Costs/Revenue
D1 Distribution of Actual Costs (By Source Assignment)
D2 Distribution of Commitments (By Source Assignment)
D3 Distribution of Work-in-Process (By Source Assignment)
D4 Distribution of Earned Value (By Source Assignment)
D5 Distribution of Payments (By Source Assignment)
D6 Distribution of Down Payments (By Source Assignment)
P1 Earned Value (Plan)
P2 Earned Value (Actual)
P3 Capitalized Remainder Costs
3C Control Costs
BPGE Planning/Budget Overall Values BP_BPGE CHAR 1 0
X Yes
NULL No
BPJA Planning/budget annual values BP_BPJA CHAR 1 0
X Yes
NULL No
BPPE Planning/budget period values BP_BPPE CHAR 1 0
X Yes
NULL No
AVA_ALL Availability control against overall value BP_AVA_ALL CHAR 1 0
X Yes
NULL No
Y_FUTURE Future timeframe allowed BP_FUTURE INT1 3 0
Y_PAST Timeframe allowed in the past BP_PAST INT1 3 0
Y_START Start planning/budgeting from current fiscal year BP_START INT1 3 0
SIGHT Data view BP_SIGHT NUMC 2 0
01 Distributed
02 Distributable
03 Cumulative
04 Remainder
05 Planned total
06 Previous year
07 Assigned
08 Costing
09 Cost element plan
10 Order/Network
11 Current budget
12 Release
14 Parked
15 Revenue elements
16 Available
17 Sales Order Value
18 Carryforward
19 Actuals
20 Commitments
21 Assigned
22 Total costs
23 Invest. costs
24 Billing plan
25 Revenue
30 HR Funds and Position Management
35 Current plan
SCALE Scaling factor SCALE_D NUMC 1 0
DECIM Number of Decimal Places DECIM CUKY 5 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
PLDAT Value Date for Currency Translation PLDAT DATS 8 0
PLSAV Save exchange rate type/value date BP_PLSAV CHAR 1 0
X Yes
NULL No
KLVAR Costing Variant CK_KLVAR TCK03 CHAR 4 0
PLELE Planning on planning elements only BP_PLELE CHAR 1 0
X Yes
NULL No
SPRED Distribution Key SPRED T821S CHAR 4 0
KAGRU_PRK Cost element group for primary costs KAGRU_PRK CHAR 15 0
KAGRU_LST Sender Activity Type Group SLGRU CHAR 15 0
KAGRU_SKZ Statistical key figure group STGRU CHAR 15 0
KAGRU_ERL Revenue cost element group KAGRU_ERL CHAR 15 0
RPLAN_KST Cost planning parameters RPLAN_KST T820 CHAR 8 0
RPLAN_ERL Revenue planning parameters RPLAN_ERL T820 CHAR 8 0
SKGRU Sender Cost Center Group SKGRU CHAR 15 0
RELE Availability control against releases BP_RELEASE CHAR 1 0
X Yes
NULL No
PRARTBU Program type for budgeting IM_PRARTBU TAI05 CHAR 4 0
BOTTOMUP Bottom-up planning in structure planning BP_BOTT_UP CHAR 1 0
X Yes
NULL No
AKT_ART Availability control activation type BP_AKT_ART CHAR 1 0
0 Cannot be activated
1 Automatic activation during budget allocation
2 Background activation
PROZBAT Usage in % for background activator BP_PROZBAT DEC 5 2
ERLART Revenue element for billing plan to WSB element PSFPERLART CHAR 10 0
FPART Billing/Invoicing Plan Type FPART TFPLA CHAR 2 0
CUROBJ Budgeting/Planning in the Object Currency BP_CUROBJ CHAR 1 0
X Yes
NULL No
CURTRA Budgeting/panning in any transaction currency BP_CURTRA CHAR 1 0
X Yes
NULL No
CURKOKR Budgeting/Planning in the Controlling Area Currency BP_CURKOKR CHAR 1 0
X Yes
NULL No
SDPLAN Transfer Plan Values from Sales Order PSSDPLAN CHAR 1 0
X Yes
NULL No
QUPLAN Transfer Plan Values from Quotation PSQUPLAN CHAR 1 0
X Yes
NULL No
AUTORELEASE Automatic Release FM_BK_AUTORELEASE CHAR 1 0
X Yes
NULL No
GBGRU Fund Group GBGRU CHAR 15 0
SGBGRU Sender Fund Group SGBGRU CHAR 15 0
FKGRU Functional Area Group FKGRU CHAR 15 0
SFKGRU Sender Function Group SFKGRU CHAR 15 0
FM_GRANT_GROUP Grant Group FM_GRANT_GROUP CHAR 15 0
FM_SGRANT_GROUP Sender Grant Group FM_SGRANT_GROUP CHAR 15 0
AVA Availability Control in Object Currency OBJ_AVA CHAR 1 0
X Yes
NULL No
OBJ Default Object Currency for Planning in Trans. Currency OBJ_DEF CHAR 1 0
X Yes
NULL No
CONV Currency Translation of Remainder OBJ_CONV CHAR 1 0
X Yes
NULL No
BUDGET_PD_GROUP Budget Period Group FM_BPD_GROUP CHAR 15 0
SBUDGET_PD_GROUP Sender Budget Period Group FM_SBPD_GROUP CHAR 15 0

TBP1C foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TBP1C FPART TBP1C MANDT TFPLA Billing Plan Type MANDT
TBP1C FPART TBP1C FPART TFPLA Billing Plan Type FPART
TBP1C KLVAR TBP1C MANDT TCK03 Costing Variants MANDT
TBP1C KLVAR TBP1C KLVAR TCK03 Costing Variants KLVAR
TBP1C KURST TBP1C KURST TCURV Exchange rate types for currency translation KURST
TBP1C KURST TBP1C MANDT TCURV Exchange rate types for currency translation MANDT
TBP1C MANDT TBP1C MANDT T000 Clients MANDT
TBP1C PRARTBU TBP1C MANDT TAI05 CI Program Types MANDT
TBP1C PRARTBU TBP1C PRARTBU TAI05 CI Program Types PRART
TBP1C RPLAN_ERL TBP1C RPLAN_ERL T820 Planning Parameters RPLAN
TBP1C RPLAN_ERL TBP1C MANDT T820 Planning Parameters MANDT
TBP1C RPLAN_KST TBP1C MANDT T820 Planning Parameters MANDT
TBP1C RPLAN_KST TBP1C RPLAN_KST T820 Planning Parameters RPLAN
TBP1C SPRED TBP1C MANDT T821S Distribution keys MANDT
TBP1C SPRED TBP1C SPRED T821S Distribution keys SPRED