SAP ABAP Table J_7LIZAFG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	J_7LIZAFG	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	J_7LM03
3	VARIANTE	☑	J_7LAVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant of Article	J_7LM03
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	J_7LM03
5	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	J_7LM03
6	VRKME	☑	VRKME	MEINS	UNIT	3	0	Sales unit	J_7LM03
7	VRPNRVRP	☑	J_7LVRP	MATNR	CHAR	18	0	Packaging	J_7LV01
8	VVARIANTEVRP	☑	J_7LVVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant of Packaging	J_7LV01
9	DATBIVRP	☑	DATBI	DATUM	DATS	8	0	Valid To Date
10	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
11	VPGRP	☑	J_7LVPGRP	J_7LRVPGRP	CHAR	6	0	Packaging Group
12	VRSIO	☑	J_7LVRS	CHAR6	CHAR	6	0	Version	J_7LV04
13	VRPNR	☑	J_7LVRP	MATNR	CHAR	18	0	Packaging	J_7LV01
14	VVARIANTE	☑	J_7LVVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant of Packaging	J_7LV01
15	STOFF	☑	J_7LRSTOFI	J_7LRSTOFI	CHAR	6	0	Internal Fraction	J_7LS01
16	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
17	MATNRM	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
18	MEINH	☐	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	T006
19	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
20	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
21	MAKTG	☐	MAKTG	CHAR40	CHAR	40	0	Material description in upper case for matchcodes
22	KPEIN	☐	J_7LRKPEIN	KPEIN	DEC	5	0	Number of Sales Units in Packaging Bill of Material
23	DATABVRP	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
24	MEINS_M04	☐	KMPME	MEINS	UNIT	3	0	Component Unit of Measure
25	FMENG	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
26	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
27	STGEW	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
28	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
29	STOKL	☐	MGEF_STOKL	MATKL	CHAR	9	0	Class of substances	T023
30	GSTFN	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	MGEF
31	STOKTX	☐	J_7LRSTKTX	TEXT40	CHAR	40	0	Internal Fraction: Short Text
32	STOKTG	☐	J_7LRSTKTG	CHAR40	CHAR	40	0	Internal Fraction: Short Text in Uppercase
33	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
34	MTYP	☐	J_7LRMTYP	J_7LRMTYP	CHAR	1	0	Article Category
35	MEREL	☐	J_7LMEREL	J_7LMEREL	CHAR	1	0	Derivation of Sales Units for REA Article
36	GMENG	☐	J_7LRGMENG	MENGE	QUAN	13	3	Quantity Limit
37	MEVWX	☐	J_7LMEVWX	XFELD	CHAR	1	0	Ind.: Reference UoM for All Non-Defined UoMs for Article
38	DATBIVRPGR	☐	DATBI	DATUM	DATS	8	0	Valid To Date
39	DATABVRPGR	☐	DATAB	DATUM	DATS	8	0	Valid-From Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LIZAFG	BUKRS	J_7LM03	BUKRS
2	J_7LIZAFG	GEWEI	T006	MSEHI
3	J_7LIZAFG	GSTFN	MGEF	STOFF
4	J_7LIZAFG	LAND1	J_7LM03	LAND1
5	J_7LIZAFG	MANDT	T000	MANDT
6	J_7LIZAFG	MATNR	J_7LM03	MATNR
7	J_7LIZAFG	MATNRM	MARA	MATNR	KEY	1	CN
8	J_7LIZAFG	MEINH	T006	MSEHI	KEY	1	CN
9	J_7LIZAFG	MEINS	T006	MSEHI	REF	1	CN
10	J_7LIZAFG	SPRAS	T002	SPRAS	KEY	1	CN
11	J_7LIZAFG	STOFF	J_7LS01	STOFI
12	J_7LIZAFG	STOKL	T023	MATKL
13	J_7LIZAFG	VARIANTE	J_7LM03	VARIANTE
14	J_7LIZAFG	VRKME	J_7LM03	VRKME
15	J_7LIZAFG	VRPNR	J_7LV01	VRPNR
16	J_7LIZAFG	VRPNRVRP	J_7LV01	VRPNR
17	J_7LIZAFG	VRSIO	J_7LV04	VRSIO
18	J_7LIZAFG	VVARIANTE	J_7LV01	VARIANTE
19	J_7LIZAFG	VVARIANTEVRP	J_7LV01	VARIANTE

History

Last changed by/on	SAP	20140121
SAP Release Created in