STXL
STXD SAPscript Text-Datei Lines
STXL is an SAP database table in S/4HANA. STXD SAPscript Text-Datei Lines. It contains 9 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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-Datei 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA