SAP FMBLEXTT Targets Fields in Derivation Tool for BL Extensions Table data and field list

FMBLEXTT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Targets Fields in Derivation Tool for BL Extensions" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FMBLEXTT TYPE FMBLEXTT.

The FMBLEXTT table consists of various fields, each holding specific information or linking keys about Targets Fields in Derivation Tool for BL Extensions data available in SAP. These include GLACCOUNTOFF (General Ledger offset account), BLDOCTYPE (Budgetary Ledger Document Type), ONLYONE (All BL documents in only one BL document), LAST_TARGET (Last Target Object)... 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. .

FMBLEXTT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP FMBLEXTT structure 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 FMBLEXTT 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
GLACCOUNTGeneral Ledger account FMBL_ACCOUNTCHAR10SKA1ALPHASAKNR
GLACCOUNTOFFGeneral Ledger offset account FMBL_ACCOUNT_OFFSETCHAR10SKA1ALPHASAKNR
BLDOCTYPEBudgetary Ledger Document Type FMBLDOCTYPECHAR2T003BLART
ONLYONEAll BL documents in only one BL document FMBLONLYONECHAR1X
LAST_TARGETLast Target Object FM_LAST_TARGETCHAR1XFELD
TARGET1First Intermediate Target for Derivation Tool FMBLTARGET1CHAR30CHAR30
TARGET2Second Intermediate Target for Derivation Tool FMBLTARGET2CHAR30CHAR30

Key field Non-key field



How do I retrieve data from SAP structure FMBLEXTT using ABAP code?

As FMBLEXTT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMBLEXTT as there is no data to select.

How to access SAP table FMBLEXTT

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

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