SAP ABAP View V_WRF_PRGRP (View: Price Group Extraction)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-LIS-DC (Application Component) Data Collection
     ⤷ WRF_MASTERDATA_EXTRACTION (Package) Retail Fashion: BW Master Data Extraction

Basic Data

View Type	D	Database View
Database View	V_WRF_PRGRP
Short Description	View: Price Group Extraction
Root table	WRF_PRGRPLEVELS	Price Levels of a Price Pattern

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WRF_PRGRPLEVELS	WRF_PRGRPLEVELS
2	WRF_PRGRPSCHEMA
3	WRF_PRGRP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WRF_PRGRPLEVELS	MANDT	JL	EQ				0	0
2	WRF_PRGRPSCHEMA	MANDT	JR	EQ			AND	0	0
3	WRF_PRGRPSCHEMA	MANDT	JL	EQ				0	0
4	WRF_PRGRP	MANDT	JR	EQ			AND	0	0
5	WRF_PRGRPLEVELS	PRICE_GROUP	JL	EQ				0	0
6	WRF_PRGRPSCHEMA	PRICE_GROUP	JR	EQ			AND	0	0
7	WRF_PRGRPSCHEMA	PRICE_GROUP	JL	EQ				0	0
8	WRF_PRGRP	PRICE_GROUP	JR	EQ			AND	0	0
9	WRF_PRGRPLEVELS	PRICE_SCHEMA	JL	EQ				0	0
10	WRF_PRGRPSCHEMA	PRICE_SCHEMA	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WRF_PRGRPLEVELS	MANDT		☐	MANDT	☐	Client
2	PRICE_GROUP	WRF_PRGRPLEVELS	PRICE_GROUP		☐	PRICE_GROUP	☐	Price Level Group
3	PRICE_SCHEMA	WRF_PRGRPLEVELS	PRICE_SCHEMA		☐	PRICE_SCHEMA	☐	Price Pattern
4	PRICE_LEVEL	WRF_PRGRPLEVELS	PRICE_LEVEL		☐	PRICE_LEVEL	☐	Price Level
5	DATE_FROM	WRF_PRGRPSCHEMA	DATE_FROM		☐	PRGRP_DATE_FROM	☐	Valid From
6	DATE_TO	WRF_PRGRPSCHEMA	DATE_TO		☐	PRGRP_DATE_TO	☐	Valid To
7	PRICE_LIMIT	WRF_PRGRPLEVELS	PRICE_LIMIT		☐	PRICE_LIMIT	☐	Price Threshold
8	PRICE_GROUP_CAT	WRF_PRGRP	PRICE_GROUP_CAT		☐	PRICE_GROUP_CAT	☐	Price Level Group Category
9	PRICE_GROUP_CURR	WRF_PRGRP	PRICE_GROUP_CURR		☐	PRICE_GROUP_CURR	☐	Price Level Currency
10	PLGTP	WRF_PRGRPLEVELS	PLGTP		☐	PLGTP	☐	Price band category
11	TIMESTAMP	WRF_PRGRPLEVELS	TIMESTAMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	DELFLAG	WRF_PRGRPLEVELS	DELFLAG		☐	DELFLAG_PRICE_LEVEL	☐	Deletion Flag Price Level

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