dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table DGMS2

DG: Dangerous Goods Document Table (Appendix 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 DGMS2 (DG: Dangerous Goods Document Table (Appendix Table)) is a standard table in SAP ERP. It belongs to the package CBDG.

Technical Information

Table DGMS2
Short Text DG: Dangerous Goods Document Table (Appendix Table)
Package CBDG
Table Type Transparent Table

Fields for Table DGMS2

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 T000
VBELN ✔ Sales and Distribution Document Number VBELN CHAR 10 VBUK
POSNR ✔ Sales Document Item POSNR_VA NUMC 6 VBUP
LFDNR ✔ Counter used to differentiate between data base entries J_ZAEHL NUMC 4
TRANSP_TYPE Dangerous Goods Transport Type THME_MOS NUMC 3 THM003
TRANSP_APPROVED Transport Permitted CBDUE_FLG_TRANSP_APPR CHAR 1
LEG_SRC_RESTR Regulatory Basis for Transport Restrictions CBDUE_LEG_SRC_RESTR CHAR 25 CCUNC117
RESTR_PHRKEY Phrase Key for Transport Restriction CBDUE_RESTR_PHRKEY CHAR 21
MIN_QUANT Minimum Quantity for Restriction CBDUE_MIN_QUANT QUAN 8
U_MIN_QUANT Unit of Measurement for Minimum Quantity CBDUE_U_MIN_QUANT UNIT 3 *
FLG_MIN_QUANT Value Entered for Minimum Quantity for Restriction CBDUE_FLG_MIN_QUANT CHAR 1
MAX_QUANT Maximum Quantity for Exemption CBDUE_MAX_QUANT QUAN 8
U_MAX_QUANT Unit of Measurement for Maximum Quantity CBDUE_U_MAX_QUANT UNIT 3 *
FLG_MAX_QUANT Value Entered for Maximum Quantity for Restriction CBDUE_FLG_MAX_QUANT CHAR 1
SPPROV_PHRKEY Phrase Key for Special Provision CBDUE_SP_PHRKEY CHAR 21
SP_PRINT_PHRKEY Phrase Key for Special Provision Print Text CBDUE_SP_PRINT_PHRKEY CHAR 21
MIX_PACK_PHRKEY Phrase Key for Mixed Packing CBDUE_MIX_PACK_PHRKEY CHAR 21
SEGREGAT_PHRKEY Phrase Key for Segregation Regulation CBDUE_SEGREGAT_PHRKEY CHAR 21
PACKAGES_PHRKEY Phrase Key for Packages CBDUE_PACKAGES_PHRKEY CHAR 21
BULK_PHRKEY Phrase Key for Bulk CBDUE_BULK_PHRKEY CHAR 21
HANDLING_PHRKEY Phrase Key for Handling CBDUE_HANDLING_PHRKEY CHAR 21
OPERATION_PHRKEY Phrase Key for Operation CBDUE_OPERATION_PHRKEY CHAR 21
VEHICLE_PHRKEY Phrase Key for Vehicle CBDUE_VEHICLE_PHRKEY CHAR 21
SP_PRINT_PHRKEY1 Phrase Key for Special Provision Print Text CBDUE_SP_PRINT_PHRKEY CHAR 21
SP_PRINT_PHRKEY2 Phrase Key for Special Provision Print Text CBDUE_SP_PRINT_PHRKEY CHAR 21
SP_PRINT_PHRKEY3 Phrase Key for Special Provision Print Text CBDUE_SP_PRINT_PHRKEY CHAR 21
PRIO_ALTERN Priority of Release CBDUE_PRIO_ALTERN NUMC 2
FLG_RELEASED Product Released for Regulation CBDUE_FLG_RELEASED CHAR 1
FLG_TRANS_PERM Transport Not Permitted CBDUE_FLG_TRANS_PERM CHAR 1
FLG_NO_DG Not Dangerous Goods CBDUE_FLG_NO_DG CHAR 1
FLG_LQ Limited Quantity CBDUE_FLG_LQ CHAR 1
FLG_RQ Reportable Quantity CBDUE_FLG_RQ CHAR 1
INSTR_ENCL Actual Instruction for Enclosure CBDUE_INSTR_ENCL CHAR 10 CCUNC115
FLG_SINGLE_PACK Single Packaging CBDUE_FLG_SGL_PACK CHAR 1
PACOD Actual Packaging Code CBDUE_PACOD CHAR 10 CCUNC121
QUANT_OUT_PACK Quantity Single/Outer Packaging CBDUE_QUANT_OUT QUAN 8
U_QUANT_OUT_PACK Unit of Measurement for Quantity Outer Packaging CBDUE_U_QUANT_OUT UNIT 3 T006
PACK_NOTE Note for Release CBDUE_PACK_NOTE CHAR 21
RECN_SUB Sequential Number of Data Record ESERECN NUMC 20
RECN_CLASS Sequential Number of Data Record ESERECN NUMC 20
FLG_CC Consumer Commodity CBDUE_FLG_CC CHAR 1
FLG_PACKED Packed Goods CBDUE_FLG_PACKED CHAR 1
TRANSPORT_TYPE Actual Transport Type CBDUE_TRANSP_TYPE NUMC 3 THM003
APPROVAL_CODE Full UN Packaging Code CBDUE_APPROVAL_CODE CHAR 72
MAT_DAMAGED_CL7 Damaged Material (Class 7) ADGE_MAT_DAMAGED_CL7 CHAR 1
MAX_GROSS_WEIGHT Maximum Gross Mass ADGE_MAX_GROSS_WEIGHT QUAN 8
U_MAX_GROSS_WGHT Unit for Maximum Gross Mass ADGE_U_MAX_GROSS_WGHT UNIT 3 *
SUBID_DG_CLASS Key (ID) of Dangerous Goods Classification ADGE_SUBID_CLASS CHAR 12
EMV_DYN Electromagnetic Compatibility ADGE_EMV_DYN CHAR 1
LTSK_DYN Air Transport Safety Code ADGE_LTSK_DYN CHAR 1
EXPL_NET_DYN Net Explosive Substance Mass ADGE_EXPL_NET_DYN QUAN 9
EXPL_NET_DYN_U Unit for Net Explosive Substance Mass EHS_ADGE_EXPL_NET_U UNIT 3 *
MAX_ACT_SGL Maximum Activity: Item ADGE_MAX_ACT_SGL_DYN QUAN 11
MAX_ACT_SGL_U Maximum Activity Unit: Item ADGE_MAX_ACT_SGL_DYN_U UNIT 3 *
ACT_SGL_UNLIMIT Maximum Activity of Item Unlimited ADGE_ACT_SGL_DYN_UNLIMIT CHAR 1
MAX_ACT_PACK Maximum Activity: Package ADGE_MAX_ACT_PACK_DYN QUAN 11
MAX_ACT_PACK_U Maximum Activity Unit: Package ADGE_MAX_ACT_PACK_DYN_U UNIT 3 *
ACT_PACK_UNLIMIT Maximum Activity of Package Unlimited ADGE_ACT_PACK_DYN_UNLIMIT CHAR 1
EXCEPT_PACK_OPT Excepted Package: Optional ADGE_EXCEPT_PACK_OPT CHAR 1
DG_USE_CASE Dangerous Goods: Use Case ADGE_DG_USE_CASE CHAR 1
PRIO_DYNCL Priority of Dynamic Classification ADGE_PRIO_DYNCL NUMC 2
MAX_NEM Maximum Net Explosive Substance Mass ADGE_MAX_NEM_DYN QUAN 9
MAX_NEM_U Unit of Maximum Net Explosive Substance Mass ADGE_MAX_NEM_DYN_U UNIT 3 *
DUMMY_RCBDUDGREL Dummy Fld CHAR 1
FLG_EQ Excepted Quantity ADGE_EXC_QUANT CHAR 1
DGREL_TRANSIND01 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
DGREL_TRANSIND02 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
DGREL_TRANSIND03 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
DGREL_TRANSIND04 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
DGREL_TRANSIND05 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
DGREL_TRANSIND06 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
DGREL_TRANSIND07 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
DGREL_TRANSIND08 Indicator for Transport ADGE_TRANSPORT_INDICATOR CHAR 10
PACKAGE_MATNR Packing Material CBDUE_PACKMAT CHAR 18 *
MATNR_REPLACE Material Number of Replacement Material ADGE_MATNR_REPLACE CHAR 18 *
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