SAP ABAP Table LIPSDGAP (DG: Appendix Table for 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	TRANSP	Transparent table
Transparent table	LIPSDGAP	Table Relationship Diagram
Short Description	DG: Appendix Table for LIPSDG

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

History

Last changed by/on	SAP	20110901
SAP Release Created in