SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

DGMS2 Table in SAP | DG: Dangerous Goods Document Table (Appendix Table) Table & Fields List

DGMS2 is a SAP table coming under EHS module and SAP_APPL component.View details, Fields & related tables of DGMS2 in SAP.

  • Table description : DG: Dangerous Goods Document Table (Appendix Table)
  • Module : EHS
  • Parent Module : EHS
  • Package : CBEHS
  • Software Component : SAP_APPL
DGMS2 table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP DGMS2 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
VBELNSales and Distribution Document NumberVBELNVBELN
POSNRSales Document ItemPOSNR_VAPOSNR
LFDNRCounter used to differentiate between data base entriesJ_ZAEHLJ_ZAEHL
.INCLUDEDG: Structure for Enhanced Dangerous Goods Master Model    
.INCLUDEEHS: Application Data for Table CCDUTTRAPPR    
TRANSP_TYPEDangerous Goods Transport TypeTHME_MOSHMD_MOS
TRANSP_APPROVEDTransport PermittedCBDUE_FLG_TRANSP_APPRCBUND_FLG
LEG_SRC_RESTRRegulatory Basis for Transport RestrictionsCBDUE_LEG_SRC_RESTRCBUND_LEG_SRC_RESTR
RESTR_PHRKEYPhrase Key for Transport RestrictionCBDUE_RESTR_PHRKEYCBDUD_FIELD_WITH_PHRASE
MIN_QUANTMinimum Quantity for RestrictionCBDUE_MIN_QUANTHMD_QUAN
U_MIN_QUANTUnit of Measurement for Minimum QuantityCBDUE_U_MIN_QUANTMEINS
FLG_MIN_QUANTValue Entered for Minimum Quantity for RestrictionCBDUE_FLG_MIN_QUANTCBUND_FLG
MAX_QUANTMaximum Quantity for ExemptionCBDUE_MAX_QUANTHMD_QUAN
U_MAX_QUANTUnit of Measurement for Maximum QuantityCBDUE_U_MAX_QUANTMEINS
FLG_MAX_QUANTValue Entered for Maximum Quantity for RestrictionCBDUE_FLG_MAX_QUANTCBUND_FLG
.INCLUDEEHS: Relevant Output Fields of Table CCDUTCARR    
.INCLUDEEHS: Application Data for Table CCDUTCARR    
SPPROV_PHRKEYPhrase Key for Special ProvisionCBDUE_SP_PHRKEYCBDUD_FIELD_WITH_PHRASE
SP_PRINT_PHRKEYPhrase Key for Special Provision Print TextCBDUE_SP_PRINT_PHRKEYCBDUD_FIELD_WITH_PHRASE
MIX_PACK_PHRKEYPhrase Key for Mixed PackingCBDUE_MIX_PACK_PHRKEYCBDUD_FIELD_WITH_PHRASE
SEGREGAT_PHRKEYPhrase Key for Segregation RegulationCBDUE_SEGREGAT_PHRKEYCBDUD_FIELD_WITH_PHRASE
PACKAGES_PHRKEYPhrase Key for PackagesCBDUE_PACKAGES_PHRKEYCBDUD_FIELD_WITH_PHRASE
BULK_PHRKEYPhrase Key for BulkCBDUE_BULK_PHRKEYCBDUD_FIELD_WITH_PHRASE
HANDLING_PHRKEYPhrase Key for HandlingCBDUE_HANDLING_PHRKEYCBDUD_FIELD_WITH_PHRASE
OPERATION_PHRKEYPhrase Key for OperationCBDUE_OPERATION_PHRKEYCBDUD_FIELD_WITH_PHRASE
VEHICLE_PHRKEYPhrase Key for VehicleCBDUE_VEHICLE_PHRKEYCBDUD_FIELD_WITH_PHRASE
SP_PRINT_PHRKEY1Phrase Key for Special Provision Print TextCBDUE_SP_PRINT_PHRKEYCBDUD_FIELD_WITH_PHRASE
SP_PRINT_PHRKEY2Phrase Key for Special Provision Print TextCBDUE_SP_PRINT_PHRKEYCBDUD_FIELD_WITH_PHRASE
SP_PRINT_PHRKEY3Phrase Key for Special Provision Print TextCBDUE_SP_PRINT_PHRKEYCBDUD_FIELD_WITH_PHRASE
.INCLUDEEHS: Application Data for Table CCDUTDGREL    
PRIO_ALTERNPriority of ReleaseCBDUE_PRIO_ALTERNNUMC2
FLG_RELEASEDProduct Released for RegulationCBDUE_FLG_RELEASEDX
FLG_TRANS_PERMTransport Not PermittedCBDUE_FLG_TRANS_PERMX
FLG_NO_DGNot Dangerous GoodsCBDUE_FLG_NO_DGX
FLG_LQLimited QuantityCBDUE_FLG_LQX
FLG_RQReportable QuantityCBDUE_FLG_RQX
INSTR_ENCLActual Instruction for EnclosureCBDUE_INSTR_ENCLCBUND_INSTR_ENCL
FLG_SINGLE_PACKSingle PackagingCBDUE_FLG_SGL_PACKX
PACODActual Packaging CodeCBDUE_PACODCBUND_PACOD
QUANT_OUT_PACKQuantity Single/Outer PackagingCBDUE_QUANT_OUTHMD_QUAN
U_QUANT_OUT_PACKUnit of Measurement for Quantity Outer PackagingCBDUE_U_QUANT_OUTMEINS
PACK_NOTENote for ReleaseCBDUE_PACK_NOTECBDUD_FIELD_WITH_PHRASE
RECN_SUBSequential Number of Data RecordESERECNESDRECN
RECN_CLASSSequential Number of Data RecordESERECNESDRECN
FLG_CCConsumer CommodityCBDUE_FLG_CCX
FLG_PACKEDPacked GoodsCBDUE_FLG_PACKEDX
TRANSPORT_TYPEActual Transport TypeCBDUE_TRANSP_TYPEHMD_MOS
APPROVAL_CODEFull UN Packaging CodeCBDUE_APPROVAL_CODECHAR72
MAT_DAMAGED_CL7Damaged Material (Class 7)ADGE_MAT_DAMAGED_CL7ADGD_YES_NO_NOT_DEFINED
MAX_GROSS_WEIGHTMaximum Gross MassADGE_MAX_GROSS_WEIGHTHMD_QUAN
U_MAX_GROSS_WGHTUnit for Maximum Gross MassADGE_U_MAX_GROSS_WGHTMEINS
SUBID_DG_CLASSKey (ID) of Dangerous Goods ClassificationADGE_SUBID_CLASSCHAR12
EMV_DYNElectromagnetic CompatibilityADGE_EMV_DYNEHS_ADGD_CODE
LTSK_DYNAir Transport Safety CodeADGE_LTSK_DYNEHS_ADGD_CODE
EXPL_NET_DYNNet Explosive Substance MassADGE_EXPL_NET_DYNEHS_ADGD_Q93
EXPL_NET_DYN_UUnit for Net Explosive Substance MassEHS_ADGE_EXPL_NET_UMEINS
MAX_ACT_SGLMaximum Activity: ItemADGE_MAX_ACT_SGL_DYNADGD_QUAN_11_4
MAX_ACT_SGL_UMaximum Activity Unit: ItemADGE_MAX_ACT_SGL_DYN_UMEINS
ACT_SGL_UNLIMITMaximum Activity of Item UnlimitedADGE_ACT_SGL_DYN_UNLIMITESDFLAG
MAX_ACT_PACKMaximum Activity: PackageADGE_MAX_ACT_PACK_DYNADGD_QUAN_11_4
MAX_ACT_PACK_UMaximum Activity Unit: PackageADGE_MAX_ACT_PACK_DYN_UMEINS
ACT_PACK_UNLIMITMaximum Activity of Package UnlimitedADGE_ACT_PACK_DYN_UNLIMITESDFLAG
EXCEPT_PACK_OPTExcepted Package: OptionalADGE_EXCEPT_PACK_OPTESDFLAG
DG_USE_CASEDangerous Goods: UseADGE_DG_USE_CASEADGD_DG_USE_CASE
PRIO_DYNCLPriority of Dynamic ClassificationADGE_PRIO_DYNCLNUMC2
MAX_NEMMaximum Net Explosive Substance MassADGE_MAX_NEM_DYNEHS_ADGD_Q93
MAX_NEM_UUnit of Maximum Net Explosive Substance MassADGE_MAX_NEM_DYN_UMEINS
.INCLU--APStructure-Append Application Data Table CCDUTDGREL EhP3    
DUMMY_RCBDUDGREL   
.INCLU--APStructure Append Application Data Table CCDUTDGREL EhP5    
FLG_EQExcepted QuantityADGE_EXC_QUANTX
.INCLU--APStructure Append Application Data Table CCDUTDGREL EhP6    
.INCLUDEStructure for Transport Indicators in Product Release    
DGREL_TRANSIND01Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND02Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND03Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND04Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND05Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND06Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND07Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
DGREL_TRANSIND08Indicator for TransportADGE_TRANSPORT_INDICATORADGD_TRANSPORT_INDICATOR
PACKAGE_MATNRPacking MaterialCBDUE_PACKMATMATNR
MATNR_REPLACEMaterial Number of Replacement MaterialADGE_MATNR_REPLACEMATNR
.INCLUDEDG: Structure for Dangerous Goods Master Table DGTM2    
TEXTPATT_PROF01Text Pattern Profile 01ADGE_TEXTPATT_PROF01ADGD_TEXTPATT_PROF
TEXTPATT01Dangerous Goods Text Pattern 01ADGE_PTXTPATT01CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF02Text Pattern Profile 02ADGE_TEXTPATT_PROF02ADGD_TEXTPATT_PROF
TEXTPATT02Dangerous Goods Text Pattern 02ADGE_PTXTPATT02CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF03Text Pattern Profile 03ADGE_TEXTPATT_PROF03ADGD_TEXTPATT_PROF
TEXTPATT03Dangerous Goods Text Pattern 03ADGE_PTXTPATT03CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF04Text Pattern Profile 04ADGE_TEXTPATT_PROF04ADGD_TEXTPATT_PROF
TEXTPATT04Dangerous Goods Text Pattern 04ADGE_PTXTPATT04CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF05Text Pattern Profile 05ADGE_TEXTPATT_PROF05ADGD_TEXTPATT_PROF
TEXTPATT05Dangerous Goods Text Pattern 05ADGE_PTXTPATT05CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF06Text Pattern Profile 06ADGE_TEXTPATT_PROF06ADGD_TEXTPATT_PROF
TEXTPATT06Dangerous Goods Text Pattern 06ADGE_PTXTPATT06CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF07Text Pattern Profile 07ADGE_TEXTPATT_PROF07ADGD_TEXTPATT_PROF
TEXTPATT07Dangerous Goods Text Pattern 07ADGE_PTXTPATT07CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF08Text Pattern Profile 08ADGE_TEXTPATT_PROF08ADGD_TEXTPATT_PROF
TEXTPATT08Dangerous Goods Text Pattern 08ADGE_PTXTPATT08CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF09Text Pattern Profile 09ADGE_TEXTPATT_PROF09ADGD_TEXTPATT_PROF
TEXTPATT09Dangerous Goods Text Pattern 09ADGE_PTXTPATT09CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF10Text Pattern Profile 10ADGE_TEXTPATT_PROF10ADGD_TEXTPATT_PROF
TEXTPATT10Dangerous Goods Text Pattern 10ADGE_PTXTPATT10CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF11Text Pattern Profile 11ADGE_TEXTPATT_PROF11ADGD_TEXTPATT_PROF
TEXTPATT11Dangerous Goods Text Pattern 11ADGE_PTXTPATT11CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF12Text Pattern Profile 12ADGE_TEXTPATT_PROF12ADGD_TEXTPATT_PROF
TEXTPATT12Dangerous Goods Text Pattern 12ADGE_PTXTPATT12CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF13Text Pattern Profile 13ADGE_TEXTPATT_PROF13ADGD_TEXTPATT_PROF
TEXTPATT13Dangerous Goods Text Pattern 13ADGE_PTXTPATT13CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF14Text Pattern Profile 14ADGE_TEXTPATT_PROF14ADGD_TEXTPATT_PROF
TEXTPATT14Dangerous Goods Text Pattern 14ADGE_PTXTPATT14CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF15Text Pattern Profile 15ADGE_TEXTPATT_PROF15ADGD_TEXTPATT_PROF
TEXTPATT15Dangerous Goods Text Pattern 15ADGE_PTXTPATT15CBDUD_FIELD_WITH_PHRASE
ABS_ACTAbsolute ActivityADGE_ABS_ACTADGD_QUAN_11_4
ABS_ACT_UUnit of Absolute ActivityADGE_ABS_ACT_UMEINS
REL_SPEC_ACTRelative Specific ActivityADGE_REL_SPEC_ACTADGD_QUAN_11_4
REL_SPEC_ACT_UUnit of Relative Specific ActivityADGE_REL_SPEC_ACT_UMEINS
CONTAMINATIONContaminationADGE_CONTAMINATIONADGD_QUAN_8_3
CONTAMINATION_UUnit of ContaminationADGE_CONTAMINATION_UMEINS
DOSE_RATERadiation Level (Unpacked)ADGE_DOSE_RATEADGD_QUAN_9_5
DOSE_RATE_UUnit of Radiation Level (Unpacked)ADGE_DOSE_RATE_UMEINS
MAX_ACT1A1 Activity LimitADGE_MAX_ACT1ADGD_QUAN_11_4
MAX_ACT1_UA1 Activity Limit: UnitADGE_MAX_ACT1_UMEINS
ACT1_UNLIMITA1 Activity Limit: UnlimitedADGE_ACT1_UNLIMITESDFLAG
MAX_ACT2A2 Activity LimitADGE_MAX_ACT2ADGD_QUAN_11_4
MAX_ACT2_UA2 Activity Limit: UnitADGE_MAX_ACT2_UMEINS
ACT2_UNLIMITA2 Activity Limit: UnlimitedADGE_ACT2_UNLIMITESDFLAG
ACT_SUB_PACKActivity Concentration for Substances in Excepted PackagesADGE_ACT_SUB_PACKADGD_QUAN_11_4
ACT_SUB_PACK_UActivity Concentration Unit for Substances in Excepted PkgsADGE_ACT_SUB_PACK_UMEINS
MAX_ACT_CONSGActivity Limit for Exempt ConsignmentADGE_MAX_ACT_CONSGADGD_QUAN_11_4
MAX_ACT_CONSG_UUnit of Activity Limit for Exempt ConsignmentADGE_MAX_ACT_CONSG_UMEINS
MULT_ACT_SGLMultiplier Activity Limit ItemADGE_MULT_ACT_SGLADGD_DEC_11_7
REF_ACT_SGLReference Value for Multiplier ItemADGE_REF_ACT_SGLADGD_REF_ACT
MULT_ACT_PACKMultiplier Activity Limit PackageADGE_MULT_ACT_PACKADGD_DEC_11_7
REF_ACT_PACKReference Value for Multiplier PackageADGE_REF_ACT_PACKADGD_REF_ACT
MAX_CONT_AContamination Limit (Alpha)ADGE_MAX_CONT_AADGD_QUAN_8_3
MAX_CONT_A_UUnit of Contamination Limit (Alpha)ADGE_MAX_CONT_A_UMEINS
MAX_CONT_B_GContamination Limit (Beta, Gamma)ADGE_MAX_CONT_B_GADGD_QUAN_8_3
MAX_CONT_B_G_UUnit of Contamination Limit (Beta, Gamma)ADGE_MAX_CONT_B_G_UMEINS
MAX_DOSE_UNPLimit Radiation Level UnpackedADGE_MAX_DOSE_UNPADGD_QUAN_9_5
MAX_DOSE_UNP_UUnit of Limit Radiation Level UnpackedADGE_MAX_DOSE_UNP_UMEINS
DIST_DOSE_UNPMeasured Distance for Limit UnpackedADGE_DIST_DOSE_UNPADGD_QUAN_5_3
DIST_DOSE_UNP_UUnit of Measured Distance for Limit UnpackedADGE_DIST_DOSE_UNP_UMEINS
NO_DIST_UNPMeasurement Unpacked at SurfaceADGE_NO_DIST_UNPESDFLAG
MAX_DOSE_PACKLimit Radiation Level PackedADGE_MAX_DOSE_PACKADGD_QUAN_9_5
MAX_DOSE_PACK_UUnit of Limit Radiation Level PackedADGE_MAX_DOSE_PACK_UMEINS
DIST_DOSE_PACKMeasured Distance for Limit PackedADGE_DIST_DOSE_PACKADGD_QUAN_5_3
DIST_DOSE_PACK_UUnit of Measured Distance for Limit PackedADGE_DIST_DOSE_PACK_UMEINS
NO_DIST_PACKMeasurement Packed at SurfaceADGE_NO_DIST_PACKESDFLAG
MAX_ACT_SGL_DCMaximum Activity: ItemADGE_MAX_ACT_SGL_DCADGD_QUAN_11_4
MAX_ACT_SGL_U_DCMaximum Activity Unit: ItemADGE_MAX_ACT_SGL_DYN_UMEINS
ACT_SGL_UNLIM_DCMaximum Activity of Item UnlimitedADGE_ACT_SGL_UNLIM_DCESDFLAG
MAX_ACT_PAC_DCMaximum Activity: PackageADGE_MAX_ACT_PAC_DCADGD_QUAN_11_4
MAX_ACT_PAC_U_DCMaximum Activity Unit: PackageADGE_MAX_ACT_PACK_DYN_UMEINS
ACT_PAC_UNLIM_DCMaximum Activity of Package UnlimitedADGE_ACT_PAC_UNLIM_DCESDFLAG
EXCPT_PAC_OPT_DCExcepted Package: OptionalADGE_EXCPT_PAC_OPT_DCESDFLAG
MAX_GRS_WGHT_DCMaximum Gross MassADGE_MAX_GRS_WGHT_DCHMD_QUAN
U_MAX_GRS_WGT_DCUnit for Maximum Gross MassADGE_U_MAX_GROSS_WGHTMEINS
EXCEPTID01Exception to Dangerous Goods Regulations 01ADGE_EXCEPTID01ADGD_EXCEPTID
EXCEPTID02Exception to Dangerous Goods Regulations 02ADGE_EXCEPTID02ADGD_EXCEPTID
EXCEPTID03Exception to Dangerous Goods Regulations 03ADGE_EXCEPTID03ADGD_EXCEPTID
EXCEPTID04Exception to Dangerous Goods Regulations 04ADGE_EXCEPTID04ADGD_EXCEPTID
EXCEPTID05Exception to Dangerous Goods Regulations 05ADGE_EXCEPTID05ADGD_EXCEPTID
EXCEPTID06Exception to Dangerous Goods Regulations 06ADGE_EXCEPTID06ADGD_EXCEPTID
EXCEPTID07Exception to Dangerous Goods Regulations 07ADGE_EXCEPTID07ADGD_EXCEPTID
EXCEPTID08Exception to Dangerous Goods Regulations 08ADGE_EXCEPTID08ADGD_EXCEPTID
EXCEPTID09Exception to Dangerous Goods Regulations 09ADGE_EXCEPTID09ADGD_EXCEPTID
EXCEPTID10Exception to Dangerous Goods Regulations 10ADGE_EXCEPTID10ADGD_EXCEPTID
ACT_EMIS_TYPERadioactive Emission TypeADGE_ACT_EMIS_TYPEADGD_ACT_EMIS_TYPE
MAX_NEM_DCMaximum Net Explosive Substance MassADGE_MAX_NEM_DCEHS_ADGD_Q93
MAX_NEM_U_DCUnit of Maximum Net Explosive Substance MassADGE_MAX_NEM_DC_UMEINS
.INCLUDEDG: Structure for Dangerous Goods Master Table DGTM2    
PINEQExcepted Quantity: Packing Instruction NumberADGE_PINEQHMD_PIN
EXC_QUANT_IPExcepted Quantity: Maximum Quantity/Volume Inner PackagingADGE_EXC_QUANT_IPHMD_QUAN
EXC_QUANT_IP_UExcepted Quantity: Unit of Meas. for Max.Qty Inner PackagingADGE_EXC_QUANT_IP_UMEINS
EXC_QUANT_OPExcepted Quantity: Maximum Quantity/Volume Outer PackagingADGE_EXC_QUANT_OPHMD_QUAN
EXC_QUANT_OP_UExcepted Quantity: Unit of Meas. for Max.Qty Outer PackagingADGE_EXC_QUANT_OP_UMEINS
FLG_EXC_QUANT_IPValue Entered for Max. Qty Inner Packaging (Excepted Qty)ADGE_FLG_EXC_QUANT_IPCBUND_FLG
FLG_EXC_QUANT_OPValue Entered for Max. Qty Outer Packaging (Excepted Qty)ADGE_FLG_EXC_QUANT_OPCBUND_FLG

DGMS2 related tables

TableNote
DGMS2DG: Dangerous Goods Document Table (Appendix Table)
LIPSDGAppendix Table for Dangerous Goods Data
VBEPDGAppendix Table for Dangerous Goods Data
DGMSDDG: Dangerous Goods Document Table DGMSD
TZ18Appendix group R11/76, appendix 1-5 and R2/87, append. 1-2
DGREL_LOCK_KEYDangerous Goods: Lock Table for CCDUTDGREL
DGTM2DG: Dangerous Goods Master (App. Table)
TDG96DG: Text Table for Level of Dangerous Goods Packaging
CCGLC_DGPHRRELEHS: GHS/Dangerous Goods: Phrase Assignment
DGTEXCCHKMETHExceptions to Dangerous Goods Regulations: Check Methods
DGTEXCCNTRIESExceptions to Dangerous Goods Regulations: Countries
DGTMDDG: Dangerous Goods Master
EST07EHS: Dangerous Goods Management - Transport Approval
EST0BEHS: Dangerous Goods Management - Packaging Code Approval
EST0DEHS: Dangerous Goods Management - Risk Classification
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com