The FMBUDSTA table in SAP ERP or S/4HANA stores Budgetary ledger account derivation: Open items/Actuals bdgt data. There are total 18 fields in FMBUDSTA table. The Budgetary ledger account derivation: Open items/Actuals bdgt 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 FMBUDSTA 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 FMBUDSTA Table Fields
Following is the list of fields that are available in SAP FMBUDSTA 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), VALUE_TYPE (Value Type), TRANSAC (CO Business Transaction), AMT_TYPE (Amount Type), FUND_STATUS (FM Fund Status (Unexpired, Expired, Cancelled)), BL_DOC_TYPE (FM budgetary ledger document type), CFLEV (Carryforward Level), DP_WITH_PO (FM Down payment with reference to purchase order for BL), VBUND_FLG (Company ID of trading partner flag for BL), 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) |
| VALUE_TYPE | Value Type | FM_WRTTP | CHAR (2) | |
| TRANSAC | CO Business Transaction | CO_VORGANG | TJ01 | CHAR (4) |
| AMT_TYPE | Amount Type | FM_BTART | CHAR (4) | |
| FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | FM_FUND_STATUS | CHAR (1) | |
| BL_DOC_TYPE | FM budgetary ledger document type | FM_BL_DOC_TYPE | CHAR (4) | |
| CFLEV | Carryforward Level | FM_CFLEV | CHAR (1) | |
| DP_WITH_PO | FM Down payment with reference to purchase order for BL | FM_DP_WITH_PO | CHAR (1) | |
| VBUND_FLG | Company ID of trading partner flag for BL | FM_VBUND_FLG | CHAR (1) | |
| 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) |
