1. Home
  2. Resources
  3. SAP Tables
  4. DGTM2 - DG: Dangerous Goods Master (App. Table)

SAP Table DGTM2

DG: Dangerous Goods Master (App. Table)

DGTM2 (DG: Dangerous Goods Master (App. Table)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DGTM2 to other SAP tables.

DGTM2 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RECN Sequential Number of Data Record ESERECN NUMC 20 0
ACTN Sequential Number of the Change State ESEACTN NUMC 20 0
PDGNUD Dangerous Goods Description ADGE_PDGND CHAR 21 0
PRES1 Hazard-Inducing Substance ADGE_PRES CHAR 21 0
PRES2 Hazard-Inducing Substance ADGE_PRES CHAR 21 0
PRES3 Hazard-Inducing Substance ADGE_PRES CHAR 21 0
PREMP1 Hazard-inducing substance (marine pollutant) ADGE_PRMP CHAR 21 0
PRERQ1 Hazard-inducing substance (reportable quantity) ADGE_PRRQ CHAR 21 0
PRERQ2 Hazard-inducing substance (reportable quantity) ADGE_PRRQ CHAR 21 0
PSTOSU Aggregate State for Transport ADGE_PSTOS CHAR 21 0
PDAIN1 Hazard Note 1 ADGE_PDAI1 CHAR 21 0
PDAIN2 Hazard Note 2 ADGE_PDAI2 CHAR 21 0
PDAIN3 Hazard Note 3 ADGE_PDAI3 CHAR 21 0
PDAIN4 Hazard Note 4 ADGE_PDAI4 CHAR 21 0
PDAIN5 Hazard Note 5 ADGE_PDAI5 CHAR 21 0
PDAIN6 Hazard Note 6 ADGE_PDAI6 CHAR 21 0
PDAIN7 Hazard Note 7 ADGE_PDAI7 CHAR 21 0
PDAIN8 Hazard Note 8 ADGE_PDAI8 CHAR 21 0
PDAIN9 Hazard Note 9 ADGE_PDAI9 CHAR 21 0
PDAIN10 Hazard Note 10 ADGE_PDAIA CHAR 21 0
MIOWA Miscibility with Water ADGE_MIOWA QUAN 8 2
UMIOW Unit for Miscibility with Water ADGE_UMIOW T006 UNIT 3 0
PHYGRO Hygroscopicity ADGE_PHYGR CHAR 21 0
PDGF1 User-Defined Text Key 1 ADGE_PDGF1 CHAR 21 0
PDGF2 User-Defined Text Key 2 ADGE_PDGF2 CHAR 21 0
PDGF3 User-Defined Text Key 3 ADGE_PDGF3 CHAR 21 0
PDGF4 User-Defined Text Key 4 ADGE_PDGF4 CHAR 21 0
PDGF5 User-Defined Text Key 5 ADGE_PDGF5 CHAR 21 0
PDGF6 User-Defined Text Key 6 ADGE_PDGF6 CHAR 21 0
PDGF7 User-Defined Text Key 7 ADGE_PDGF7 CHAR 21 0
PDGF8 User-Defined Text Key 8 ADGE_PDGF8 CHAR 21 0
PDGF9 User-Defined Text Key 9 ADGE_PDGF9 CHAR 21 0
PDGFA User-Defined Text Key 10 ADGE_PDGFA CHAR 21 0
PDGFB User-Defined Text Key 11 ADGE_PDGFB CHAR 21 0
PDGFC User-Defined Text Key 12 ADGE_PDGFC CHAR 21 0
PDGFD User-Defined Text Key 13 ADGE_PDGFD CHAR 21 0
PDGFE User-Defined Text Key 14 ADGE_PDGFE CHAR 21 0
PDGFF User-Defined Text Key 15 ADGE_PDGFF CHAR 21 0
PTXTPATT Dangerous Goods Text Pattern ADGE_PTXTPATT CHAR 21 0
MSEPR1 Segregation Key 1 THME_DYKY1 THM091 CHAR 4 0
MSEPR2 Segregation Key 2 THME_DYKY2 THM091 CHAR 4 0
MSEPR3 Segregation Key 3 THME_DYKY3 THM091 CHAR 4 0
MSEPR4 Segregation Key 4 THME_DYKY4 THM091 CHAR 4 0
MSEPR5 Segregation Key 5 THME_DYKY5 THM091 CHAR 4 0
MSEPR6 Segregation Key 6 THME_DYKY6 THM091 CHAR 4 0
MSEPR7 Segregation Key 7 THME_DYKY7 THM091 CHAR 4 0
MSEPR8 Segregation Key 8 THME_DYKY8 THM091 CHAR 4 0
MSEPR9 Segregation Key 9 THME_DYKY9 THM091 CHAR 4 0
MSEPRA Segregation Key 10 THME_DYKYA THM091 CHAR 4 0
MSEPRB Segregation Key 11 THME_DYKYB THM091 CHAR 4 0
MSEPRC Segregation Key 12 THME_DYKYC THM091 CHAR 4 0
MSEPRD Segregation Key 13 THME_DYKYD1 THM091 CHAR 4 0
MSEPRE Segregation Key 14 THME_DYKYE THM091 CHAR 4 0
MSEPRF Segregation Key 15 THME_DYKYF THM091 CHAR 4 0
MSEPRG Segregation Key 16 THME_DYKYG THM091 CHAR 4 0
MSEPRH Segregation Key 17 THME_DYKYH THM091 CHAR 4 0
MLOAR1 Mixed Loading Rule 1 THME_MLOAR1 THM097 CHAR 6 0
MLOAR2 Mixed Loading Rule 2 THME_MLOAR2 THM097 CHAR 6 0
MLOAR3 Mixed Loading Rule 3 THME_MLOAR3 THM097 CHAR 6 0
MLOAR4 Mixed Loading Rule 4 THME_MLOAR4 THM097 CHAR 6 0
MLOAR5 Mixed Loading Rule 5 THME_MLOAR5 THM097 CHAR 6 0
MLOAR6 Mixed Loading Rule 6 THME_MLOAR6 THM097 CHAR 6 0
MLOAR7 Mixed Loading Rule 7 THME_MLOAR7 THM097 CHAR 6 0
MLOAR8 Mixed Loading Rule 8 THME_MLOAR8 THM097 CHAR 6 0
MLOAR9 Mixed Loading Rule 9 THME_MLOAR9 THM097 CHAR 6 0
MLOARA Mixed Loading Rule 10 THME_MLOARA THM097 CHAR 6 0
RSMLG1 Regulation-Dependent Mixed Loading Group 1 THME_RSMLG1 THM101 CHAR 4 0
RSMLG2 Regulation-Dependent Mixed Loading Group 2 THME_RSMLG2 THM101 CHAR 4 0
RSMLG3 Regulation-Dependent Mixed Loading Group 3 THME_RSMLG3 THM101 CHAR 4 0
ESMLG1 Enterprise-Specific Mixed Loading Group 1 THME_ESMLG1 THM103 CHAR 4 0
ESMLG2 Enterprise-Specific Mixed Loading Group 2 THME_ESMLG2 THM103 CHAR 4 0
ESMLG3 Enterprise-Specific Mixed Loading Group 3 THME_ESMLG3 THM103 CHAR 4 0
PREMP2 Hazard-inducing substance (marine pollutant) ADGE_PRMP CHAR 21 0
RQA2 Reportable Quantity ADGE_RQA QUAN 8 2
RQU2 Unit of measure for reportable quantities ADGE_RQU T006 UNIT 3 0
PPDG1 Profile for Dangerous Goods User-Defined Text 1 THME_PPDG1 CHAR 2 0
PPDG2 Profile for Dangerous Goods User-Defined Text 2 THME_PPDG2 CHAR 2 0
PPDG3 Profile for Dangerous Goods User-Defined Text 3 THME_PPDG3 CHAR 2 0
PPDG4 Profile for Dangerous Goods User-Defined Text 4 THME_PPDG4 CHAR 2 0
PPDG5 Profile for Dangerous Goods User-Defined Text 5 THME_PPDG5 CHAR 2 0
PPDG6 Profile for Dangerous Goods User-Defined Text 6 THME_PPDG6 CHAR 2 0
PPDG7 Profile for Dangerous Goods User-Defined Text 7 THME_PPDG7 CHAR 2 0
PPDG8 Profile for Dangerous Goods User-Defined Text 8 THME_PPDG8 CHAR 2 0
PPDG9 Profile for Dangerous Goods User-Defined Text 9 THME_PPDG9 CHAR 2 0
PPDGA Profile for Dangerous Goods User-Defined Text 10 THME_PPDGA CHAR 2 0
PPDGB Profile for Dangerous Goods User-Defined Text 11 THME_PPDGB CHAR 2 0
PPDGC Profile for Dangerous Goods User-Defined Text 12 THME_PPDGC CHAR 2 0
PPDGE Profile for Dangerous Goods User-Defined Text 13 THME_PPDGE CHAR 2 0
PPDGF Profile for Dangerous Goods User-Defined Text 14 THME_PPDGF CHAR 2 0
PPDGG Profile for Dangerous Goods User-Defined Text 15 THME_PPDGG CHAR 2 0
DAOR Data Origin (Filling and Distribution) ADGE_DAOR CHAR 1 0
1 Distribution
2 Filling
3 Non-SAP System
4 Dialog
FORM_PHYS_CHEM Physical and Chemical Form EHS_ADGE_FORM_PHYS_CHEM CHAR 21 0
EXPL_NET Net Explosive Substance Mass EHS_ADGE_EXPL_NET QUAN 9 3
EXPL_NET_U Unit for Net Explosive Substance Mass EHS_ADGE_EXPL_NET_U T006 UNIT 3 0
EXPL_REL_PERCENT Relative Net Explosive Substance Percentage EHS_ADGE_EXPL_REL_PERCENT DEC 6 3
ACTVTY_MAX Maximum Activity EHS_ADGE_ACTVTY_MAX QUAN 8 2
ACTVTY_MAX_U Unit of Maximum Activity EHS_ADGE_ACTVTY_MAX_U T006 UNIT 3 0
ACTVTY_MAX_REL Relative Maximum Activity EHS_ADGE_ACTVTY_MAX_REL QUAN 8 2
ACTVTY_MAX_REL_U Unit of Relative Maximum Activity EHS_ADGE_ACTVTY_MAX_REL_U T006 UNIT 3 0
LTSK Air Transport Safety Code EHS_ADGE_LTSK CHAR 1 0
X Yes
- No
R Restricted
EMV Electromagnetic Compatibility EHS_ADGE_EMV CHAR 1 0
X Yes
- No
R Restricted
FSAK Parachute Drop Code EHS_ADGE_FSAK CHAR 1 0
X Yes
- No
R Restricted
SFK Thrust Code EHS_ADGE_SFK CHAR 1 0
X Yes
- No
R Restricted
MUNAKODE Ammunition Code EHS_ADGE_MUNAKODE CHAR 4 0
EXNUMBER EX-Number EHS_ADGE_EXNUMBER CHAR 12 0
CERTIFIC Identification Mark for Approval Certificate EHS_ADGE_APPROV_CERTIFIC CHAR 21 0
HAZCHEM_CODE Code for Chemical Hazard CBDUE_HAZCHEM_CODE CHAR 10 0
FLG_EMSN1_U EmS Number 1 Underlined CBDUE_FLG_EMSN1_U CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_EMSN2_U EmS Number 2 Underlined CBDUE_FLG_EMSN2_U CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
STOWAGE Stowage Category CBDUE_STOWAGE CCUNC111 CHAR 3 0
CARR_TYPE Transport Category CBDUE_CARR_TYPE CHAR 3 0
FLG_PAI Value Entered for Limited Quantity (LQ) Inner Packaging CBDUE_FLG_PAI CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_PAO Value Entered for Limited Quantity (LQ) Outer Packaging CBDUE_FLG_PAO CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_PASI Value Entered for Maximum Quantity per Package CBDUE_FLG_PASI CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_PAGW Value Entered for Limited Quantity (LQ) Gross Weight CBDUE_FLG_PAGW CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_RELQ Value Entered for Exemption CBDUE_FLG_RELQ CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_MULRQ Value Entered for Multiplication Factor CBDUE_FLG_MULRQ CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_RELQ_UNLIMIT Unlimited Set for Exemption CBDUE_FLG_RELQ_UNLIMIT CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_MULRQ_FORBID Prohibited Set for Multiplication Factor CBDUE_FLG_MULRQ_FORBID CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PDGNUDPRE Dangerous Goods Description Prefix CBDUE_PDGNUDPRE CHAR 21 0
PDGNUDSUF Dangerous Goods Description Suffix CBDUE_PDGNUDSUF CHAR 21 0
TEXTPATT_PROF01 Text Pattern Profile 01 ADGE_TEXTPATT_PROF01 TDG91 CHAR 10 0
TEXTPATT01 Dangerous Goods Text Pattern 01 ADGE_PTXTPATT01 CHAR 21 0
TEXTPATT_PROF02 Text Pattern Profile 02 ADGE_TEXTPATT_PROF02 TDG91 CHAR 10 0
TEXTPATT02 Dangerous Goods Text Pattern 02 ADGE_PTXTPATT02 CHAR 21 0
TEXTPATT_PROF03 Text Pattern Profile 03 ADGE_TEXTPATT_PROF03 TDG91 CHAR 10 0
TEXTPATT03 Dangerous Goods Text Pattern 03 ADGE_PTXTPATT03 CHAR 21 0
TEXTPATT_PROF04 Text Pattern Profile 04 ADGE_TEXTPATT_PROF04 TDG91 CHAR 10 0
TEXTPATT04 Dangerous Goods Text Pattern 04 ADGE_PTXTPATT04 CHAR 21 0
TEXTPATT_PROF05 Text Pattern Profile 05 ADGE_TEXTPATT_PROF05 TDG91 CHAR 10 0
TEXTPATT05 Dangerous Goods Text Pattern 05 ADGE_PTXTPATT05 CHAR 21 0
TEXTPATT_PROF06 Text Pattern Profile 06 ADGE_TEXTPATT_PROF06 TDG91 CHAR 10 0
TEXTPATT06 Dangerous Goods Text Pattern 06 ADGE_PTXTPATT06 CHAR 21 0
TEXTPATT_PROF07 Text Pattern Profile 07 ADGE_TEXTPATT_PROF07 TDG91 CHAR 10 0
TEXTPATT07 Dangerous Goods Text Pattern 07 ADGE_PTXTPATT07 CHAR 21 0
TEXTPATT_PROF08 Text Pattern Profile 08 ADGE_TEXTPATT_PROF08 TDG91 CHAR 10 0
TEXTPATT08 Dangerous Goods Text Pattern 08 ADGE_PTXTPATT08 CHAR 21 0
TEXTPATT_PROF09 Text Pattern Profile 09 ADGE_TEXTPATT_PROF09 TDG91 CHAR 10 0
TEXTPATT09 Dangerous Goods Text Pattern 09 ADGE_PTXTPATT09 CHAR 21 0
TEXTPATT_PROF10 Text Pattern Profile 10 ADGE_TEXTPATT_PROF10 TDG91 CHAR 10 0
TEXTPATT10 Dangerous Goods Text Pattern 10 ADGE_PTXTPATT10 CHAR 21 0
TEXTPATT_PROF11 Text Pattern Profile 11 ADGE_TEXTPATT_PROF11 TDG91 CHAR 10 0
TEXTPATT11 Dangerous Goods Text Pattern 11 ADGE_PTXTPATT11 CHAR 21 0
TEXTPATT_PROF12 Text Pattern Profile 12 ADGE_TEXTPATT_PROF12 TDG91 CHAR 10 0
TEXTPATT12 Dangerous Goods Text Pattern 12 ADGE_PTXTPATT12 CHAR 21 0
TEXTPATT_PROF13 Text Pattern Profile 13 ADGE_TEXTPATT_PROF13 TDG91 CHAR 10 0
TEXTPATT13 Dangerous Goods Text Pattern 13 ADGE_PTXTPATT13 CHAR 21 0
TEXTPATT_PROF14 Text Pattern Profile 14 ADGE_TEXTPATT_PROF14 TDG91 CHAR 10 0
TEXTPATT14 Dangerous Goods Text Pattern 14 ADGE_PTXTPATT14 CHAR 21 0
TEXTPATT_PROF15 Text Pattern Profile 15 ADGE_TEXTPATT_PROF15 TDG91 CHAR 10 0
TEXTPATT15 Dangerous Goods Text Pattern 15 ADGE_PTXTPATT15 CHAR 21 0
ABS_ACT Absolute Activity ADGE_ABS_ACT QUAN 11 4
ABS_ACT_U Unit of Absolute Activity ADGE_ABS_ACT_U T006 UNIT 3 0
REL_SPEC_ACT Relative Specific Activity ADGE_REL_SPEC_ACT QUAN 11 4
REL_SPEC_ACT_U Unit of Relative Specific Activity ADGE_REL_SPEC_ACT_U T006 UNIT 3 0
CONTAMINATION Contamination ADGE_CONTAMINATION QUAN 8 3
CONTAMINATION_U Unit of Contamination ADGE_CONTAMINATION_U T006 UNIT 3 0
DOSE_RATE Radiation Level (Unpacked) ADGE_DOSE_RATE QUAN 9 5
DOSE_RATE_U Unit of Radiation Level (Unpacked) ADGE_DOSE_RATE_U T006 UNIT 3 0
MAX_ACT1 A1 Activity Limit ADGE_MAX_ACT1 QUAN 11 4
MAX_ACT1_U A1 Activity Limit: Unit ADGE_MAX_ACT1_U T006 UNIT 3 0
ACT1_UNLIMIT A1 Activity Limit: Unlimited ADGE_ACT1_UNLIMIT CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
MAX_ACT2 A2 Activity Limit ADGE_MAX_ACT2 QUAN 11 4
MAX_ACT2_U A2 Activity Limit: Unit ADGE_MAX_ACT2_U T006 UNIT 3 0
ACT2_UNLIMIT A2 Activity Limit: Unlimited ADGE_ACT2_UNLIMIT CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
ACT_SUB_PACK Activity Concentration for Substances in Excepted Packages ADGE_ACT_SUB_PACK QUAN 11 4
ACT_SUB_PACK_U Activity Concentration Unit for Substances in Excepted Pkgs ADGE_ACT_SUB_PACK_U T006 UNIT 3 0
MAX_ACT_CONSG Activity Limit for Exempt Consignment ADGE_MAX_ACT_CONSG QUAN 11 4
MAX_ACT_CONSG_U Unit of Activity Limit for Exempt Consignment ADGE_MAX_ACT_CONSG_U T006 UNIT 3 0
MULT_ACT_SGL Multiplier Activity Limit Item ADGE_MULT_ACT_SGL DEC 11 7
REF_ACT_SGL Reference Value for Multiplier Item ADGE_REF_ACT_SGL CHAR 2 0
MULT_ACT_PACK Multiplier Activity Limit Package ADGE_MULT_ACT_PACK DEC 11 7
REF_ACT_PACK Reference Value for Multiplier Package ADGE_REF_ACT_PACK CHAR 2 0
MAX_CONT_A Contamination Limit (Alpha) ADGE_MAX_CONT_A QUAN 8 3
MAX_CONT_A_U Unit of Contamination Limit (Alpha) ADGE_MAX_CONT_A_U T006 UNIT 3 0
MAX_CONT_B_G Contamination Limit (Beta, Gamma) ADGE_MAX_CONT_B_G QUAN 8 3
MAX_CONT_B_G_U Unit of Contamination Limit (Beta, Gamma) ADGE_MAX_CONT_B_G_U T006 UNIT 3 0
MAX_DOSE_UNP Limit Radiation Level Unpacked ADGE_MAX_DOSE_UNP QUAN 9 5
MAX_DOSE_UNP_U Unit of Limit Radiation Level Unpacked ADGE_MAX_DOSE_UNP_U T006 UNIT 3 0
DIST_DOSE_UNP Measured Distance for Limit Unpacked ADGE_DIST_DOSE_UNP QUAN 5 3
DIST_DOSE_UNP_U Unit of Measured Distance for Limit Unpacked ADGE_DIST_DOSE_UNP_U T006 UNIT 3 0
NO_DIST_UNP Measurement Unpacked at Surface ADGE_NO_DIST_UNP CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
MAX_DOSE_PACK Limit Radiation Level Packed ADGE_MAX_DOSE_PACK QUAN 9 5
MAX_DOSE_PACK_U Unit of Limit Radiation Level Packed ADGE_MAX_DOSE_PACK_U T006 UNIT 3 0
DIST_DOSE_PACK Measured Distance for Limit Packed ADGE_DIST_DOSE_PACK QUAN 5 3
DIST_DOSE_PACK_U Unit of Measured Distance for Limit Packed ADGE_DIST_DOSE_PACK_U T006 UNIT 3 0
NO_DIST_PACK Measurement Packed at Surface ADGE_NO_DIST_PACK CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
MAX_ACT_SGL_DC Maximum Activity: Item ADGE_MAX_ACT_SGL_DC QUAN 11 4
MAX_ACT_SGL_U_DC Maximum Activity Unit: Item ADGE_MAX_ACT_SGL_DYN_U T006 UNIT 3 0
ACT_SGL_UNLIM_DC Maximum Activity of Item Unlimited ADGE_ACT_SGL_UNLIM_DC CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
MAX_ACT_PAC_DC Maximum Activity: Package ADGE_MAX_ACT_PAC_DC QUAN 11 4
MAX_ACT_PAC_U_DC Maximum Activity Unit: Package ADGE_MAX_ACT_PACK_DYN_U T006 UNIT 3 0
ACT_PAC_UNLIM_DC Maximum Activity of Package Unlimited ADGE_ACT_PAC_UNLIM_DC CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
EXCPT_PAC_OPT_DC Excepted Package: Optional ADGE_EXCPT_PAC_OPT_DC CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
MAX_GRS_WGHT_DC Maximum Gross Mass ADGE_MAX_GRS_WGHT_DC QUAN 8 2
U_MAX_GRS_WGT_DC Unit for Maximum Gross Mass ADGE_U_MAX_GROSS_WGHT T006 UNIT 3 0
EXCEPTID01 Exception to Dangerous Goods Regulations 01 ADGE_EXCEPTID01 CHAR 18 0
EXCEPTID02 Exception to Dangerous Goods Regulations 02 ADGE_EXCEPTID02 CHAR 18 0
EXCEPTID03 Exception to Dangerous Goods Regulations 03 ADGE_EXCEPTID03 CHAR 18 0
EXCEPTID04 Exception to Dangerous Goods Regulations 04 ADGE_EXCEPTID04 CHAR 18 0
EXCEPTID05 Exception to Dangerous Goods Regulations 05 ADGE_EXCEPTID05 CHAR 18 0
EXCEPTID06 Exception to Dangerous Goods Regulations 06 ADGE_EXCEPTID06 CHAR 18 0
EXCEPTID07 Exception to Dangerous Goods Regulations 07 ADGE_EXCEPTID07 CHAR 18 0
EXCEPTID08 Exception to Dangerous Goods Regulations 08 ADGE_EXCEPTID08 CHAR 18 0
EXCEPTID09 Exception to Dangerous Goods Regulations 09 ADGE_EXCEPTID09 CHAR 18 0
EXCEPTID10 Exception to Dangerous Goods Regulations 10 ADGE_EXCEPTID10 CHAR 18 0
ACT_EMIS_TYPE Radioactive Emission Type ADGE_ACT_EMIS_TYPE CHAR 3 0
A-- Alpha Radiation
-B- Beta Radiation
--G Gamma Radiation
AB- Alpha and Beta Radiation
A-G Alpha and Gamma Radiation
-BG Beta and Gamma Radiation
ABG Alpha, Beta, and Gamma Radiation
ND Not Determined
MAX_NEM_DC Maximum Net Explosive Substance Mass ADGE_MAX_NEM_DC QUAN 9 3
MAX_NEM_U_DC Unit of Maximum Net Explosive Substance Mass ADGE_MAX_NEM_DC_U UNIT 3 0
PINEQ Excepted Quantity: Packing Instruction Number ADGE_PINEQ CHAR 25 0
EXC_QUANT_IP Excepted Quantity: Maximum Quantity/Volume Inner Packaging ADGE_EXC_QUANT_IP QUAN 8 2
EXC_QUANT_IP_U Excepted Quantity: Unit of Meas. for Max.Qty Inner Packaging ADGE_EXC_QUANT_IP_U UNIT 3 0
EXC_QUANT_OP Excepted Quantity: Maximum Quantity/Volume Outer Packaging ADGE_EXC_QUANT_OP QUAN 8 2
EXC_QUANT_OP_U Excepted Quantity: Unit of Meas. for Max.Qty Outer Packaging ADGE_EXC_QUANT_OP_U UNIT 3 0
FLG_EXC_QUANT_IP Value Entered for Max. Qty Inner Packaging (Excepted Qty) ADGE_FLG_EXC_QUANT_IP CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLG_EXC_QUANT_OP Value Entered for Max. Qty Outer Packaging (Excepted Qty) ADGE_FLG_EXC_QUANT_OP CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive

DGTM2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DGTM2 ABS_ACT_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 ABS_ACT_U DGTM2 ABS_ACT_U T006 Units of Measurement MSEHI
DGTM2 ACTVTY_MAX_REL_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 ACTVTY_MAX_REL_U DGTM2 ACTVTY_MAX_REL_U T006 Units of Measurement MSEHI
DGTM2 ACTVTY_MAX_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 ACTVTY_MAX_U DGTM2 ACTVTY_MAX_U T006 Units of Measurement MSEHI
DGTM2 ACT_SUB_PACK_U DGTM2 ACT_SUB_PACK_U T006 Units of Measurement MSEHI
DGTM2 ACT_SUB_PACK_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 CONTAMINATION_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 CONTAMINATION_U DGTM2 CONTAMINATION_U T006 Units of Measurement MSEHI
DGTM2 DIST_DOSE_PACK_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 DIST_DOSE_PACK_U DGTM2 DIST_DOSE_PACK_U T006 Units of Measurement MSEHI
DGTM2 DIST_DOSE_UNP_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 DIST_DOSE_UNP_U DGTM2 DIST_DOSE_UNP_U T006 Units of Measurement MSEHI
DGTM2 DOSE_RATE_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 DOSE_RATE_U DGTM2 DOSE_RATE_U T006 Units of Measurement MSEHI
DGTM2 ESMLG1 SYST MANDT THM103 DG: Enterprise-Specific Mixed Loading Groups MANDT
DGTM2 ESMLG1 DGTM2 ESMLG1 THM103 DG: Enterprise-Specific Mixed Loading Groups ESMLG
DGTM2 ESMLG2 SYST MANDT THM103 DG: Enterprise-Specific Mixed Loading Groups MANDT
DGTM2 ESMLG2 DGTM2 ESMLG2 THM103 DG: Enterprise-Specific Mixed Loading Groups ESMLG
DGTM2 ESMLG3 SYST MANDT THM103 DG: Enterprise-Specific Mixed Loading Groups MANDT
DGTM2 ESMLG3 DGTM2 ESMLG3 THM103 DG: Enterprise-Specific Mixed Loading Groups ESMLG
DGTM2 EXPL_NET_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 EXPL_NET_U DGTM2 EXPL_NET_U T006 Units of Measurement MSEHI
DGTM2 MANDT DGTM2 MANDT T000 Clients MANDT
DGTM2 MAX_ACT1_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_ACT1_U DGTM2 MAX_ACT1_U T006 Units of Measurement MSEHI
DGTM2 MAX_ACT2_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_ACT2_U DGTM2 MAX_ACT2_U T006 Units of Measurement MSEHI
DGTM2 MAX_ACT_CONSG_U DGTM2 MAX_ACT_CONSG_U T006 Units of Measurement MSEHI
DGTM2 MAX_ACT_CONSG_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_ACT_PAC_U_DC SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_ACT_PAC_U_DC DGTM2 MAX_ACT_PAC_U_DC T006 Units of Measurement MSEHI
DGTM2 MAX_ACT_SGL_U_DC SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_ACT_SGL_U_DC DGTM2 MAX_ACT_SGL_U_DC T006 Units of Measurement MSEHI
DGTM2 MAX_CONT_A_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_CONT_A_U DGTM2 MAX_CONT_A_U T006 Units of Measurement MSEHI
DGTM2 MAX_CONT_B_G_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_CONT_B_G_U DGTM2 MAX_CONT_B_G_U T006 Units of Measurement MSEHI
DGTM2 MAX_DOSE_PACK_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_DOSE_PACK_U DGTM2 MAX_DOSE_PACK_U T006 Units of Measurement MSEHI
DGTM2 MAX_DOSE_UNP_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 MAX_DOSE_UNP_U DGTM2 MAX_DOSE_UNP_U T006 Units of Measurement MSEHI
DGTM2 MLOAR1 DGTM2 MLOAR1 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR1 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR1 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR2 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR2 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR2 DGTM2 MLOAR2 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR3 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR3 DGTM2 MLOAR3 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR3 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR4 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR4 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR4 DGTM2 MLOAR4 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR5 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR5 DGTM2 MLOAR5 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR5 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR6 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR6 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR6 DGTM2 MLOAR6 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR7 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR7 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR7 DGTM2 MLOAR7 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR8 DGTM2 MLOAR8 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOAR8 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR8 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR9 SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOAR9 * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MLOAR9 DGTM2 MLOAR9 THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOARA DGTM2 MLOARA THM097 DG: Mixed Loading Rules MLOAR
DGTM2 MLOARA SYST MANDT THM097 DG: Mixed Loading Rules MANDT
DGTM2 MLOARA * THM097 DG: Mixed Loading Rules LWDG
DGTM2 MSEPR1 DGTM2 MSEPR1 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR1 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR1 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR2 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR2 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR2 DGTM2 MSEPR2 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR3 DGTM2 MSEPR3 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR3 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR3 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR4 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR4 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR4 DGTM2 MSEPR4 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR5 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR5 DGTM2 MSEPR5 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR5 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR6 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR6 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR6 DGTM2 MSEPR6 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR7 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR7 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR7 DGTM2 MSEPR7 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR8 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR8 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR8 DGTM2 MSEPR8 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPR9 SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPR9 * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPR9 DGTM2 MSEPR9 THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRA DGTM2 MSEPRA THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRA SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRA * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRB SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRB * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRB DGTM2 MSEPRB THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRC * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRC DGTM2 MSEPRC THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRC SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRD SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRD * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRD DGTM2 MSEPRD THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRE * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRE DGTM2 MSEPRE THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRE SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRF SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRF * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRF DGTM2 MSEPRF THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRG SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRG * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRG DGTM2 MSEPRG THM091 DG: Dynamic Key DYKY
DGTM2 MSEPRH SYST MANDT THM091 DG: Dynamic Key MANDT
DGTM2 MSEPRH * THM091 DG: Dynamic Key LWDG
DGTM2 MSEPRH DGTM2 MSEPRH THM091 DG: Dynamic Key DYKY
DGTM2 REL_SPEC_ACT_U SYST MANDT T006 Units of Measurement MANDT
DGTM2 REL_SPEC_ACT_U DGTM2 REL_SPEC_ACT_U T006 Units of Measurement MSEHI
DGTM2 RQU2 DGTM2 RQU2 T006 Units of Measurement MSEHI
DGTM2 RQU2 SY MANDT T006 Units of Measurement MANDT
DGTM2 RSMLG1 SYST MANDT THM101 DG: Regulation-Dependent Mixed Loading Groups MANDT
DGTM2 RSMLG1 * THM101 DG: Regulation-Dependent Mixed Loading Groups LWDG
DGTM2 RSMLG1 DGTM2 RSMLG1 THM101 DG: Regulation-Dependent Mixed Loading Groups RSMLG
DGTM2 RSMLG2 * THM101 DG: Regulation-Dependent Mixed Loading Groups LWDG
DGTM2 RSMLG2 DGTM2 RSMLG2 THM101 DG: Regulation-Dependent Mixed Loading Groups RSMLG
DGTM2 RSMLG2 SYST MANDT THM101 DG: Regulation-Dependent Mixed Loading Groups MANDT
DGTM2 RSMLG3 SYST MANDT THM101 DG: Regulation-Dependent Mixed Loading Groups MANDT
DGTM2 RSMLG3 * THM101 DG: Regulation-Dependent Mixed Loading Groups LWDG
DGTM2 RSMLG3 DGTM2 RSMLG3 THM101 DG: Regulation-Dependent Mixed Loading Groups RSMLG
DGTM2 STOWAGE SYST MANDT CCUNC111 Stowage Categories MANDT
DGTM2 STOWAGE * CCUNC111 Stowage Categories LWDG
DGTM2 STOWAGE DGTM2 STOWAGE CCUNC111 Stowage Categories STOWAGE
DGTM2 TEXTPATT_PROF01 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF01 DGTM2 TEXTPATT_PROF01 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF02 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF02 DGTM2 TEXTPATT_PROF02 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF03 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF03 DGTM2 TEXTPATT_PROF03 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF04 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF04 DGTM2 TEXTPATT_PROF04 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF05 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF05 DGTM2 TEXTPATT_PROF05 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF06 DGTM2 TEXTPATT_PROF06 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF06 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF07 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF07 DGTM2 TEXTPATT_PROF07 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF08 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF08 DGTM2 TEXTPATT_PROF08 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF09 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF09 DGTM2 TEXTPATT_PROF09 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF10 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF10 DGTM2 TEXTPATT_PROF10 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF11 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF11 DGTM2 TEXTPATT_PROF11 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF12 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF12 DGTM2 TEXTPATT_PROF12 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF13 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF13 DGTM2 TEXTPATT_PROF13 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF14 DGTM2 TEXTPATT_PROF14 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 TEXTPATT_PROF14 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF15 SYST MANDT TDG91 Text Pattern Profiles MANDT
DGTM2 TEXTPATT_PROF15 DGTM2 TEXTPATT_PROF15 TDG91 Text Pattern Profiles TEXTPATT_PROF
DGTM2 UMIOW * T006 Units of Measurement MANDT
DGTM2 UMIOW DGTM2 UMIOW T006 Units of Measurement MSEHI
DGTM2 U_MAX_GRS_WGT_DC SYST MANDT T006 Units of Measurement MANDT
DGTM2 U_MAX_GRS_WGT_DC DGTM2 U_MAX_GRS_WGT_DC T006 Units of Measurement MSEHI