SAP Table TXI_MGEF
Hazardous materials
TXI_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 TXI_MGEF to other SAP tables.
TXI_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 |
Possible values
|
||||||||||
| WGKKZ | Ind.: water pollution classification prescribed by law | MGEF_WGKKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| SFKO2 | Concentration of hazardous substances | MGEF_SFKO0 | DEC | 5 | 2 |
Possible values
|
||||||||||
| SFKO3 | Concentration of hazardous substances | MGEF_SFKO0 | DEC | 5 | 2 |
Possible values
|
||||||||||
| SFKO4 | Concentration of hazardous substances | MGEF_SFKO0 | DEC | 5 | 2 |
Possible 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 | ||||||||||
TXI_MGEF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TXI_MGEF | AGGRE | TXI_MGEF | MANDT | T646A | Aggregate States | MANDT |
| TXI_MGEF | AGGRE | TXI_MGEF | AGGRE | T646A | Aggregate States | AGGRE |
| TXI_MGEF | GFVM1 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM1 | TXI_MGEF | GFVM1 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | GFVM2 | TXI_MGEF | GFVM2 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | GFVM2 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM3 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM3 | TXI_MGEF | GFVM3 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | GFVM4 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM4 | TXI_MGEF | GFVM4 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | GFVM5 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM5 | TXI_MGEF | GFVM5 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | GFVM6 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM6 | TXI_MGEF | GFVM6 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | GFVM7 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM7 | TXI_MGEF | GFVM7 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | GFVM8 | TXI_MGEF | MANDT | T646G | Hazardous Material Warnings | MANDT |
| TXI_MGEF | GFVM8 | TXI_MGEF | GFVM8 | T646G | Hazardous Material Warnings | GEFVM |
| TXI_MGEF | LAGKL | TXI_MGEF | MANDT | T646L | Storage Classes | MANDT |
| TXI_MGEF | LAGKL | TXI_MGEF | LAGKL | T646L | Storage Classes | LAGKL |
| TXI_MGEF | LGFVM | TXI_MGEF | MANDT | T646V | Hazardous Material Warnings | MANDT |
| TXI_MGEF | LGFVM | TXI_MGEF | LGFVM | T646V | Hazardous Material Warnings | LGFVM |
| TXI_MGEF | REGKZ | TXI_MGEF | REGKZ | T646R | Region Codes | REGKZ |
| TXI_MGEF | REGKZ | TXI_MGEF | MANDT | T646R | Region Codes | MANDT |
| TXI_MGEF | STOKL | TXI_MGEF | MANDT | T023 | Material Groups | MANDT |
| TXI_MGEF | STOKL | TXI_MGEF | STOKL | T023 | Material Groups | MATKL |
