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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
BLANK_BPD
Indicator: Blank Budget Period Allowed
|
FM_BLANK_BPD |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | SYST | MANDT |
FMMDFDSUB2
Value of Substring 2 of Fund
|
MANDT |
| 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 | FIKRS | FMFINCODE | MANDT |
FM01
Financial Management Areas
|
MANDT |
| FMFINCODE | FIKRS | FMFINCODE | FIKRS |
FM01
Financial Management Areas
|
FIKRS |
| FMFINCODE | FINUSE | FMFINCODE | FIKRS |
FMFUSE
FIFM: Application of Funds from Secondary Sources
|
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 | 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 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| FMFINCODE | SPONSOR | FMFINCODE | SPONSOR |
KNA1
General Data in Customer Master
|
KUNNR |
| FMFINCODE | STR_ID | FMFINCODE | STR_ID |
FMMDSTRID
Define Subdivision ID of FM Master Data
|
STR_ID |
| 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 | 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 |