SAP ABAP Table LGEF1 (For Data Transfer from Substance Database to MGEF)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ CBLVS (Package) EH&S: Warehouse Management Functionality Supported by EH&S

Basic Data

Table Category	INTTAB	Structure
Structure	LGEF1	Table Relationship Diagram
Short Description	For Data Transfer from Substance Database to MGEF

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	SUBID	☐	ESESUBID	ESDSUBID	CHAR	12	0	Specification
2	QSTOFT	☐	ESEIDENT	TEXT132	CHAR	132	0	Identifier
3	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	VACLID	☐	ESEVACLID	ESDVACLID	CHAR	10	0	Rating	*
5	RVLID	☐	ESERVLID	ESDRVLID	CHAR	10	0	Validity Area	*
6	QLAGKL	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
7	QWGFKL	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
8	QWGKKZ	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
9	QGFVM1	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
10	QGFVM2	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
11	QGFVM3	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
12	QGFVM4	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
13	QGFVM5	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
14	QGFVM6	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
15	QGFVM7	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
16	QGFVM8	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
17	QLGFVM	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
18	QAGGRE	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
19	QVBFKL	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
20	SELFLG	☐	FLG_SEL	XFELD	CHAR	1	0	Selection indicator
21	STATUS	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
22	.INCLUDE	☐				0	0	Hazardous materials
23	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
24	STOFF	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	*
25	REGKZ	☐	REGKZ	REGKZ	CHAR	3	0	Region code	T646R
26	LAGKL	☐	LVS_LAGKL	MGEF_LAGKL	CHAR	5	0	Storage class	T646L
27	WGFKL	☐	MGEF_WGFKL	MGEF_WGFKL	NUMC	1	0	Water Pollution Class
28	WGKKZ	☐	MGEF_WGKKZ	XFELD	CHAR	1	0	Ind.: water pollution classification prescribed by law
29	GFVM1	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
30	GFVM2	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
31	GFVM3	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
32	GFVM4	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
33	GFVM5	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
34	GFVM6	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
35	GFVM7	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
36	GFVM8	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
37	SFNR1	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
38	SFNR2	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
39	SFNR3	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
40	SFNR4	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
41	SFKO1	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
42	SFKO2	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
43	SFKO3	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
44	SFKO4	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
45	FLAPU	☐	MGEF_FLAPU	MGEF_FLAPU	DEC	5	1	Flash point
46	SIDNR	☐	MGEF_SIDNR	MGEF_SIDNR	CHAR	10	0	Safety specifications sheet number
47	SIVAR	☐	MGEF_SIVAR	MGEF_SIVAR	CHAR	8	0	Variant of safety specifications sheet
48	SIVER	☐	MGEF_SIVER	MGEF_SIVER	CHAR	6	0	Version of safety specifications sheet
49	LGFVM	☐	MGEF_LGFVM	MGEF_LGFVM	CHAR	2	0	Hazardous material storage warning	T646V
50	AGGRE	☐	MGEF_AGGRE	MGEF_AGGRE	CHAR	1	0	State of matter	T646A
51	VBFKL	☐	MGEF_VBFKL	MGEF_VBFKL	CHAR	4	0	Hazard classification of regulation on combustible fluids
52	STOFT	☐	MGEF_STOFT	TEXT40	CHAR	40	0	Short text for number of hazardous material
53	STOKL	☐	MGEF_STOKL	MATKL	CHAR	9	0	Class of substances	T023
54	QFLAPU	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LGEF1	AGGRE	T646A	AGGRE
2	LGEF1	GFVM1	T646G	GEFVM
3	LGEF1	GFVM2	T646G	GEFVM
4	LGEF1	GFVM3	T646G	GEFVM
5	LGEF1	GFVM4	T646G	GEFVM
6	LGEF1	GFVM5	T646G	GEFVM
7	LGEF1	GFVM6	T646G	GEFVM
8	LGEF1	GFVM7	T646G	GEFVM
9	LGEF1	GFVM8	T646G	GEFVM
10	LGEF1	LAGKL	T646L	LAGKL
11	LGEF1	LGFVM	T646V	LGFVM
12	LGEF1	REGKZ	T646R	REGKZ
13	LGEF1	STOKL	T023	MATKL	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in