SAP ABAP View WFCS_MDSTKEY1_V (Key View via MARC, MAPR and PROP (for Replenishment))

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ MM-CBP (Application Component) Consumption-Based Planning (See Also PP-MRP)
     ⤷ WFCS (Package) IS-R: Sales Forecasting for Stores

Basic Data

View Type	D	Database View
Database View	WFCS_MDSTKEY1_V
Short Description	Key View via MARC, MAPR and PROP (for Replenishment)
Root table	MARC	Plant Data for Material

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARC	MARC
2	MAPR
3	PROP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARC	MANDT	JL	EQ				0	0
2	MAPR	MANDT	JR	EQ			AND	0	0
3	MARC	MANDT	JL	EQ				0	0
4	PROP	MANDT	JR	EQ			AND	0	0
5	MARC	MATNR	JL	EQ				0	0
6	MAPR	MATNR	JR	EQ			AND	0	0
7	MARC	WERKS	JL	EQ				0	0
8	MAPR	WERKS	JR	EQ			AND	0	0
9	MAPR	PNUM1	JL	EQ				0	0
10	PROP	PNUM1	JR	EQ			AND	0	0
11	PROP	HSNUM		EQ	'00'		AND	0	0
12	PROP	VERSP		EQ	'00'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MARC	MANDT		☐	MANDT	☐	Client
2	MATNR	MARC	MATNR		☐	MATNR	☐	Material Number
3	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant
4	PNUM1	PROP	PNUM1		☐	PNUM1	☐	Pointer: forecast parameters
5	HSNUM	PROP	HSNUM		☐	HSNUM	☐	Number for history
6	VERSP	PROP	VERSP		☐	VERSP	☐	Version number of forecast parameters
7	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
8	MMSTA	MARC	MMSTA		☐	MMSTA	☐	Plant-Specific Material Status
9	PERKZ	MARC	PERKZ		☐	PERKZ	☐	Period indicator
10	PERIV	MARC	PERIV		☐	PERIV	☐	Fiscal Year Variant
11	PRDAT	PROP	PRDAT		☐	PRDAT	☐	Date of last forecast
12	PRMOD	PROP	PRMOD		☐	PRMOD	☐	Forecast model

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	46C