SAP ABAP Table DGTM2 (DG: Dangerous Goods Master (App. Table))

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-EHS (Application Component) Environment, Health and Safety: Master Data
     ⤷ CBEHS_DGP (Package) Dangerous Goods Master Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DGTM2	Table Relationship Diagram
Short Description	DG: Dangerous Goods Master (App. Table)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	DG: Structure for appendix table for DGTMD
6	PDGNUD	☐	ADGE_PDGND	CHAR21	CHAR	21	0	Dangerous Goods Description
7	PRES1	☐	ADGE_PRES	CHAR21	CHAR	21	0	Hazard-Inducing Substance
8	PRES2	☐	ADGE_PRES	CHAR21	CHAR	21	0	Hazard-Inducing Substance
9	PRES3	☐	ADGE_PRES	CHAR21	CHAR	21	0	Hazard-Inducing Substance
10	PREMP1	☐	ADGE_PRMP	CHAR21	CHAR	21	0	Hazard-inducing substance (marine pollutant)
11	PRERQ1	☐	ADGE_PRRQ	CHAR21	CHAR	21	0	Hazard-inducing substance (reportable quantity)
12	PRERQ2	☐	ADGE_PRRQ	CHAR21	CHAR	21	0	Hazard-inducing substance (reportable quantity)
13	PSTOSU	☐	ADGE_PSTOS	CHAR21	CHAR	21	0	Aggregate State for Transport
14	PDAIN1	☐	ADGE_PDAI1	CHAR21	CHAR	21	0	Hazard Note 1
15	PDAIN2	☐	ADGE_PDAI2	CHAR21	CHAR	21	0	Hazard Note 2
16	PDAIN3	☐	ADGE_PDAI3	CHAR21	CHAR	21	0	Hazard Note 3
17	PDAIN4	☐	ADGE_PDAI4	CHAR21	CHAR	21	0	Hazard Note 4
18	PDAIN5	☐	ADGE_PDAI5	CHAR21	CHAR	21	0	Hazard Note 5
19	PDAIN6	☐	ADGE_PDAI6	CHAR21	CHAR	21	0	Hazard Note 6
20	PDAIN7	☐	ADGE_PDAI7	CHAR21	CHAR	21	0	Hazard Note 7
21	PDAIN8	☐	ADGE_PDAI8	CHAR21	CHAR	21	0	Hazard Note 8
22	PDAIN9	☐	ADGE_PDAI9	CHAR21	CHAR	21	0	Hazard Note 9
23	PDAIN10	☐	ADGE_PDAIA	CHAR21	CHAR	21	0	Hazard Note 10
24	MIOWA	☐	ADGE_MIOWA	ADGD_Q82	QUAN	8	2	Miscibility with Water
25	UMIOW	☐	ADGE_UMIOW	MEINS	UNIT	3	0	Unit for Miscibility with Water	T006
26	PHYGRO	☐	ADGE_PHYGR	CHAR21	CHAR	21	0	Hygroscopicity
27	PDGF1	☐	ADGE_PDGF1	CHAR21	CHAR	21	0	User-Defined Text Key 1
28	PDGF2	☐	ADGE_PDGF2	CHAR21	CHAR	21	0	User-Defined Text Key 2
29	PDGF3	☐	ADGE_PDGF3	CHAR21	CHAR	21	0	User-Defined Text Key 3
30	PDGF4	☐	ADGE_PDGF4	CHAR21	CHAR	21	0	User-Defined Text Key 4
31	PDGF5	☐	ADGE_PDGF5	CHAR21	CHAR	21	0	User-Defined Text Key 5
32	PDGF6	☐	ADGE_PDGF6	CHAR21	CHAR	21	0	User-Defined Text Key 6
33	PDGF7	☐	ADGE_PDGF7	CHAR21	CHAR	21	0	User-Defined Text Key 7
34	PDGF8	☐	ADGE_PDGF8	CHAR21	CHAR	21	0	User-Defined Text Key 8
35	PDGF9	☐	ADGE_PDGF9	CHAR21	CHAR	21	0	User-Defined Text Key 9
36	PDGFA	☐	ADGE_PDGFA	CHAR21	CHAR	21	0	User-Defined Text Key 10
37	PDGFB	☐	ADGE_PDGFB	CHAR21	CHAR	21	0	User-Defined Text Key 11
38	PDGFC	☐	ADGE_PDGFC	CHAR21	CHAR	21	0	User-Defined Text Key 12
39	PDGFD	☐	ADGE_PDGFD	CHAR21	CHAR	21	0	User-Defined Text Key 13
40	PDGFE	☐	ADGE_PDGFE	CHAR21	CHAR	21	0	User-Defined Text Key 14
41	PDGFF	☐	ADGE_PDGFF	CHAR21	CHAR	21	0	User-Defined Text Key 15
42	PTXTPATT	☐	ADGE_PTXTPATT	CHAR21	CHAR	21	0	Dangerous Goods Text Pattern
43	MSEPR1	☐	THME_DYKY1	HMD_DYKY	CHAR	4	0	Segregation Key 1	THM091
44	MSEPR2	☐	THME_DYKY2	HMD_DYKY	CHAR	4	0	Segregation Key 2	THM091
45	MSEPR3	☐	THME_DYKY3	HMD_DYKY	CHAR	4	0	Segregation Key 3	THM091
46	MSEPR4	☐	THME_DYKY4	HMD_DYKY	CHAR	4	0	Segregation Key 4	THM091
47	MSEPR5	☐	THME_DYKY5	HMD_DYKY	CHAR	4	0	Segregation Key 5	THM091
48	MSEPR6	☐	THME_DYKY6	HMD_DYKY	CHAR	4	0	Segregation Key 6	THM091
49	MSEPR7	☐	THME_DYKY7	HMD_DYKY	CHAR	4	0	Segregation Key 7	THM091
50	MSEPR8	☐	THME_DYKY8	HMD_DYKY	CHAR	4	0	Segregation Key 8	THM091
51	MSEPR9	☐	THME_DYKY9	HMD_DYKY	CHAR	4	0	Segregation Key 9	THM091
52	MSEPRA	☐	THME_DYKYA	HMD_DYKY	CHAR	4	0	Segregation Key 10	THM091
53	MSEPRB	☐	THME_DYKYB	HMD_DYKY	CHAR	4	0	Segregation Key 11	THM091
54	MSEPRC	☐	THME_DYKYC	HMD_DYKY	CHAR	4	0	Segregation Key 12	THM091
55	MSEPRD	☐	THME_DYKYD1	HMD_DYKY	CHAR	4	0	Segregation Key 13	THM091
56	MSEPRE	☐	THME_DYKYE	HMD_DYKY	CHAR	4	0	Segregation Key 14	THM091
57	MSEPRF	☐	THME_DYKYF	HMD_DYKY	CHAR	4	0	Segregation Key 15	THM091
58	MSEPRG	☐	THME_DYKYG	HMD_DYKY	CHAR	4	0	Segregation Key 16	THM091
59	MSEPRH	☐	THME_DYKYH	HMD_DYKY	CHAR	4	0	Segregation Key 17	THM091
60	MLOAR1	☐	THME_MLOAR1	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 1	THM097
61	MLOAR2	☐	THME_MLOAR2	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 2	THM097
62	MLOAR3	☐	THME_MLOAR3	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 3	THM097
63	MLOAR4	☐	THME_MLOAR4	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 4	THM097
64	MLOAR5	☐	THME_MLOAR5	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 5	THM097
65	MLOAR6	☐	THME_MLOAR6	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 6	THM097
66	MLOAR7	☐	THME_MLOAR7	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 7	THM097
67	MLOAR8	☐	THME_MLOAR8	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 8	THM097
68	MLOAR9	☐	THME_MLOAR9	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 9	THM097
69	MLOARA	☐	THME_MLOARA	HMD_MLOAR	CHAR	6	0	Mixed Loading Rule 10	THM097
70	RSMLG1	☐	THME_RSMLG1	HMD_RSMLG	CHAR	4	0	Regulation-Dependent Mixed Loading Group 1	THM101
71	RSMLG2	☐	THME_RSMLG2	HMD_RSMLG	CHAR	4	0	Regulation-Dependent Mixed Loading Group 2	THM101
72	RSMLG3	☐	THME_RSMLG3	HMD_RSMLG	CHAR	4	0	Regulation-Dependent Mixed Loading Group 3	THM101
73	ESMLG1	☐	THME_ESMLG1	HMD_ESMLG	CHAR	4	0	Enterprise-Specific Mixed Loading Group 1	THM103
74	ESMLG2	☐	THME_ESMLG2	HMD_ESMLG	CHAR	4	0	Enterprise-Specific Mixed Loading Group 2	THM103
75	ESMLG3	☐	THME_ESMLG3	HMD_ESMLG	CHAR	4	0	Enterprise-Specific Mixed Loading Group 3	THM103
76	PREMP2	☐	ADGE_PRMP	CHAR21	CHAR	21	0	Hazard-inducing substance (marine pollutant)
77	RQA2	☐	ADGE_RQA	ADGD_Q82	QUAN	8	2	Reportable Quantity
78	RQU2	☐	ADGE_RQU	MEINS	UNIT	3	0	Unit of measure for reportable quantities	T006
79	PPDG1	☐	THME_PPDG1	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 1
80	PPDG2	☐	THME_PPDG2	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 2
81	PPDG3	☐	THME_PPDG3	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 3
82	PPDG4	☐	THME_PPDG4	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 4
83	PPDG5	☐	THME_PPDG5	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 5
84	PPDG6	☐	THME_PPDG6	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 6
85	PPDG7	☐	THME_PPDG7	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 7
86	PPDG8	☐	THME_PPDG8	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 8
87	PPDG9	☐	THME_PPDG9	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 9
88	PPDGA	☐	THME_PPDGA	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 10
89	PPDGB	☐	THME_PPDGB	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 11
90	PPDGC	☐	THME_PPDGC	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 12
91	PPDGE	☐	THME_PPDGE	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 13
92	PPDGF	☐	THME_PPDGF	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 14
93	PPDGG	☐	THME_PPDGG	CHAR2	CHAR	2	0	Profile for Dangerous Goods User-Defined Text 15
94	DAOR	☐	ADGE_DAOR	ADGD_DAOR	CHAR	1	0	Data Origin (Filling and Distribution)
95	FORM_PHYS_CHEM	☐	EHS_ADGE_FORM_PHYS_CHEM	CHAR21	CHAR	21	0	Physical and Chemical Form
96	EXPL_NET	☐	EHS_ADGE_EXPL_NET	EHS_ADGD_Q93	QUAN	9	3	Net Explosive Substance Mass
97	EXPL_NET_U	☐	EHS_ADGE_EXPL_NET_U	MEINS	UNIT	3	0	Unit for Net Explosive Substance Mass	T006
98	EXPL_REL_PERCENT	☐	EHS_ADGE_EXPL_REL_PERCENT	DEC3_3	DEC	6	3	Relative Net Explosive Substance Percentage
99	ACTVTY_MAX	☐	EHS_ADGE_ACTVTY_MAX	ADGD_Q82	QUAN	8	2	Maximum Activity
100	ACTVTY_MAX_U	☐	EHS_ADGE_ACTVTY_MAX_U	MEINS	UNIT	3	0	Unit of Maximum Activity	T006
101	ACTVTY_MAX_REL	☐	EHS_ADGE_ACTVTY_MAX_REL	ADGD_Q82	QUAN	8	2	Relative Maximum Activity
102	ACTVTY_MAX_REL_U	☐	EHS_ADGE_ACTVTY_MAX_REL_U	MEINS	UNIT	3	0	Unit of Relative Maximum Activity	T006
103	LTSK	☐	EHS_ADGE_LTSK	EHS_ADGD_CODE	CHAR	1	0	Air Transport Safety Code
104	EMV	☐	EHS_ADGE_EMV	EHS_ADGD_CODE	CHAR	1	0	Electromagnetic Compatibility
105	FSAK	☐	EHS_ADGE_FSAK	EHS_ADGD_CODE	CHAR	1	0	Parachute Drop Code
106	SFK	☐	EHS_ADGE_SFK	EHS_ADGD_CODE	CHAR	1	0	Thrust Code
107	MUNAKODE	☐	EHS_ADGE_MUNAKODE	CHAR4	CHAR	4	0	Ammunition Code
108	EXNUMBER	☐	EHS_ADGE_EXNUMBER	CHAR12	CHAR	12	0	EX Number
109	CERTIFIC	☐	EHS_ADGE_APPROV_CERTIFIC	CHAR21	CHAR	21	0	Identification Mark for Approval Certificate
110	HAZCHEM_CODE	☐	CBDUE_HAZCHEM_CODE	CBDUD_HAZCHEM_CODE	CHAR	10	0	Code for Chemical Hazard
111	FLG_EMSN1_U	☐	CBDUE_FLG_EMSN1_U	CBUND_FLG_EMSN_U	CHAR	1	0	EmS Number 1 Underlined
112	FLG_EMSN2_U	☐	CBDUE_FLG_EMSN2_U	CBUND_FLG_EMSN_U	CHAR	1	0	EmS Number 2 Underlined
113	STOWAGE	☐	CBDUE_STOWAGE	CBUND_STOWAGE	CHAR	3	0	Stowage Category	CCUNC111
114	CARR_TYPE	☐	CBDUE_CARR_TYPE	CBUND_CARR_TYPE	CHAR	3	0	Transport Category
115	FLG_PAI	☐	CBDUE_FLG_PAI	CBUND_FLG	CHAR	1	0	Value Entered for Limited Quantity (LQ) Inner Packaging
116	FLG_PAO	☐	CBDUE_FLG_PAO	CBUND_FLG	CHAR	1	0	Value Entered for Limited Quantity (LQ) Outer Packaging
117	FLG_PASI	☐	CBDUE_FLG_PASI	CBUND_FLG	CHAR	1	0	Value Entered for Maximum Quantity per Package
118	FLG_PAGW	☐	CBDUE_FLG_PAGW	CBUND_FLG	CHAR	1	0	Value Entered for Limited Quantity (LQ) Gross Weight
119	FLG_RELQ	☐	CBDUE_FLG_RELQ	CBUND_FLG	CHAR	1	0	Value Entered for Exemption
120	FLG_MULRQ	☐	CBDUE_FLG_MULRQ	CBUND_FLG	CHAR	1	0	Value Entered for Multiplication Factor
121	FLG_RELQ_UNLIMIT	☐	CBDUE_FLG_RELQ_UNLIMIT	CBUND_FLG	CHAR	1	0	Unlimited Set for Exemption
122	FLG_MULRQ_FORBID	☐	CBDUE_FLG_MULRQ_FORBID	CBUND_FLG	CHAR	1	0	Prohibited Set for Multiplication Factor
123	PDGNUDPRE	☐	CBDUE_PDGNUDPRE	CHAR21	CHAR	21	0	Dangerous Goods Description Prefix
124	PDGNUDSUF	☐	CBDUE_PDGNUDSUF	CHAR21	CHAR	21	0	Dangerous Goods Description Suffix

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DGTM2	ACTVTY_MAX_REL_U	T006	MSEHI		1	CN
2	DGTM2	ACTVTY_MAX_U	T006	MSEHI		1	CN
3	DGTM2	ESMLG1	THM103	ESMLG		1	CN
4	DGTM2	ESMLG2	THM103	ESMLG		1	CN
5	DGTM2	ESMLG3	THM103	ESMLG		1	CN
6	DGTM2	EXPL_NET_U	T006	MSEHI		1	CN
7	DGTM2	MANDT	T000	MANDT
8	DGTM2	MLOAR1	THM097	MLOAR		1	CN
9	DGTM2	MLOAR2	THM097	MLOAR		1	CN
10	DGTM2	MLOAR3	THM097	MLOAR		1	CN
11	DGTM2	MLOAR4	THM097	MLOAR		1	CN
12	DGTM2	MLOAR5	THM097	MLOAR		1	CN
13	DGTM2	MLOAR6	THM097	MLOAR		1	CN
14	DGTM2	MLOAR7	THM097	MLOAR		1	CN
15	DGTM2	MLOAR8	THM097	MLOAR		1	CN
16	DGTM2	MLOAR9	THM097	MLOAR		1	CN
17	DGTM2	MLOARA	THM097	MLOAR		1	CN
18	DGTM2	MSEPR1	THM091	DYKY		1	CN
19	DGTM2	MSEPR2	THM091	DYKY		1	CN
20	DGTM2	MSEPR3	THM091	DYKY		1	CN
21	DGTM2	MSEPR4	THM091	DYKY		1	CN
22	DGTM2	MSEPR5	THM091	DYKY		1	CN
23	DGTM2	MSEPR6	THM091	DYKY		1	CN
24	DGTM2	MSEPR7	THM091	DYKY		1	CN
25	DGTM2	MSEPR8	THM091	DYKY		1	CN
26	DGTM2	MSEPR9	THM091	DYKY		1	CN
27	DGTM2	MSEPRA	THM091	DYKY		1	CN
28	DGTM2	MSEPRB	THM091	DYKY		1	CN
29	DGTM2	MSEPRC	THM091	DYKY		1	CN
30	DGTM2	MSEPRD	THM091	DYKY		1	CN
31	DGTM2	MSEPRE	THM091	DYKY		1	CN
32	DGTM2	MSEPRF	THM091	DYKY		1	CN
33	DGTM2	MSEPRG	THM091	DYKY		1	CN
34	DGTM2	MSEPRH	THM091	DYKY		1	CN
35	DGTM2	RQU2	T006	MSEHI		1	CN
36	DGTM2	RSMLG1	THM101	RSMLG		1	CN
37	DGTM2	RSMLG2	THM101	RSMLG		1	CN
38	DGTM2	RSMLG3	THM101	RSMLG		1	CN
39	DGTM2	STOWAGE	CCUNC111	STOWAGE	REF	1	CN
40	DGTM2	UMIOW	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20050314
SAP Release Created in