FINCS_FSITEMT

Transparent Table Customizing Table
7 Fields 5 CDS Views

FS Item Text

FINCS_FSITEMT is an SAP database table in S/4HANA. FS Item Text. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CnsldtnFinStmntItemLongText view from BASIC Financial Statement Item Long - Text
I_CnsldtnFinStmntItemText view from BASIC Financial Statement Item - Text
I_CnsldtnFinStmntItemTextEnhcd view from BASIC Consolidation Financial Statement Item Text Enhanced
I_CnsldtnFSItemText_2 view_entity from BASIC Cnsldtn Fincancial Statement Item - Text
I_CnsldtnRptgItmText view from BASIC Consolidation Reporting Item - Text

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY langu SPRAS Language
KEY itclg FC_ITCLG Cons. COA
KEY item FINCS_FSI_ITEM FS Item
txtsh FC_TXTSH Short Text
txtmi FC_TXTMI_I Medium Text
txtlg FC_TXTLG_I Long Text

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 Text
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_FSITEMT (
    MANDT,  -- Client [MANDT]
    LANGU,  -- Language [SPRAS]
    ITCLG,  -- Cons. COA [FC_ITCLG]
    ITEM,   -- FS Item [FINCS_FSI_ITEM]
    TXTSH,  -- Short Text [FC_TXTSH]
    TXTMI,  -- Medium Text [FC_TXTMI_I]
    TXTLG,  -- Long Text [FC_TXTLG_I]
    PRIMARY KEY (MANDT, LANGU, ITCLG, ITEM)
);

Learn More