SAP table TW18T (Text table for TW18 SCB indicators)
SAP table TW18T has 3 primary key fields being MANDT,SPRAS,SGLZBE.
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 | T000 | MANDT | |
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| SGLZBE | SCB ID revenue/expense | CHAR | 4 | 0 | TW18 | VVSGLZBE | |
| XLANGBEZ | ATAB tables long name | CHAR | 60 | 0 | XLANGBEZ | ||
| XKURZBEZ | Short Name for ATAB Tables | CHAR | 15 | 0 | XKURZBEZ |
TW18T foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TW18T | SGLZBE | TW18 | Customizing table for SCB indicator | MANDT |
| 0 TW18T | SGLZBE | TW18 | Customizing table for SCB indicator | SGLZBE |
| 1 TW18T | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |