SAP ABAP Table RDGENHINTEGR (DG: Structure for Enhanced Dangerous Goods Master Model)
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 | INTTAB | Structure |
Structure | RDGENHINTEGR | Table Relationship Diagram |
Short Description | DG: Structure for Enhanced Dangerous Goods Master Model |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | EHS: Application Data for Table CCDUTTRAPPR | |||||
2 | TRANSP_TYPE | THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
3 | TRANSP_APPROVED | CBDUE_FLG_TRANSP_APPR | CBUND_FLG | CHAR | 1 | 0 | Transport Permitted | ||
4 | LEG_SRC_RESTR | CBDUE_LEG_SRC_RESTR | CBUND_LEG_SRC_RESTR | CHAR | 25 | 0 | Regulatory Basis for Transport Restrictions | CCUNC117 | |
5 | RESTR_PHRKEY | CBDUE_RESTR_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Transport Restriction | ||
6 | MIN_QUANT | CBDUE_MIN_QUANT | HMD_QUAN | QUAN | 8 | 2 | Minimum Quantity for Restriction | ||
7 | U_MIN_QUANT | CBDUE_U_MIN_QUANT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Minimum Quantity | * | |
8 | FLG_MIN_QUANT | CBDUE_FLG_MIN_QUANT | CBUND_FLG | CHAR | 1 | 0 | Value Entered for Minimum Quantity for Restriction | ||
9 | MAX_QUANT | CBDUE_MAX_QUANT | HMD_QUAN | QUAN | 8 | 2 | Maximum Quantity for Exemption | ||
10 | U_MAX_QUANT | CBDUE_U_MAX_QUANT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Maximum Quantity | * | |
11 | FLG_MAX_QUANT | CBDUE_FLG_MAX_QUANT | CBUND_FLG | CHAR | 1 | 0 | Value Entered for Maximum Quantity for Restriction | ||
12 | .INCLUDE | 0 | 0 | EHS: Relevant Output Fields of Table CCDUTCARR | |||||
13 | .INCLUDE | 0 | 0 | EHS: Application Data for Table CCDUTCARR | |||||
14 | SPPROV_PHRKEY | CBDUE_SP_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Special Provision | ||
15 | SP_PRINT_PHRKEY | CBDUE_SP_PRINT_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Special Provision Print Text | ||
16 | MIX_PACK_PHRKEY | CBDUE_MIX_PACK_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Mixed Packing | ||
17 | SEGREGAT_PHRKEY | CBDUE_SEGREGAT_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Segregation Regulation | ||
18 | PACKAGES_PHRKEY | CBDUE_PACKAGES_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Packages | ||
19 | BULK_PHRKEY | CBDUE_BULK_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Bulk | ||
20 | HANDLING_PHRKEY | CBDUE_HANDLING_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Handling | ||
21 | OPERATION_PHRKEY | CBDUE_OPERATION_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Operation | ||
22 | VEHICLE_PHRKEY | CBDUE_VEHICLE_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Vehicle | ||
23 | SP_PRINT_PHRKEY1 | CBDUE_SP_PRINT_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Special Provision Print Text | ||
24 | SP_PRINT_PHRKEY2 | CBDUE_SP_PRINT_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Special Provision Print Text | ||
25 | SP_PRINT_PHRKEY3 | CBDUE_SP_PRINT_PHRKEY | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Phrase Key for Special Provision Print Text | ||
26 | .INCLUDE | 0 | 0 | EHS: Application Data for Table CCDUTDGREL | |||||
27 | PRIO_ALTERN | CBDUE_PRIO_ALTERN | NUMC2 | NUMC | 2 | 0 | Priority of Release | ||
28 | FLG_RELEASED | CBDUE_FLG_RELEASED | X | CHAR | 1 | 0 | Product Released for Regulation | ||
29 | FLG_TRANS_PERM | CBDUE_FLG_TRANS_PERM | X | CHAR | 1 | 0 | Transport Not Permitted | ||
30 | FLG_NO_DG | CBDUE_FLG_NO_DG | X | CHAR | 1 | 0 | Not Dangerous Goods | ||
31 | FLG_LQ | CBDUE_FLG_LQ | X | CHAR | 1 | 0 | Limited Quantity | ||
32 | FLG_RQ | CBDUE_FLG_RQ | X | CHAR | 1 | 0 | Reportable Quantity | ||
33 | INSTR_ENCL | CBDUE_INSTR_ENCL | CBUND_INSTR_ENCL | CHAR | 10 | 0 | Actual Instruction for Enclosure | CCUNC115 | |
34 | FLG_SINGLE_PACK | CBDUE_FLG_SGL_PACK | X | CHAR | 1 | 0 | Single Packaging | ||
35 | PACOD | CBDUE_PACOD | CBUND_PACOD | CHAR | 10 | 0 | Actual Packaging Code | CCUNC121 | |
36 | QUANT_OUT_PACK | CBDUE_QUANT_OUT | HMD_QUAN | QUAN | 8 | 2 | Quantity Single/Outer Packaging | ||
37 | U_QUANT_OUT_PACK | CBDUE_U_QUANT_OUT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Quantity Outer Packaging | T006 | |
38 | PACK_NOTE | CBDUE_PACK_NOTE | CBDUD_FIELD_WITH_PHRASE | CHAR | 21 | 0 | Note for Release | ||
39 | RECN_SUB | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
40 | RECN_CLASS | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
41 | FLG_CC | CBDUE_FLG_CC | X | CHAR | 1 | 0 | Consumer Commodity | ||
42 | FLG_PACKED | CBDUE_FLG_PACKED | X | CHAR | 1 | 0 | Packed Goods | ||
43 | TRANSPORT_TYPE | CBDUE_TRANSP_TYPE | HMD_MOS | NUMC | 3 | 0 | Actual Transport Type | THM003 | |
44 | APPROVAL_CODE | CBDUE_APPROVAL_CODE | CHAR72 | CHAR | 72 | 0 | Full UN Packaging Code | ||
45 | MAT_DAMAGED_CL7 | ADGE_MAT_DAMAGED_CL7 | ADGD_YES_NO_NOT_DEFINED | CHAR | 1 | 0 | Damaged Material (Class 7) | ||
46 | MAX_GROSS_WEIGHT | ADGE_MAX_GROSS_WEIGHT | HMD_QUAN | QUAN | 8 | 2 | Maximum Gross Mass | ||
47 | U_MAX_GROSS_WGHT | ADGE_U_MAX_GROSS_WGHT | MEINS | UNIT | 3 | 0 | Unit for Maximum Gross Mass | * | |
48 | SUBID_DG_CLASS | ADGE_SUBID_CLASS | CHAR12 | CHAR | 12 | 0 | Key (ID) of Dangerous Goods Classification | ||
49 | EMV_DYN | ADGE_EMV_DYN | EHS_ADGD_CODE | CHAR | 1 | 0 | Electromagnetic Compatibility | ||
50 | LTSK_DYN | ADGE_LTSK_DYN | EHS_ADGD_CODE | CHAR | 1 | 0 | Air Transport Safety Code | ||
51 | EXPL_NET_DYN | ADGE_EXPL_NET_DYN | EHS_ADGD_Q93 | QUAN | 9 | 3 | Net Explosive Substance Mass | ||
52 | EXPL_NET_DYN_U | EHS_ADGE_EXPL_NET_U | MEINS | UNIT | 3 | 0 | Unit for Net Explosive Substance Mass | * | |
53 | MAX_ACT_SGL | ADGE_MAX_ACT_SGL_DYN | ADGD_QUAN_11_4 | QUAN | 11 | 4 | Maximum Activity: Item | ||
54 | MAX_ACT_SGL_U | ADGE_MAX_ACT_SGL_DYN_U | MEINS | UNIT | 3 | 0 | Maximum Activity Unit: Item | * | |
55 | ACT_SGL_UNLIMIT | ADGE_ACT_SGL_DYN_UNLIMIT | ESDFLAG | CHAR | 1 | 0 | Maximum Activity of Item Unlimited | ||
56 | MAX_ACT_PACK | ADGE_MAX_ACT_PACK_DYN | ADGD_QUAN_11_4 | QUAN | 11 | 4 | Maximum Activity: Package | ||
57 | MAX_ACT_PACK_U | ADGE_MAX_ACT_PACK_DYN_U | MEINS | UNIT | 3 | 0 | Maximum Activity Unit: Package | * | |
58 | ACT_PACK_UNLIMIT | ADGE_ACT_PACK_DYN_UNLIMIT | ESDFLAG | CHAR | 1 | 0 | Maximum Activity of Package Unlimited | ||
59 | EXCEPT_PACK_OPT | ADGE_EXCEPT_PACK_OPT | ESDFLAG | CHAR | 1 | 0 | Excepted Package: Optional | ||
60 | DG_USE_CASE | ADGE_DG_USE_CASE | ADGD_DG_USE_CASE | CHAR | 1 | 0 | Dangerous Goods: Use | ||
61 | PRIO_DYNCL | ADGE_PRIO_DYNCL | NUMC2 | NUMC | 2 | 0 | Priority of Dynamic Classification | ||
62 | MAX_NEM | ADGE_MAX_NEM_DYN | EHS_ADGD_Q93 | QUAN | 9 | 3 | Maximum Net Explosive Substance Mass | ||
63 | MAX_NEM_U | ADGE_MAX_NEM_DYN_U | MEINS | UNIT | 3 | 0 | Unit of Maximum Net Explosive Substance Mass | * | |
64 | .INCLU--AP | 0 | 0 | Structure-Append Application Data Table CCDUTDGREL EhP3 | |||||
65 | DUMMY_RCBDUDGREL | CHAR | 1 | 0 | |||||
66 | .INCLU--AP | 0 | 0 | Structure Append Application Data Table CCDUTDGREL EhP5 | |||||
67 | FLG_EQ | ADGE_EXC_QUANT | X | CHAR | 1 | 0 | Excepted Quantity | ||
68 | .INCLU--AP | 0 | 0 | Structure Append Application Data Table CCDUTDGREL EhP6 | |||||
69 | .INCLUDE | 0 | 0 | Structure for Transport Indicators in Product Release | |||||
70 | DGREL_TRANSIND01 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
71 | DGREL_TRANSIND02 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
72 | DGREL_TRANSIND03 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
73 | DGREL_TRANSIND04 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
74 | DGREL_TRANSIND05 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
75 | DGREL_TRANSIND06 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
76 | DGREL_TRANSIND07 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
77 | DGREL_TRANSIND08 | ADGE_TRANSPORT_INDICATOR | ADGD_TRANSPORT_INDICATOR | CHAR | 10 | 0 | Indicator for Transport | ||
78 | PACKAGE_MATNR | CBDUE_PACKMAT | MATNR | CHAR | 18 | 0 | Packing Material | * | |
79 | MATNR_REPLACE | ADGE_MATNR_REPLACE | MATNR | CHAR | 18 | 0 | Material Number of Replacement Material | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RDGENHINTEGR | INSTR_ENCL | CCUNC115 | INSTR_ENCL | 1 | CN | |
2 | RDGENHINTEGR | LEG_SRC_RESTR | CCUNC117 | LEG_SRC_RESTR | 1 | CN | |
3 | RDGENHINTEGR | PACOD | CCUNC121 | PACKCODE | 1 | CN | |
4 | RDGENHINTEGR | TRANSPORT_TYPE | THM003 | MOS | 1 | CN | |
5 | RDGENHINTEGR | TRANSP_TYPE | THM003 | MOS | 1 | CN | |
6 | RDGENHINTEGR | U_QUANT_OUT_PACK | T006 | MSEHI |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 600 |