SAP Table FMFINCODE

FIFM: Financing code

FMFINCODE (FIFM: Financing code) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FMFINCODE to other SAP tables.

FMFINCODE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FIKRS Financial Management Area FIKRS FM01 CHAR 4 0
FINCODE Fund BP_GEBER CHAR 10 0
SPONSOR Customer account number for fund FM_SPONSOR KNA1 CHAR 10 0
FINUSE Application of Secondary Source Funds FM_FINUSE FMFUSE CHAR 16 0
ERFNAME FIFM: Created by FM_ERFNAME CHAR 12 0
ERFDAT FIFM: Entry Date FM_ERFDAT DATS 8 0
AENNAME FIFM: Name of Last Person to Make a Change FM_AENNAME CHAR 12 0
AENDAT FIFM: Changed on FM_AENDAT DATS 8 0
PROFIL Budget profile for fund BP_PROF_SP CHAR 6 0
KZBST "Balance update" indicator FM_KZBST CHAR 1 0
AUGRP FM: Fund authorization group FM_AUTHGRF CHAR 10 0
DATAB FM: Valid from date FM_DATAB DATS 8 0
DATBIS FM: Valid to date FM_DATBIS DATS 8 0
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
TYPE FM Fund Type FM_FUNDTYPE FMFUNDTYPE CHAR 6 0
DATE_EXP Expiration Date FM_DATE_EXP DATS 8 0
DATE_CAN Reversal Date FM_DATE_CAN DATS 8 0
LOGSYSTEM Logical System LOGSYSTEM TBDLS CHAR 10 0
DECKUNG Relevant for Real Cover Eligibility FM_DECKUNG CHAR 1 0
X Yes
NULL No
BLANK_BPD Indicator: Blank Budget Period Allowed FM_BLANK_BPD CHAR 1 0
X Yes
NULL No
STR_ID Master Data Subdivision ID FM_STR_ID FMMDSTRID CHAR 10 0
FDSUB1 Substring 1 of Fund FM_FDSUB1 FMMDFDSUB1 CHAR 10 0
FDSUB2 Substring 2 of Fund FM_FDSUB2 FMMDFDSUB2 CHAR 10 0

FMFINCODE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMFINCODE FDSUB1 SYST MANDT FMMDFDSUB1 Value of Substring 1 of Fund MANDT
FMFINCODE FDSUB1 FMFINCODE STR_ID FMMDFDSUB1 Value of Substring 1 of Fund STR_ID
FMFINCODE FDSUB1 FMFINCODE FDSUB1 FMMDFDSUB1 Value of Substring 1 of Fund FDSUB1
FMFINCODE FDSUB2 FMFINCODE STR_ID FMMDFDSUB2 Value of Substring 2 of Fund STR_ID
FMFINCODE FDSUB2 FMFINCODE FDSUB2 FMMDFDSUB2 Value of Substring 2 of Fund FDSUB2
FMFINCODE FDSUB2 SYST MANDT FMMDFDSUB2 Value of Substring 2 of Fund MANDT
FMFINCODE FIKRS FMFINCODE MANDT FM01 Financial Management Areas MANDT
FMFINCODE FIKRS FMFINCODE FIKRS FM01 Financial Management Areas FIKRS
FMFINCODE FINUSE FMFINCODE FINUSE FMFUSE FIFM: Application of Funds from Secondary Sources FINUSE
FMFINCODE FINUSE FMFINCODE MANDT FMFUSE FIFM: Application of Funds from Secondary Sources MANDT
FMFINCODE FINUSE FMFINCODE FIKRS FMFUSE FIFM: Application of Funds from Secondary Sources FIKRS
FMFINCODE LOGSYSTEM FMFINCODE LOGSYSTEM TBDLS Logical system LOGSYS
FMFINCODE MANDT FMFINCODE MANDT T000 Clients MANDT
FMFINCODE PERIV FMFINCODE MANDT T009 Fiscal Year Variants MANDT
FMFINCODE PERIV FMFINCODE PERIV T009 Fiscal Year Variants PERIV
FMFINCODE SPONSOR FMFINCODE SPONSOR KNA1 General Data in Customer Master KUNNR
FMFINCODE SPONSOR FMFINCODE MANDT KNA1 General Data in Customer Master MANDT
FMFINCODE STR_ID SYST MANDT FMMDSTRID Define Subdivision ID of FM Master Data MANDT
FMFINCODE STR_ID '3' FMMDSTRID Define Subdivision ID of FM Master Data MASDAT_ID
FMFINCODE STR_ID FMFINCODE STR_ID FMMDSTRID Define Subdivision ID of FM Master Data STR_ID
FMFINCODE TYPE FMFINCODE MANDT FMFUNDTYPE FM Fund Types MANDT
FMFINCODE TYPE FMFINCODE FIKRS FMFUNDTYPE FM Fund Types FM_AREA
FMFINCODE TYPE FMFINCODE TYPE FMFUNDTYPE FM Fund Types FUND_TYPE