SAP FMBUDSTA Budgetary ledger account derivation: Open items/Actuals bdgt Table data and field list

FMBUDSTA is a standard SAP Table which is used to store Budgetary ledger account derivation: Open items/Actuals bdgt data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMBUDSTA table consists of various fields, each holding specific information or linking keys about Budgetary ledger account derivation: Open items/Actuals bdgt data available in SAP. These include LDGR_AREA (Ledger area), FM_AREA (Financial Management Area), COMP_CODE (Company Code), FISC_YEAR (From year)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FMBUDSTA table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP FMBUDSTA table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FMBUDSTA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LDGR_AREALedger area FM_LDAREACHAR1FM_LDAREA
FM_AREAFinancial Management Area FIKRSCHAR4FM01FIKRSFIK
COMP_CODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
FISC_YEARFrom year FM_BK_YEAR_FROMNUMC4GJAHRGJAHR
PSTNG_PERIODPeriod from which this entry is valid FM_ABPERNUMC3PERBLVPE
FUND_TYPEFM Fund Type FM_FUNDTYPECHAR6FMFUNDTYPEFM_FUNDTYPE
VALUE_TYPEValue Type FM_WRTTPCHAR2FM_WRTTP
TRANSACCO Business Transaction CO_VORGANGCHAR4TJ01J_VORGANG
AMT_TYPEAmount type FM_BTARTCHAR4FM_BTART
FUND_STATUSFM Fund Status (Unexpired, Expired, Cancelled) FM_FUND_STATUSCHAR1FM_FUND_STATUS
BL_DOC_TYPEFM budgetary ledger document type FM_BL_DOC_TYPECHAR4CHAR4
CFLEVCarryforward level FM_CFLEVCHAR1FM_CFLEV
DP_WITH_POFM Down payment with reference to purchase order for BL FM_DP_WITH_POCHAR1FM_DP_WITH_PO
VBUND_FLGCompany ID of trading partner flag for BL FM_VBUND_FLGCHAR1FM_VBUND_FLG
FM_LINEFM US Budgetary Ledger (BL) Line for Account Derivation FM_USBL_LINENUMC3FM_USBL_LINE
GL_ACCOUNTG/L Account Number SAKNRCHAR10SKB1ALPHASAKNRSAKC_SAKNR
GL_ACCOUNT_ADJG/L Account Number SAKNRCHAR10SKB1ALPHASAKNRSAKC_SAKNR

Key field Non-key field



How do I retrieve data from SAP table FMBUDSTA using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMBUDSTA to SELECT all data from the table
DATA: WA_FMBUDSTA TYPE FMBUDSTA.

SELECT SINGLE *
FROM FMBUDSTA
INTO CORRESPONDING FIELDS OF WA_FMBUDSTA
WHERE...

How to access SAP table FMBUDSTA

Within an ECC or HANA version of SAP you can also view further information about FMBUDSTA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).