Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

MANDT

Client

MANDT

T000

CLNT

PROFIL

Profile

BP_PROFIL

CHAR

APPLIK

Application

BP_APPLIK

CHAR

Value	Description
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

Value	Description
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

Value	Description
X	Yes
NULL	No

BPJA

Planning/budget annual values

BP_BPJA

CHAR

Value	Description
X	Yes
NULL	No

BPPE

Planning/budget period values

BP_BPPE

CHAR

Value	Description
X	Yes
NULL	No

AVA_ALL

Availability control against overall value

BP_AVA_ALL

CHAR

Value	Description
X	Yes
NULL	No

Y_FUTURE

Future timeframe allowed

BP_FUTURE

INT1

Y_PAST

Timeframe allowed in the past

BP_PAST

INT1

Y_START

Start planning/budgeting from current fiscal year

BP_START

INT1

SIGHT

Data view

BP_SIGHT

NUMC

Value	Description
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

DECIM

Number of Decimal Places

DECIM

CUKY

KURST

Exchange Rate Type

KURST

TCURV

CHAR

PLDAT

Value Date for Currency Translation

PLDAT

DATS

PLSAV

Save exchange rate type/value date

BP_PLSAV

CHAR

Value	Description
X	Yes
NULL	No

KLVAR

Costing Variant

CK_KLVAR

TCK03

CHAR

PLELE

Planning on planning elements only

BP_PLELE

CHAR

Value	Description
X	Yes
NULL	No

SPRED

Distribution Key

SPRED

T821S

CHAR

KAGRU_PRK

Cost element group for primary costs

KAGRU_PRK

CHAR

KAGRU_LST

Sender Activity Type Group

SLGRU

CHAR

KAGRU_SKZ

Statistical key figure group

STGRU

CHAR

KAGRU_ERL

Revenue cost element group

KAGRU_ERL

CHAR

RPLAN_KST

Cost planning parameters

RPLAN_KST

T820

CHAR

RPLAN_ERL

Revenue planning parameters

RPLAN_ERL

T820

CHAR

SKGRU

Sender Cost Center Group

SKGRU

CHAR

RELE

Availability control against releases

BP_RELEASE

CHAR

Value	Description
X	Yes
NULL	No

PRARTBU

Program type for budgeting

IM_PRARTBU

TAI05

CHAR

BOTTOMUP

Bottom-up planning in structure planning

BP_BOTT_UP

CHAR

Value	Description
X	Yes
NULL	No

AKT_ART

Availability control activation type

BP_AKT_ART

CHAR

Value	Description
NULL	Cannot be activated
1	Automatic activation during budget allocation
2	Background activation

PROZBAT

Usage in % for background activator

BP_PROZBAT

DEC

ERLART

Revenue element for billing plan to WSB element

PSFPERLART

CHAR

FPART

Billing/Invoicing Plan Type

FPART

TFPLA

CHAR

CUROBJ

Budgeting/Planning in the Object Currency

BP_CUROBJ

CHAR

Value	Description
X	Yes
NULL	No

CURTRA

Budgeting/panning in any transaction currency

BP_CURTRA

CHAR

Value	Description
X	Yes
NULL	No

CURKOKR

Budgeting/Planning in the Controlling Area Currency

BP_CURKOKR

CHAR

Value	Description
X	Yes
NULL	No

SDPLAN

Transfer Plan Values from Sales Order

PSSDPLAN

CHAR

Value	Description
X	Yes
NULL	No

QUPLAN

Transfer Plan Values from Quotation

PSQUPLAN

CHAR

Value	Description
X	Yes
NULL	No

AUTORELEASE

Automatic Release

FM_BK_AUTORELEASE

CHAR

Value	Description
X	Yes
NULL	No

GBGRU

Fund Group

GBGRU

CHAR

SGBGRU

Sender Fund Group

SGBGRU

CHAR

FKGRU

Functional Area Group

FKGRU

CHAR

SFKGRU

Sender Function Group

SFKGRU

CHAR

FM_GRANT_GROUP

Grant Group

FM_GRANT_GROUP

CHAR

FM_SGRANT_GROUP

Sender Grant Group

FM_SGRANT_GROUP

CHAR

AVA

Availability Control in Object Currency

OBJ_AVA

CHAR

Value	Description
X	Yes
NULL	No

OBJ

Default Object Currency for Planning in Trans. Currency

OBJ_DEF

CHAR

Value	Description
X	Yes
NULL	No

CONV

Currency Translation of Remainder

OBJ_CONV

CHAR

Value	Description
X	Yes
NULL	No

BUDGET_PD_GROUP

Budget Period Group

FM_BPD_GROUP

CHAR

SBUDGET_PD_GROUP

Sender Budget Period Group

FM_SBPD_GROUP

CHAR

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	MANDT	TCURV Exchange rate types for currency translation	MANDT
TBP1C	KURST	TBP1C	KURST	TCURV Exchange rate types for currency translation	KURST
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	MANDT	T820 Planning Parameters	MANDT
TBP1C	RPLAN_ERL	TBP1C	RPLAN_ERL	T820 Planning Parameters	RPLAN
TBP1C	RPLAN_KST	TBP1C	MANDT	T820 Planning Parameters	MANDT
TBP1C	RPLAN_KST	TBP1C	RPLAN_KST	T820 Planning Parameters	RPLAN
TBP1C	SPRED	TBP1C	SPRED	T821S Distribution keys	SPRED
TBP1C	SPRED	TBP1C	MANDT	T821S Distribution keys	MANDT