FMBDT

FM budget totals table (no more updated!) | view | #transactional | Component: Budgeting
Column Name Description
RCLNT FK Client
RLDNR FK Ledger
RRCTY Record Type Show values
RVERS FK Version
RYEAR Fiscal Year
ROBJNR Object number for objects (account assignment elements)
COBJNR Object number for transaction attributes
SOBJNR Object number for partner objects (accnt assignmnt elements)
RTCUR FK Currency Key
DRCRK Debit/Credit Indicator Show values
RPMAX Period
Column Name Description
💲 Currency Key (RTCUR):
TSLVT Balance carried forward in transaction currency
TSL01 Total of transactions of the period in transaction currency
TSL02 Total of transactions of the period in transaction currency
TSL03 Total of transactions of the period in transaction currency
TSL04 Total of transactions of the period in transaction currency
TSL05 Total of transactions of the period in transaction currency
TSL06 Total of transactions of the period in transaction currency
TSL07 Total of transactions of the period in transaction currency
TSL08 Total of transactions of the period in transaction currency
TSL09 Total of transactions of the period in transaction currency
TSL10 Total of transactions of the period in transaction currency
TSL11 Total of transactions of the period in transaction currency
TSL12 Total of transactions of the period in transaction currency
TSL13 Total of transactions of the period in transaction currency
TSL14 Total of transactions of the period in transaction currency
TSL15 Total of transactions of the period in transaction currency
TSL16 Total of transactions of the period in transaction currency
💲 Currency key of currency 2 (T882.CURR1):
HSLVT Balance carried forward in local currency
HSL01 Total of transactions of the period in local currency
HSL02 Total of transactions of the period in local currency
HSL03 Total of transactions of the period in local currency
HSL04 Total of transactions of the period in local currency
HSL05 Total of transactions of the period in local currency
HSL06 Total of transactions of the period in local currency
HSL07 Total of transactions of the period in local currency
HSL08 Total of transactions of the period in local currency
HSL09 Total of transactions of the period in local currency
HSL10 Total of transactions of the period in local currency
HSL11 Total of transactions of the period in local currency
HSL12 Total of transactions of the period in local currency
HSL13 Total of transactions of the period in local currency
HSL14 Total of transactions of the period in local currency
HSL15 Total of transactions of the period in local currency
HSL16 Total of transactions of the period in local currency
💲 Currency key of currency 3 (T882.CURR2):
KSLVT Balance carried forward in group currency
KSL01 Total of transactions of the period in group currency
KSL02 Total of transactions of the period in group currency
KSL03 Total of transactions of the period in group currency
KSL04 Total of transactions of the period in group currency
KSL05 Total of transactions of the period in group currency
KSL06 Total of transactions of the period in group currency
KSL07 Total of transactions of the period in group currency
KSL08 Total of transactions of the period in group currency
KSL09 Total of transactions of the period in group currency
KSL10 Total of transactions of the period in group currency
KSL11 Total of transactions of the period in group currency
KSL12 Total of transactions of the period in group currency
KSL13 Total of transactions of the period in group currency
KSL14 Total of transactions of the period in group currency
KSL15 Total of transactions of the period in group currency
KSL16 Total of transactions of the period in group currency
Column Name Description
Column Name Description
Column Name Description
RRCTY Record Type Show values
DRCRK Debit/Credit Indicator Show values
WFSTATE_9 Workflow Status of a Record in the Budget Totals Table Show values
CTEM_CATEGORY_9 Commitment Item Category Show values
Column Name Description Domain name
RUSERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM
BUDGET_PD_9 Budget Period FM_BUDGET_PERIOD
CEFFYEAR_9 Year of Cash Effectivity GJAHR
VALTYPE_9 BCS Value Type BUKU_VALTYPE
Master Data Relations Join Conditions
Budget Type
  • Budget Type
  • Client
  • Financial Management Area
  • BCS Value Type
Distribution key for currency amounts
  • Distribution key for currency amounts
  • Client
  • FMBDT.CSPRED == T821S.SPRED
  • FMBDT.RCLNT == T821S.MANDT
Logical system FMBDT.LOGSYS == TBDLS.LOGSYS
Internal Budgeting Process FMBDT.PROCESS_9 == BUPROCESS.PROCESS
Client FMBDT.RCLNT == T000.MANDT
Commitment Item
  • Financial Management Area
  • Fiscal Year
  • Commitment Item
  • FMBDT.RFIKRS == FMCI.MANDT
  • FMBDT.RYEAR == FMCI.FIKRS
  • FMBDT.RCMMTITEM == FMCI.GJAHR
Financial Management Area
  • FMBDT.RCLNT == FM01.MANDT
  • FMBDT.RFIKRS == FM01.FIKRS
Functional Area
  • FMBDT.RCLNT == TFKB.MANDT
  • FMBDT.RFUNCAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Fund
  • Client
Funds Center
  • Funds Center
  • ?
  • Client
  • Financial Management Area
  • FMBDT.RFUNDSCTR == FMFCTR.FICTR
  • FMBDT.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • FMBDT.RCLNT == FMFCTR.MANDT
  • FMBDT.RFIKRS == FMFCTR.FIKRS
Grant
  • FMBDT.RCLNT == GMGR.CLIENT
  • FMBDT.RGRANT_NBR == GMGR.GRANT_NBR
Ledger
  • Ledger
  • Client
  • FMBDT.RLDNR == T881.RLDNR
  • FMBDT.RCLNT == T881.MANDT
Funded Program
  • Funded Program
  • Financial Management Area
Currency Key
  • FMBDT.RCLNT == TCURC.MANDT
  • FMBDT.RTCUR == TCURC.WAERS
Version
  • Version
  • Client
  • FMBDT.RVERS == TKVS.VERSI
  • FMBDT.RCLNT == TKVS.MANDT