STXL

Transparent Table System Table (transport)
9 Fields 5 CDS Views

STXD SAPscript text file lines

STXL is an SAP database table in S/4HANA. STXD SAPscript text file lines. It contains 9 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CustomerMaterialText view_entity from BASIC Customer Material - Text
I_Productplanttext view from BASIC Plant Text Core enttity
I_Productsalestext view from BASIC Product text core entity
I_Producttexts view from BASIC Product text active entity
P_CustomerMaterialLongText view from BASIC

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY relid SYCHAR02 CHAR02 data element for SYST
KEY tdobject TDOBJECT Text object
KEY tdname TDOBNAME Text Name
KEY tdid TDID Text ID
KEY tdspras SPRAS Language
KEY srtf2 SYBIN1 BIN1 data element for SYST
clustr SYBIN2 BIN2 data element for SYST
clustd STXLDUMMY2 Data

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.

-- STXD SAPscript text file lines
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STXL (
    MANDT,     -- Client [MANDT]
    RELID,     -- CHAR02 data element for SYST [SYCHAR02]
    TDOBJECT,  -- Text object [TDOBJECT]
    TDNAME,    -- Text Name [TDOBNAME]
    TDID,      -- Text ID [TDID]
    TDSPRAS,   -- Language [SPRAS]
    SRTF2,     -- BIN1 data element for SYST [SYBIN1]
    CLUSTR,    -- BIN2 data element for SYST [SYBIN2]
    CLUSTD,    -- Data [STXLDUMMY2]
    PRIMARY KEY (MANDT, RELID, TDOBJECT, TDNAME, TDID, TDSPRAS, SRTF2)
);

Learn More