SAP ABAP View WRF_V_ARTLIST (Extraction View for Material List)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ WRF_ARTICLELIST (Package) Material List

Basic Data

View Type	D	Database View
Database View	WRF_V_ARTLIST
Short Description	Extraction View for Material List
Root table	WRF_HIER_OBJ	Objects of a Hierarchy

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WRF_HIER_OBJ	WRF_HIER_OBJ
2	WRF_HIER_OBJBOX
3	WRF_AL_ARTICLE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WRF_HIER_OBJ	MANDT	JL	EQ				0	0
2	WRF_HIER_OBJBOX	MANDT	JR	EQ			AND	0	0
3	WRF_HIER_OBJBOX	MANDT	JL	EQ				0	0
4	WRF_AL_ARTICLE	MANDT	JR	EQ			AND	0	0
5	WRF_HIER_OBJ	APP_ID	JL	EQ				0	0
6	WRF_HIER_OBJBOX	APP_ID	JR	EQ			AND	0	0
7	WRF_HIER_OBJ	HIER_ID	JL	EQ				0	0
8	WRF_HIER_OBJBOX	HIER_ID	JR	EQ			AND	0	0
9	WRF_HIER_OBJ	NODE_ID	JL	EQ				0	0
10	WRF_HIER_OBJBOX	NODE_ID	JR	EQ			AND	0	0
11	WRF_HIER_OBJ	OBJ_ID	JL	EQ				0	0
12	WRF_HIER_OBJBOX	OBJ_ID	JR	EQ			AND	0	0
13	WRF_HIER_OBJBOX	OBJ_ID	JL	EQ				0	0
14	WRF_AL_ARTICLE	AL_ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WRF_HIER_OBJ	MANDT		☐	MANDT	☐	Client
2	APP_ID	WRF_HIER_OBJ	APP_ID		☐	WRF_APPID	☐	Application ID
3	HIER_ID	WRF_HIER_OBJ	HIER_ID		☐	WRF_HIERID	☐	Hierarchy ID
4	NODE_ID	WRF_HIER_OBJ	NODE_ID		☐	WRF_NODEID	☐	Node ID
5	LFDNR	WRF_HIER_OBJBOX	LFDNR		☐	WRF_LFDNR	☐	Sequence Number
6	AL_ID	WRF_AL_ARTICLE	AL_ID		☐	WRF_ALID	☐	Material List ID
7	MATNR	WRF_AL_ARTICLE	MATNR		☐	MATNR	☐	Material Number
8	CONTENT	WRF_HIER_OBJBOX	CONTENT		☐	WRF_CONTENT	☐	Content for Structure
9	VALID_FROM	WRF_HIER_OBJ	VALID_FROM		☐	WRF_VALID_FROM	☐	Valid From
10	VALID_TO	WRF_HIER_OBJ	VALID_TO		☐	WRF_VALID_TO	☐	Valid To
11	CREATOR	WRF_HIER_OBJ	CREATOR		☐	WRF_CREATOR	☐	Created By
12	CREATE_DATE	WRF_HIER_OBJ	CREATE_DATE		☐	WRF_CREATEDATE	☐	Creation Date
13	MODIFIER	WRF_HIER_OBJ	MODIFIER		☐	WRF_MODIFIER	☐	Last Changed by
14	LOGSYS	WRF_HIER_OBJ	LOGSYS		☐	WRF_LOGSYS	☐	Logical System
15	TIMESTAMP	WRF_HIER_OBJ	TIMESTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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	20110901
SAP Release Created in	111