SAP FMBLEXTBS Source for Budgets in Derivation Tool for BL Extensions Table data and field list

FMBLEXTBS 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 Budgets 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_FMBLEXTBS TYPE FMBLEXTBS.

The FMBLEXTBS table consists of various fields, each holding specific information or linking keys about Source for Budgets in Derivation Tool for BL Extensions data available in SAP. These include FISC_YEAR (Fiscal Year), CASH_YEAR (Year of Cash Effectivity), CATEGORY (Budget Category in Funds Management), TRANSAC (Budgeting Process)... 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. .

FMBLEXTBS 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 FMBLEXTBS 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 FMBLEXTBS 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	Budgeting Process	BUKU_PROCESS_UI	CHAR	4	BUPROCESS_UI		BUKU_PROCESS_UI
COMP_CODE	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
VALUE_TYPE	BCS Value Type	BUKU_VALTYPE	CHAR	2	BUVALTYPE		BUKU_VALTYPE
BDGT_SUBTYPE	Budget Type	BUKU_BUDTYPE	CHAR	4			CHAR4	BUTY
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

Key field

Non-key field

< FMBLEXTACT - Activation of BL Ext for Budget Category FMBLEXTBU - Substitute BL Doc Types for Budget Docs >

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

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

How to access SAP table FMBLEXTBS

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

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