SAP table STXH (STXD SAPscript text file header)
SAP table STXH has 5 primary key fields being MANDT,TDOBJECT,TDNAME,TDID,TDSPRAS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| TDOBJECT | Texts: application object | CHAR | 10 | 0 | * | TDOBJECT | |
| TDNAME | Name | CHAR | 70 | 0 | TDOBNAME | ||
| TDID | Text ID | CHAR | 4 | 0 | * | TDID | |
| TDSPRAS | 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 |
STXH foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 STXH | TDOSPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |