SAP table TCG81 (EHS: Regulatory List)
SAP table TCG81 has 2 primary key fields being MANDT,SLSTID.
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 | |
| SLSTID | Regulatory List | CHAR | 10 | 0 | ESESLSTID | ||
| SLSTDIS | Regulatory List Distributor | CHAR | 40 | 0 | ESESLSTDIS | ||
| SLSTDAT | Date of Publication of Regulatory List | DATS | 8 | 0 | ESESLSTDAT | ||
| SLSTVER | Version Number of Regulatory List | CHAR | 10 | 0 | ESESLSTVER | ||
| SLSTRES | Contact Person or Person Responsible for Regulatory List | CHAR | 10 | 0 | * | ESESLSTRES | |
| RVLID | Validity Area | CHAR | 10 | 0 | TCG91 | ESERVLID | |
| REM | Note | CHAR | 60 | 0 | ESEREM | ||
| SLSTLAN | Languages Contained in the Regulatory List | CHAR | 132 | 0 | ESESLSTLAN | ||
| SLSTSID | Identifier Contained in the Regulatory List | CHAR | 132 | 0 | ESESLSTSID | ||
| SLSTSCH | Value Assignment Type Contained in the Regulatory List | CHAR | 132 | 0 | ESESLSTSCH | ||
| NEGATIVFLG | Negative List (Regulatory List) | CHAR | 1 | 0 | EHS_NEGATIVFLG |
TCG81 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCG81 | RVLID | TCG91 | EHS: Validity Area | MANDT |
| 0 TCG81 | RVLID | TCG91 | EHS: Validity Area | RVLID |