FMFUSE

Transparent Table Application Table
26 Fields 4 CDS Views

FIFM: Application of Funds from Secondary Sources

FMFUSE is an SAP database table in S/4HANA. FIFM: Application of Funds from Secondary Sources. It contains 26 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_ApplicationOfFund view from EXTENSION Application of Fund Extension
I_ApplicationOfFundBasic view from BASIC Application of Fund
I_USFedApplSecdrySrceFunds view from BASIC US Federal Application of Secondary Source Funds
I_USFEDAPPLSECDRYSRCEFUNDVH view from BASIC US Federal Application of Secondary Source Funds

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fikrs FIKRS FM Area
KEY finuse FM_FINUSE Application of Funds
datab FM_DATAB Valid From
datbis FM_DATBIS Valid To
erfname FM_ERFNAME Created By
erfdat FM_ERFDAT Entered On
aenname FM_AENNAME Changed By
aendat FM_AENDAT Changed On
dept_reg FM_DEPT_REG Dept regular
dept_tran FM_DEPT_TRAN Dept transfer
fiscal_yr CHAR4 Undefined range (can be used for patch levels)
main_acct FM_MAIN_ACCT Main Acct
sub_acct FM_SUB_ACCT Sub account
split_num FM_SPLIT_NUM Split seq no
factsii_rel FMFG_FACTSII_REL Relevant
preparerid FM_PREPARER Preparer ID
certifierid FMFG_CERTIFIERID Certifier
dummy_fmaf_incl_eew_ps CFD_DUMMY Dummy
gtas_rel FMFG_GTAS_REL GTAS Relevant
sublevl FMFG_SUBLEVL Sublevel Prefix
agencid FMFG_AGENCID Agency ID
altraid FMFG_ALTRAID Alloc Transfr Agency
begper FMFG_BEGPER Begin Prd of Avail
endper FMFG_ENDPER Ending Prd of Avail
avtype FMFG_AVTYPE Avail Type Code

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: Application of Funds from Secondary Sources
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMFUSE (
    MANDT,                   -- Client [MANDT]
    FIKRS,                   -- FM Area [FIKRS]
    FINUSE,                  -- Application of Funds [FM_FINUSE]
    DATAB,                   -- Valid From [FM_DATAB]
    DATBIS,                  -- Valid To [FM_DATBIS]
    ERFNAME,                 -- Created By [FM_ERFNAME]
    ERFDAT,                  -- Entered On [FM_ERFDAT]
    AENNAME,                 -- Changed By [FM_AENNAME]
    AENDAT,                  -- Changed On [FM_AENDAT]
    DEPT_REG,                -- Dept regular [FM_DEPT_REG]
    DEPT_TRAN,               -- Dept transfer [FM_DEPT_TRAN]
    FISCAL_YR,               -- Undefined range (can be used for patch levels) [CHAR4]
    MAIN_ACCT,               -- Main Acct [FM_MAIN_ACCT]
    SUB_ACCT,                -- Sub account [FM_SUB_ACCT]
    SPLIT_NUM,               -- Split seq no [FM_SPLIT_NUM]
    FACTSII_REL,             -- Relevant [FMFG_FACTSII_REL]
    PREPARERID,              -- Preparer ID [FM_PREPARER]
    CERTIFIERID,             -- Certifier [FMFG_CERTIFIERID]
    DUMMY_FMAF_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    GTAS_REL,                -- GTAS Relevant [FMFG_GTAS_REL]
    SUBLEVL,                 -- Sublevel Prefix [FMFG_SUBLEVL]
    AGENCID,                 -- Agency ID [FMFG_AGENCID]
    ALTRAID,                 -- Alloc Transfr Agency [FMFG_ALTRAID]
    BEGPER,                  -- Begin Prd of Avail [FMFG_BEGPER]
    ENDPER,                  -- Ending Prd of Avail [FMFG_ENDPER]
    AVTYPE,                  -- Avail Type Code [FMFG_AVTYPE]
    PRIMARY KEY (MANDT, FIKRS, FINUSE)
);

Learn More