FINCS_FSITEM

Transparent Table Customizing Table
14 Fields 9 CDS Views

Financial Statement Item

FINCS_FSITEM is an SAP database table in S/4HANA. Financial Statement Item. It contains 14 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 (14)

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
created_at fincs_creationdatetime
is_sign_item_specific fincs_is_sign_item_specific
sign fincs_sign
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]
    CREATED_AT,             -- fincs_creationdatetime
    IS_SIGN_ITEM_SPECIFIC,  -- fincs_is_sign_item_specific
    SIGN,                   -- fincs_sign
    ETAG,                   -- FS Item ETag [fincs_fsi_etag]
    PRIMARY KEY (MANDT, ITCLG, ITEM)
);

Learn More