TF116

Transparent Table Customizing Table
6 Fields 3 CDS Views

Subitems: Short and Medium Texts

TF116 is an SAP database table in S/4HANA. Subitems: Short and Medium Texts. It contains 6 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CnsldtnSubItemText view from BASIC Consolidation Subitem - Text
I_CnsldtnSubitemText_2 view_entity from BASIC Consolidation Subitem - Text
I_CnsldtnSubItemTextEnhcd view from BASIC Consolidation SubItem Text Enhanced

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY langu SPRAS Language
KEY sityp FC_SITYP Subitem Category
KEY sitem FC_SITEM Subitem
txtsh FC_TXTSH Short Text
txtmi FC_TXTMI Medium 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.

-- Subitems: Short and Medium Texts
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TF116 (
    MANDT,  -- Client [MANDT]
    LANGU,  -- Language [SPRAS]
    SITYP,  -- Subitem Category [FC_SITYP]
    SITEM,  -- Subitem [FC_SITEM]
    TXTSH,  -- Short Text [FC_TXTSH]
    TXTMI,  -- Medium Text [FC_TXTMI]
    PRIMARY KEY (MANDT, LANGU, SITYP, SITEM)
);

Learn More