FINCS_FSITEM

Transparent Table Customizing Table
11 Fields 9 CDS Views

Financial Statement Item

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

CDS Views using this table (9)

ViewTypeJoinVDMDescription
E_CnsldtnFSItem view from EXTENSION Financial Statement Item - Extension
I_CnsldtnFinStmntItem view from BASIC Financial Statement Item
I_CnsldtnFSItem_2 view 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 (11)

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

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

Learn More