STXH

Transparent Table System Table (transport)
31 Fields 21 CDS Views

STXD SAPscript text file header

STXH is an SAP database table in S/4HANA. STXD SAPscript text file header. It contains 31 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
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 from BASIC Notes for In-House Service Object
I_InhRepairNote view from BASIC Notes for In-House Service
I_InspMethodVersLongTxtHeader view_entity from BASIC Inspection Method Long Text Header
I_InspSpecVersionLongTxtHeader view_entity from BASIC MIC Long Text Header
I_InvgCsMNote view from BASIC Basic View For ICM Object Note
I_InvgCsMRelationshipMemo view from BASIC Basic View for Relationship Note
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_PublicSectorNoteHeader view from BASIC
P_ServiceDocumentTextObject view from BASIC
P_ServiceItemTextObject view from BASIC
SDM_STXH_PP view_entity from
SDM_STXH_PP view_entity union_all

Fields (31)

KeyField Data ElementDescription DomainTypeLength
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 file 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