SAP ABAP Table J_7LIZAFVR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	J_7LIZAFVR	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	VRPNR	☑	J_7LVRP	MATNR	CHAR	18	0	Packaging	J_7LV01
10	VVARIANTE	☑	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	STOFF	☑	J_7LRSTOFI	J_7LRSTOFI	CHAR	6	0	Internal Fraction	J_7LS01
14	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
15	MATNRM	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
16	MEINH	☑	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	T006
17	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
18	RMATN	☐	MATNR	MATNR	CHAR	18	0	Material Number	J_7LM03
19	AVARIANTE	☐	J_7LAVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant of Article	J_7LM03
20	KPEIN	☐	J_7LRKPEIN	KPEIN	DEC	5	0	Number of Sales Units in Packaging Bill of Material
21	DATABVRP	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
22	FMENG	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
23	MEINS_M04	☐	KMPME	MEINS	UNIT	3	0	Component Unit of Measure	T006
24	GMENG	☐	J_7LRGMENG	MENGE	QUAN	13	3	Quantity Limit
25	MEVWX	☐	J_7LMEVWX	XFELD	CHAR	1	0	Ind.: Reference UoM for All Non-Defined UoMs for Article
26	MTYP	☐	J_7LRMTYP	J_7LRMTYP	CHAR	1	0	Article Category
27	MEREL	☐	J_7LMEREL	J_7LMEREL	CHAR	1	0	Derivation of Sales Units for REA Article
28	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
29	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
30	MAKTG	☐	MAKTG	CHAR40	CHAR	40	0	Material description in upper case for matchcodes
31	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
32	STGEW	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
33	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
34	STOKL	☐	MGEF_STOKL	MATKL	CHAR	9	0	Class of substances	T023
35	GSTFN	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	MGEF
36	STOKTX	☐	J_7LRSTKTX	TEXT40	CHAR	40	0	Internal Fraction: Short Text
37	STOKTG	☐	J_7LRSTKTG	CHAR40	CHAR	40	0	Internal Fraction: Short Text in Uppercase

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LIZAFVR	AVARIANTE	J_7LM03	VARIANTE
2	J_7LIZAFVR	BUKRS	J_7LM03	BUKRS
3	J_7LIZAFVR	BUKRSREF	J_7LC01	BUKRS
4	J_7LIZAFVR	GEWEI	T006	MSEHI
5	J_7LIZAFVR	GSTFN	MGEF	STOFF
6	J_7LIZAFVR	LAND1	J_7LM03	LAND1
7	J_7LIZAFVR	LAND1REF	J_7LC10	LAND1
8	J_7LIZAFVR	MANDT	T000	MANDT
9	J_7LIZAFVR	MATNR	J_7LM07	MATNR
10	J_7LIZAFVR	MATNRM	MARA	MATNR	KEY	1	CN
11	J_7LIZAFVR	MEINH	T006	MSEHI	KEY	1	CN
12	J_7LIZAFVR	MEINS	T006	MSEHI	REF	1	CN
13	J_7LIZAFVR	MEINS_M04	T006	MSEHI
14	J_7LIZAFVR	RMATN	J_7LM03	MATNR
15	J_7LIZAFVR	SPRAS	T002	SPRAS	KEY	1	CN
16	J_7LIZAFVR	STOFF	J_7LS01	STOFI
17	J_7LIZAFVR	STOKL	T023	MATKL
18	J_7LIZAFVR	VARIANTE	J_7LM07	VARIANTE
19	J_7LIZAFVR	VRKME	J_7LM03	VRKME
20	J_7LIZAFVR	VRPNR	J_7LV01	VRPNR
21	J_7LIZAFVR	VVARIANTE	J_7LV01	VARIANTE

History

Last changed by/on	SAP	20140121
SAP Release Created in