SAP ABAP Table RDGLIPSDG (DG: Structure for Dangerous Goods Data in LIPSDG)

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	INTTAB	Structure
Structure	RDGLIPSDG	Table Relationship Diagram
Short Description	DG: Structure for Dangerous Goods Data in LIPSDG

Delivery and Maintenance

Pool/cluster
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	DGNTGEW	☐	ADGE_NTGEW	MENG15	QUAN	15	3	Dangerous goods - net weight
2	DGBRGEW	☐	ADGE_BRGEW	MENG15	QUAN	15	3	Dangerous Goods - Gross Weight
3	DGGEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
4	DGVOLUM	☐	ADGE_VOLUM	MENG15	QUAN	15	3	Dangerous goods - volume
5	DGVOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
6	DGARAND	☐	ADGE_KARN	X	CHAR	1	0	Exemption
7	DGREPQU	☐	ADGE_IRQA	X	CHAR	1	0	Indicator: Reportable quantity
8	DGPULIM	☐	ADGE_IPUL	X	CHAR	1	0	Packed Under 450 l
9	DGPAS	☐	ADGE_PAS	X	CHAR	1	0	Listed Goods
10	DGMAN	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
11	DGMANRQ	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
12	DGMANLIM	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
13	DGMANLG	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
14	DGMDDAT	☐	ADGE_MDDAT	DATUM	DATS	8	0	Selection date dangerous goods master data
15	DGARANDPR	☐	ADGE_RPRAR	ADGD_PROFILE	CHAR	4	0	Regulation Profile for Exemption	TDGD1
16	DGREPQUPR	☐	ADGE_RPRRQ	ADGD_PROFILE	CHAR	4	0	Regulation Profile for Reportable Quantity	TDGD1
17	DGPULIMPR	☐	ADGE_RPRPU	ADGD_PROFILE	CHAR	4	0	Regulation Profile for Exemption: Highly Viscous (< 450 l)	TDGD1
18	DGPASPR	☐	ADGE_RPRP7	ADGD_PROFILE	CHAR	4	0	Regulation Profile for Listed Goods	TDGD1
19	DGCHKAR	☐	ADGE_CHKAR	X	CHAR	1	0	Dangerous Goods Checks Performed for Exemption
20	DGCHKRQ	☐	ADGE_CHKRQ	X	CHAR	1	0	Dangerous Goods Checks Run for Reportable Quantity
21	DGCHKPU	☐	ADGE_CHKPU	X	CHAR	1	0	Dangerous Goods Checks Run for Exemption: Highly Viscous
22	DGCHKLG	☐	ADGE_CHKLG	X	CHAR	1	0	Dangerous Goods Checks Performed for Listed Goods
23	RANDNUMMER	☐	ADGE_RANDNR	ADGE_DRANDNR	NUMC	6	0	Total Chapter 1.1.3.6 for ADR/ADNR
24	DRIVERSPRAS	☐	ADGE_LKDRIV	SPRAS	LANG	1	0	Language Key for Driver	T002
25	CODRIVERSPRAS	☐	ADGE_LKDRIV	SPRAS	LANG	1	0	Language Key for Driver	T002
26	TRANSP_INDEX	☐	EHS_ADGE_TRANSP_INDEX	DEC5_2	DEC	7	2	Transport Index
27	CRIT_SAF_INDEX	☐	EHS_ADGE_CRIT_SAF_INDEX	DEC5_2	DEC	7	2	Criticality Safety Index
28	PACKAGE_CAT	☐	EHS_ADGE_PACKAGE_CAT	EHS_ADGD_PACKAGE_CAT	CHAR	15	0	Category of Package
29	ACTVTY_SINGLE_A2	☐	EHS_ADGE_ACTVTY_SINGLE_A2	DEC7_2	DEC	9	2	Single Activity as Multiple of A2 Value
30	ACTVTY_TOTAL_A2	☐	EHS_ADGE_ACTVTY_TOTAL_A2	DEC10_2	DEC	10	2	Total Activity as Multiple of A2 Value
31	EXPL_NET_SUM	☐	EHS_ADGE_EXPL_NET_SUM	ADGD_Q92	QUAN	9	2	Total Net Explosive Substance Mass
32	EXPL_NET_SUM_U	☐	EHS_ADGE_EXPL_NET_U	MEINS	UNIT	3	0	Unit for Net Explosive Substance Mass	*
33	DGEXCQU	☐	ADGE_EXC_QUANT	X	CHAR	1	0	Excepted Quantity
34	DGMANEQ	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
35	DGCHKEQ	☐	ADGE_EXC_QUANT_CHK	X	CHAR	1	0	Dangerous Goods Checks Performed for Excepted Quantity
36	DGEXCQUPR	☐	ADGE_EXC_QUANT_PRF	ADGD_PROFILE	CHAR	4	0	Regulation Profile for Excepted Quantity	TDGD1
37	.INCLUDE	☐				0	0	Structure for Indicators for Transport in DG Supplement
38	DGSUP_TRANSIND01	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
39	DGSUP_TRANSIND02	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
40	DGSUP_TRANSIND03	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
41	DGSUP_TRANSIND04	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
42	DGSUP_TRANSIND05	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
43	DGSUP_TRANSIND06	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
44	DGSUP_TRANSIND07	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
45	DGSUP_TRANSIND08	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport	TDG103
46	.INCLUDE	☐				0	0	Structure for Indicating Indicators for Transport (Supplemt)
47	TRANSIND_MAN_01	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
48	TRANSIND_MAN_02	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
49	TRANSIND_MAN_03	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
50	TRANSIND_MAN_04	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
51	TRANSIND_MAN_05	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
52	TRANSIND_MAN_06	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
53	TRANSIND_MAN_07	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
54	TRANSIND_MAN_08	☐	ADGE_MAN	X	CHAR	1	0	Not Overwritten by Check Methods
55	TRANSIND_CHK_01	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
56	TRANSIND_CHK_02	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
57	TRANSIND_CHK_03	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
58	TRANSIND_CHK_04	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
59	TRANSIND_CHK_05	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
60	TRANSIND_CHK_06	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
61	TRANSIND_CHK_07	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
62	TRANSIND_CHK_08	☐	ADGE_TRANSPORT_INDICATOR_CHK	X	CHAR	1	0	Indicator for Transport Set by Dangerous Goods Check
63	.INCLUDE	☐				0	0	Structure for Descriptors of Indicators for Transport
64	TRANSIND_DESC_01	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport
65	TRANSIND_DESC_02	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport
66	TRANSIND_DESC_03	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport
67	TRANSIND_DESC_04	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport
68	TRANSIND_DESC_05	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport
69	TRANSIND_DESC_06	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport
70	TRANSIND_DESC_07	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport
71	TRANSIND_DESC_08	☐	ADGE_TRANSPORT_INDICATORD	HMD_STXT	CHAR	132	0	Description of Indicator for Transport

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RDGLIPSDG	CODRIVERSPRAS	T002	SPRAS	REF
2	RDGLIPSDG	DGARANDPR	TDGD1	DGRPROF		1	CN
3	RDGLIPSDG	DGEXCQUPR	TDGD1	DGRPROF
4	RDGLIPSDG	DGGEWEI	T006	MSEHI
5	RDGLIPSDG	DGPASPR	TDGD1	DGRPROF		1	CN
6	RDGLIPSDG	DGPULIMPR	TDGD1	DGRPROF		1	CN
7	RDGLIPSDG	DGREPQUPR	TDGD1	DGRPROF		1	CN
8	RDGLIPSDG	DGSUP_TRANSIND01	TDG103	TRANS_IND
9	RDGLIPSDG	DGSUP_TRANSIND02	TDG103	TRANS_IND
10	RDGLIPSDG	DGSUP_TRANSIND03	TDG103	TRANS_IND
11	RDGLIPSDG	DGSUP_TRANSIND04	TDG103	TRANS_IND
12	RDGLIPSDG	DGSUP_TRANSIND05	TDG103	TRANS_IND
13	RDGLIPSDG	DGSUP_TRANSIND06	TDG103	TRANS_IND
14	RDGLIPSDG	DGSUP_TRANSIND07	TDG103	TRANS_IND
15	RDGLIPSDG	DGSUP_TRANSIND08	TDG103	TRANS_IND
16	RDGLIPSDG	DGVOLEH	T006	MSEHI
17	RDGLIPSDG	DRIVERSPRAS	T002	SPRAS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in