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

DGTMD Table in SAP | DG: Dangerous Goods Master Table & Fields List

DGTMD is a SAP table coming under CA module and SAP_ABA component.View details, Fields & related tables of DGTMD in SAP.

  • Table description : DG: Dangerous Goods Master
  • Module : CA-GTF-EHS
  • Parent Module : CA
  • Package : CBEHS_DGP
  • Software Component : SAP_ABA
DGTMD 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 DGTMD Table Fields structure

FieldNoteData ElementDomain
.INCLUDEEHS: Structure for key info of master data    
MANDTClientMANDTMANDT
RECNSequential Number of Data RecordESERECNESDRECN
ACTNSequential Number of the Change StateESEACTNESDACTN
.INCLUDEDG: Structure for General Administration Information    
VALFRValid-From DateESEVALFRDATUM
VALTOValid-To DateESEVALTODATUM
AENNRChange NumberESEAENNRAENNR
DELFLGDeletion IndicatorADGE_DELFLGESDFLAG
PARKFLGData Record Is InactiveESEPARKFLGESDFLAG
CRDATCreated OnESECRDATDATUM
CRNAMCreated ByESECRNAMUSNAM
UPDDATChanged OnESEUPDDATDATUM
UPDNAMLast Changed ByESEUPDNAMUSNAM
SRSIDSource of DataESESRSIDESDSRSID
OWNIDData ProviderESEVENDRIDAD_ADDRNUM
RECNROOTSequential Number of Data RecordESERECNESDRECN
.INCLUDEEHS: Logical Database Key to RDGKEY    
MATNRMaterial or Product (Internal Key)BASE_MATIDBASD_MATID
MOTDangerous Goods - Mode-of-Transport CategoryTHME_MOTHMD_MOT
RVLIDValidity AreaESERVLIDESDRVLID
.INCLUDEEHS: Application Data for Table DGTMD    
DGNHMNon-Dangerous Goods Full TransportTHME_NHMHMD_NDG
DGCAOOnly Cargo Air Transport PermittedADGE_DGCAOX
TKUIIdentification Number TypeTHME_TKUIHMD_TKUI
DGNUIdentification NumberTHME_DGNUCHAR4
DGRES1Hazard-Inducing SubstanceADGE_RESCHAR12
DGRES2Hazard-Inducing SubstanceADGE_RESCHAR12
DGCLDangerous Goods ClassTHME_DGCLHMD_DGCL
DGSCDangerous Goods SubclassADGE_DGSCCHAR6
SDBCHazard Item NumberADGE_SDBCNUMC4
SLBEHazard Item Number (Empty Transport)THME_SLBENUMC4
LDBCClassification CodeTHME_LDBCHMD_LDBC
LWDGDangerous Goods RegulationTHME_LWDGHMD_LWDG
STOSUAggregate State for TransportADGE_STOSUCHAR1
COTMPControl TemperatureADGE_COTMPADGD_Q82
TPCUNTemperature Unit (Control)ADGE_TPCUNMEINS
EMTMPEmergency TemperatureADGE_EMTMPADGD_Q82
TPEUNTemperature Unit (Emergency)ADGE_TPEUNMEINS
FLTMPFlash PointADGE_FLTMPADGD_Q82
TPFUNTemperature Unit (Flame)ADGE_TPFUNMEINS
TPSNLTemperature Sensitivity (Lower Limit)ADGE_TPSNLADGD_Q82
TPSLUUnit for temperature sensitivity (lower limit)ADGE_TPSLUMEINS
TPSNHTemperature sensitivity (upper limit)ADGE_TPSNHADGD_Q82
TPSHUTemperature Unit (Sensitivity - Upper Limit)ADGE_TPSHUMEINS
DAIN1Hazard NoteADGE_DAINCHAR4
DAIN2Hazard NoteADGE_DAINCHAR4
DAIN3Hazard NoteADGE_DAINCHAR4
DAIN4Hazard NoteADGE_DAINCHAR4
DAIN5Hazard NoteADGE_DAINCHAR4
DAIN6Hazard NoteADGE_DAINCHAR4
DAIN7Hazard NoteADGE_DAINCHAR4
DAIN8Hazard NoteADGE_DAINCHAR4
DAIN9Hazard NoteADGE_DAINCHAR4
DAIN10Hazard NoteADGE_DAINCHAR4
COWEWater Pollution ClassADGE_COWEADGD_COWE
VBFCVbF ClassADGE_VBFCADGD_VBFC
SDCLStorage Hazard ClassADGE_SDCLADGD_SDCL
EINUTremcard NumberADGE_EINUCHAR7
EICNReplacement Tremcard NumberADGE_EICNCHAR7
EMSN1EmS/ERG Number 1ADGE_EMSN1CHAR7
EMSN2EmS/ERG Number 2ADGE_EMSN2CHAR7
MFAG1MFAG Number 1ADGE_MFAG1CHAR4
MFAG2MFAG Number 2ADGE_MFAG2CHAR4
MOS1Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS2Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS3Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS4Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS5Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS6Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS7Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS8Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOS9Dangerous Goods Transport TypeTHME_MOSHMD_MOS
MOSADangerous Goods Transport TypeTHME_MOSHMD_MOS
HQTUMaximum Quantity per Transport UnitADGE_HQTUADGD_Q82
HQTUNMaximum Quantity UnitADGE_HQTUNMEINS
PINPacking Instruction NumberTHME_PINHMD_PIN
PGROPacking GroupTHME_PGROCHAR3
HNUHazard Identification NumberTHME_HNUHMD_HNU
HPN1Danger Label Number 1THME_HPN1HMD_HPN
HPN2Danger Label Number 2THME_HPN2HMD_HPN
HPN3Danger Label Number 3THME_HPN3HMD_HPN
HPN4Danger Label Number 4THME_HPN4HMD_HPN
HPN5Danger Label Number 5THME_HPN5HMD_HPN
HPN6Danger Label Number 6THME_HPN6HMD_HPN
HPN7Danger Label Number 7THME_HPN7HMD_HPN
LAB1Label Number 1ADGE_LAB1ADGD_LAB
LAB2Label Number 2ADGE_LAB2ADGD_LAB
LAB3Label Number 3ADGE_LAB3ADGD_LAB
LAB4Label Number 4ADGE_LAB4ADGD_LAB
LAB5Label Number 5ADGE_LAB5ADGD_LAB
LAB6Label Number 6ADGE_LAB6ADGD_LAB
LAB7Label Number 7ADGE_LAB7ADGD_LAB
LAB8Label Number 8ADGE_LAB8ADGD_LAB
LAB9Label Number 9ADGE_LAB9ADGD_LAB
LAB10Label Number 10ADGE_LABAADGD_LAB
KDGVSText Key Highly Viscous SubstancesADGE_KDGVSTDOBNAME
KDGNSText Key Exemption for Named SubstancesADGE_KDGNSTDOBNAME
KDGMPText Key Marine PollutantADGE_KDGMPTDOBNAME
KDGEXText Key ExceptionsADGE_KDGEXTDOBNAME
KDGHIText key handling dataADGE_KDGHITDOBNAME
KDGF1User-Defined Text Key 1ADGE_KDGF1TDOBNAME
KDGF2User-Defined Text Key 2ADGE_KDGF2TDOBNAME
KDGF3User-Defined Text Key 3ADGE_KDGF3TDOBNAME
KDGF4User-Defined Text Key 4ADGE_KDGF4TDOBNAME
KDGF5User-Defined Text Key 5ADGE_KDGF5TDOBNAME
KDGF6User-Defined Text Key 6ADGE_KDGF6TDOBNAME
KDGF7User-Defined Text Key 7ADGE_KDGF7TDOBNAME
KDGF8User-Defined Text Key 8ADGE_KDGF8TDOBNAME
KDGF9User-Defined Text Key 9ADGE_KDGF9TDOBNAME
KDGF10User-Defined Text Key 10ADGE_KDGFATDOBNAME
PAILimited Quantity (LQ) Inner PackagingTHME_PAIHMD_QUAN
PAIUUnit of Meas. for Limited Quantity (LQ) Inner PackagingTHME_PAIUMEINS
PAOLimited Quantity (LQ) Outer PackagingTHME_PAOHMD_QUAN
PAOUUnit of Meas. for Limited Quantity (LQ) Outer PackagingTHME_PAOUMEINS
RQAReportable QuantityADGE_RQAADGD_Q82
RQUUnit of measure for reportable quantitiesADGE_RQUMEINS
PBIPoisonous by InhalationADGE_PBIADGD_PIH
MINQMinimum Quantity for Listed GoodsADGE_MINQADGD_Q82
MINUUnit of Measurement Minimum Quantity (Listed Goods)ADGE_MINUMEINS
MAXQMaximum Quantity for Listed GoodsADGE_MAXQADGD_Q82
MAXUUnit of Measurement Maximum Quantity (Listed Goods)ADGE_MAXUMEINS
RELQExemption (ADR 1.1.3.6)THME_RELQHMD_QUAN
RELUUnit of Measure Quantity LimitTHME_RELUMEINS
MULRQMultiplication Factor Exemption (ADR 1.1.3.6)THME_MULRQNUMC4
RCHEMNotification Status (Law on Control of Toxic Substances)ADGE_RCHEMX
DGPTAShipping by Mail PermittedADGE_DGPTAX
DGTNATransport Not PermittedADGE_DGTNAX
DGWOSProcessing Status for Basic Data and Master DataTHME_WOSHMD_WOS
NHMENon-Dangerous Goods Empty TransportTHME_NHMEHMD_NDG
DGSHESchedule of Class 7ADGE_DGSHECHAR4
PIMDGNote on RegulationADGE_PIMDGCHAR10
SOOWASolubility of waterADGE_SOOWAADGD_Q122
USOOWUnit for solubility of waterADGE_USOOWMEINS
DENFEEDensity IADGE_DENFEADGD_Q112
UDENFEUnit for density IADGE_UDENFMEINS
DENTWEDensity IIADGE_DENTWADGD_Q112
UDENTWUnit for density IIADGE_UDENTMEINS
DENFIFDensity IIIADGE_DENFIADGD_Q112
UDENFIUnit for density IIIADGE_UDEFIMEINS
BUDENBulk DensityADGE_BUDENADGD_Q112
UBUDEUnit for Bulk DensityADGE_UBUDEMEINS
BOPOIBoiling PointADGE_BOPOIHMD_QUAN
UBOPOUnit for Boiling PointADGE_UBOPOMEINS
VISCOViscosityADGE_VISCOADGD_Q92
UVISCUnit for ViscosityADGE_UVISCMEINS
STPRESVapor PressureADGE_STPREADGD_Q102
USTPREUnit for vapor pressureADGE_USTPRMEINS
HYGROHygroscopicityADGE_HYGROCHAR1
MEPOIMelting PointADGE_MEPOIHMD_QUAN
UMEPOUnit for Melting PointADGE_UMEPOMEINS
COOEXCoefficient of ExpansionADGE_COOEXHMD_QUAN
UCOOEUnit for Coefficient of ExpansionADGE_UCOOEMEINS
MTMPFMedium Temperature of Liquid During FillingADGE_MTMPFHMD_QUAN
UMTMPUnit for medium filling temperatureADGE_UMTMPMEINS
STOPAPackaging MarkTHME_STOPACHAR1
SPPROSpecial ProvisionTHME_SPPROCHAR5
MAPOLMarine PollutantADGE_MAPOLADGD_MAPOL
PINLQPacking Instruction Number for Limited Quantity (LQ)THME_PINLQHMD_PIN
PASIMaximum Quantity per PackageTHME_PASIHMD_QUAN
UPASIUnit of Measurement for Single PackagingTHME_UPASIMEINS
PAGWLimited Quantity (LQ) Gross WeightTHME_PAGWHMD_QUAN
UPAGWUnit of Measurement for Limited Quantity (LQ) GrossTHME_UPAGWMEINS
EXCEPException and Agreement NumberADGE_EXCEPCHAR40
SCASESpecial Case (Packing Check)ADGE_SCASEX
COLNOCollective NumberADGE_COLNOX
DGRES3Hazard-Inducing SubstanceADGE_RESCHAR12
DGREMPHazard-inducing substance (marine pollutant)ADGE_REMPCHAR12
DGRERQHazard-inducing substance (reportable quantity)ADGE_RERQCHAR12
EIMDGRegulation EditionADGE_EIMDGCHAR4

DGTMD related tables

TableNote
DGTM2DG: Dangerous Goods Master (App. Table)
DGTMDDG: Dangerous Goods Master
TDG81Dynamic Tab Titles for Dangerous Goods Master
TDGA11DG: Relevant Dangerous Goods Master Tables for SD Process
CCGLC_DGPHRRELEHS: GHS/Dangerous Goods: Phrase Assignment
DGMS2DG: Dangerous Goods Document Table (Appendix Table)
DGMSDDG: Dangerous Goods Document Table DGMSD
DGREL_LOCK_KEYDangerous Goods: Lock Table for CCDUTDGREL
DGTEXCCHKMETHExceptions to Dangerous Goods Regulations: Check Methods
DGTEXCCNTRIESExceptions to Dangerous Goods Regulations: Countries
EST07EHS: Dangerous Goods Management - Transport Approval
EST0BEHS: Dangerous Goods Management - Packaging Code Approval
EST0DEHS: Dangerous Goods Management - Risk Classification
EST0FEHS: Dangerous Goods Management - Transport Classification
J_1BNFDANG_GOODSControl derivation of automatic NF texts for dangerous goods
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