FMBUDSTA SAP table for – Budgetary ledger account derivation: Open items/Actuals bdgt

Here we would like to draw your attention to FMBUDSTA table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMBUDSTA is a SAP standard transp table used for storing Budgetary ledger account derivation: Open items/Actuals bdgt related data in SAP. It comes under the package FMFG_E.

SAP FMBUDSTA table

Table FMBUDSTA technical data

TableFMBUDSTA
Data storingBudgetary ledger account derivation: Open items/Actuals bdgt
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFG_E
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-PS
Table CategoryTRANSP

SAP FMBUDSTA Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMBUDSTA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LDGR_AREA : Ledger area
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FM_AREA : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • COMP_CODE : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FISC_YEAR : From year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • PSTNG_PERIOD : Period from which this entry is valid
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • FUND_TYPE : FM Fund Type
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • VALUE_TYPE : Value Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • TRANSAC : CO Business Transaction
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • AMT_TYPE : Amount type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FUND_STATUS : FM Fund Status (Unexpired, Expired, Cancelled)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BL_DOC_TYPE : FM budgetary ledger document type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CFLEV : Carryforward level
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DP_WITH_PO : FM Down payment with reference to purchase order for BL
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • VBUND_FLG : Company ID of trading partner flag for BL
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FM_LINE : FM US Budgetary Ledger (BL) Line for Account Derivation
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • GL_ACCOUNT : G/L Account Number
    Its data type is CHAR (Character String) with field length 10
  • GL_ACCOUNT_ADJ : G/L Account Number
    Its data type is CHAR (Character String) with field length 10