SAP table FMFINCODE (FIFM: Financing code)
SAP table FMFINCODE has 3 primary key fields being MANDT,FIKRS,FINCODE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| FIKRS | Financial Management Area | CHAR | 4 | 0 | FM01 | FIKRS | |
| FINCODE | Fund | CHAR | 10 | 0 | BP_GEBER | ||
| SPONSOR | Customer Account Number for Fund | CHAR | 10 | 0 | KNA1 | FM_SPONSOR | |
| FINUSE | Application of Funds | CHAR | 16 | 0 | FMFUSE | FM_FINUSE | |
| ERFNAME | FIFM: Created By | CHAR | 12 | 0 | FM_ERFNAME | ||
| ERFDAT | FIFM: Entry Date | DATS | 8 | 0 | FM_ERFDAT | ||
| AENNAME | FIFM: Name of Last Person to Make a Change | CHAR | 12 | 0 | FM_AENNAME | ||
| AENDAT | FIFM: Changed On | DATS | 8 | 0 | FM_AENDAT | ||
| PROFIL | Budget profile for fund | CHAR | 6 | 0 | BP_PROF_SP | ||
| KZBST | "Balance Update" Indicator | CHAR | 1 | 0 | FM_KZBST | ||
| AUGRP | Fund Authorization Group | CHAR | 10 | 0 | FM_AUTHGRF | ||
| DATAB | FM: Valid-From Date | DATS | 8 | 0 | FM_DATAB | ||
| DATBIS | FM: Valid-To Date | DATS | 8 | 0 | FM_DATBIS | ||
| PERIV | Fiscal Year Variant | CHAR | 2 | 0 | T009 | PERIV | |
| TYPE | FM Fund Type | CHAR | 6 | 0 | FMFUNDTYPE | FM_FUNDTYPE | |
| DATE_EXP | Expiration Date | DATS | 8 | 0 | FM_DATE_EXP | ||
| DATE_CAN | Reversal Date | DATS | 8 | 0 | FM_DATE_CAN | ||
| LOGSYSTEM | Logical System | CHAR | 10 | 0 | TBDLS | LOGSYSTEM | |
| DECKUNG | Relevant for Real Cover Eligibility | CHAR | 1 | 0 | FM_DECKUNG | ||
| PERIODICITY | Fund Frequency | CHAR | 10 | 0 | PSM_D_PRDICITY | PSM_FUND_PERIODICITY | |
| DUMMY | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY | ||
| LNCA | Postable? | CHAR | 1 | 0 | PFM_1LANC | ||
| CGP | Classification in large projects | CHAR | 1 | 0 | PFM_1CGP | ||
| CIC | Classification in maintenance investments | CHAR | 1 | 0 | PFM_1CIC | ||
| FREG | Parishes | CHAR | 2 | 0 | * | PFM_1FREG | |
| RESP | Responsible for project | CHAR | 16 | 0 | * | PFM_1RESP | |
| FFAC | Financing source - Central administration | NUMC | 3 | 0 | PFM_1FFAC | ||
| FFAA | Financing source - Municipal administration | NUMC | 3 | 0 | PFM_1FFAA | ||
| FFFC | Financing source - Community funds | NUMC | 3 | 0 | PFM_1FFFC | ||
| DINI | FM: Valid-From Date | DATS | 8 | 0 | FM_DATAB | ||
| DFIM | FM: Valid-To Date | DATS | 8 | 0 | FM_DATBIS | ||
| FFIN | Financing source | CHAR | 3 | 0 | PFM_TFFIN | PFM_01FONTEFINANCIAMENTO | |
| PROG | Program | CHAR | 3 | 0 | PFM_TPROG | PFM_01PROGRAMA | |
| MEDI | Measure | CHAR | 3 | 0 | PFM_TMEDI | PFM_01MEDIDA | |
| PROJ | Project | CHAR | 5 | 0 | PFM_TPROJ | PFM_01PROJECTO | |
| SUBPROJ | Subproject | CHAR | 5 | 0 | PFM_TSUBPROJ | PFM_01SUBPROJECTO | |
| ACTI | Activity | CHAR | 3 | 0 | PFM_TACTIV | PFM_01ACTIVIDADE | |
| PFM_POIC | Code of Operational Program (European Initiative) | CHAR | 14 | 0 | PFM_TPOIC | PFM_POIC | |
| PFM_GO | Operational Manager Code | CHAR | 3 | 0 | PFM_TGO | PFM_GO | |
| PSM_FM_FUND_DUMMY_PS | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||
| BLANK_BPD | Indicator: Blank Budget Period Allowed | CHAR | 1 | 0 | FM_BLANK_BPD | ||
| STR_ID | Master Data Subdivision ID | CHAR | 10 | 0 | FMMDSTRID | FM_STR_ID | |
| FDSUB1 | Substring 1 of Fund | CHAR | 10 | 0 | FMMDFDSUB1 | FM_FDSUB1 | |
| FDSUB2 | Substring 2 of Fund | CHAR | 10 | 0 | FMMDFDSUB2 | FM_FDSUB2 |
FMFINCODE foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 FMFINCODE | ACTI | PFM_TACTIV | Additional data: funds - activity | MANDT |
| 0 FMFINCODE | ACTI | PFM_TACTIV | Additional data: funds - activity | BEGDA |
| 1 FMFINCODE | FDSUB1 | FMMDFDSUB1 | Value of Substring 1 of Fund | MANDT |
| 1 FMFINCODE | FDSUB1 | FMMDFDSUB1 | Value of Substring 1 of Fund | FDSUB1 |
| 0 FMFINCODE | FDSUB2 | FMMDFDSUB2 | Value of Substring 2 of Fund | MANDT |
| 0 FMFINCODE | FDSUB2 | FMMDFDSUB2 | Value of Substring 2 of Fund | FDSUB2 |
| 1 FMFINCODE | FFIN | PFM_TFFIN | Funds additional data - financing source | MANDT |
| 1 FMFINCODE | FFIN | PFM_TFFIN | Funds additional data - financing source | BEGDA |
| 0 FMFINCODE | FIKRS | FM01 | Financial Management Areas | FIKRS |
| 1 FMFINCODE | FINUSE | FMFUSE | FIFM: Application of Funds from Secondary Sources | FIKRS |
| 0 FMFINCODE | LOGSYSTEM | TBDLS | Logical system | LOGSYS |
| 1 FMFINCODE | MANDT | T000 | Clients | MANDT |
| 0 FMFINCODE | MEDI | PFM_TMEDI | Addit.data funds - measure | MANDT |
| 0 FMFINCODE | MEDI | PFM_TMEDI | Addit.data funds - measure | PROG |
| 0 FMFINCODE | MEDI | PFM_TMEDI | Addit.data funds - measure | BEGDA |
| 1 FMFINCODE | PERIODICITY | PSM_D_PRDICITY | Periodicity Type | CLIENT |
| 1 FMFINCODE | PERIODICITY | PSM_D_PRDICITY | Periodicity Type | PERIODICITY |
| 0 FMFINCODE | PERIV | T009 | Fiscal Year Variants | MANDT |
| 0 FMFINCODE | PERIV | T009 | Fiscal Year Variants | PERIV |
| 1 FMFINCODE | PFM_GO | PFM_TGO | Operational Managers | MANDT |
| 0 FMFINCODE | PFM_POIC | PFM_TPOIC | Operational Programs (European Initiatives) | MANDT |
| 1 FMFINCODE | PROG | PFM_TPROG | Additional data funds - program | MANDT |
| 1 FMFINCODE | PROG | PFM_TPROG | Additional data funds - program | PROG |
| 1 FMFINCODE | PROG | PFM_TPROG | Additional data funds - program | BEGDA |
| 0 FMFINCODE | PROJ | PFM_TPROJ | Additional data funds - project | MANDT |
| 0 FMFINCODE | PROJ | PFM_TPROJ | Additional data funds - project | PROJ |
| 0 FMFINCODE | PROJ | PFM_TPROJ | Additional data funds - project | BEGDA |
| 1 FMFINCODE | SPONSOR | KNA1 | General Data in Customer Master | MANDT |
| 1 FMFINCODE | SPONSOR | KNA1 | General Data in Customer Master | KUNNR |
| 0 FMFINCODE | STR_ID | FMMDSTRID | Define Subdivision ID of FM Master Data | MASDAT_ID |
| 0 FMFINCODE | STR_ID | FMMDSTRID | Define Subdivision ID of FM Master Data | STR_ID |
| 1 FMFINCODE | SUBPROJ | PFM_TSUBPROJ | Additional data funds - project and subproject | MANDT |
| 1 FMFINCODE | SUBPROJ | PFM_TSUBPROJ | Additional data funds - project and subproject | SUBPROJ |
| 1 FMFINCODE | SUBPROJ | PFM_TSUBPROJ | Additional data funds - project and subproject | BEGDA |
| 0 FMFINCODE | TYPE | FMFUNDTYPE | FM Fund Types | MANDT |
| 0 FMFINCODE | TYPE | FMFUNDTYPE | FM Fund Types | FM_AREA |