SAP ABAP Table LIPSDG (Appendix Table for Dangerous Goods Data)

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	TRANSP	Transparent table
Transparent table	LIPSDG	Table Relationship Diagram
Short Description	Appendix Table for Dangerous Goods Data

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

History

Last changed by/on	SAP	20110901
SAP Release Created in