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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
WGKKZ
Ind.: water pollution classification prescribed by law
|
MGEF_WGKKZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
SFKO2
Concentration of hazardous substances
|
MGEF_SFKO0 |
DEC
|
5 | 2 | ||||||||||||
|
||||||||||||||||
|
SFKO3
Concentration of hazardous substances
|
MGEF_SFKO0 |
DEC
|
5 | 2 | ||||||||||||
|
||||||||||||||||
|
SFKO4
Concentration of hazardous substances
|
MGEF_SFKO0 |
DEC
|
5 | 2 | ||||||||||||
|
||||||||||||||||
|
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 | GFVM4 |
T646G
Hazardous Material Warnings
|
GEFVM |
| MGEF | GFVM4 | MGEF | MANDT |
T646G
Hazardous Material Warnings
|
MANDT |
| MGEF | GFVM5 | MGEF | MANDT |
T646G
Hazardous Material Warnings
|
MANDT |
| MGEF | GFVM5 | MGEF | GFVM5 |
T646G
Hazardous Material Warnings
|
GEFVM |
| MGEF | GFVM6 | MGEF | MANDT |
T646G
Hazardous Material Warnings
|
MANDT |
| MGEF | GFVM6 | MGEF | GFVM6 |
T646G
Hazardous Material Warnings
|
GEFVM |
| 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 |