SAP Table MGEF

Hazardous materials

MGEF (Hazardous materials) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MGEF to other SAP tables.

MGEF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
STOFF Hazardous material number STOFF CHAR 18 0
REGKZ Region code REGKZ T646R CHAR 3 0
LAGKL Storage class LVS_LAGKL T646L CHAR 5 0
WGFKL Water Pollution Class MGEF_WGFKL NUMC 1 0
0 Not a water pollutant
1 Minimal water pollution danger
2 Water pollutant
3 Extreme water pollution danger
WGKKZ Ind.: water pollution classification prescribed by law MGEF_WGKKZ CHAR 1 0
X Yes
NULL No
GFVM1 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
GFVM2 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
GFVM3 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
GFVM4 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
GFVM5 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
GFVM6 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
GFVM7 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
GFVM8 Hazardous material warning MGEF_GFVM0 T646G CHAR 2 0
SFNR1 Number of hazardous substance MGEF_SFNR0 CHAR 6 0
SFNR2 Number of hazardous substance MGEF_SFNR0 CHAR 6 0
SFNR3 Number of hazardous substance MGEF_SFNR0 CHAR 6 0
SFNR4 Number of hazardous substance MGEF_SFNR0 CHAR 6 0
SFKO1 Concentration of hazardous substances MGEF_SFKO0 DEC 5 2
0 Appropriate percentage values
SFKO2 Concentration of hazardous substances MGEF_SFKO0 DEC 5 2
0 Appropriate percentage values
SFKO3 Concentration of hazardous substances MGEF_SFKO0 DEC 5 2
0 Appropriate percentage values
SFKO4 Concentration of hazardous substances MGEF_SFKO0 DEC 5 2
0 Appropriate percentage values
FLAPU Flash point MGEF_FLAPU DEC 5 1
SIDNR Safety specifications sheet number MGEF_SIDNR CHAR 10 0
SIVAR Variant of safety specifications sheet MGEF_SIVAR CHAR 8 0
SIVER Version of safety specifications sheet MGEF_SIVER CHAR 6 0
LGFVM Hazardous material storage warning MGEF_LGFVM T646V CHAR 2 0
AGGRE State of matter MGEF_AGGRE T646A CHAR 1 0
VBFKL Hazard classification of regulation on combustible fluids MGEF_VBFKL CHAR 4 0
STOFT Short text for number of hazardous material MGEF_STOFT CHAR 40 0
STOKL Class of substances MGEF_STOKL T023 CHAR 9 0

MGEF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MGEF AGGRE MGEF MANDT T646A Aggregate States MANDT
MGEF AGGRE MGEF AGGRE T646A Aggregate States AGGRE
MGEF GFVM1 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM1 MGEF GFVM1 T646G Hazardous Material Warnings GEFVM
MGEF GFVM2 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM2 MGEF GFVM2 T646G Hazardous Material Warnings GEFVM
MGEF GFVM3 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM3 MGEF GFVM3 T646G Hazardous Material Warnings GEFVM
MGEF GFVM4 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM4 MGEF GFVM4 T646G Hazardous Material Warnings GEFVM
MGEF GFVM5 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM5 MGEF GFVM5 T646G Hazardous Material Warnings GEFVM
MGEF GFVM6 MGEF GFVM6 T646G Hazardous Material Warnings GEFVM
MGEF GFVM6 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM7 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM7 MGEF GFVM7 T646G Hazardous Material Warnings GEFVM
MGEF GFVM8 MGEF MANDT T646G Hazardous Material Warnings MANDT
MGEF GFVM8 MGEF GFVM8 T646G Hazardous Material Warnings GEFVM
MGEF LAGKL MGEF MANDT T646L Storage Classes MANDT
MGEF LAGKL MGEF LAGKL T646L Storage Classes LAGKL
MGEF LGFVM MGEF MANDT T646V Hazardous Material Warnings MANDT
MGEF LGFVM MGEF LGFVM T646V Hazardous Material Warnings LGFVM
MGEF REGKZ MGEF MANDT T646R Region Codes MANDT
MGEF REGKZ MGEF REGKZ T646R Region Codes REGKZ
MGEF STOKL MGEF MANDT T023 Material Groups MANDT
MGEF STOKL MGEF STOKL T023 Material Groups MATKL