SAP table SBPBWBUDGET (Structure for Plan Data Transfer (Only Contains FM Fields))

Field Description Data Type Length Decimals Checktable Data Element
FM_AREA Financial Management Area CHAR 4 0 FM01 FIKRS
VERSION Budget Version CHAR 3 0 * BUKU_VERSION
DOCDATE Document Date DATS 8 0 BP_BLDAT
PSTNG_DATE Posting Date in the Document DATS 8 0 BUDAT
DOCTYPE Budget entry document type CHAR 4 0 FMEDDOCTYPE BUED_DOCTYPE
DOCSTATE Status of a budget entry document CHAR 1 0 BUED_DOCSTATE
1 Posted
2 Preposted
3 Preposted Posted
4 Undone
PROCESS Budgeting Process CHAR 4 0 BUPROCESS_UI BUKU_PROCESS_UI
EXTERNAL_NUMBER External Number for Budget Entry Document CHAR 10 0 BUED_EXT_DOCNR
PERS_RESP Person Responsible for Planning/Budgeting CHAR 20 0 BP_VERANT
HEADER_TEXT Header Text for Budget Entry Document CHAR 50 0 BUED_HDTEXT
PUBLAW Public Law Cited CHAR 20 0 FM_PUBLAW
LEGIS Type of Legislation CHAR 1 0 FM_LEGIS
COHORT Reporting Year for Cohort CHAR 4 0 FM_COHORT
TEXT_NAME Text Name CHAR 32 0 BP_TDNAM
REF_ORG_UN Reference Organizational Units CHAR 10 0 AWORG
REF_DOC Reference document number CHAR 10 0 AWREF
OBJ_SYS Logical system of source document CHAR 10 0 * AWSYS
OBJ_TYPE Reference procedure CHAR 5 0 * AWTYP
TRANSFER_AGENCY Transfer Agency CHAR 2 0 * FMFG_TRANSFER_AGCY
TRANSFER_ACCOUNT Transfer Account CHAR 4 0 * FMFG_TRANSFER_ACCT
RCOMP Company ID of Trading Partner CHAR 6 0 * RASSC
DOCFAM Document Family Number CHAR 10 0 BUED_DOCFAM
DEL_FLAG Delete Data Record (in Repeat Tables) CHAR 1 0 DELETE_FLAG
HELDSTATE Status of FM Held Documents CHAR 1 0 BUHD_HELD_STATE
0 Normal Held
1 Request Created
2 Request Updated
3 Request Submitted
4 Request Approved
5 Request Rejected
DOC_YEAR Document Year NUMC 4 0 BUKU_DOCYEAR
DOCUMENT Budget entry document number CHAR 10 0 BUED_DOCNR
GET_ITEM Item data required CHAR 1 0 BAPI_GET_ITEM
GET_PERIOD Period data required CHAR 1 0 BAPI_GET_PERIOD
GET_LONGTEXT Long text required CHAR 1 0 BAPI_GET_LONGTEXT
GET_STDTEXT Standard text required CHAR 1 0 BAPI_GET_STDTEXT
LANGUAGE Language Key LANG 1 0 SYLANGU
BAPIMAXROW Maximum number of lines of hits INT4 10 0 BAPIMAXROW
TESTRUN Switch to Simulation Session for Write BAPIs CHAR 1 0 TESTRUN
ITEM_NUM Budget entry document line CHAR 6 0 BUED_DOCLN
FISC_YEAR Fiscal Year NUMC 4 0 GJAHR
BUDCAT Budget Category CHAR 2 0 * BUKU_BUDCAT
BUDTYPE Budget Type CHAR 4 0 BUKU_BUDTYPE
FUND Fund CHAR 10 0 FMFINCODE BP_GEBER
FUNDS_CTR Funds Center CHAR 16 0 FMFCTR FISTL
CMMT_ITEM Commitment Item CHAR 24 0 FMCI FM_FIPEX
FUNC_AREA Functional Area CHAR 16 0 TFKB FM_FAREA
MEASURE Funded Program CHAR 24 0 * FM_MEASURE
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
TRANS_CURR Transaction Currency CUKY 5 0 TCURC TWAER
TRANS_CURR_ISO ISO currency code CHAR 3 0 ISOCD
TOTAL_AMOUNT Currency Amount in BAPI Interfaces DEC 23 4 BAPICURR_D
DISTKEY Distribution Key CHAR 4 0 T821S BUKU_SPRED
ITEM_TEXT Item Text CHAR 50 0 SGTXT
VALTYPE BCS Value Type CHAR 2 0 * BUKU_VALTYPE
CASH_YEAR Year of Cash Effectivity NUMC 4 0 GNJHR
BUDGET_PERIOD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
USERDIM Customer Field for FM Actual and Commitment Data CHAR 10 0 FM_USERDIM
BUDGETING_PERIOD Budgeting period NUMC 3 0 BUKU_PERIOD
PERIOD_AMOUNT Currency Amount in BAPI Interfaces DEC 23 4 BAPICURR_D
TEXT_ID Text ID CHAR 4 0 TTXID TDID
FORMAT_COL Tag column CHAR 2 0 TDFORMAT
TEXT_LINE Text Line CHAR 132 0 TDLINE
STRUCTURE Structure name of BAPI table extension CHAR 30 0 * TE_STRUC
VALUEPART1 Data part of BAPI extension parameter CHAR 240 0 VALUEPART
VALUEPART2 Data part of BAPI extension parameter CHAR 240 0 VALUEPART
VALUEPART3 Data part of BAPI extension parameter CHAR 240 0 VALUEPART
VALUEPART4 Data part of BAPI extension parameter CHAR 240 0 VALUEPART
OVERALL Overall values too CHAR 1 0 BP_WGES
AUTORELEASE Automatic Release CHAR 1 0 FM_BK_AUTORELEASE
RESPONSIBLE Person Responsible for Planning/Budgeting CHAR 20 0 BP_VERANT
RPUBLAW Public Law Cited CHAR 20 0 FM_PUBLAW
RLEGIS Type of Legislation CHAR 1 0 FM_LEGIS
RCOHORT Reporting Year for Cohort CHAR 4 0 FM_COHORT
AWTYP Reference procedure CHAR 5 0 AWTYP
AWREF Reference document number CHAR 10 0 AWREF
AWORG Reference Organizational Units CHAR 10 0 AWORG
AWSYS Logical system of source document CHAR 10 0 AWSYS
VALUE_DATE Planning/budgeting value date DATS 8 0 BD_VADAT
DOC_DATE Document Date DATS 8 0 BP_BLDAT
POSTING_DATE Posting Date in the Document DATS 8 0 BUDAT
POSTING_PERIOD Posting period NUMC 3 0 POPER
DOC_TEXT Item Text CHAR 50 0 SGTXT
VALKEY Validation Key Budget/Planning CHAR 10 0 BP_VALKEY
VALUE_TYPE 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
BDGT_TYPE Budget Type Budgeting/Planning CHAR 4 0 BP_VORGANG
BDGT_SUBTYPE Budget Subtype CHAR 4 0 BP_SUBVO
COMMT_YEAR Year of Cash Effectivity NUMC 4 0 GNJHR
PERIOD Posting period NUMC 3 0 POPER
DISTR_KEY Distribution Key CHAR 4 0 SPRED
FAREA Functional Area CHAR 16 0 FM_FAREA
LNITEM_GROUP Doc. Line Items Grp NUMC 3 0 FM_LNITEM_GROUP
VALUE Amount CURR 15 2 BP_WERT3

SBPBWBUDGET foreign key relationships

Table Field Check Table Check Field
0 SBPBWBUDGET CMMT_ITEM FMCI Commitment items master data .INCLUDE
0 SBPBWBUDGET CMMT_ITEM FMCI Commitment items master data MANDT
0 SBPBWBUDGET CMMT_ITEM FMCI Commitment items master data FIKRS
0 SBPBWBUDGET CMMT_ITEM FMCI Commitment items master data GJAHR
1 SBPBWBUDGET DISTKEY T821S Distribution keys MANDT
1 SBPBWBUDGET DISTKEY T821S Distribution keys SPRED
0 SBPBWBUDGET DOCTYPE FMEDDOCTYPE FM budget entry document type DOCTYPE
1 SBPBWBUDGET FM_AREA FM01 Financial Management Areas FIKRS
0 SBPBWBUDGET FUNC_AREA TFKB Functional areas FKBER
1 SBPBWBUDGET FUND FMFINCODE FIFM: Financing code FIKRS
1 SBPBWBUDGET FUND FMFINCODE FIFM: Financing code FINCODE
0 SBPBWBUDGET FUNDS_CTR FMFCTR Funds Center Master Record FIKRS
0 SBPBWBUDGET FUNDS_CTR FMFCTR Funds Center Master Record DATBIS
1 SBPBWBUDGET TRANS_CURR TCURC Currency Codes MANDT
1 SBPBWBUDGET TRANS_CURR TCURC Currency Codes WAERS