SAP FMFINCODE FIFM: Financing code Table data and field list

FMFINCODE is a standard SAP Table which is used to store FIFM: Financing code data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMFINCODE table consists of various fields, each holding specific information or linking keys about FIFM: Financing code data available in SAP. These include FIKRS (Financial Management Area), FINCODE (Fund), SPONSOR (Customer account number for fund), FINUSE (Application of Secondary Source Funds)... 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. .

FMFINCODE 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 or numeric)

Text table = FMFINT

SAP FMFINCODE 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 FMFINCODE 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
FINCODE	Fund	BP_GEBER	CHAR	10			BP_GEBER	FIC
SPONSOR	Customer account number for fund	FM_SPONSOR	CHAR	10	KNA1	ALPHA	KUNNR	KUN
FINUSE	Application of Secondary Source Funds	FM_FINUSE	CHAR	16	FMFUSE		FM_FINUSE	FIU
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
PROFIL	Budget profile for fund	BP_PROF_SP	CHAR	6	Assigned to domain		BP_PROFIL	BP1
KZBST	'Balance update' indicator	FM_KZBST	CHAR	1			FM_KZBST
AUGRP	FM: Fund authorization group	FM_AUTHGRF	CHAR	10			CHAR10
DATAB	FM: Valid from date	FM_DATAB	DATS	8			DATUM	FM_DATAB
DATBIS	FM: Valid to date	FM_DATBIS	DATS	8			DATUM	FM_DATBIS
PERIV	Fiscal Year Variant	PERIV	CHAR	2	T009		PERIV
TYPE	FM Fund Type	FM_FUNDTYPE	CHAR	6	FMFUNDTYPE		FM_FUNDTYPE
DATE_EXP	Expiration Date	FM_DATE_EXP	DATS	8			DATUM
DATE_CAN	Reversal Date	FM_DATE_CAN	DATS	8			DATUM
LOGSYSTEM	Logical System	LOGSYSTEM	CHAR	10	TBDLS	ALPHA	LOGSYS
DECKUNG	Relevant for Real Cover Eligibility	FM_DECKUNG	CHAR	1			XFELD
.INCLU--AP				0
BLANK_BPD	Indicator: Blank Budget Period Allowed	FM_BLANK_BPD	CHAR	1			XFELD
.INCLU--AP				0
STR_ID	Master Data Subdivision ID	FM_STR_ID	CHAR	10	FMMDSTRID		CHAR10	FMS
FDSUB1	Substring 1 of Fund	FM_FDSUB1	CHAR	10	FMMDFDSUB1		CHAR10
FDSUB2	Substring 2 of Fund	FM_FDSUB2	CHAR	10	FMMDFDSUB2		CHAR10

Key field

Non-key field

< FMFINBTR - FMFINCODEB - Fund master strucure for change documents >

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

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

SELECT SINGLE *
FROM FMFINCODE
INTO CORRESPONDING FIELDS OF WA_FMFINCODE
WHERE...

How to access SAP table FMFINCODE

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

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