SAP ABAP Table MGEF (Hazardous materials)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ LVS (Package) Application development Warehouse Management (WM)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MGEF	Table Relationship Diagram
Short Description	Hazardous materials

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	STOFF	☑	STOFF	STOFF	CHAR	18	0	Hazardous material number
3	REGKZ	☑	REGKZ	REGKZ	CHAR	3	0	Region code	T646R
4	LAGKL	☐	LVS_LAGKL	MGEF_LAGKL	CHAR	5	0	Storage class	T646L
5	WGFKL	☐	MGEF_WGFKL	MGEF_WGFKL	NUMC	1	0	Water Pollution Class
6	WGKKZ	☐	MGEF_WGKKZ	XFELD	CHAR	1	0	Ind.: water pollution classification prescribed by law
7	GFVM1	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
8	GFVM2	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
9	GFVM3	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
10	GFVM4	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
11	GFVM5	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
12	GFVM6	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
13	GFVM7	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
14	GFVM8	☐	MGEF_GFVM0	MGEF_GFVM0	CHAR	2	0	Hazardous material warning	T646G
15	SFNR1	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
16	SFNR2	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
17	SFNR3	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
18	SFNR4	☐	MGEF_SFNR0	MGEF_SFNR0	CHAR	6	0	Number of hazardous substance
19	SFKO1	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
20	SFKO2	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
21	SFKO3	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
22	SFKO4	☐	MGEF_SFKO0	MGEF_SFKO0	DEC	5	2	Concentration of hazardous substances
23	FLAPU	☐	MGEF_FLAPU	MGEF_FLAPU	DEC	5	1	Flash point
24	SIDNR	☐	MGEF_SIDNR	MGEF_SIDNR	CHAR	10	0	Safety specifications sheet number
25	SIVAR	☐	MGEF_SIVAR	MGEF_SIVAR	CHAR	8	0	Variant of safety specifications sheet
26	SIVER	☐	MGEF_SIVER	MGEF_SIVER	CHAR	6	0	Version of safety specifications sheet
27	LGFVM	☐	MGEF_LGFVM	MGEF_LGFVM	CHAR	2	0	Hazardous material storage warning	T646V
28	AGGRE	☐	MGEF_AGGRE	MGEF_AGGRE	CHAR	1	0	State of matter	T646A
29	VBFKL	☐	MGEF_VBFKL	MGEF_VBFKL	CHAR	4	0	Hazard classification of regulation on combustible fluids
30	STOFT	☐	MGEF_STOFT	TEXT40	CHAR	40	0	Short text for number of hazardous material
31	STOKL	☐	MGEF_STOKL	MATKL	CHAR	9	0	Class of substances	T023

Foreign Keys

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

History

Last changed by/on	SAP	20020219
SAP Release Created in