SAP IFMDERIVE_SOURCE Budgetary Ledger Account derivation source fields Table data and field list

IFMDERIVE_SOURCE 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 "Budgetary Ledger Account derivation source fields" 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_IFMDERIVE_SOURCE TYPE IFMDERIVE_SOURCE.

The IFMDERIVE_SOURCE table consists of various fields, each holding specific information or linking keys about Budgetary Ledger Account derivation source fields data available in SAP. These include FUND_TYPE (FM Fund Type), FUND_STATUS (FM Fund Status (Unexpired, Expired, Cancelled)), SGL_BDGT_ADJSTMNT (Budget Adjustment), FMFG_BLSTATUS_SH (Budget status without source)... 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. .

IFMDERIVE_SOURCE structure Technical Details:

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

SAP IFMDERIVE_SOURCE 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 IFMDERIVE_SOURCE 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
TRADE_PARTNER_FLG	Company ID of trading partner flag for BL enterprise release	FMUSSGLVBUND	CHAR	1			FMUSSGLVBUND
FUND_TYPE	FM Fund Type	FM_FUNDTYPE	CHAR	6	FMFUNDTYPE		FM_FUNDTYPE
FUND_STATUS	FM Fund Status (Unexpired, Expired, Cancelled)	FM_FUND_STATUS	CHAR	1			FM_FUND_STATUS
SGL_BDGT_ADJSTMNT	Budget Adjustment	FMUSSGLADJSTMNT	CHAR	2			FMUSSGLADJSTMNT
FMFG_BLSTATUS_SH	Budget status without source	FMFG_BLSTATUS_SH	CHAR	4			FMFG_BLSTATUS_SH
BUDTYPE	Budget Type	BUKU_BUDTYPE	CHAR	4	FMPTCOMB		CHAR4	BUTY
REVENUE_OR_COLLECTION	Revenue or Collection (used for Acc. Deriv. Misc Receipts)	FMFG_REVCOL	CHAR	1			FMFG_REVCOL
FLG_APPROPR_YEAR	Appropriation year or subsequent year	FMFG_FLG_APPROPR_YEAR	CHAR	1			FMFG_FLG_APPROPR_YEAR
COMPANY_CODE	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
DOC_TYPE	Document Type	BLART	CHAR	2	T003		BLART	BAR
CMMT_ITEM	Commitment Item	FM_FIPEX	CHAR	24	FMCI		FM_FIPEX	FPS
FUND	Fund	FM_FUND	CHAR	10	FMFINCODE		BP_GEBER	FIC
USER_DIM	Customer Field for FM Actual and Commitment Data	FM_USERDIM	CHAR	10			CHAR10
GL_ACCOUNT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
ASSSETTRTYP	Asset Transaction Type	ANBWA	CHAR	3	Assigned to domain		BWASL
TRANSAC	CO Business Transaction	CO_VORGANG	CHAR	4	Assigned to domain		J_VORGANG
BUD_PROCESS	Budgeting Process	BUKU_PROCESS_UI	CHAR	4	BUPROCESS_UI		BUKU_PROCESS_UI
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
FMVOR	Classification of Document Lines	FMVOR	CHAR	4			FMVOR

Key field

Non-key field

< IFMDECKHK2 - Assignment of FM Account Assignment to Cover Pool IFMDERIVE_SOURCE_AREA - Source fields for deriving BL Area >

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

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

How to access SAP table IFMDERIVE_SOURCE

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

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