SAP ABAP Table J_7LIZAFGR (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20140121
SAP Release Created in