SAP table TCG89 (EHS: Validity Area Category)
SAP table TCG89 has 2 primary key fields being MANDT,RVLTYPE.
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 | |
| RVLTYPE | Validity Area Category | CHAR | 10 | 0 | ESERVLTYPE | ||
| CHECKFKT | Check Function for Validity Areas for Validity Area Category | CHAR | 30 | 0 | ESECHECKFKT | ||
| F4TABLE | Table for Dynamic Input Help | CHAR | 30 | 0 | DD02L | ESEF4TABLE | |
| F4FIELD | Field for Dynamic Input Help | CHAR | 30 | 0 | DD03L | ESEF4FIELD | |
| OTHERS | Values Other Than Those of Input Help Are Permitted | CHAR | 1 | 0 | ESEOTHERS | ||
| AUTHFLG | Authorization-Relevant Validity Area Category | CHAR | 1 | 0 | ESEAUTHFLG | ||
| REGIONFLG | Truth Value | CHAR | 1 | 0 | ESEBOOLE | ||
| DGREGFLG | Assigned Validity Areas Are Dangerous Goods Regulations | CHAR | 1 | 0 | ESEDGREGFLG |
TCG89 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCG89 | F4FIELD | DD03L | Table Fields | TABNAME |
| 0 TCG89 | F4FIELD | DD03L | Table Fields | FIELDNAME |
| 0 TCG89 | F4FIELD | DD03L | Table Fields | AS4LOCAL |
| 0 TCG89 | F4FIELD | DD03L | Table Fields | AS4VERS |
| 1 TCG89 | F4TABLE | DD02L | SAP Tables | TABNAME |
| 1 TCG89 | F4TABLE | DD02L | SAP Tables | AS4LOCAL |
| 1 TCG89 | F4TABLE | DD02L | SAP Tables | AS4VERS |