FINCS_FSIASSGMT

Transparent Table Customizing Table
18 Fields 6 CDS Views

FS Item Assignments, Version- and Year-Period-Dependent

FINCS_FSIASSGMT is an SAP database table in S/4HANA. FS Item Assignments, Version- and Year-Period-Dependent. It contains 18 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_CnsldtnFSItemByTimeVersion view_entity from EXTENSION Financial Statement Item - Extension
I_CnsldtnFinStmntItemAssgmt view from BASIC Financial Statement Item Assignment
ICA_FS_ITEM view from
P_CnsldtnFSItemByTimeVersion view from BASIC Consolidation FS Item by Time Version
P_CnsldtnTargetFSItemAssgmt_2 view from BASIC
P_FSItemAttributeAssignment_2 view from BASIC

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY itclg FC_ITCLG Cons. COA
KEY item FINCS_FSI_ITEM FS Item
KEY iatvs FC_IATVS FS Item Attributes
KEY fromyearper FINCS_FISCALYEARPER Fiscal Year Period
toyearper FINCS_FISCALYEARPER Fiscal Year Period
sa_role FINCS_FSI_ROLE FS Item Role
sa_data_collection FINCS_FSI_DATA_COLLECTION Data Coll. Attrib.
sa_currency_translation FINCS_FSI_CURRENCY_TRANSLATION Crcy Transl. Attrib.
sa_elimination FINCS_FSI_ELIMINATION Elimination Attrib.
sa_cash_flow FINCS_FSI_CASH_FLOW Cash Flow Attribute
sa_scope FINCS_FSI_SCOPE Scope Attribute
sa_customer_specific FINCS_FSI_CUSTOMER_SPECIFIC Other Sel. Attribute
ta_elimination FINCS_FSI_ELIMINATION_TARGET Elimination Target
ta_nci FINCS_FSI_NCI_TARGET NCI Target
ta_planning FINCS_FSI_PLANNING_TARGET Planning Target
ta_offsetting FINCS_FSI_OFFSETTING_TARGET Offsetting Target
dummy_fincs_fsi_tv_incl_eew_ps CFD_DUMMY Dummy

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.

-- FS Item Assignments, Version- and Year-Period-Dependent
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_FSIASSGMT (
    MANDT,                           -- Client [MANDT]
    ITCLG,                           -- Cons. COA [FC_ITCLG]
    ITEM,                            -- FS Item [FINCS_FSI_ITEM]
    IATVS,                           -- FS Item Attributes [FC_IATVS]
    FROMYEARPER,                     -- Fiscal Year Period [FINCS_FISCALYEARPER]
    TOYEARPER,                       -- Fiscal Year Period [FINCS_FISCALYEARPER]
    SA_ROLE,                         -- FS Item Role [FINCS_FSI_ROLE]
    SA_DATA_COLLECTION,              -- Data Coll. Attrib. [FINCS_FSI_DATA_COLLECTION]
    SA_CURRENCY_TRANSLATION,         -- Crcy Transl. Attrib. [FINCS_FSI_CURRENCY_TRANSLATION]
    SA_ELIMINATION,                  -- Elimination Attrib. [FINCS_FSI_ELIMINATION]
    SA_CASH_FLOW,                    -- Cash Flow Attribute [FINCS_FSI_CASH_FLOW]
    SA_SCOPE,                        -- Scope Attribute [FINCS_FSI_SCOPE]
    SA_CUSTOMER_SPECIFIC,            -- Other Sel. Attribute [FINCS_FSI_CUSTOMER_SPECIFIC]
    TA_ELIMINATION,                  -- Elimination Target [FINCS_FSI_ELIMINATION_TARGET]
    TA_NCI,                          -- NCI Target [FINCS_FSI_NCI_TARGET]
    TA_PLANNING,                     -- Planning Target [FINCS_FSI_PLANNING_TARGET]
    TA_OFFSETTING,                   -- Offsetting Target [FINCS_FSI_OFFSETTING_TARGET]
    DUMMY_FINCS_FSI_TV_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, ITCLG, ITEM, IATVS, FROMYEARPER)
);

Learn More