SAP ABAP Table TXI_MGEF (Hazardous materials)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_MGEF	Table Relationship Diagram
Short Description	Hazardous materials

Delivery and Maintenance

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

History

Last changed by/on	SAP	20100310
SAP Release Created in