The FMFINCODE table in SAP ERP or S/4HANA stores FIFM: Financing code data. There are total 44 fields in FMFINCODE table. The FIFM: Financing code table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMFINCODE table. It is in Funds Management: Master Data Core Objects (FMMD_CORE) ABAP package and is part of the Master Data (PSM-FM-MD) module.
SAP FMFINCODE Table Fields
Following is the list of fields that are available in SAP FMFINCODE table. The primary key fields of the table are MANDT (Client), FIKRS (Financial Management Area), FINCODE (Fund).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| FIKRS | Financial Management Area | FIKRS | FM01 | CHAR (4) |
| FINCODE | Fund | BP_GEBER | CHAR (10) | |
| SPONSOR | Customer Account Number for Fund | FM_SPONSOR | KNA1 | CHAR (10) |
| FINUSE | Application of Funds | FM_FINUSE | FMFUSE | CHAR (16) |
| ERFNAME | FIFM: Created By | FM_ERFNAME | CHAR (12) | |
| ERFDAT | FIFM: Entry Date | FM_ERFDAT | DATS (8) | |
| AENNAME | FIFM: Name of Last Person to Make a Change | FM_AENNAME | CHAR (12) | |
| AENDAT | FIFM: Changed On | FM_AENDAT | DATS (8) | |
| PROFIL | Budget profile for fund | BP_PROF_SP | CHAR (6) | |
| KZBST | Balance Update Indicator | FM_KZBST | CHAR (1) | |
| AUGRP | Fund Authorization Group | FM_AUTHGRF | CHAR (10) | |
| DATAB | FM: Valid-From Date | FM_DATAB | DATS (8) | |
| DATBIS | FM: Valid-To Date | FM_DATBIS | DATS (8) | |
| PERIV | Fiscal Year Variant | PERIV | T009 | CHAR (2) |
| TYPE | FM Fund Type | FM_FUNDTYPE | FMFUNDTYPE | CHAR (6) |
| DATE_EXP | Expiration Date | FM_DATE_EXP | DATS (8) | |
| DATE_CAN | Reversal Date | FM_DATE_CAN | DATS (8) | |
| LOGSYSTEM | Logical System | LOGSYSTEM | TBDLS | CHAR (10) |
| DECKUNG | Relevant for Real Cover Eligibility | FM_DECKUNG | CHAR (1) | |
| PERIODICITY | Fund Frequency | PSM_FUND_PERIODICITY | PSM_D_PRDICITY | CHAR (10) |
| DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) | |
| LNCA | Postable? | PFM_1LANC | CHAR (1) | |
| CGP | Classification in large projects | PFM_1CGP | CHAR (1) | |
| CIC | Classification in maintenance investments | PFM_1CIC | CHAR (1) | |
| FREG | Parishes | PFM_1FREG | * | CHAR (2) |
| RESP | Responsible for project | PFM_1RESP | * | CHAR (16) |
| FFAC | Financing source – Central administration | PFM_1FFAC | NUMC (3) | |
| FFAA | Financing source – Municipal administration | PFM_1FFAA | NUMC (3) | |
| FFFC | Financing source – Community funds | PFM_1FFFC | NUMC (3) | |
| DINI | FM: Valid-From Date | FM_DATAB | DATS (8) | |
| DFIM | FM: Valid-To Date | FM_DATBIS | DATS (8) | |
| FFIN | Financing source | PFM_01FONTEFINANCIAMENTO | PFM_TFFIN | CHAR (3) |
| PROG | Program | PFM_01PROGRAMA | PFM_TPROG | CHAR (3) |
| MEDI | Measure | PFM_01MEDIDA | PFM_TMEDI | CHAR (3) |
| PROJ | Project | PFM_01PROJECTO | PFM_TPROJ | CHAR (5) |
| SUBPROJ | Subproject | PFM_01SUBPROJECTO | PFM_TSUBPROJ | CHAR (5) |
| ACTI | Activity | PFM_01ACTIVIDADE | PFM_TACTIV | CHAR (3) |
| PFM_POIC | Code of Operational Program (European Initiative) | PFM_POIC | PFM_TPOIC | CHAR (14) |
| PFM_GO | Operational Manager Code | PFM_GO | PFM_TGO | CHAR (3) |
| BLANK_BPD | Indicator: Blank Budget Period Allowed | FM_BLANK_BPD | CHAR (1) | |
| STR_ID | Master Data Subdivision ID | FM_STR_ID | FMMDSTRID | CHAR (10) |
| FDSUB1 | Substring 1 of Fund | FM_FDSUB1 | FMMDFDSUB1 | CHAR (10) |
| FDSUB2 | Substring 2 of Fund | FM_FDSUB2 | FMMDFDSUB2 | CHAR (10) |
