SAP table THM063 (DG: Dangerous Goods Regulation)
SAP table THM063 has 2 primary key fields being MANDT,LWDG.
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 | |
| LWDG | Dangerous Goods Regulation | CHAR | 12 | 0 | THME_LWDG | ||
| RVLID | Validity Area | CHAR | 10 | 0 | TCG91 | ESERVLID | |
| MOT | Dangerous Goods - Mode-of-Transport Category | NUMC | 2 | 0 | THM151 | THME_MOT | |
| LWDGN | Name of Dangerous Goods Regulation | CHAR | 132 | 0 | THME_LWDGN | ||
| SLSTID | Regulatory List | CHAR | 10 | 0 | TCG81 | ESESLSTID | |
| ORD | Sort Order | NUMC | 4 | 0 | ESEORD | ||
| ESTCAT | Value Assignment Type | CHAR | 30 | 0 | TCG11 | ESEESTCAT | |
| IDLID | Identification Listing | CHAR | 10 | 0 | TCG26 | ESEIDLID | |
| DCTRY | Consider Language of Forwarding Country/Region | CHAR | 1 | 0 | THME_DCTRY | ||
| PCTRY | Respect Print Language | CHAR | 1 | 0 | THME_PCTRY |
THM063 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 THM063 | ESTCAT | TCG11 | EHS: Value Assignment Type | MANDT |
| 0 THM063 | ESTCAT | TCG11 | EHS: Value Assignment Type | ESTCAT |
| 1 THM063 | IDLID | TCG26 | EHS: Identification Listings | MANDT |
| 1 THM063 | IDLID | TCG26 | EHS: Identification Listings | IDLID |
| 0 THM063 | RVLID | TCG91 | EHS: Validity Area | MANDT |
| 0 THM063 | RVLID | TCG91 | EHS: Validity Area | RVLID |
| 1 THM063 | SLSTID | TCG81 | EHS: Regulatory List | MANDT |
| 1 THM063 | SLSTID | TCG81 | EHS: Regulatory List | SLSTID |