SAP FMBUDREV Revenue/Statistical Postings & Open items/actuals Resource Table data and field list

FMBUDREV is a standard SAP Table which is used to store Revenue/Statistical Postings & Open items/actuals Resource data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMBUDREV table consists of various fields, each holding specific information or linking keys about Revenue/Statistical Postings & Open items/actuals Resource 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. .

FMBUDREV 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 FMBUDREV 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 FMBUDREV 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
LDGR_AREA	Ledger area	FM_LDAREA	CHAR	1			FM_LDAREA
FM_AREA	Financial Management Area	FIKRS	CHAR	4	FM01		FIKRS	FIK
COMP_CODE	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
FISC_YEAR	From year	FM_BK_YEAR_FROM	NUMC	4		GJAHR	GJAHR
PSTNG_PERIOD	Period from which this entry is valid	FM_ABPER	NUMC	3			PERBL	VPE
FUND_TYPE	FM Fund Type	FM_FUNDTYPE	CHAR	6	FMFUNDTYPE		FM_FUNDTYPE
VALUE_TYPE	Value Type	FM_WRTTP	CHAR	2			FM_WRTTP
TRANSAC	CO Business Transaction	CO_VORGANG	CHAR	4	TJ01		J_VORGANG
AMT_TYPE	Amount type	FM_BTART	CHAR	4			FM_BTART
FUND_STATUS	FM Fund Status (Unexpired, Expired, Cancelled)	FM_FUND_STATUS	CHAR	1			FM_FUND_STATUS
BL_DOC_TYPE	FM budgetary ledger document type	FM_BL_DOC_TYPE	CHAR	4			CHAR4
CFLEV	Carryforward level	FM_CFLEV	CHAR	1			FM_CFLEV
DP_WITH_PO	FM Down payment with reference to purchase order for BL	FM_DP_WITH_PO	CHAR	1			FM_DP_WITH_PO
VBUND_FLG	Company ID of trading partner flag for BL	FM_VBUND_FLG	CHAR	1			FM_VBUND_FLG
FM_LINE	FM US Budgetary Ledger (BL) Line for Account Derivation	FM_USBL_LINE	NUMC	3			FM_USBL_LINE
GL_ACCOUNT	G/L Account Number	SAKNR	CHAR	10	SKB1	ALPHA	SAKNR	SAK	C_SAKNR
GL_ACCOUNT_ADJ	G/L Account Number	SAKNR	CHAR	10	SKA1	ALPHA	SAKNR	SAK	C_SAKNR

Key field

Non-key field

< FMBUDRES - Budgetary ledger account derivation: Revenue/Statistical FMBUDSTA - Budgetary ledger account derivation: Open items/Actuals bdgt >

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

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

SELECT SINGLE *
FROM FMBUDREV
INTO CORRESPONDING FIELDS OF WA_FMBUDREV
WHERE...

How to access SAP table FMBUDREV

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

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