SAP ABAP View J_7LIZRF_V2 (REA Info Systems Re.Partner-to-Material Type Asgmt(no_stofe))

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_7LIZRF_V2
Short Description	REA Info Systems Re.Partner-to-Material Type Asgmt(no_stofe)
Root table	J_7LS03	REA Mat.Types: Internal/Recycling Partner Material Types

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	J_7LS03	J_7LS03
2	J_7LS01
3	J_7LS01T
4	J_7LS02
5	J_7LS02T
6	J_7LE01

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	J_7LS01	MANDT	JL	EQ				0	0
2	J_7LS03	MANDT	JR	EQ			AND	0	0
3	J_7LS01	STOFI	JL	EQ				0	0
4	J_7LS03	STOFI	JR	EQ			AND	0	0
5	J_7LS01	MANDT	JL	EQ				0	0
6	J_7LS01T	MANDT	JR	EQ			AND	0	0
7	J_7LS01	STOFI	JL	EQ				0	0
8	J_7LS01T	STOFF	JR	EQ			AND	0	0
9	J_7LS02	MANDT	JL	EQ				0	0
10	J_7LS03	MANDT	JR	EQ			AND	0	0
11	J_7LS02	MANDT	JL	EQ				0	0
12	J_7LS02T	MANDT	JR	EQ			AND	0	0
13	J_7LS02	STOFF	JL	EQ				0	0
14	J_7LS02T	STOFF	JR	EQ			AND	0	0
15	J_7LS02	ENTNR	JL	EQ				0	0
16	J_7LS02T	ENTNR	JR	EQ			AND	0	0
17	J_7LS02T	SPRAS	JL	EQ				0	0
18	J_7LS01T	SPRAS	JR	EQ			AND	0	0
19	J_7LE01	MANDT	JL	EQ				0	0
20	J_7LS02	MANDT	JR	EQ			AND	0	0
21	J_7LE01	ENTNR	JL	EQ				0	0
22	J_7LS02	ENTNR	JR	EQ			AND	0	0
23	J_7LS03	MANDT	JL	EQ				0	0
24	J_7LE01	MANDT	JR	EQ			AND	0	0
25	J_7LS03	ENTNA	JL	EQ				0	0
26	J_7LE01	ENTNA	JR	EQ			AND	0	0
27	J_7LS03	LVORMADM		EQ	' '		AND	0	0
28	J_7LS01	LVORMADM		EQ	' '		AND	0	0
29	J_7LS02	LVORMADM		EQ	' '		AND	0	0
30	J_7LE01	LVORMADM		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	J_7LS03	MANDT		☐	MANDT	☐	Client
2	STOFI	J_7LS03	STOFI		☐	J_7LRSTOFI	☐	Internal Fraction
3	ENTNA	J_7LS03	ENTNA		☐	J_7LENTNAM	☐	Recycling Partner
4	STOFF	J_7LS02	STOFF		☐	J_7LRSTOFE	☐	Partner Fraction
5	ENTNR	J_7LS02	ENTNR		☐	J_7LRENT	☐	Recycling Partner
6	SPRASP	J_7LS02T	SPRAS		☐	SPRAS	☐	Language Key
7	STOFE	J_7LS03	STOFE		☐	J_7LRSTOFE	☐	Partner Fraction
8	LAND1	J_7LE01	LAND1		☐	LAND1	☐	Country Key
9	STOKLF	J_7LS01	STOKL		☐	MGEF_STOKL	☐	Class of substances
10	GSTFNF	J_7LS01	GSTFN		☐	STOFF	☐	Hazardous material number
11	GEWEIF	J_7LS01	GEWEI		☐	GEWEI	☐	Weight Unit
12	STOKTXP	J_7LS01T	STOKTX		☐	J_7LRSTKTX	☐	Internal Fraction: Short Text
13	STOKTXPG	J_7LS01T	STOKTG		☐	J_7LRSTKTG	☐	Internal Fraction: Short Text in Uppercase
14	STOKLP	J_7LS02	STOKL		☐	MGEF_STOKL	☐	Class of substances
15	GSTFNP	J_7LS02	GSTFN		☐	STOFF	☐	Hazardous material number
16	GEWEIP	J_7LS02	GEWEI		☐	GEWEI	☐	Weight Unit
17	MATNR	J_7LS02	MATNR		☐	J_7LZMATNR	☐	Assigned Material Number
18	STOKTXF	J_7LS02T	STOKTX		☐	J_7LRSTKXT	☐	REA Recycling Partner Fraction: Short Text
19	STOKTXFG	J_7LS02T	STOKTG		☐	J_7LRSTKGT	☐	REA Recycling Partner Fraction: Short Text in Uppercase
20	NO_STOFE	J_7LS03	NO_STOFE		☐	J_7LNO_STOFE	☐	Indicator: Re.Partner Fraction Requirement Canceled

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	20130529
SAP Release Created in	471