SAP ABAP Table LIPSDGVB (Reference structure for X_LIPSDG_TAB/Y_LIPSDG_TAB)

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	LIPSDGVB	Table Relationship Diagram
Short Description	Reference structure for X_LIPSDG_TAB/Y_LIPSDG_TAB

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in