SAP table BPPE (Totals Record for Period Values Controlling Obj.)

SAP table BPPE has 15 primary key fields being MANDT,LEDNR,OBJNR,POSIT,TRGKZ,WRTTP,GJAHR,GEBER,VERSN,VORGA,TWAER,SUBVO,GNJHR,FAREA,PERBL.

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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LEDNR Budget/Planning Ledger CHAR 4 0 BP_LEDNR
OBJNR Object Number CHAR 22 0 ONR00 BP_OBJEKT
POSIT Internal commitment item (8 chars) CHAR 8 0 BP_POSIT
TRGKZ Object Indicator CHAR 1 0 BP_TRGKZ
Node object
1 Order plan values: appended, apportioned
2 Order plan values: not defined
3 Order plan values: appended, not apportioned
4 Order values: appended, deleted
5 Order values: appended, deleted, other organizational unit
6 Order plan values: not appended, apportioned
7 Order values: not appended, deleted, different org.unit
8 Order plan values: not appended, not apportioned
9 Order values: not appended, deleted
A Archive object
B Investment Program Carryforward
C Capital investment program - forecast
D Dummy object
E Individual object
K Cost Center
N Capital investment program - current values
P Project item
WRTTP Value Type CHAR 2 0 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
GJAHR Fiscal Year NUMC 4 0 GJAHR
GEBER Fund CHAR 10 0 FMFINCODE BP_GEBER
VERSN Planning/budgeting version CHAR 3 0 * BP_VERSION
VORGA Budget Type Budgeting/Planning CHAR 4 0 T022 BP_VORGANG
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
SUBVO Budget Subtype CHAR 4 0 * BP_SUBVO
GNJHR Year of Cash Effectivity NUMC 4 0 GNJHR
FAREA Functional Area CHAR 16 0 * FM_FAREA
PERBL Period Block NUMC 3 0 PERBL
WTP01 Period value in transaction currency CURR 15 2 BP_WPT
WTP02 Period value in transaction currency CURR 15 2 BP_WPT
WTP03 Period value in transaction currency CURR 15 2 BP_WPT
WTP04 Period value in transaction currency CURR 15 2 BP_WPT
WTP05 Period value in transaction currency CURR 15 2 BP_WPT
WTP06 Period value in transaction currency CURR 15 2 BP_WPT
WTP07 Period value in transaction currency CURR 15 2 BP_WPT
WTP08 Period value in transaction currency CURR 15 2 BP_WPT
WTP09 Period value in transaction currency CURR 15 2 BP_WPT
WTP10 Period value in transaction currency CURR 15 2 BP_WPT
WTP11 Period value in transaction currency CURR 15 2 BP_WPT
WTP12 Period value in transaction currency CURR 15 2 BP_WPT
WTP13 Period value in transaction currency CURR 15 2 BP_WPT
WTP14 Period value in transaction currency CURR 15 2 BP_WPT
WTP15 Period value in transaction currency CURR 15 2 BP_WPT
WTP16 Period value in transaction currency CURR 15 2 BP_WPT
WLP01 Period value in ledger currency CURR 15 2 BP_WPL
WLP02 Period value in ledger currency CURR 15 2 BP_WPL
WLP03 Period value in ledger currency CURR 15 2 BP_WPL
WLP04 Period value in ledger currency CURR 15 2 BP_WPL
WLP05 Period value in ledger currency CURR 15 2 BP_WPL
WLP06 Period value in ledger currency CURR 15 2 BP_WPL
WLP07 Period value in ledger currency CURR 15 2 BP_WPL
WLP08 Period value in ledger currency CURR 15 2 BP_WPL
WLP09 Period value in ledger currency CURR 15 2 BP_WPL
WLP10 Period value in ledger currency CURR 15 2 BP_WPL
WLP11 Period value in ledger currency CURR 15 2 BP_WPL
WLP12 Period value in ledger currency CURR 15 2 BP_WPL
WLP13 Period value in ledger currency CURR 15 2 BP_WPL
WLP14 Period value in ledger currency CURR 15 2 BP_WPL
WLP15 Period value in ledger currency CURR 15 2 BP_WPL
WLP16 Period value in ledger currency CURR 15 2 BP_WPL
WTV01 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV02 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV03 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV04 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV05 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV06 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV07 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV08 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV09 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV10 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV11 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV12 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV13 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV14 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV15 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WTV16 Distributed period value in transaction currency CURR 15 2 BP_WPTV
WLV01 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV02 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV03 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV04 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV05 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV06 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV07 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV08 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV09 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV10 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV11 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV12 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV13 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV14 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV15 Distributed period value in legdger currency CURR 15 2 BP_WPLV
WLV16 Distributed period value in legdger currency CURR 15 2 BP_WPLV
BELTP Debit Type NUMC 1 0 BP_INOUT
0
1 Costs and credit-side payments
2 Revenues and debit-side payments

BPPE foreign key relationships

Table Field Check Table Check Field
0 BPPE GEBER FMFINCODE FIFM: Financing code FIKRS
0 BPPE GEBER FMFINCODE FIFM: Financing code FINCODE
1 BPPE MANDT T000 Clients MANDT
0 BPPE OBJNR ONR00 General Object Number MANDT
1 BPPE TWAER TCURC Currency Codes MANDT
1 BPPE TWAER TCURC Currency Codes WAERS