STXH
STXD SAPscript Text-Datei Header
STXH is an SAP database table in S/4HANA. STXD SAPscript Text-Datei Header. It contains 31 fields. 23 CDS views read from this table.
CDS Views using this table (23)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AuditComponentLongTextHeader | view | from | BASIC | Audit Component Long Text Header |
| I_BOOCharcVersionLongTxtHeader | view_entity | from | BASIC | Plan Characteristic Long Text Header |
| I_BusSolnQuotationItemText | view | from | BASIC | Solution Quotation Item Text |
| I_BusSolutionQuotationText | view | from | BASIC | Solution Quotation Text |
| I_InhRepairItemNote | view_entity | from | BASIC | Notes for In-House Repair Item |
| I_InhRepairNote | view_entity | from | BASIC | Notes for In-House Repair |
| I_InspMethodVersLongTxtHeader | view_entity | from | BASIC | Inspection Method Version Long Text Header |
| I_InspSpecVersionLongTxtHeader | view_entity | from | BASIC | MIC Long Text Header |
| I_MigrtnBOMAltvLongTextRtrv | view_entity | from | BASIC | Long Text for BOM Alternative |
| I_MigrtnBOMHdrLongTextRtrv | view_entity | from | BASIC | Long Text for BOM Header |
| I_MigrtnBOMItemLongTextRtrv | view_entity | from | BASIC | Retrieve Long Text for BOM Items |
| I_MigrtnBOMLongText | view_entity | from | BASIC | BOM Long Text |
| I_PurchasingLongText | view | from | BASIC | Purchasing Long Text |
| I_SubscriptionContractText | view_entity | from | BASIC | Subscription Contract Text |
| I_SubscrpnContrItmText | view_entity | from | BASIC | Subscription Contract Item Text |
| I_Text_Templates | view | from | BASIC | Text Templates |
| I_Textfileheader | view | from | BASIC | Longtexts |
| I_TextObject | view | from | BASIC | Text Object |
| P_MigrtnBOMLongText | view_entity | from | BASIC | BOM Long Text |
| P_ServiceDocumentTextObject | view_entity | from | BASIC | Server Document Text Object |
| P_ServiceItemTextObject | view | from | BASIC | Service Item Notes |
| SDM_STXH_PP | view_entity | from | Work list for CL_CO_ESH_LONGTEXT_MAPPING_V3 | |
| SDM_STXH_PP | view_entity | union_all | Work list for CL_CO_ESH_LONGTEXT_MAPPING_V3 |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | tdobject | tdobject | Text object | |||
| KEY | tdname | tdobname | Text Name | |||
| KEY | tdid | tdid | Text ID | |||
| KEY | tdspras | spras | Language | |||
| tdtitle | tdtitle | Short Title | ||||
| tdfreles | tdfreles | Release | ||||
| tdfuser | tdfuser | Created By | ||||
| tdfdate | tdfdate | Date | ||||
| tdftime | tdftime | Time | ||||
| tdlreles | tdlreles | Release | ||||
| tdluser | tdluser | Changed by | ||||
| tdldate | tdldate | Date | ||||
| tdltime | tdltime | Time | ||||
| tdversion | tdversion | Version | ||||
| tdstyle | tdstyle | Style | ||||
| tdform | tdform | Form | ||||
| tdhyphenat | tdhyphenat | Hyphenation | ||||
| tdtranstat | tdtranstat | Translation | ||||
| tdospras | tdospras | Original Lang. | ||||
| tdmacode1 | tdmacode1 | Short Title 1 | ||||
| tdmacode2 | tdmacode2 | Short Title 2 | ||||
| tdtxtlines | tdtxtlines | No. of Lines | ||||
| tdref | tdref | Reference | ||||
| tdrefobj | tdrefobj | Reference obj. | ||||
| tdrefname | tdrefname | Reference name | ||||
| tdrefid | tdrefid | Reference ID | ||||
| tdtexttype | tdtexttype | Text format | ||||
| tdcompress | tdcompress | Compressed | ||||
| tdoclass | tdoclass | Class | ||||
| logsys | logsys | Logical system |
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 Header
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STXH (
MANDT, -- Client [mandt]
TDOBJECT, -- Text object [tdobject]
TDNAME, -- Text Name [tdobname]
TDID, -- Text ID [tdid]
TDSPRAS, -- Language [spras]
TDTITLE, -- Short Title [tdtitle]
TDFRELES, -- Release [tdfreles]
TDFUSER, -- Created By [tdfuser]
TDFDATE, -- Date [tdfdate]
TDFTIME, -- Time [tdftime]
TDLRELES, -- Release [tdlreles]
TDLUSER, -- Changed by [tdluser]
TDLDATE, -- Date [tdldate]
TDLTIME, -- Time [tdltime]
TDVERSION, -- Version [tdversion]
TDSTYLE, -- Style [tdstyle]
TDFORM, -- Form [tdform]
TDHYPHENAT, -- Hyphenation [tdhyphenat]
TDTRANSTAT, -- Translation [tdtranstat]
TDOSPRAS, -- Original Lang. [tdospras]
TDMACODE1, -- Short Title 1 [tdmacode1]
TDMACODE2, -- Short Title 2 [tdmacode2]
TDTXTLINES, -- No. of Lines [tdtxtlines]
TDREF, -- Reference [tdref]
TDREFOBJ, -- Reference obj. [tdrefobj]
TDREFNAME, -- Reference name [tdrefname]
TDREFID, -- Reference ID [tdrefid]
TDTEXTTYPE, -- Text format [tdtexttype]
TDCOMPRESS, -- Compressed [tdcompress]
TDOCLASS, -- Class [tdoclass]
LOGSYS, -- Logical system [logsys]
PRIMARY KEY (MANDT, TDOBJECT, TDNAME, TDID, TDSPRAS)
);
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