SAP FMFUSE FIFM: Application of Funds from Secondary Sources Table data and field list

FMFUSE is a standard SAP Table which is used to store FIFM: Application of Funds from Secondary Sources data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMFUSE table consists of various fields, each holding specific information or linking keys about FIFM: Application of Funds from Secondary Sources data available in SAP. These include FIKRS (Financial Management Area), FINUSE (Application of Secondary Source Funds), DATAB (FM: Valid from date), DATBIS (FM: Valid to date)... 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. .

FMFUSE table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table = FMFUSET

SAP FMFUSE 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 FMFUSE 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	T000		MANDT
FIKRS	Financial Management Area	FIKRS	CHAR	4	FM01		FIKRS	FIK
FINUSE	Application of Secondary Source Funds	FM_FINUSE	CHAR	16			FM_FINUSE	FIU
DATAB	FM: Valid from date	FM_DATAB	DATS	8			DATUM	FM_DATAB
DATBIS	FM: Valid to date	FM_DATBIS	DATS	8			DATUM	FM_DATBIS
ERFNAME	FIFM: Created by	FM_ERFNAME	CHAR	12			USNAM
ERFDAT	FIFM: Entry Date	FM_ERFDAT	DATS	8			DATUM
AENNAME	FIFM: Name of Last Person to Make a Change	FM_AENNAME	CHAR	12			USNAM
AENDAT	FIFM: Changed on	FM_AENDAT	DATS	8			DATUM
DEPT_REG	Treasury Account Symbol - Department Regular	FM_DEPT_REG	CHAR	2			FM_DEPT_REG
DEPT_TRAN	Treasury Account Symbol - Department Transfer	FM_DEPT_TRAN	CHAR	2			FM_DEPT_TRAN
FISCAL_YR	Not More Closely Defined Area, Possibly Used for Patchlevels	CHAR4	CHAR	4			CHAR4
MAIN_ACCT	Treasury Account Symbol - Main Account	FM_MAIN_ACCT	CHAR	4			FM_MAIN_ACCT
SUB_ACCT	Treasury Account Symbol - Subaccount	FM_SUB_ACCT	CHAR	3			FM_SUB_ACCT
SPLIT_NUM	Treasury Account Symbol - account split sequence number	FM_SPLIT_NUM	CHAR	3			FM_SPLIT_NUM
FACTSII_REL	Relevant for FACTS II	FMFG_FACTSII_REL	CHAR	1			FMFG_FACTSII_REL
PREPARERID	Preparer ID	FM_PREPARER	CHAR	8
CERTIFIERID	Certifier ID	FMFG_CERTIFIERID	CHAR	8
.INCLU--AP				0
GTAS_REL	GTAS Relevant Indicator	FMFG_GTAS_REL	CHAR	1			FMFG_GTAS_REL
SUBLEVL	Sublevel Prefix (SP)	FMFG_SUBLEVL	CHAR	2			FMFG_SUBLEVL
AGENCID	Agency Identifier (AID)	FMFG_AGENCID	CHAR	3			FMFG_AGENCID
ALTRAID	Allocation Transfer Agency Identifier (ATA)	FMFG_ALTRAID	CHAR	3			FMFG_ALTRAID
BEGPER	Beginning Period of Availability (BPOA)	FMFG_BEGPER	NUMC	4		GJAHR	FMFG_BEGPER
ENDPER	Ending Period of Availability (EPOA)	FMFG_ENDPER	NUMC	4		GJAHR	FMFG_ENDPER
AVTYPE	Availability Type Code (A)	FMFG_AVTYPE	CHAR	1			FMFG_AVTYPE

Key field

Non-key field

< FMFUND_TEXT - Text Structure for Fund FMFUSET - FIFM: Application of Funds from Secondary Sources >

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

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

SELECT SINGLE *
FROM FMFUSE
INTO CORRESPONDING FIELDS OF WA_FMFUSE
WHERE...

How to access SAP table FMFUSE

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

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