Menu

SAP Table DGTM2

DG: Dangerous Goods Master (App. Table)

The table DGTM2 (DG: Dangerous Goods Master (App. Table)) is a standard table in SAP ERP. It belongs to the package CBDG.

Technical Information

Table DGTM2
Short Text DG: Dangerous Goods Master (App. Table)
Package CBDG
Table Type Transparent Table

Fields for Table DGTM2

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