1. Home
  2. Resources
  3. SAP Tables
  4. SBPBWBUDGET - Structure for Plan Data Transfer (Only Contains FM Fields)

SAP Table SBPBWBUDGET

Structure for Plan Data Transfer (Only Contains FM Fields)

SBPBWBUDGET (Structure for Plan Data Transfer (Only Contains FM Fields)) 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 SBPBWBUDGET to other SAP tables.

Source: SBPBWBUDGET (Structure for Plan Data Transfer (Only Contains FM Fields))

SBPBWBUDGET table fields

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

SBPBWBUDGET foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SBPBWBUDGET CMMT_ITEM * FMCI Commitment items master data MANDT
SBPBWBUDGET CMMT_ITEM SBPBWBUDGET FISC_YEAR FMCI Commitment items master data FIKRS
SBPBWBUDGET CMMT_ITEM SBPBWBUDGET CMMT_ITEM FMCI Commitment items master data GJAHR
SBPBWBUDGET CMMT_ITEM SYST MANDT FMCI Commitment items master data .INCLUDE
SBPBWBUDGET DISTKEY SYST MANDT T821S Distribution keys MANDT
SBPBWBUDGET DISTKEY SBPBWBUDGET DISTKEY T821S Distribution keys SPRED
SBPBWBUDGET DOCTYPE SYST MANDT FMEDDOCTYPE FM budget entry document type CLIENT
SBPBWBUDGET DOCTYPE SBPBWBUDGET DOCTYPE FMEDDOCTYPE FM budget entry document type DOCTYPE
SBPBWBUDGET FM_AREA SYST MANDT FM01 Financial Management Areas MANDT
SBPBWBUDGET FM_AREA SBPBWBUDGET FM_AREA FM01 Financial Management Areas FIKRS
SBPBWBUDGET FUNC_AREA SBPBWBUDGET FUNC_AREA TFKB Functional areas FKBER
SBPBWBUDGET FUNC_AREA SYST MANDT TFKB Functional areas MANDT
SBPBWBUDGET FUND SYST MANDT FMFINCODE FIFM: Financing code MANDT
SBPBWBUDGET FUND * FMFINCODE FIFM: Financing code FIKRS
SBPBWBUDGET FUND SBPBWBUDGET FUND FMFINCODE FIFM: Financing code FINCODE
SBPBWBUDGET FUNDS_CTR SBPBWBUDGET FUNDS_CTR FMFCTR Funds Center Master Record FICTR
SBPBWBUDGET FUNDS_CTR * FMFCTR Funds Center Master Record FIKRS
SBPBWBUDGET FUNDS_CTR SYST MANDT FMFCTR Funds Center Master Record MANDT
SBPBWBUDGET FUNDS_CTR * FMFCTR Funds Center Master Record DATBIS
SBPBWBUDGET PROCESS SBPBWBUDGET PROCESS BUPROCESS_UI User Interface Process PROCESS_UI
SBPBWBUDGET TEXT_ID SBPBWBUDGET TEXT_ID TTXID Valid text IDs TDID
SBPBWBUDGET TEXT_ID 'FMED' TTXID Valid text IDs TDOBJECT
SBPBWBUDGET TRANS_CURR SBPBWBUDGET TRANS_CURR TCURC Currency Codes WAERS
SBPBWBUDGET TRANS_CURR SYST MANDT TCURC Currency Codes MANDT