SAP Table

TBP1C Budget/Plan Profile

SAP table TBP1C has 4 primary key fields being MANDT,PROFIL,APPLIK,WRTTP.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TBP1C columns.

Field

Description

Data Type

Length

Decimals

Checktable

Data Element

KeyMANDT

Client

CLNT

T000

MANDT

KeyPROFIL

Profile

CHAR

BP_PROFIL

KeyAPPLIK

Application

CHAR

BP_APPLIK

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

KeyWRTTP

Value Type

CHAR

CO_WRTTP

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
3C	Control Costs
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
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
5A	Payment Obligations from Purchasing Down Payments
60	Parked Document
61	Down Payments
62	Planned Payments
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
6A	Planned Down Payments
6B	Clarification Worklist FI-CA
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
U1	Source Document - Statistical Actuals
U4	Source Document - Actual

BPGE

Planning/Budget Overall Values

CHAR

BP_BPGE

BPJA

Planning/budget annual values

CHAR

BP_BPJA

BPPE

Planning/budget period values

CHAR

BP_BPPE

AVA_ALL

Availability control against overall value

CHAR

BP_AVA_ALL

Y_FUTURE

Future timeframe allowed

INT1

BP_FUTURE

Y_PAST

Timeframe allowed in the past

INT1

BP_PAST

Y_START

Start planning/budgeting from current fiscal year

INT1

BP_START

SIGHT

Data view

NUMC

BP_SIGHT

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

NUMC

SCALE_D

DECIM

Number of Decimal Places

CUKY

DECIM

KURST

Exchange Rate Type

CHAR

TCURV

KURST

PLDAT

Value Date for Currency Translation

DATS

PLDAT

PLSAV

Save exchange rate type/value date

CHAR

BP_PLSAV

KLVAR

Costing Variant

CHAR

TCK03

CK_KLVAR

PLELE

Planning on planning elements only

CHAR

BP_PLELE

SPRED

Distribution Key

CHAR

T821S

SPRED

KAGRU_PRK

Cost element group for primary costs

CHAR

KAGRU_PRK

KAGRU_LST

Sender Activity Type Group

CHAR

SLGRU

KAGRU_SKZ

Statistical key figure group

CHAR

STGRU

KAGRU_ERL

Revenue cost element group

CHAR

KAGRU_ERL

RPLAN_KST

Cost planning parameters

CHAR

T820

RPLAN_KST

RPLAN_ERL

Revenue planning parameters

CHAR

T820

RPLAN_ERL

SKGRU

Sender Cost Center Group

CHAR

SKGRU

RELE

Availability control against releases

CHAR

BP_RELEASE

PRARTBU

Program type for budgeting

CHAR

TAI05

IM_PRARTBU

BOTTOMUP

Bottom-up planning in structure planning

CHAR

BP_BOTT_UP

AKT_ART

Availability control activation type

CHAR

BP_AKT_ART

PROZBAT

Usage in % for background activator

DEC

BP_PROZBAT

ERLART

Revenue element for billing plan to WSB element

CHAR

PSFPERLART

FPART

Billing/Invoicing Plan Type

CHAR

TFPLA

FPART

CUROBJ

Budgeting/Planning in the Object Currency

CHAR

BP_CUROBJ

CURTRA

Budgeting/panning in any transaction currency

CHAR

BP_CURTRA

CURKOKR

Budgeting/Planning in the Controlling Area Currency

CHAR

BP_CURKOKR

SDPLAN

Transfer Plan Values from Sales Order

CHAR

PSSDPLAN

QUPLAN

Transfer Plan Values from Quotation

CHAR

PSQUPLAN

AUTORELEASE

Automatic Release

CHAR

FM_BK_AUTORELEASE

GBGRU

Fund Group

CHAR

GBGRU

SGBGRU

Sender Fund Group

CHAR

SGBGRU

FKGRU

Functional Area Group

CHAR

FKGRU

SFKGRU

Sender Function Group

CHAR

SFKGRU

FM_GRANT_GROUP

Grant Group

CHAR

FM_GRANT_GROUP

FM_SGRANT_GROUP

Sender Grant Group

CHAR

FM_SGRANT_GROUP

AVA

Availability Control in Object Currency

CHAR

OBJ_AVA

OBJ

Default Object Currency for Planning in Trans. Currency

CHAR

OBJ_DEF

CONV

Currency Translation of Remainder

CHAR

OBJ_CONV

BUDGET_PD_GROUP

Budget Period Group

CHAR

FM_BPD_GROUP

SBUDGET_PD_GROUP

Sender Budget Period Group

CHAR

FM_SBPD_GROUP

/ Relationships

TBP1C foreign keys.

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

Back to SAP tables