FINCS_FSITEM_WA

Transparent Table Application Table
33 Fields 3 CDS Views

Consolidation Financial Statement Item Upload Work Area

FINCS_FSITEM_WA is an SAP database table in S/4HANA. Consolidation Financial Statement Item Upload Work Area. It contains 33 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CnsldtnMDUpldFSItem view_entity from EXTENSION Financial Statement Item - Extension
I_CnsldtnMDUpldFSItemWrkArea view from BASIC Consolidation FS-Item Work Area
I_CnsldtnMDUpldFSItemWrkArea_2 view_entity from BASIC Consolidation FS Item Upload Work Area

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uuid FINCS_UUID UUID
username SYST_UNAME User Name
status FINCS_MD_UPL_STATUS Status
status_detail FINCS_MD_UPL_STATUS_DETAIL Status Detail
itclg FC_ITCLG Cons. COA
rvers FC_RVERS Version
fiscyearper FINCS_FISCALYEARPER Fiscal Year Period
langu SPRAS Language
item FC_ITEM FS Item
txtsh FC_TXTSH Short Text
txtmi FC_TXTMI_I Medium Text
txtlg FC_TXTLG_I Long Text
itclass FINCS_ITTYPE Item Type
itbrkdwn FINCS_ITBRKDWN Breakdown Category
itblkd FINCS_ITBLKD Blocked for Posting
itcitem FINCS_ITCITEM Consolidation Item
itnbcf FINCS_ITNBCF Carry Fwd Balances
sa_elimination FINCS_FSI_ATTRIBUTE_VALUE_NAME Attribute Value Name
sa_currency_translation FINCS_FSI_ATTRIBUTE_VALUE_NAME Attribute Value Name
sa_data_collection FINCS_FSI_DATA_COLLECTION Data Coll. 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
role FINCS_FSI_ATTRIBUTE_VALUE_NAME Attribute Value Name
ta_elimination FC_ITEM_TARGET Target Item
ta_nci FC_ITEM_TARGET Target Item
ta_planning FC_ITEM_TARGET Target Item
ta_offsetting FC_ITEM_TARGET Target Item
linklabel FINCS_LINK_LABEL Link Title
link FINCS_LINK Link URL
dummy_fincs_fsi_h_incl_eew_ps CFD_DUMMY Dummy
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.

-- Consolidation Financial Statement Item Upload Work Area
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_FSITEM_WA (
    MANDT,                           -- Client [MANDT]
    UUID,                            -- UUID [FINCS_UUID]
    USERNAME,                        -- User Name [SYST_UNAME]
    STATUS,                          -- Status [FINCS_MD_UPL_STATUS]
    STATUS_DETAIL,                   -- Status Detail [FINCS_MD_UPL_STATUS_DETAIL]
    ITCLG,                           -- Cons. COA [FC_ITCLG]
    RVERS,                           -- Version [FC_RVERS]
    FISCYEARPER,                     -- Fiscal Year Period [FINCS_FISCALYEARPER]
    LANGU,                           -- Language [SPRAS]
    ITEM,                            -- FS Item [FC_ITEM]
    TXTSH,                           -- Short Text [FC_TXTSH]
    TXTMI,                           -- Medium Text [FC_TXTMI_I]
    TXTLG,                           -- Long Text [FC_TXTLG_I]
    ITCLASS,                         -- Item Type [FINCS_ITTYPE]
    ITBRKDWN,                        -- Breakdown Category [FINCS_ITBRKDWN]
    ITBLKD,                          -- Blocked for Posting [FINCS_ITBLKD]
    ITCITEM,                         -- Consolidation Item [FINCS_ITCITEM]
    ITNBCF,                          -- Carry Fwd Balances [FINCS_ITNBCF]
    SA_ELIMINATION,                  -- Attribute Value Name [FINCS_FSI_ATTRIBUTE_VALUE_NAME]
    SA_CURRENCY_TRANSLATION,         -- Attribute Value Name [FINCS_FSI_ATTRIBUTE_VALUE_NAME]
    SA_DATA_COLLECTION,              -- Data Coll. Attrib. [FINCS_FSI_DATA_COLLECTION]
    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]
    ROLE,                            -- Attribute Value Name [FINCS_FSI_ATTRIBUTE_VALUE_NAME]
    TA_ELIMINATION,                  -- Target Item [FC_ITEM_TARGET]
    TA_NCI,                          -- Target Item [FC_ITEM_TARGET]
    TA_PLANNING,                     -- Target Item [FC_ITEM_TARGET]
    TA_OFFSETTING,                   -- Target Item [FC_ITEM_TARGET]
    LINKLABEL,                       -- Link Title [FINCS_LINK_LABEL]
    LINK,                            -- Link URL [FINCS_LINK]
    DUMMY_FINCS_FSI_H_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    DUMMY_FINCS_FSI_TV_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, UUID)
);

Learn More