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 |
Possible values
|
||||||
| BLANK_BPD | Indicator: Blank Budget Period Allowed | FM_BLANK_BPD | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
