1. Home
  2. Resources
  3. SAP Tables
  4. FMBDT - FM budget totals table

SAP Table FMBDT

FM budget totals table

FMBDT (FM budget totals table) 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 FMBDT to other SAP tables.

FMBDT table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version VERSN TKVS CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
ROBJNR Object number for objects (account assignment elements) GOBJNR_R CHAR 18 0
COBJNR Object number for transaction attributes GOBJNR_C CHAR 18 0
SOBJNR Object number for partner objects (accnt assignmnt elements) GOBJNR_S CHAR 18 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
RPMAX Period RPMAX NUMC 3 0
RFIKRS Financial Management Area FIKRS FM01 CHAR 4 0
RFUND Fund FM_FUND FMFINCODE CHAR 10 0
RFUNDSCTR Funds Center FISTL FMFCTR CHAR 16 0
RCMMTITEM Commitment Item FM_FIPEX FMCI CHAR 24 0
RFUNCAREA Functional Area FKBER TFKB CHAR 16 0
RUSERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM CHAR 10 0
RGRANT_NBR Grant GM_GRANT_NBR GMGR CHAR 20 0
RMEASURE Funded Program FM_MEASURE FMMEASURE CHAR 24 0
BUDGET_PD_9 FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
CEFFYEAR_9 Year of Cash Effectivity GNJHR NUMC 4 0
VALTYPE_9 BCS Value Type BUKU_VALTYPE CHAR 2 0
WFSTATE_9 Workflow Status of a Record in the Budget Totals Table BUKU_WFSTATE CHAR 1 0
P Posted
R Reserved
E Earmarked
PROCESS_9 Internal Budgeting Process BUKU_PROCESS BUPROCESS CHAR 4 0
BUDTYPE_9 Budget Type BUKU_BUDTYPE FMBUDTYPE CHAR 4 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
TSLVT Balance carried forward in transaction currency TSLVT9 CURR 17 2
TSL01 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL02 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL03 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL04 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL05 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL06 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL07 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL08 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL09 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL10 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL11 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL12 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL13 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL14 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL15 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
TSL16 Total of transactions of the period in transaction currency TSLXX9 CURR 17 2
HSLVT Balance carried forward in local currency HSLVT9 CURR 17 2
HSL01 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL02 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL03 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL04 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL05 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL06 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL07 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL08 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL09 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL10 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL11 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL12 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL13 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL14 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL15 Total of transactions of the period in local currency HSLXX9 CURR 17 2
HSL16 Total of transactions of the period in local currency HSLXX9 CURR 17 2
KSLVT Balance carried forward in group currency KSLVT9 CURR 17 2
KSL01 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL02 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL03 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL04 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL05 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL06 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL07 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL08 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL09 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL10 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL11 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL12 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL13 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL14 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL15 Total of transactions of the period in group currency KSLXX9 CURR 17 2
KSL16 Total of transactions of the period in group currency KSLXX9 CURR 17 2
CSPRED Distribution key for currency amounts CSPRED T821S CHAR 4 0
CTEM_CATEGORY_9 Commitment Item Category FM_POTYP NUMC 1 0
1 Balance
2 Revenues
3 Expenditures
4 Balances
5 Clarification Worklist

FMBDT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMBDT BUDTYPE_9 FMBDT RFIKRS FMBUDTYPE Budget type definition FM_AREA
FMBDT BUDTYPE_9 FMBDT BUDTYPE_9 FMBUDTYPE Budget type definition BUDTYPE
FMBDT BUDTYPE_9 FMBDT VALTYPE_9 FMBUDTYPE Budget type definition VALTYPE
FMBDT BUDTYPE_9 FMBDT RCLNT FMBUDTYPE Budget type definition CLIENT
FMBDT CSPRED FMBDT RCLNT T821S Distribution keys MANDT
FMBDT CSPRED FMBDT CSPRED T821S Distribution keys SPRED
FMBDT LOGSYS FMBDT LOGSYS TBDLS Logical system LOGSYS
FMBDT PROCESS_9 FMBDT PROCESS_9 BUPROCESS Internal budgeting process PROCESS
FMBDT RCLNT FMBDT RCLNT T000 Clients MANDT
FMBDT RCMMTITEM FMBDT RCMMTITEM FMCI Commitment items master data GJAHR
FMBDT RCMMTITEM FMBDT RCLNT FMCI Commitment items master data .INCLUDE
FMBDT RCMMTITEM FMBDT RFIKRS FMCI Commitment items master data MANDT
FMBDT RCMMTITEM FMBDT RYEAR FMCI Commitment items master data FIKRS
FMBDT RFIKRS FMBDT RCLNT FM01 Financial Management Areas MANDT
FMBDT RFIKRS FMBDT RFIKRS FM01 Financial Management Areas FIKRS
FMBDT RFUNCAREA FMBDT RCLNT TFKB Functional areas MANDT
FMBDT RFUNCAREA FMBDT RFUNCAREA TFKB Functional areas FKBER
FMBDT RFUND FMBDT RCLNT FMFINCODE FIFM: Financing code MANDT
FMBDT RFUND FMBDT RFIKRS FMFINCODE FIFM: Financing code FIKRS
FMBDT RFUND FMBDT RFUND FMFINCODE FIFM: Financing code FINCODE
FMBDT RFUNDSCTR FMBDT RCLNT FMFCTR Funds Center Master Record MANDT
FMBDT RFUNDSCTR FMBDT RFIKRS FMFCTR Funds Center Master Record FIKRS
FMBDT RFUNDSCTR FMBDT RFUNDSCTR FMFCTR Funds Center Master Record FICTR
FMBDT RFUNDSCTR * FMFCTR Funds Center Master Record DATBIS
FMBDT RGRANT_NBR FMBDT RCLNT GMGR Grant Master CLIENT
FMBDT RGRANT_NBR FMBDT RGRANT_NBR GMGR Grant Master GRANT_NBR
FMBDT RLDNR FMBDT RCLNT T881 Ledger Master MANDT
FMBDT RLDNR FMBDT RLDNR T881 Ledger Master RLDNR
FMBDT RMEASURE FMBDT RMEASURE FMMEASURE FM Funded Program Master Data MEASURE
FMBDT RMEASURE FMBDT RCLNT FMMEASURE FM Funded Program Master Data CLIENT
FMBDT RMEASURE FMBDT RFIKRS FMMEASURE FM Funded Program Master Data FMAREA
FMBDT RTCUR FMBDT RCLNT TCURC Currency Codes MANDT
FMBDT RTCUR FMBDT RTCUR TCURC Currency Codes WAERS
FMBDT RVERS FMBDT RCLNT TKVS CO Versions MANDT
FMBDT RVERS FMBDT RVERS TKVS CO Versions VERSI