Menu

SAP Table DGTM2

DG: Dangerous Goods Master (App. Table)

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

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