FMFINCODE
FIFM: Finanzierungscode
FMFINCODE is an SAP database table in S/4HANA. FIFM: Finanzierungscode. It contains 21 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_Fund | view | from | EXTENSION | Manage Fund Extension |
| I_FundBasic | view | from | BASIC | Fund |
| PSM_FMFUNDBPD | view | cross | Common CDS for FMFUNDBPD in CE and OP |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | fikrs | fikrs | FM Area | |||
| KEY | fincode | bp_geber | Fund | |||
| sponsor | fm_sponsor | Customer for Fund | ||||
| finuse | fm_finuse | Application of Funds | ||||
| erfname | fm_erfname | Created By | ||||
| erfdat | fm_erfdat | Entered On | ||||
| aenname | fm_aenname | Changed By | ||||
| aendat | fm_aendat | Changed On | ||||
| profil | bp_prof_sp | Fund profile | ||||
| kzbst | fm_kzbst | Balance Update | ||||
| augrp | fm_authgrf | Authoriz. Group | ||||
| datab | fm_datab | Valid From | ||||
| datbis | fm_datbis | Valid To | ||||
| periv | periv | FY Variant | ||||
| type | fm_fundtype | Fund Type | ||||
| date_exp | fm_date_exp | Expiration Date | ||||
| date_can | fm_date_can | Reversal Date | ||||
| logsystem | logsystem | Logical System | ||||
| deckung | fm_deckung | Eligible f.Covr | ||||
| periodicity | psm_fund_periodicity | Frequency |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- FIFM: Finanzierungscode
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMFINCODE (
MANDT, -- Client [mandt]
FIKRS, -- FM Area [fikrs]
FINCODE, -- Fund [bp_geber]
SPONSOR, -- Customer for Fund [fm_sponsor]
FINUSE, -- Application of Funds [fm_finuse]
ERFNAME, -- Created By [fm_erfname]
ERFDAT, -- Entered On [fm_erfdat]
AENNAME, -- Changed By [fm_aenname]
AENDAT, -- Changed On [fm_aendat]
PROFIL, -- Fund profile [bp_prof_sp]
KZBST, -- Balance Update [fm_kzbst]
AUGRP, -- Authoriz. Group [fm_authgrf]
DATAB, -- Valid From [fm_datab]
DATBIS, -- Valid To [fm_datbis]
PERIV, -- FY Variant [periv]
TYPE, -- Fund Type [fm_fundtype]
DATE_EXP, -- Expiration Date [fm_date_exp]
DATE_CAN, -- Reversal Date [fm_date_can]
LOGSYSTEM, -- Logical System [logsystem]
DECKUNG, -- Eligible f.Covr [fm_deckung]
PERIODICITY, -- Frequency [psm_fund_periodicity]
PRIMARY KEY (MANDT, FIKRS, FINCODE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA