SAP ABAP Table DGTEXCEPT (Exceptions to DG Regulations - Header Table)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ EHS (Application Component) Environment, Health and Safety
⤷ CBEHS (Package) EH&S: Interface Objects
⤷ EHS (Application Component) Environment, Health and Safety
⤷ CBEHS (Package) EH&S: Interface Objects
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | DGTEXCEPT | Table Relationship Diagram |
Short Description | Exceptions to DG Regulations - Header Table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | .INCLUDE | 0 | 0 | EHS: Logical Key for Exceptions to DG Regulations | |||||
3 | LWDG | THME_LWDG | HMD_LWDG | CHAR | 12 | 0 | Dangerous Goods Regulation | THM063 | |
4 | EXCEPTID | ADGE_EXCEPTID | ADGD_EXCEPTID | CHAR | 18 | 0 | Exception to Dangerous Goods Regulations | * | |
5 | VERSION | ADGE_EXCEPT_VERSION | ADGD_EXCEPT_VERSION | NUMC | 3 | 0 | Version of Exception to Dangerous Goods Regulations | * | |
6 | DELFLG | ADGE_DELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
7 | BLOCKEDFLG | ADGE_BLOCKEDFLG | ESDFLAG | CHAR | 1 | 0 | Block Indicator for Exception to Dangerous Goods Regulations | ||
8 | DISTRIBFLG | ADGE_DISTRIBFLG | ESDFLAG | CHAR | 1 | 0 | Exception Was Distributed | ||
9 | .INCLUDE | 0 | 0 | EHS: Administrative Data for Exceptions to DG Regulations | |||||
10 | CRDAT | ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
11 | CRNAM | ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
12 | UPDDAT | ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
13 | UPDNAM | ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
14 | EXCEPT_VALFR | ADGE_EXCEPT_VALFR | DATUM | DATS | 8 | 0 | Valid From Date for Exception | ||
15 | EXCEPT_VALTO | ADGE_EXCEPT_VALTO | DATUM | DATS | 8 | 0 | Valid To Date for Exception | ||
16 | ENTPR_SPECFLG | ADGE_ENTPR_SPECFLG | ESDFLAG | CHAR | 1 | 0 | Exception is Company Specific | ||
17 | UNNO_SPECFLG | ADGE_UNNO_SPECFLG | ESDFLAG | CHAR | 1 | 0 | Exception is UN Number Specific | ||
18 | CNTRY_SPECFLG | ADGE_CNTRY_SPECFLG | ESDFLAG | CHAR | 1 | 0 | Exception Is Country Specific | ||
19 | EXCEPTPROFILE | ADGE_EXCEPTPROFILE | ADGD_EXCEPTPROFILE | NUMC | 2 | 0 | Assignment Profile for Exception to DG Regulations | TDG85 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | DGTEXCEPT | EXCEPTPROFILE | TDG85 | EXCEPTPROFILE | 1 | CN | |
2 | DGTEXCEPT | LWDG | THM063 | LWDG | 1 | CN | |
3 | DGTEXCEPT | MANDT | T000 | MANDT | 1 | CN |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in | 600 |