FMBL SAP table for – Funds management budget document lines (entry documents)

Here we would like to draw your attention to FMBL 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). FMBL is a SAP standard transp table used for storing Funds management budget document lines (entry documents) related data in SAP. It comes under the package FMBPA_E.

SAP FMBL table

Table FMBL technical data

TableFMBL
Data storingFunds management budget document lines (entry documents)
ModulePSM
Sub ModulePSM-FM-BCS-BU
SAP PackageFMBPA_E
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMBL 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 FMBL table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • FM_AREA : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DOCYEAR : Document Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOCNR : Budget entry document number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • DOCLN : Budget entry document line
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • RPMAX : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • FLG_ADDED : Indicator for Additional Line
    Its data type is CHAR (Character String) with field length 1
  • CTEM_CATEGORY : Commitment Item Category
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FISCYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CEFFYEAR : Year of Cash Effectivity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • FUNDSCTR : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • CMMTITEM : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FUNCAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • USERDIM : Customer Field for FM Actual and Commitment Data
    Its data type is CHAR (Character String) with field length 10
  • BUDCAT : Budget Category
    Its data type is CHAR (Character String) with field length 2
  • VALTYPE : BCS Value Type
    Its data type is CHAR (Character String) with field length 2
  • PROCESS : Internal Budgeting Process
    Its data type is CHAR (Character String) with field length 4
  • BUDTYPE : Budget Type
    Its data type is CHAR (Character String) with field length 4
  • TCURR : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TVAL01 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL02 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL03 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL04 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL05 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL06 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL07 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL08 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL09 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL10 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL11 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL12 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL13 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL14 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL15 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • TVAL16 : Budget amount in transaction currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL01 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL02 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL03 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL04 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL05 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL06 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL07 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL08 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL09 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL10 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL11 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL12 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL13 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL14 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL15 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • LVAL16 : Budget amount in local currency
    Its data type is CURR (Currency Field) with field length 17
  • DISTKEY : Distribution Key
    Its data type is CHAR (Character String) with field length 4
  • TEXT50 : Item Text
    Its data type is CHAR (Character String) with field length 50