FINCS_FSITEM

Transparent Table Customizing Table
12 Fields 9 CDS Views

Financial Statement Item

FINCS_FSITEM is an SAP database table in S/4HANA. Financial Statement Item. It contains 12 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
E_CnsldtnFSItem view_entity from EXTENSION Financial Statement Item - Extension
I_CnsldtnFinStmntItem view from BASIC Financial Statement Item
I_CnsldtnFSItem_2 view_entity from BASIC Consolidation Financial Statement Item
I_CnsldtnRptgItem view from BASIC Consolidation Reporting Item
I_CnsldtnRptgItemText_2 view inner BASIC Consolidation Reporting Item - Text
I_CnsldtnRptgItmText view inner BASIC Consolidation Reporting Item - Text
I_GroupReportingFSItem view from BASIC Financial Statement Item
ICA_CONSJOURNALENTRIES_4 view inner Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_6 view_entity inner ICA: Consolidation Journal Entry Line Items

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY itclg FC_ITCLG Cons. COA
KEY item FINCS_FSI_ITEM FS Item
itclass FINCS_ITTYPE Item Type
itbrkdwn FINCS_ITBRKDWN Breakdown Category
itblkd FINCS_ITBLKD Blocked for Posting
itcitem FINCS_ITCITEM Consolidation Item
linklabel FINCS_LINK_LABEL Link Title
link FINCS_LINK Link URL
itnbcf FINCS_ITNBCF Carry Fwd Balances
etag FINCS_FSI_ETAG FS Item ETag
dummy_fincs_fsi_h_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.

-- Financial Statement Item
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_FSITEM (
    MANDT,                          -- Client [MANDT]
    ITCLG,                          -- Cons. COA [FC_ITCLG]
    ITEM,                           -- FS Item [FINCS_FSI_ITEM]
    ITCLASS,                        -- Item Type [FINCS_ITTYPE]
    ITBRKDWN,                       -- Breakdown Category [FINCS_ITBRKDWN]
    ITBLKD,                         -- Blocked for Posting [FINCS_ITBLKD]
    ITCITEM,                        -- Consolidation Item [FINCS_ITCITEM]
    LINKLABEL,                      -- Link Title [FINCS_LINK_LABEL]
    LINK,                           -- Link URL [FINCS_LINK]
    ITNBCF,                         -- Carry Fwd Balances [FINCS_ITNBCF]
    ETAG,                           -- FS Item ETag [FINCS_FSI_ETAG]
    DUMMY_FINCS_FSI_H_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, ITCLG, ITEM)
);

Learn More