Menu

SAP Table DGMS2

DG: Dangerous Goods Document Table (Appendix Table)

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