FMBDA

Actual line item table | #transactional | Component: Budgeting
Column Name Description
RCLNT FK Client
GL_SIRID Record number of the line item record
Column Name Description
💲 Currency Key (RTCUR):
TSL Value in Transaction Currency
💲 Currency key of currency 2 (T882.CURR1):
HSL Value in local currency
💲 Currency key of currency 3 (T882.CURR2):
KSL Value in group currency
Column Name Description
Column Name Description
BUDAT Posting Date in the Document
WSDAT Value Date for Currency Translation
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
Column Name Description
RRCTY Record Type Show values
DRCRK Debit/Credit Indicator Show values
DOCCT Document Category Show values
WFSTATE_9 Workflow Status of a Record in the Budget Totals Table Show values
REFDOCCT Reference Document Category Show values
CTEM_CATEGORY_9 Commitment Item Category Show values
Column Name Description Domain name
RYEAR Fiscal Year GJAHR
POPER Posting period POPER
DOCNR Document Number of an Accounting Document BELNR
DOCLN Six-Character Posting Item for Ledger DOCLN6
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
BUDTYPE_9 Budget Type CHAR4
SGTXT Item Text TEXT50
ACTIV Business Transaction CHAR4
REFDOCNR Reference document number of an accounting document BELNR
REFRYEAR Reference fiscal year GJAHR
REFDOCLN Six-Digit Number of the Reference Posting Line BUZEI6
REFACTIV FI-SL Business Reference Transaction CHAR4
USNAM User Name XUBNAME
AWORG Reference Organizational Units AWORG
TECHORG_9 Original Application BUKU_TECHORG
Master Data Relations Join Conditions
Reference procedure FMBDA.AWTYP == TTYP.AWTYP
FI-SL Document Type
  • FMBDA.RCLNT == T889.MANDT
  • FMBDA.DOCTY == T889.DOCTY
Logical system FMBDA.LOGSYS == TBDLS.LOGSYS
Internal Budgeting Process FMBDA.PROCESS_9 == BUPROCESS.PROCESS
Client FMBDA.RCLNT == T000.MANDT
Commitment Item
  • Financial Management Area
  • Fiscal Year
  • Commitment Item
  • FMBDA.RFIKRS == FMCI.MANDT
  • FMBDA.RYEAR == FMCI.FIKRS
  • FMBDA.RCMMTITEM == FMCI.GJAHR
Financial Management Area
  • FMBDA.RCLNT == FM01.MANDT
  • FMBDA.RFIKRS == FM01.FIKRS
Functional Area
  • FMBDA.RCLNT == TFKB.MANDT
  • FMBDA.RFUNCAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Fund
  • Client
Funds Center
  • Funds Center
  • ?
  • Client
  • Financial Management Area
  • FMBDA.RFUNDSCTR == FMFCTR.FICTR
  • FMBDA.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • FMBDA.RCLNT == FMFCTR.MANDT
  • FMBDA.RFIKRS == FMFCTR.FIKRS
Grant
  • FMBDA.RCLNT == GMGR.CLIENT
  • FMBDA.RGRANT_NBR == GMGR.GRANT_NBR
Ledger
  • Ledger
  • Client
  • FMBDA.RLDNR == T881.RLDNR
  • FMBDA.RCLNT == T881.MANDT
Funded Program
  • Funded Program
  • Financial Management Area
Currency Key
  • FMBDA.RCLNT == TCURC.MANDT
  • FMBDA.RTCUR == TCURC.WAERS
Version
  • Version
  • Client
  • FMBDA.RVERS == TKVS.VERSI
  • FMBDA.RCLNT == TKVS.MANDT
BCS Value Type FMBDA.VALTYPE_9 == BUVALTYPE.VALTYPE