SAP FMBUDRES Table – Budgetary ledger account derivation: Revenue/Statistical

The FMBUDRES table in SAP ERP or S/4HANA stores Budgetary ledger account derivation: Revenue/Statistical data. There are total 11 fields in FMBUDRES table. The Budgetary ledger account derivation: Revenue/Statistical table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMBUDRES table. It is in US Federal Government budgetary ledger account derivation (FMFG_E) ABAP package and is part of the Funds Management (PSM-FM) module.

SAP FMBUDRES Table Fields

Following is the list of fields that are available in SAP FMBUDRES table. The primary key fields of the table are MANDT (Client), LDGR_AREA (Ledger Area), FM_AREA (Financial Management Area), COMP_CODE (Company Code), FISC_YEAR (From year), PSTNG_PERIOD (Period from which this entry is valid), FUND_TYPE (FM Fund Type), BDGT_SUBTYPE (Budget Subtype), FM_LINE (FM US Budgetary Ledger (BL) Line for Account Derivation).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT (3)
LDGR_AREA Ledger Area FM_LDAREA CHAR (1)
FM_AREA Financial Management Area FIKRS FM01 CHAR (4)
COMP_CODE Company Code BUKRS T001 CHAR (4)
FISC_YEAR From year FM_BK_YEAR_FROM NUMC (4)
PSTNG_PERIOD Period from which this entry is valid FM_ABPER NUMC (3)
FUND_TYPE FM Fund Type FM_FUNDTYPE FMFUNDTYPE CHAR (6)
BDGT_SUBTYPE Budget Subtype BP_SUBVO TBP4A CHAR (4)
FM_LINE FM US Budgetary Ledger (BL) Line for Account Derivation FM_USBL_LINE NUMC (3)
GL_ACCOUNT G/L Account Number SAKNR SKB1 CHAR (10)
GL_ACCOUNT_ADJ G/L Account Number SAKNR SKB1 CHAR (10)