SAP table reference

MGEF

Hazardous materials

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table MGEF.

SAP table MGEF has 3 primary key fields: MANDT,STOFF,REGKZ.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

MGEF fields.

31 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 * MANDT
Key STOFF Hazardous material numberCHAR400 STOFF
Key REGKZ Region codeCHAR30 T646R REGKZ
LAGKL Storage classCHAR50 T646L LVS_LAGKL
WGFKL Water Pollution ClassNUMC10 MGEF_WGFKL
WGKKZ Ind.: water pollution classification prescribed by lawCHAR10 MGEF_WGKKZ
GFVM1 Hazardous material warningCHAR20 T646G MGEF_GFVM0
GFVM2 Hazardous material warningCHAR20 T646G MGEF_GFVM0
GFVM3 Hazardous material warningCHAR20 T646G MGEF_GFVM0
GFVM4 Hazardous material warningCHAR20 T646G MGEF_GFVM0
GFVM5 Hazardous material warningCHAR20 T646G MGEF_GFVM0
GFVM6 Hazardous material warningCHAR20 T646G MGEF_GFVM0
GFVM7 Hazardous material warningCHAR20 T646G MGEF_GFVM0
GFVM8 Hazardous material warningCHAR20 T646G MGEF_GFVM0
SFNR1 Number of hazardous substanceCHAR60 MGEF_SFNR0
SFNR2 Number of hazardous substanceCHAR60 MGEF_SFNR0
SFNR3 Number of hazardous substanceCHAR60 MGEF_SFNR0
SFNR4 Number of hazardous substanceCHAR60 MGEF_SFNR0
SFKO1 Concentration of hazardous substancesDEC52 MGEF_SFKO0
SFKO2 Concentration of hazardous substancesDEC52 MGEF_SFKO0
SFKO3 Concentration of hazardous substancesDEC52 MGEF_SFKO0
SFKO4 Concentration of hazardous substancesDEC52 MGEF_SFKO0
FLAPU Flash pointDEC51 MGEF_FLAPU
SIDNR Safety specifications sheet numberCHAR100 MGEF_SIDNR
SIVAR Variant of safety specifications sheetCHAR80 MGEF_SIVAR
SIVER Version of safety specifications sheetCHAR60 MGEF_SIVER
LGFVM Hazardous material storage warningCHAR20 T646V MGEF_LGFVM
AGGRE State of matterCHAR10 T646A MGEF_AGGRE
VBFKL Hazard classification of regulation on combustible fluidsCHAR40 MGEF_VBFKL
STOFT Short text for number of hazardous materialCHAR400 MGEF_STOFT
STOKL Class of substancesCHAR90 T023 MGEF_STOKL
/ Relationships

MGEF relationships.

23 relationships
TableFieldCheck tableDescriptionCheck field
MGEFAGGRET646AAggregate StatesMANDT
MGEFAGGRET646AAggregate StatesAGGRE
MGEFGFVM1T646GHazardous Material WarningsMANDT
MGEFGFVM1T646GHazardous Material WarningsGEFVM
MGEFGFVM2T646GHazardous Material WarningsMANDT
MGEFGFVM2T646GHazardous Material WarningsGEFVM
MGEFGFVM3T646GHazardous Material WarningsMANDT
MGEFGFVM3T646GHazardous Material WarningsGEFVM
MGEFGFVM4T646GHazardous Material WarningsMANDT
MGEFGFVM4T646GHazardous Material WarningsGEFVM
MGEFGFVM5T646GHazardous Material WarningsMANDT
MGEFGFVM5T646GHazardous Material WarningsGEFVM
MGEFGFVM6T646GHazardous Material WarningsMANDT
MGEFGFVM6T646GHazardous Material WarningsGEFVM
MGEFGFVM7T646GHazardous Material WarningsMANDT
MGEFGFVM7T646GHazardous Material WarningsGEFVM
MGEFGFVM8T646GHazardous Material WarningsMANDT
MGEFGFVM8T646GHazardous Material WarningsGEFVM
MGEFLAGKLT646LStorage ClassesMANDT
MGEFLGFVMT646VHazardous Material WarningsMANDT
MGEFLGFVMT646VHazardous Material WarningsLGFVM
MGEFREGKZT646RRegion CodesMANDT
MGEFSTOKLT023Material GroupsMATKL