SAP Table
STXH STXD SAPscript text file header
SAP table STXH has 5 primary key fields being MANDT,TDOBJECT,TDNAME,TDID,TDSPRAS.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
STXH columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| KeyTDOBJECT | Texts: application object | CHAR | 10 | 0 | * | TDOBJECT | |
| KeyTDNAME | Name | CHAR | 70 | 0 | TDOBNAME | ||
| KeyTDID | Text ID | CHAR | 4 | 0 | * | TDID | |
| KeyTDSPRAS | Language Key | LANG | 1 | 0 | * | SPRAS | |
| TDTITLE | Title in dialog box | CHAR | 50 | 0 | TDTITLE | ||
| TDFRELES | Release | CHAR | 4 | 0 | TDFRELES | ||
| TDFUSER | Created by | CHAR | 12 | 0 | TDFUSER | ||
| TDFDATE | Date created | DATS | 8 | 0 | TDFDATE | ||
| TDFTIME | Time Created | TIMS | 6 | 0 | TDFTIME | ||
| TDLRELES | Last Changed in Release | CHAR | 4 | 0 | TDLRELES | ||
| TDLUSER | Last changed by | CHAR | 12 | 0 | TDLUSER | ||
| TDLDATE | Changed On | DATS | 8 | 0 | TDLDATE | ||
| TDLTIME | Last Changed At | TIMS | 6 | 0 | TDLTIME | ||
| TDVERSION | Version | NUMC | 5 | 0 | TDVERSION | ||
| TDSTYLE | Style Name | CHAR | 8 | 0 | TDSTYLE | ||
| TDFORM | Form name | CHAR | 16 | 0 | TDFORM | ||
| TDHYPHENAT | Hyphenation Active | CHAR | 1 | 0 | TDHYPHENAT | ||
| TDTRANSTAT | Translation status | NUMC | 1 | 0 | TDTRANSTAT | ||
| TDOSPRAS | Original language | LANG | 1 | 0 | T002 | TDOSPRAS | |
| TDMACODE1 | Short Title 1 | CHAR | 16 | 0 | TDMACODE1 | ||
| TDMACODE2 | Short Title 2 | CHAR | 16 | 0 | TDMACODE2 | ||
| TDTXTLINES | Number of Text Lines in Line Table | NUMC | 5 | 0 | TDTXTLINES | ||
| TDREF | Reference text | CHAR | 1 | 0 | TDREF | ||
| TDREFOBJ | Object of Referenced Text | CHAR | 10 | 0 | * | TDREFOBJ | |
| TDREFNAME | Name of Referenced Text | CHAR | 70 | 0 | TDREFNAME | ||
| TDREFID | ID of Referenced Text | CHAR | 4 | 0 | * | TDREFID | |
| TDTEXTTYPE | SAPscript: Format of Text | CHAR | 6 | 0 | TDTEXTTYPE | ||
| TDCOMPRESS | SAPscript: Text is compressed | CHAR | 1 | 0 | TDCOMPRESS | ||
| TDOCLASS | SAPscript: Object Class | CHAR | 4 | 0 | TDOCLASS | ||
| LOGSYS | Logical system | CHAR | 10 | 0 | * | LOGSYS |
/ Relationships
STXH foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| STXH | TDOSPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |