SAP ABAP Table EHS_DGTM2_APPEND_03 (Structure-Append Dangerous Goods Append Table EhP3)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ CBEHS (Package) EH&S: Interface Objects

Basic Data

Table Category	APPEND	Append structure
Append structure	EHS_DGTM2_APPEND_03	Table Relationship Diagram
Short Description	Structure-Append Dangerous Goods Append Table EhP3

Delivery and Maintenance

Pool/cluster	DGTM2
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	DG: Structure for Dangerous Goods Master Table DGTM2
2	TEXTPATT_PROF01	☐	ADGE_TEXTPATT_PROF01	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 01	TDG91
3	TEXTPATT01	☐	ADGE_PTXTPATT01	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 01
4	TEXTPATT_PROF02	☐	ADGE_TEXTPATT_PROF02	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 02	TDG91
5	TEXTPATT02	☐	ADGE_PTXTPATT02	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 02
6	TEXTPATT_PROF03	☐	ADGE_TEXTPATT_PROF03	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 03	TDG91
7	TEXTPATT03	☐	ADGE_PTXTPATT03	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 03
8	TEXTPATT_PROF04	☐	ADGE_TEXTPATT_PROF04	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 04	TDG91
9	TEXTPATT04	☐	ADGE_PTXTPATT04	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 04
10	TEXTPATT_PROF05	☐	ADGE_TEXTPATT_PROF05	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 05	TDG91
11	TEXTPATT05	☐	ADGE_PTXTPATT05	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 05
12	TEXTPATT_PROF06	☐	ADGE_TEXTPATT_PROF06	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 06	TDG91
13	TEXTPATT06	☐	ADGE_PTXTPATT06	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 06
14	TEXTPATT_PROF07	☐	ADGE_TEXTPATT_PROF07	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 07	TDG91
15	TEXTPATT07	☐	ADGE_PTXTPATT07	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 07
16	TEXTPATT_PROF08	☐	ADGE_TEXTPATT_PROF08	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 08	TDG91
17	TEXTPATT08	☐	ADGE_PTXTPATT08	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 08
18	TEXTPATT_PROF09	☐	ADGE_TEXTPATT_PROF09	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 09	TDG91
19	TEXTPATT09	☐	ADGE_PTXTPATT09	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 09
20	TEXTPATT_PROF10	☐	ADGE_TEXTPATT_PROF10	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 10	TDG91
21	TEXTPATT10	☐	ADGE_PTXTPATT10	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 10
22	TEXTPATT_PROF11	☐	ADGE_TEXTPATT_PROF11	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 11	TDG91
23	TEXTPATT11	☐	ADGE_PTXTPATT11	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 11
24	TEXTPATT_PROF12	☐	ADGE_TEXTPATT_PROF12	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 12	TDG91
25	TEXTPATT12	☐	ADGE_PTXTPATT12	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 12
26	TEXTPATT_PROF13	☐	ADGE_TEXTPATT_PROF13	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 13	TDG91
27	TEXTPATT13	☐	ADGE_PTXTPATT13	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 13
28	TEXTPATT_PROF14	☐	ADGE_TEXTPATT_PROF14	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 14	TDG91
29	TEXTPATT14	☐	ADGE_PTXTPATT14	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 14
30	TEXTPATT_PROF15	☐	ADGE_TEXTPATT_PROF15	ADGD_TEXTPATT_PROF	CHAR	10	0	Text Pattern Profile 15	TDG91
31	TEXTPATT15	☐	ADGE_PTXTPATT15	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Dangerous Goods Text Pattern 15
32	ABS_ACT	☐	ADGE_ABS_ACT	ADGD_QUAN_11_4	QUAN	11	4	Absolute Activity
33	ABS_ACT_U	☐	ADGE_ABS_ACT_U	MEINS	UNIT	3	0	Unit of Absolute Activity	T006
34	REL_SPEC_ACT	☐	ADGE_REL_SPEC_ACT	ADGD_QUAN_11_4	QUAN	11	4	Relative Specific Activity
35	REL_SPEC_ACT_U	☐	ADGE_REL_SPEC_ACT_U	MEINS	UNIT	3	0	Unit of Relative Specific Activity	T006
36	CONTAMINATION	☐	ADGE_CONTAMINATION	ADGD_QUAN_8_3	QUAN	8	3	Contamination
37	CONTAMINATION_U	☐	ADGE_CONTAMINATION_U	MEINS	UNIT	3	0	Unit of Contamination	T006
38	DOSE_RATE	☐	ADGE_DOSE_RATE	ADGD_QUAN_9_5	QUAN	9	5	Radiation Level (Unpacked)
39	DOSE_RATE_U	☐	ADGE_DOSE_RATE_U	MEINS	UNIT	3	0	Unit of Radiation Level (Unpacked)	T006
40	MAX_ACT1	☐	ADGE_MAX_ACT1	ADGD_QUAN_11_4	QUAN	11	4	A1 Activity Limit
41	MAX_ACT1_U	☐	ADGE_MAX_ACT1_U	MEINS	UNIT	3	0	A1 Activity Limit: Unit	T006
42	ACT1_UNLIMIT	☐	ADGE_ACT1_UNLIMIT	ESDFLAG	CHAR	1	0	A1 Activity Limit: Unlimited
43	MAX_ACT2	☐	ADGE_MAX_ACT2	ADGD_QUAN_11_4	QUAN	11	4	A2 Activity Limit
44	MAX_ACT2_U	☐	ADGE_MAX_ACT2_U	MEINS	UNIT	3	0	A2 Activity Limit: Unit	T006
45	ACT2_UNLIMIT	☐	ADGE_ACT2_UNLIMIT	ESDFLAG	CHAR	1	0	A2 Activity Limit: Unlimited
46	ACT_SUB_PACK	☐	ADGE_ACT_SUB_PACK	ADGD_QUAN_11_4	QUAN	11	4	Activity Concentration for Substances in Excepted Packages
47	ACT_SUB_PACK_U	☐	ADGE_ACT_SUB_PACK_U	MEINS	UNIT	3	0	Activity Concentration Unit for Substances in Excepted Pkgs	T006
48	MAX_ACT_CONSG	☐	ADGE_MAX_ACT_CONSG	ADGD_QUAN_11_4	QUAN	11	4	Activity Limit for Exempt Consignment
49	MAX_ACT_CONSG_U	☐	ADGE_MAX_ACT_CONSG_U	MEINS	UNIT	3	0	Unit of Activity Limit for Exempt Consignment	T006
50	MULT_ACT_SGL	☐	ADGE_MULT_ACT_SGL	ADGD_DEC_11_7	DEC	11	7	Multiplier Activity Limit Item
51	REF_ACT_SGL	☐	ADGE_REF_ACT_SGL	ADGD_REF_ACT	CHAR	2	0	Reference Value for Multiplier Item
52	MULT_ACT_PACK	☐	ADGE_MULT_ACT_PACK	ADGD_DEC_11_7	DEC	11	7	Multiplier Activity Limit Package
53	REF_ACT_PACK	☐	ADGE_REF_ACT_PACK	ADGD_REF_ACT	CHAR	2	0	Reference Value for Multiplier Package
54	MAX_CONT_A	☐	ADGE_MAX_CONT_A	ADGD_QUAN_8_3	QUAN	8	3	Contamination Limit (Alpha)
55	MAX_CONT_A_U	☐	ADGE_MAX_CONT_A_U	MEINS	UNIT	3	0	Unit of Contamination Limit (Alpha)	T006
56	MAX_CONT_B_G	☐	ADGE_MAX_CONT_B_G	ADGD_QUAN_8_3	QUAN	8	3	Contamination Limit (Beta, Gamma)
57	MAX_CONT_B_G_U	☐	ADGE_MAX_CONT_B_G_U	MEINS	UNIT	3	0	Unit of Contamination Limit (Beta, Gamma)	T006
58	MAX_DOSE_UNP	☐	ADGE_MAX_DOSE_UNP	ADGD_QUAN_9_5	QUAN	9	5	Limit Radiation Level Unpacked
59	MAX_DOSE_UNP_U	☐	ADGE_MAX_DOSE_UNP_U	MEINS	UNIT	3	0	Unit of Limit Radiation Level Unpacked	T006
60	DIST_DOSE_UNP	☐	ADGE_DIST_DOSE_UNP	ADGD_QUAN_5_3	QUAN	5	3	Measured Distance for Limit Unpacked
61	DIST_DOSE_UNP_U	☐	ADGE_DIST_DOSE_UNP_U	MEINS	UNIT	3	0	Unit of Measured Distance for Limit Unpacked	T006
62	NO_DIST_UNP	☐	ADGE_NO_DIST_UNP	ESDFLAG	CHAR	1	0	Measurement Unpacked at Surface
63	MAX_DOSE_PACK	☐	ADGE_MAX_DOSE_PACK	ADGD_QUAN_9_5	QUAN	9	5	Limit Radiation Level Packed
64	MAX_DOSE_PACK_U	☐	ADGE_MAX_DOSE_PACK_U	MEINS	UNIT	3	0	Unit of Limit Radiation Level Packed	T006
65	DIST_DOSE_PACK	☐	ADGE_DIST_DOSE_PACK	ADGD_QUAN_5_3	QUAN	5	3	Measured Distance for Limit Packed
66	DIST_DOSE_PACK_U	☐	ADGE_DIST_DOSE_PACK_U	MEINS	UNIT	3	0	Unit of Measured Distance for Limit Packed	T006
67	NO_DIST_PACK	☐	ADGE_NO_DIST_PACK	ESDFLAG	CHAR	1	0	Measurement Packed at Surface
68	MAX_ACT_SGL_DC	☐	ADGE_MAX_ACT_SGL_DC	ADGD_QUAN_11_4	QUAN	11	4	Maximum Activity: Item
69	MAX_ACT_SGL_U_DC	☐	ADGE_MAX_ACT_SGL_DYN_U	MEINS	UNIT	3	0	Maximum Activity Unit: Item	T006
70	ACT_SGL_UNLIM_DC	☐	ADGE_ACT_SGL_UNLIM_DC	ESDFLAG	CHAR	1	0	Maximum Activity of Item Unlimited
71	MAX_ACT_PAC_DC	☐	ADGE_MAX_ACT_PAC_DC	ADGD_QUAN_11_4	QUAN	11	4	Maximum Activity: Package
72	MAX_ACT_PAC_U_DC	☐	ADGE_MAX_ACT_PACK_DYN_U	MEINS	UNIT	3	0	Maximum Activity Unit: Package	T006
73	ACT_PAC_UNLIM_DC	☐	ADGE_ACT_PAC_UNLIM_DC	ESDFLAG	CHAR	1	0	Maximum Activity of Package Unlimited
74	EXCPT_PAC_OPT_DC	☐	ADGE_EXCPT_PAC_OPT_DC	ESDFLAG	CHAR	1	0	Excepted Package: Optional
75	MAX_GRS_WGHT_DC	☐	ADGE_MAX_GRS_WGHT_DC	HMD_QUAN	QUAN	8	2	Maximum Gross Mass
76	U_MAX_GRS_WGT_DC	☐	ADGE_U_MAX_GROSS_WGHT	MEINS	UNIT	3	0	Unit for Maximum Gross Mass	T006
77	EXCEPTID01	☐	ADGE_EXCEPTID01	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 01
78	EXCEPTID02	☐	ADGE_EXCEPTID02	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 02
79	EXCEPTID03	☐	ADGE_EXCEPTID03	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 03
80	EXCEPTID04	☐	ADGE_EXCEPTID04	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 04
81	EXCEPTID05	☐	ADGE_EXCEPTID05	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 05
82	EXCEPTID06	☐	ADGE_EXCEPTID06	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 06
83	EXCEPTID07	☐	ADGE_EXCEPTID07	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 07
84	EXCEPTID08	☐	ADGE_EXCEPTID08	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 08
85	EXCEPTID09	☐	ADGE_EXCEPTID09	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 09
86	EXCEPTID10	☐	ADGE_EXCEPTID10	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations 10
87	ACT_EMIS_TYPE	☐	ADGE_ACT_EMIS_TYPE	ADGD_ACT_EMIS_TYPE	CHAR	3	0	Radioactive Emission Type
88	MAX_NEM_DC	☐	ADGE_MAX_NEM_DC	EHS_ADGD_Q93	QUAN	9	3	Maximum Net Explosive Substance Mass
89	MAX_NEM_U_DC	☐	ADGE_MAX_NEM_DC_U	MEINS	UNIT	3	0	Unit of Maximum Net Explosive Substance Mass	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS_DGTM2_APPEND_03	ABS_ACT_U	T006	MSEHI		1	CN
2	EHS_DGTM2_APPEND_03	ACT_SUB_PACK_U	T006	MSEHI		1	CN
3	EHS_DGTM2_APPEND_03	CONTAMINATION_U	T006	MSEHI		1	CN
4	EHS_DGTM2_APPEND_03	DIST_DOSE_PACK_U	T006	MSEHI		1	CN
5	EHS_DGTM2_APPEND_03	DIST_DOSE_UNP_U	T006	MSEHI		1	CN
6	EHS_DGTM2_APPEND_03	DOSE_RATE_U	T006	MSEHI		1	CN
7	EHS_DGTM2_APPEND_03	MAX_ACT1_U	T006	MSEHI		1	CN
8	EHS_DGTM2_APPEND_03	MAX_ACT2_U	T006	MSEHI		1	CN
9	EHS_DGTM2_APPEND_03	MAX_ACT_CONSG_U	T006	MSEHI		1	CN
10	EHS_DGTM2_APPEND_03	MAX_ACT_PAC_U_DC	T006	MSEHI		1	CN
11	EHS_DGTM2_APPEND_03	MAX_ACT_SGL_U_DC	T006	MSEHI		1	CN
12	EHS_DGTM2_APPEND_03	MAX_CONT_A_U	T006	MSEHI		1	CN
13	EHS_DGTM2_APPEND_03	MAX_CONT_B_G_U	T006	MSEHI		1	CN
14	EHS_DGTM2_APPEND_03	MAX_DOSE_PACK_U	T006	MSEHI		1	CN
15	EHS_DGTM2_APPEND_03	MAX_DOSE_UNP_U	T006	MSEHI		1	CN
16	EHS_DGTM2_APPEND_03	REL_SPEC_ACT_U	T006	MSEHI		1	CN
17	EHS_DGTM2_APPEND_03	TEXTPATT_PROF01	TDG91	TEXTPATT_PROF		1	CN
18	EHS_DGTM2_APPEND_03	TEXTPATT_PROF02	TDG91	TEXTPATT_PROF		1	CN
19	EHS_DGTM2_APPEND_03	TEXTPATT_PROF03	TDG91	TEXTPATT_PROF		1	CN
20	EHS_DGTM2_APPEND_03	TEXTPATT_PROF04	TDG91	TEXTPATT_PROF		1	CN
21	EHS_DGTM2_APPEND_03	TEXTPATT_PROF05	TDG91	TEXTPATT_PROF		1	CN
22	EHS_DGTM2_APPEND_03	TEXTPATT_PROF06	TDG91	TEXTPATT_PROF		1	CN
23	EHS_DGTM2_APPEND_03	TEXTPATT_PROF07	TDG91	TEXTPATT_PROF		1	CN
24	EHS_DGTM2_APPEND_03	TEXTPATT_PROF08	TDG91	TEXTPATT_PROF		1	CN
25	EHS_DGTM2_APPEND_03	TEXTPATT_PROF09	TDG91	TEXTPATT_PROF		1	CN
26	EHS_DGTM2_APPEND_03	TEXTPATT_PROF10	TDG91	TEXTPATT_PROF		1	CN
27	EHS_DGTM2_APPEND_03	TEXTPATT_PROF11	TDG91	TEXTPATT_PROF		1	CN
28	EHS_DGTM2_APPEND_03	TEXTPATT_PROF12	TDG91	TEXTPATT_PROF		1	CN
29	EHS_DGTM2_APPEND_03	TEXTPATT_PROF13	TDG91	TEXTPATT_PROF		1	CN
30	EHS_DGTM2_APPEND_03	TEXTPATT_PROF14	TDG91	TEXTPATT_PROF		1	CN
31	EHS_DGTM2_APPEND_03	TEXTPATT_PROF15	TDG91	TEXTPATT_PROF		1	CN
32	EHS_DGTM2_APPEND_03	U_MAX_GRS_WGT_DC	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in	603