FMFINCODE

Transparent Table Application Table
46 Fields 4 CDS Views

FIFM: Financing code

FMFINCODE is an SAP database table in S/4HANA. FIFM: Financing code. It contains 46 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
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
SHSM_EFDITM_2_GEBER view_entity from Fund for Earmarked funds search help

Fields (46)

KeyField Data ElementDescription DomainTypeLength
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
dummy DUMMY Dummy function in length 1
lnca PFM_1LANC Postable?
cgp PFM_1CGP Classif.large proj.
cic PFM_1CIC Classif.maint.inv.
freg PFM_1FREG Parishes
resp PFM_1RESP Resp.for proj.
ffac PFM_1FFAC Central admin.
ffaa PFM_1FFAA Municipal admin.
fffc PFM_1FFFC Community funds
dini FM_DATAB Valid From
dfim FM_DATBIS Valid To
ffin PFM_01FONTEFINANCIAMENTO Financing source
prog PFM_01PROGRAMA Program
medi PFM_01MEDIDA Measure
proj PFM_01PROJECTO Project
subproj PFM_01SUBPROJECTO Subroject
acti PFM_01ACTIVIDADE Activity
pfm_poic PFM_POIC Program Code
pfm_go PFM_GO Operational Manager
psm_fm_fund_dummy_ps CFD_DUMMY Dummy
fund_resp FUND_RESP_USER User Responsible
blank_bpd FM_BLANK_BPD Blank BP Allowed
str_id FM_STR_ID Subdivision ID
fdsub1 FM_FDSUB1 FD Substring 1
fdsub2 FM_FDSUB2 FD Substring 2

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: Financing code
-- 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]
    DUMMY,                 -- Dummy function in length 1 [DUMMY]
    LNCA,                  -- Postable? [PFM_1LANC]
    CGP,                   -- Classif.large proj. [PFM_1CGP]
    CIC,                   -- Classif.maint.inv. [PFM_1CIC]
    FREG,                  -- Parishes [PFM_1FREG]
    RESP,                  -- Resp.for proj. [PFM_1RESP]
    FFAC,                  -- Central admin. [PFM_1FFAC]
    FFAA,                  -- Municipal admin. [PFM_1FFAA]
    FFFC,                  -- Community funds [PFM_1FFFC]
    DINI,                  -- Valid From [FM_DATAB]
    DFIM,                  -- Valid To [FM_DATBIS]
    FFIN,                  -- Financing source [PFM_01FONTEFINANCIAMENTO]
    PROG,                  -- Program [PFM_01PROGRAMA]
    MEDI,                  -- Measure [PFM_01MEDIDA]
    PROJ,                  -- Project [PFM_01PROJECTO]
    SUBPROJ,               -- Subroject [PFM_01SUBPROJECTO]
    ACTI,                  -- Activity [PFM_01ACTIVIDADE]
    PFM_POIC,              -- Program Code [PFM_POIC]
    PFM_GO,                -- Operational Manager [PFM_GO]
    PSM_FM_FUND_DUMMY_PS,  -- Dummy [CFD_DUMMY]
    FUND_RESP,             -- User Responsible [FUND_RESP_USER]
    BLANK_BPD,             -- Blank BP Allowed [FM_BLANK_BPD]
    STR_ID,                -- Subdivision ID [FM_STR_ID]
    FDSUB1,                -- FD Substring 1 [FM_FDSUB1]
    FDSUB2,                -- FD Substring 2 [FM_FDSUB2]
    PRIMARY KEY (MANDT, FIKRS, FINCODE)
);

Learn More