SAP FMBLEXTBU Substitute BL Doc Types for Budget Docs Table data and field list

FMBLEXTBU is a standard SAP Table which is used to store Substitute BL Doc Types for Budget Docs data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMBLEXTBU table consists of various fields, each holding specific information or linking keys about Substitute BL Doc Types for Budget Docs data available in SAP. These include FM_AREA (Financial Management Area), VALUE_TYPE (BCS Value Type), DOC_TYPE (Budget entry document type), BL_DOC_TYPE (Budgetary Ledger Document Type)... 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. .

FMBLEXTBU 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 FMBLEXTBU 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 FMBLEXTBU 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	Assigned to domain		MANDT
FM_AREA	Financial Management Area	FIKRS	CHAR	4	FMBLEXTFA		FIKRS	FIK
VALUE_TYPE	BCS Value Type	BUKU_VALTYPE	CHAR	2	BUVALTYPE		BUKU_VALTYPE
DOC_TYPE	Budget entry document type	BUED_DOCTYPE	CHAR	4	FMEDDOCTYPE		BUED_DOCTYPE	DOTY
BL_DOC_TYPE	Budgetary Ledger Document Type	FMBLEXT_BLART	CHAR	2	T003		BLART

Key field

Non-key field

< FMBLEXTBS - Source for Budgets in Derivation Tool for BL Extensions FMBLEXTCS - Source for Commitments/Actuals in Derivation Tool for BL Ext >

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

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

SELECT SINGLE *
FROM FMBLEXTBU
INTO CORRESPONDING FIELDS OF WA_FMBLEXTBU
WHERE...

How to access SAP table FMBLEXTBU

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

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