1. Home
  2. Resources
  3. SAP Tables
  4. BPDY - Budgeting/Planning Screen Fields

SAP Table BPDY

Budgeting/Planning Screen Fields

BPDY (Budgeting/Planning Screen 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 BPDY to other SAP tables.

BPDY table fields

Field Data element Checktable Datatype Length Decimals
LIST Text, 40 Characters Long TEXT40 CHAR 40 0
ELEMENT Text Field TEXT50 CHAR 50 0
TITLE Text Field TEXT50 CHAR 50 0
YEAR1 Planning/budgeting timeframe BP_ZEIT CHAR 10 0
YEAR2 Planning/budgeting timeframe BP_ZEIT CHAR 10 0
TWAER Currency BP_WAERS TCURC CUKY 5 0
ROW1 Text Field of Length 60 TEXT60 CHAR 60 0
WAER1 Currency BP_WAERS TCURC CUKY 5 0
ROW2 Text (15 characters) TEXT15 CHAR 15 0
WAER2 Currency BP_WAERS TCURC CUKY 5 0
GJAHR Fiscal Year GJAHR NUMC 4 0
JAHR Budget/planning year BP_JAHR NUMC 4 0
PERIODE Posting period POPER NUMC 3 0
PERIO Posting period POPER NUMC 3 0
HERKZ Plan value origin BP_HERKZ CHAR 1 0
X Yes
NULL No
HERKL Plan value origin BP_HERKZ CHAR 1 0
X Yes
NULL No
WERT1 Plan value/budget BP_WERT1 CURR 15 2
WERT2 Values or the Different View Columns BP_WERT2 CURR 15 2
SUWERT1 Total annual value in transaction currency BP_SUWJT1 CURR 15 2
SUWERT2 Total annual value in transaction currency BP_SUWJT2 CURR 15 2
GWERT1 Overall value in transaction currency BP_WGT1 CURR 15 2
GWERT2 Overall value in transaction currency BP_WGT2 CURR 15 2
PERI1 Period value in transaction currency BP_WPT1 CURR 15 2
PERI2 Period value in transaction currency BP_WPT2 CURR 15 2
DECIMAL Number of Decimal Places DECIM CUKY 5 0
SCALE Scaling factor SCALE_D NUMC 1 0
SCALE1 Scaling factor BP_SCALE CHAR 3 0
SPREDT Distribution Key SPRED CHAR 4 0
SPREDL Distribution Key SPRED T821S CHAR 4 0
SPRED Distribution Key SPRED T821S CHAR 4 0
SPRED1 Distribution Key SPRED T821S CHAR 4 0
SPRED2 Distribution Key SPRED T821S CHAR 4 0
SUBVO Budget Subtype BP_SUBVO CHAR 4 0
VERSN Planning/budgeting version BP_VERSION CHAR 3 0
VGROUP1 Availability-control activity group BP_VGROUP1 CHAR 2 0
++ All activity groups
00 Purchase requisition
01 Purchase order
02 Orders for project
03 Goods issue
04 Financial accounting document
05 CO document
06 Budgeting
07 Funds reservation
08 Fixed prices in project
09 Payroll
TXT Version Text VSTXT CHAR 30 0
UPDATE Indicator: Availability control activation BP_UPDATE CHAR 1 0
X Yes
NULL No
PROTOKOLL Log re availability control activation BP_PROT CHAR 1 0
X Yes
NULL No
BUDAT Posting Date in the Document BUDAT DATS 8 0
BUPER Posting period POPER NUMC 3 0
BLDAT Document Date BP_BLDAT DATS 8 0
SGTXT Document Header Text BP_BLTXT CHAR 50 0
U_SJAHR Sender year BP_U_SJAHR NUMC 4 0
U_EJAHR Receiver year BP_U_EJAHR NUMC 4 0
JAHR_VON First year for processing BP_YR_STAR NUMC 4 0
JAHR_BIS Last year for processing BP_YR_END NUMC 4 0
U_SGES Sender Total BP_U_SGES CHAR 1 0
X Yes
NULL No
U_EGES Receiver overall BP_U_EGES CHAR 1 0
X Yes
NULL No
TDNAME Text Name BP_TDNAM CHAR 32 0
WGES Overall values too BP_WGES CHAR 1 0
X Yes
NULL No
SVTB Sender: Distributable BP_SVTB CURR 15 2
CALC Budget/plan - revaluation percentage BP_CALC DEC 15 2
VALUE Budget/plan - revaluation amount BP_VALUE CURR 15 2
PPROFIL Planning profile BP_PPROFIL CHAR 6 0
BPROFIL Budget Profile BP_BPROFIL CHAR 6 0
VERANT 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
DOCTYPE Budget entry document type BUED_DOCTYPE FMEDDOCTYPE CHAR 4 0
AWORG Reference Organizational Units AWORG CHAR 10 0
AWREF Reference Document Number AWREF CHAR 10 0
AWSYS Logical system of source document AWSYS CHAR 10 0
AWTYP Reference Transaction AWTYP CHAR 5 0
TI_JAHR Maintain annual values BP_TI_JAHR CHAR 1 0
X Yes
NULL No
TI_GES Maintain overall values BP_TI_GES CHAR 1 0
X Yes
NULL No
TI_JAHR_1 Maintain annual values BP_TI_JAH1 CHAR 1 0
X Yes
NULL No
TI_GES_1 Maintain overall values BP_TI_GES1 CHAR 1 0
X Yes
NULL No
U_S_GEBER Sender fund BP_S_GEBER FMFINCODE CHAR 10 0
U_E_GEBER Receiver fund BP_E_GEBER FMFINCODE CHAR 10 0
U_S_PERIO Sender period: Budgeting/planning BP_S_PERIO NUMC 3 0
U_E_PERIO Receiver period: Budgeting/planning BP_E_PERIO NUMC 3 0
V_VERS_V Reference version BP_VERS_V TBP3A CHAR 3 0
V_VERS_Z Target version BP_VERS_Z CHAR 3 0
V_TEXT_V Version Text VSTXT CHAR 30 0
V_TEXT_Z Version Text VSTXT CHAR 30 0
V_PROTO Display detailed list of records copied? CO_PROTO CHAR 1 0
X Yes
NULL No
V_BATCH Background Processing BATCHFLG CHAR 1 0
X Yes
NULL No
V_UPD Overwrite version target dates BP_V_UPD CHAR 1 0
X Yes
NULL No
V_GESAMT Total values BP_V_GES CHAR 1 0
X Yes
NULL No
V_JAHRWERT Annual values BP_V_JAHR CHAR 1 0
X Yes
NULL No
V_VJAHR Reference year BP_V_VJAHR NUMC 4 0
V_ZJAHR Target year BP_V_ZJAHR NUMC 4 0
V_GEBER Budget/planning - all sources of funds BP_V_GEBER CHAR 1 0
X Yes
NULL No
V_N_GEBER Budget / planning - without financing codes BP_V_N_GEB CHAR 1 0
X Yes
NULL No
V_ACTIV_PO Activity Selection BP_V_ACT_P CHAR 1 0
X Yes
NULL No
V_ACTIV_SE Choose business transactions BP_V_ACT_S CHAR 1 0
X Yes
NULL No
V_NO_CHANG Do not change existing target data BP_V_N_CHG CHAR 1 0
X Yes
NULL No
V_ADD Add reference data to target data BP_V_ADD CHAR 1 0
X Yes
NULL No
V_COLL Combine ref.budgets for target original budget BP_V_COLL CHAR 1 0
X Yes
NULL No
V_ORIG Original budget BP_V_ORIG CHAR 1 0
X Yes
NULL No
V_NTRAG Budget supplement BP_V_NTRAG CHAR 1 0
X Yes
NULL No
V_RUECKGA Budget return BP_V_RUECK CHAR 1 0
X Yes
NULL No
V_UMBUCH Budget transfer BP_V_UMBU CHAR 1 0
X Yes
NULL No
V_AKTU Current budget BP_V_AKTU CHAR 1 0
X Yes
NULL No
V_FREIG Releases BP_V_FREIG CHAR 1 0
X Yes
NULL No
V_ALL_PLAN Copy all planning activities BP_V_ALL_P CHAR 1 0
X Yes
NULL No
V_COST Indicator: Copy cost element planning BP_V_COST CHAR 1 0
X Yes
NULL No
V_ERLOESE Indicator: Copy revenue element planning BP_V_ERL CHAR 1 0
X Yes
NULL No
V_PSP Indicator: Copy structure planning BP_V_PSP CHAR 1 0
X Yes
NULL No
V_EINZKALK Unit costing BP_V_KALK CHAR 1 0
X Yes
NULL No
V_YEAR_1 Copy one fiscal year BP_V_YR_1 CHAR 1 0
X Yes
NULL No
V_YEAR_1V Copy one fiscal year - year in reference BP_V_YR_1V NUMC 4 0
V_YEAR_1Z Copy one fiscal year - year in target version BP_V_YR_1Z NUMC 4 0
V_YEAR_X Copy fiscal years BP_V_YR_X CHAR 1 0
X Yes
NULL No
V_YEAR_XS Copy several fiscal years - first year in sequence BP_V_YR_XS NUMC 4 0
V_YEAR_XE Copy several fiscal years - last year in sequence BP_V_YR_XE NUMC 4 0
BELNR Document number from budget allocation & structure planning BP_BELNR NUMC 10 0
VADAT Planning/budgeting value date BD_VADAT DATS 8 0
WERT3 Amount BP_WERT3 CURR 15 2
VORGA Budget Type Budgeting/Planning BP_VORGANG CHAR 4 0
VORGA_KT Short ID (text) for budgeting/planning activity BP_VORG_KT CHAR 5 0
BSTAT_T Description (text) for planning/budgeting document status BP_BSTAT_T CHAR 20 0
RSTAT_T Description (text) for reversal status BP_RSTAT_T CHAR 20 0
REV_DOCNR Original document REV_DOCNR NUMC 10 0
REV_DOCNR_TXT Text REV_DOCNR_TXT CHAR 20 0
FITXT Name of FM area FITXT CHAR 25 0
COPY_ADD Budget/plan - total view values for existing values BP_CP_ADD CHAR 1 0
X Yes
NULL No
COPY_REPL Budget/plan - overwrite existing values with view values BP_CP_REPL CHAR 1 0
X Yes
NULL No
COPY_PERC Budget/plan - percentage valuation of view to be copied BP_CP_PERC DEC 15 2
BLPOS Line Item BP_POS NUMC 3 0
POSI Position BP_POSI NUMC 3 0
SH_CTR Display Funds Center Indented BP_SH_CTR CHAR 1 0
X Yes
NULL No
SH_POS Display commitment items indented BP_SH_POS CHAR 1 0
X Yes
NULL No
SH_TOP Display hierarchy level in top commitment items BP_SH_TOP CHAR 1 0
X Yes
NULL No
SH_NTOP Hierarchy level display in non-top commitment items BP_SH_NTOP CHAR 1 0
X Yes
NULL No
CP_M1 Copy mode: create new data only BP_CP_M1 CHAR 1 0
X Yes
NULL No
CP_M2 Copy mode: reset and overwrite existing data BP_CP_M2 CHAR 1 0
X Yes
NULL No
CP_M3 Copy mode: add reference version to existing target data BP_CP_M3 CHAR 1 0
X Yes
NULL No
SH_LEVEL Display hierarchy level BP_SH_LEV CHAR 1 0
X Yes
NULL No
SHIFT Commitment item indenting according to hierarchy level BP_SHIFT CHAR 1 0
X Yes
NULL No
TOTALUP Add changed values in budget/planning BP_TOTALUP CHAR 1 0
X Yes
NULL No
MARK Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
UNTRG Element is subdivided BP_UNTRG CHAR 1 0
STUFE Level in BS hierarchy BP_STUFE INT1 3 0
BSPID Budget structure element (BS element) BP_BSPID CHAR 50 0
BSPID2 Budget structure element (BS element) BP_BSPID CHAR 50 0
ACCAR Indicator: posting object BP_ACCAR CHAR 1 0
X Yes
NULL No
BPCAR Budget Object BP_BPCAR CHAR 1 0
X Yes
NULL No
CARR_YR_S Budget object - first year BP_CA_YR_S NUMC 4 0
CARR_YR_E Budget object - last year BP_CA_YR_E NUMC 4 0
CARR_GES Budget object - overall values BP_CA_GES CHAR 1 0
X Yes
NULL No
CARR_YR_ID Text (15 characters) TEXT15 CHAR 15 0
CARR_Y_STA Beginning year for processing of budget objects BP_CA_STRT NUMC 4 0
TESTMODE Test Run ALLGTEST CHAR 1 0
X Yes
NULL No
CARR_DF_BP Define budget object BP_DF_BPCA CHAR 1 0
X Yes
NULL No
CARR_DF_AC Define posting object BP_DF_ACCA CHAR 1 0
X Yes
NULL No
XSENDER Indicator: Sender XSENDER CHAR 1 0
X Yes
NULL No
XEMPFGR Indicator: Receiver XEMPFGR CHAR 1 0
X Yes
NULL No
REFDOC Budget/planning reference document number BP_REFDOC NUMC 10 0
WERT4 Plan value/budget amount BP_WERT4 CURR 15 2
HEADER1 Text, length 21 BP_TEXT21 CHAR 21 0
HEADER2 Text, length 21 BP_TEXT21 CHAR 21 0
VALKEY Validation Key Budget/Planning BP_VALKEY CHAR 10 0
WERT11 Plan value/budget amount BP_WERT4 CURR 15 2
WERT12 Plan value/budget amount BP_WERT4 CURR 15 2
WERT13 Plan value/budget amount BP_WERT4 CURR 15 2
WERT14 Plan value/budget amount BP_WERT4 CURR 15 2
CTRLSUM1 Budgeting/planning control total BP_CTRLSUM CURR 15 2
CTRLSUM2 Budgeting/planning control total BP_CTRLSUM CURR 15 2
XPB Payment budget BP_PB CHAR 1 0
X Yes
NULL No
XCB Commitment budget BP_CB CHAR 1 0
X Yes
NULL No
XPBO Payment budget BP_PBO CHAR 1 0
X Yes
NULL No
XCBO Commitment budget BP_CBO CHAR 1 0
X Yes
NULL No
VORGA_BEZ Name for budget/planning budget types BP_VORG_BE CHAR 20 0
WRTTP_BEZ Budget category name: Budgeting/Planning BP_WRTTP_B CHAR 20 0
SUBVO_BEZ Budget Subtype Name (M) BP_SUBVOT20 CHAR 20 0
USNAM Name of Person who Created the Object ERNAM CHAR 12 0
CPUDT Date Document Was Created CO_CPUDT DATS 8 0
DOCNR Entry Document Number BP_DOCNR NUMC 10 0
COPY_PREL Copy parked budget also BP_CP_PREL CHAR 1 0
X Yes
NULL No
CARR_SINGL Define budget objects individually BP_CARR_SI CHAR 1 0
X Yes
NULL No
CARR_GROUP Define budget structure with BS template BP_CARR_GR CHAR 1 0
X Yes
NULL No
GNJHR Year of Cash Effectivity GNJHR NUMC 4 0
INFO50 Text Field TEXT50 CHAR 50 0
INFO20 Text (20 Characters) TEXT20 CHAR 20 0
PROC_TOTAL Process Budget Overall Values BP_PRC_TOT CHAR 1 0
X Yes
NULL No
TOT_UP_NEW Total Up: Add New Data Only BP_TM_NEW CHAR 1 0
X Yes
NULL No
BP_CAT_PB Payment budget BP_CAT_PB CHAR 1 0
X Yes
NULL No
BP_CAT_CB Commitment budget BP_CAT_CB CHAR 1 0
X Yes
NULL No
BP_BTP_DIT Distributed budget BP_BTP_DIT CHAR 1 0
X Yes
NULL No
BP_BTP_ORG Original budget BP_BTP_ORG CHAR 1 0
X Yes
NULL No
BP_BTP_DAB distributable budget BP_BTP_DAB CHAR 1 0
X Yes
NULL No
BP_BTP_ASS Assigned budget BP_BTP_ASS CHAR 1 0
X Yes
NULL No
BP_BTP_ACT Current budget BP_BTP_ACT CHAR 1 0
X Yes
NULL No
BP_CAT_HEA Budget category BP_CAT_HEA CHAR 1 0
X Yes
NULL No
BP_BTP_HEA Budget type header BP_BTP_HEA CHAR 1 0
X Yes
NULL No
CP_BGT Copy budget BP_CP_BGT CHAR 1 0
X Yes
NULL No
CP_ACT Copy current budget BP_CP_ACT CHAR 1 0
X Yes
NULL No
CP_SEL Only copy certain budget types BP_CP_SEL CHAR 1 0
X Yes
NULL No
CP_ORG Copy original budget BP_CP_ORG CHAR 1 0
X Yes
NULL No
CP_UMB Copy transfer postings BP_CP_UMB CHAR 1 0
X Yes
NULL No
CP_NAC Copy supplements BP_CP_NAC CHAR 1 0
X Yes
NULL No
CP_RUE Copy returns BP_CP_RUE CHAR 1 0
X Yes
NULL No
EINZEL Always generate line items BP_EINZEL CHAR 1 0
X Yes
NULL No
BGT_COLLECT Group budget types in original budget BP_BGT_COLLECT CHAR 1 0
X Yes
NULL No
BP_CAT_FIP Financial budget BP_CAT_FIP CHAR 1 0
X Yes
NULL No
DEL_TOTAL Delete all budget data BP_DEL_TOT CHAR 1 0
X Yes
NULL No
ROW3 Text (15 characters) TEXT15 CHAR 15 0
AUTORELEASE Automatic Release FM_BK_AUTORELEASE CHAR 1 0
X Yes
NULL No
FAREA Functional Area FM_FAREA TFKB CHAR 16 0
FAREA_TXT Name of the functional area FKBTX CHAR 25 0
FINCODE_TXT Name FM_BEZEICH CHAR 20 0
FMREASN_TXT Text Field TEXT50 CHAR 50 0
FMREASON Reason for decision for workflow FMREASON CHAR 2 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0
FICTR Funds Center FM_FICTR CHAR 16 0
GNJHR1 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR2 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR3 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR4 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR5 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR6 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR7 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR8 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR9 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
GNJHR10 Year in which cash is affected XGNJHR CHAR 1 0
X Yes
NULL No
T_GNJHR1 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR2 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR3 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR4 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR5 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR6 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR7 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR8 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR9 Text (10 Characters) TEXT10 CHAR 10 0
T_GNJHR10 Text (10 Characters) TEXT10 CHAR 10 0
RE_GNJHR Year of Financial Result FM_RE_GNJHR NUMC 4 0

BPDY foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BPDY DOCTYPE SYST MANDT FMEDDOCTYPE FM budget entry document type CLIENT
BPDY DOCTYPE BPDY DOCTYPE FMEDDOCTYPE FM budget entry document type DOCTYPE
BPDY FAREA SY MANDT TFKB Functional areas MANDT
BPDY FAREA BPDY FAREA TFKB Functional areas FKBER
BPDY SPRED SYST MANDT T821S Distribution keys MANDT
BPDY SPRED BPDY SPRED T821S Distribution keys SPRED
BPDY SPRED1 SYST MANDT T821S Distribution keys MANDT
BPDY SPRED1 BPDY SPRED1 T821S Distribution keys SPRED
BPDY SPRED2 SYST MANDT T821S Distribution keys MANDT
BPDY SPRED2 BPDY SPRED2 T821S Distribution keys SPRED
BPDY SPREDL SYST MANDT T821S Distribution keys MANDT
BPDY SPREDL BPDY SPREDL T821S Distribution keys SPRED
BPDY TWAER SYST MANDT TCURC Currency Codes MANDT
BPDY TWAER BPDY TWAER TCURC Currency Codes WAERS
BPDY U_E_GEBER SYST MANDT FMFINCODE FIFM: Financing code MANDT
BPDY U_E_GEBER FMDY FIKRS FMFINCODE FIFM: Financing code FIKRS
BPDY U_E_GEBER BPDY U_E_GEBER FMFINCODE FIFM: Financing code FINCODE
BPDY U_S_GEBER BPDY U_S_GEBER FMFINCODE FIFM: Financing code FINCODE
BPDY U_S_GEBER SYST MANDT FMFINCODE FIFM: Financing code MANDT
BPDY U_S_GEBER FMDY FIKRS FMFINCODE FIFM: Financing code FIKRS
BPDY V_VERS_V * TBP3A Budget / plan versions from rel.3.0 APPLIK
BPDY V_VERS_V * TBP3A Budget / plan versions from rel.3.0 WRTTP
BPDY V_VERS_V * TBP3A Budget / plan versions from rel.3.0 MANDT
BPDY V_VERS_V BPDY V_VERS_V TBP3A Budget / plan versions from rel.3.0 VERSN
BPDY WAER1 BPDY WAER1 TCURC Currency Codes WAERS
BPDY WAER1 SYST MANDT TCURC Currency Codes MANDT
BPDY WAER2 SYST MANDT TCURC Currency Codes MANDT
BPDY WAER2 BPDY WAER2 TCURC Currency Codes WAERS