SAP FMBLEXTCS Source for Commitments/Actuals in Derivation Tool for BL Ext Table data and field list

FMBLEXTCS 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 "Source for Commitments/Actuals in Derivation Tool for BL Ext" 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_FMBLEXTCS TYPE FMBLEXTCS.

The FMBLEXTCS table consists of various fields, each holding specific information or linking keys about Source for Commitments/Actuals in Derivation Tool for BL Ext data available in SAP. These include FISC_YEAR (Fiscal Year), CASH_YEAR (Year of Cash Effectivity), CATEGORY (Budget Category in Funds Management), TRANSAC (CO Business Transaction)... 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. .

FMBLEXTCS 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 FMBLEXTCS 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 FMBLEXTCS 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
FM_AREA	Financial Management Area	FIKRS	CHAR	4	FM01		FIKRS	FIK
FISC_YEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
CASH_YEAR	Year of Cash Effectivity	GNJHR	NUMC	4		GJAHR	GJAHR	GNJHR
CATEGORY	Budget Category in Funds Management	FM_BUCAT	NUMC	1			FM_BUCAT
TRANSAC	CO Business Transaction	CO_VORGANG	CHAR	4	TJ01		J_VORGANG
COMP_CODE	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
VALUE_TYPE	Value Type	FM_WRTTP	CHAR	2			FM_WRTTP
AMT_TYPE	Amount type	FM_BTART	CHAR	4			FM_BTART
STAT_IND	Funds Management Statistical Indicator	FM_STATS	CHAR	1			FM_STATS
CARRYFWD_LEVEL	Carryforward level	FM_CFLEV	CHAR	1			FM_CFLEV
FUND	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
BUDGET_PERIOD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
FUNDS_CTR	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
CMMT_ITEM	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
FUNC_AREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
CISTRID	Commitment Item Subdivision ID	FM_CISTRID	CHAR	10	FMMDSTRID		CHAR10
CISUB1	Substring 1 of Commitment Item	FM_CISUB1	CHAR	10			CHAR10
CISUB2	Substring 2 of Commitment Item	FM_CISUB2	CHAR	10			CHAR10
CISUB3	Substring 3 of Commitment Item	FM_CISUB3	CHAR	10			CHAR10
CISUB4	Substring 4 of Commitment Item	FM_CISUB4	CHAR	10			CHAR10
CISUB5	Substring 5 of Commitment Item	FM_CISUB5	CHAR	10			CHAR10
FCSTRID	Funds Center Subdivision ID	FM_FCSTRID	CHAR	10	FMMDSTRID		CHAR10
FCSUB1	Substring 1 of Funds Center	FM_FCSUB1	CHAR	10			CHAR10
FCSUB2	Substring 2 of Funds Center	FM_FCSUB2	CHAR	10			CHAR10
FCSUB3	Substring 3 of Funds Center	FM_FCSUB3	CHAR	10			CHAR10
FDSTRID	Fund Subdivision ID	FM_FDSTRID	CHAR	10	FMMDSTRID		CHAR10
FDSUB1	Substring 1 of Fund	FM_FDSUB1	CHAR	10			CHAR10
FDSUB2	Substring 2 of Fund	FM_FDSUB2	CHAR	10			CHAR10
FNSTRID	Functional Area Subdivision ID	FM_FNSTRID	CHAR	10	FMMDSTRID		CHAR10
FNSUB1	Substring 1 of Functional Area	FM_FNSUB1	CHAR	10			CHAR10
FNSUB2	Substring 2 of Functional Area	FM_FNSUB2	CHAR	10			CHAR10
FNSUB3	Substring 3 of Functional Area	FM_FNSUB3	CHAR	10			CHAR10
BLDOCSEQ	Sequence of Budgetary Ledger Documents	FMBLDOCSEQ	NUMC	2			NUM02
TARGET1	First Intermediate Target for Derivation Tool	FMBLTARGET1	CHAR	30			CHAR30
TARGET2	Second Intermediate Target for Derivation Tool	FMBLTARGET2	CHAR	30			CHAR30
DIFF_CASHFISC	Difference between Year of Cash Effectivity and Fiscal Year	FMBLEXTCFY	NUMC	2			NUMC2
AMTSIGN	Amount Sign ( + or - )	FMBLEXTSIGN	CHAR	1			FMBLEXTSIGN
CFSTAT	FM Commitment Carryforward: Status	FM_CFST	NUMC	2			FM_CFST

Key field

Non-key field

< FMBLEXTBU - Substitute BL Doc Types for Budget Docs FMBLEXTEA - Substitute BL Doc Types for Earmarked Funds >

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

As FMBLEXTCS 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 FMBLEXTCS as there is no data to select.

How to access SAP table FMBLEXTCS

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

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