FINCS_FSIASSGMT

Transparent Table Customizing Table
17 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 17 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 ICA - FS Item Access
P_CnsldtnFSItemByTimeVersion view from BASIC Consolidation FS Item by Time Version
P_CnsldtnTargetFSItemAssgmt_2 view from BASIC FS Item Target Attribute Assignment
P_FSItemAttributeAssignment_2 view from BASIC FS Item Attribute Assignment

Fields (17)

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

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]
    PRIMARY KEY (MANDT, ITCLG, ITEM, IATVS, FROMYEARPER)
);

Learn More