TF110

Transparent Table Customizing Table
21 Fields 3 CDS Views

Subitem Categories

TF110 is an SAP database table in S/4HANA. Subitem Categories. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CnsldtnSubItemCategory view from BASIC Consolidation Subitem Category
I_CnsldtnSubitemCategory_2 view_entity from BASIC Consolidation Subitem Category
I_CnsldtnSubItemCategoryEnhcd view from BASIC Consolidation Subitem Category

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sityp FC_SITYP Subitem Category
signind FC_SIGNIND Dr./Cr. sign
ttyind FC_TTYIND CFwd to Subitem
fmlind FC_FMLIND Formula
cfdind FC_CFDIND Bal.Carried Fwd
cyaind FC_CYAIND Cur.yr.acquis.
retind FC_RETIND SI Acq./Div.
fnumb FC_FNUMB No. of fields used
flg1 FC_FLG1 Length field 1
flg2 FC_FLG2 Length field 2
flg3 FC_FLG3 Length field 3
flg4 FC_FLG4 Length field 4
flg5 FC_FLG5 Length field 5
flg6 FC_FLG6 Length field 6
flg7 FC_FLG7 Length field 7
flg8 FC_FLG8 Length field 8
flg9 FC_FLG9 Length field 9
sidef FC_SIDEF Default Subitem
sitem_send FC_SITEMSD Sender Field Subitem
dsiind FC_DSIIND Carryfwd Dev SI

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.

-- Subitem Categories
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TF110 (
    MANDT,       -- Client [MANDT]
    SITYP,       -- Subitem Category [FC_SITYP]
    SIGNIND,     -- Dr./Cr. sign [FC_SIGNIND]
    TTYIND,      -- CFwd to Subitem [FC_TTYIND]
    FMLIND,      -- Formula [FC_FMLIND]
    CFDIND,      -- Bal.Carried Fwd [FC_CFDIND]
    CYAIND,      -- Cur.yr.acquis. [FC_CYAIND]
    RETIND,      -- SI Acq./Div. [FC_RETIND]
    FNUMB,       -- No. of fields used [FC_FNUMB]
    FLG1,        -- Length field 1 [FC_FLG1]
    FLG2,        -- Length field 2 [FC_FLG2]
    FLG3,        -- Length field 3 [FC_FLG3]
    FLG4,        -- Length field 4 [FC_FLG4]
    FLG5,        -- Length field 5 [FC_FLG5]
    FLG6,        -- Length field 6 [FC_FLG6]
    FLG7,        -- Length field 7 [FC_FLG7]
    FLG8,        -- Length field 8 [FC_FLG8]
    FLG9,        -- Length field 9 [FC_FLG9]
    SIDEF,       -- Default Subitem [FC_SIDEF]
    SITEM_SEND,  -- Sender Field Subitem [FC_SITEMSD]
    DSIIND,      -- Carryfwd Dev SI [FC_DSIIND]
    PRIMARY KEY (MANDT, SITYP)
);

Learn More