SAP Table
THM063 DG: Dangerous Goods Regulation
SAP table THM063 has 2 primary key fields being MANDT,LWDG.
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
THM063 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyLWDG | 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 |
/ Relationships
THM063 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| THM063 | ESTCAT | TCG11 | EHS: Value Assignment Type | MANDT |
| THM063 | ESTCAT | TCG11 | EHS: Value Assignment Type | ESTCAT |
| THM063 | IDLID | TCG26 | EHS: Identification Listings | MANDT |
| THM063 | IDLID | TCG26 | EHS: Identification Listings | IDLID |
| THM063 | RVLID | TCG91 | EHS: Validity Area | MANDT |
| THM063 | RVLID | TCG91 | EHS: Validity Area | RVLID |
| THM063 | SLSTID | TCG81 | EHS: Regulatory List | MANDT |
| THM063 | SLSTID | TCG81 | EHS: Regulatory List | SLSTID |