SAP ABAP View J_7LIPAV_V (REA Info Systems: Packaging Pricing Analysis View)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
     ⤷ J7LR (Package) REA Core Functionality

Basic Data

View Type	D	Database View
Database View	J_7LIPAV_V
Short Description	REA Info Systems: Packaging Pricing Analysis View
Root table	MARA	General Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MAKT
3	J_7LE01
4	J_7LV01
5	J_7LV03
6	J_7LP01

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	J_7LV01	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	J_7LV01	VRPNR	JR	EQ			AND	0	0
5	MARA	MANDT	JL	EQ				0	0
6	MAKT	MANDT	JR	EQ			AND	0	0
7	MARA	MATNR	JL	EQ				0	0
8	MAKT	MATNR	JR	EQ			AND	0	0
9	J_7LV01	MANDT	JL	EQ				0	0
10	J_7LV03	MANDT	JR	EQ			AND	0	0
11	J_7LV01	VRPNR	JL	EQ				0	0
12	J_7LV03	VRPNR	JR	EQ			AND	0	0
13	J_7LV01	VARIANTE	JL	EQ				0	0
14	J_7LV03	VARIANTE	JR	EQ			AND	0	0
15	J_7LV03	MANDT	JL	EQ				0	0
16	J_7LE01	MANDT	JR	EQ			AND	0	0
17	J_7LV03	ENTNR	JL	EQ				0	0
18	J_7LE01	ENTNR	JR	EQ			AND	0	0
19	J_7LV03	LAND1	JL	EQ				0	0
20	J_7LE01	LAND1	JR	EQ			AND	0	0
21	J_7LP01	ENTNR	JL	EQ				0	0
22	J_7LE01	ENTNR	JR	EQ			AND	0	0
23	J_7LP01	LAND1	JL	EQ				0	0
24	J_7LE01	LAND1	JR	EQ			AND	0	0
25	J_7LP01	BUKRS	JL	EQ				0	0
26	J_7LV03	BUKRS	JR	EQ			AND	0	0
27	J_7LV01	LVORMADM	JL	EQ				0	0
28	J_7LE01	LVORMADM	JR	EQ			AND	0	0
29	J_7LV03	LVORMADM	JL	EQ				0	0
30	J_7LE01	LVORMADM	JR	EQ			AND	0	0
31	J_7LP01	LVORMADM	JL	EQ				0	0
32	J_7LE01	LVORMADM	JR	EQ			AND	0	0
33	J_7LV01	MANDT	JL	EQ				0	0
34	J_7LE01	MANDT	JR	EQ			AND	0	0
35	J_7LV03	MANDT	JL	EQ				0	0
36	J_7LE01	MANDT	JR	EQ			AND	0	0
37	J_7LP01	MANDT	JL	EQ				0	0
38	J_7LE01	MANDT	JR	EQ			AND	0	0
39	MARA	MANDT	JL	EQ				0	0
40	J_7LE01	MANDT	JR	EQ			AND	0	0
41	MAKT	MANDT	JL	EQ				0	0
42	J_7LE01	MANDT	JR	EQ			AND	0	0
43	MAKT	MATNR	JL	EQ				0	0
44	MARA	MATNR	JR	EQ			AND	0	0
45	J_7LE01	LVORMADM		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	J_7LV01	MANDT		☐	MANDT	☐	Client
2	VRPNR	J_7LV01	VRPNR		☐	J_7LVRP	☐	Packaging
3	VVARIANTE	J_7LV01	VARIANTE		☐	J_7LVVARIANTE	☐	Variant of Packaging
4	MAKTG	MAKT	MAKTG		☐	MAKTG	☐	Material description in upper case for matchcodes
5	SPRAS	MAKT	SPRAS		☐	SPRAS	☐	Language Key
6	VPTYP	J_7LV01	VPTYP		☐	J_7LVPTYP	☐	Packaging Class
7	VPARTG	J_7LV01	VPARTG		☐	J_7LVPARTG	☐	Packaging Type Weight-Dependent Fee
8	VPARTS	J_7LV01	VPARTS		☐	J_7LVPARTS	☐	Packaging Type Item-Dependent Fee
9	VPEBENE	J_7LV01	VPEBENE		☐	J_7LVEBENE	☐	Packaging Level
10	TRENNKZ	J_7LV01	TRENNKZ		☐	J_7LVTRNKZ	☐	Indicator for Packaging Separability
11	VPFORMTYP	J_7LV01	VPFORMTYP		☐	J_7LVFORMT	☐	Packaging Form Type
12	VERSCHNITT	J_7LV01	VERSCHNITT		☐	J_7LVRSCHN	☐	Remnants
13	MUSTERVRPNR	J_7LV01	MUSTERVRPNR		☐	J_7LMSTVRP	☐	REA Packaging Master: Assigned Model Packaging
14	DATABADM	J_7LV03	DATABADM		☐	DATAB	☐	Valid-From Date
15	DATBIADM	J_7LV03	DATBIADM		☐	DATBI	☐	Valid To Date
16	ERSDAADM	J_7LV03	ERSDAADM		☐	ERSDA	☐	Created On
17	ERNAMADM	J_7LV03	ERNAMADM		☐	ERNAM	☐	Name of Person who Created the Object
18	LAEDAADM	J_7LV03	LAEDAADM		☐	LAEDA	☐	Date of Last Change
19	AENAMADM	J_7LV03	AENAMADM		☐	AENAM	☐	Name of Person Who Changed Object
20	ENTNA	J_7LE01	ENTNA		☐	J_7LENTNAM	☐	Recycling Partner
21	BUKRS	J_7LV03	BUKRS		☐	BUKRS	☐	Company Code
22	LAND1	J_7LV03	LAND1		☐	LAND1	☐	Country Key
23	ENTNR	J_7LE01	ENTNR		☐	J_7LRENT	☐	Recycling Partner
24	DATBI	J_7LV03	DATBI		☐	DATBI	☐	Valid To Date
25	DATAB	J_7LV03	DATAB		☐	DATAB	☐	Valid-From Date
26	KZSTKENTG	J_7LE01	KZSTKENTG		☐	J_7LKZSTKE	☐	Item-Dependent Fee Indicator
27	KZGEWENTG	J_7LE01	KZGEWENTG		☐	J_7LKZGEWE	☐	Weight-Dependent Fee Indicator
28	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
29	PLVRS	J_7LP01	PLVRS		☐	J_7LRPLVRS	☐	Price List Version
30	PL_DATAB	J_7LP01	DATAB		☐	DATAB	☐	Valid-From Date
31	PL_DATBI	J_7LP01	DATBI		☐	DATBI	☐	Valid To Date
32	SPLIT	J_7LV03	SPLIT		☐	J_7LRSPLIT	☐	Splitting Quota in Percent
33	SPLIT_MAN	J_7LV03	SPLIT_MAN		☐	J_7LRSPLIT	☐	Splitting Quota in Percent
34	VFLKL	J_7LV03	VFLKL		☐	J_7LVFLKL	☐	Volume/Area Class
35	SOKOA	J_7LV03	SOKOA		☐	J_7LSOKOA	☐	Special Condition Type
36	VPARTG_V03	J_7LV03	VPARTG		☐	J_7LVPARTG	☐	Packaging Type Weight-Dependent Fee
37	VPARTS_V03	J_7LV03	VPARTS		☐	J_7LVPARTS	☐	Packaging Type Item-Dependent Fee
38	KZEVPAG	J_7LE01	KZEVPAG		☐	J_7LKZEVPAG	☐	Indicator: Packaging Type Weight-Dep. Fee for Re. Partner
39	INFOK	J_7LV03	INFOK		☐	J_7LINFOK	☐	Additional Info Key

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in	471