SAP ABAP View V_WRPL_MCAT (Replenishment: view of master data and movement data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-CBP (Application Component) Consumption-Based Planning (See Also PP-MRP)
     ⤷ WRPL (Package) Retail: Replenishment

Basic Data

View Type	D	Database View
Database View	V_WRPL_MCAT
Short Description	Replenishment: view of master data and movement data
Root table	WRPL	Replenishment: quantities per customer/material

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WRPL	WRPL
2	WRPT
3	MARA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WRPL	KUNNR	JL	EQ				0	0
2	WRPT	KUNNR	JR	EQ			AND	0	0
3	WRPL	MATNR	JL	EQ				0	0
4	WRPT	MATNR	JR	EQ			AND	0	0
5	WRPL	MANDT	JL	EQ				0	0
6	WRPT	MANDT	JR	EQ			AND	0	0
7	WRPL	MATNR	JL	EQ				0	0
8	MARA	MATNR	JR	EQ			AND	0	0
9	WRPL	MANDT	JL	EQ				0	0
10	MARA	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	WRPL	*		☐		☐
2	MANDT	WRPL	MANDT		☐	MANDT	☐	Client
3	KUNNR	WRPL	KUNNR		☐	WRKUNNR	☐	Recipient
4	MATNR	WRPL	MATNR		☐	MATNR	☐	Material Number
5	-	WRPL	STOCK		☐	WRQUAN_OLD	☐	- obsolete -
6	SOBST	WRPL	SOBST		☐	WRSOBST	☐	Target stock at recipient
7	-	WRPL	MABST		☐	WRQUAN_OLD	☐	- obsolete -
8	MINBE	WRPL	MINBE		☐	WRMINBE	☐	Reorder point
9	EISBE	WRPL	EISBE		☐	EISBE	☐	Safety stock
10	-	WRPL	MEINS		☐	WRUNIT_OLD	☐	- obsolete -
11	-	WRPL	PERAN		☐	WRDEC3_OLD	☐	- obsolete -
12	-	WRPL	ANZPR		☐	WRDEC3_OLD	☐	- obsolete -
13	-	WRPL	PRMOD		☐	WRCHR1_OLD	☐	- obsolete -
14	-	WRPL	CHNGE		☐	WRCHR1_OLD	☐	- obsolete -
15	EXFLG	WRPL	EXFLG		☐	WRCHR1_OLD	☐	- obsolete -
16	NIMGT	WRPL	NIMGT		☐	WRNIMGT	☐	Use Replenishment-Based Inventory Management
17	NGRCT	WRPL	NGRCT		☐	WRNGRCT	☐	Correct replenishment stock against document quantity
18	DISMM	WRPL	DISMM		☐	DISMM	☐	MRP Type
19	PRWUG	WRPL	PRWUG		☐	WRPRWUG	☐	Minimum target stock
20	PRWOG	WRPL	PRWOG		☐	WRPRWOG	☐	Maximum target stock
21	TRCOV	WRPL	TRCOV		☐	WRANZPR	☐	Target range of coverage
22	SRP_MATKL	WRPL	SRP_MATKL		☐	MATKL	☐	Material Group
23	SRP_BFLME	WRPL	SRP_BFLME		☐	BFLME	☐	Generic Material with Logistical Variants
24	SRP_PLIFZ	WRPL	SRP_PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
25	SRP_WEBAZ	WRPL	SRP_WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
26	SRP_LFRHY	WRPL	SRP_LFRHY		☐	LFRHY	☐	Planning cycle
27	SRP_PERKZ	WRPL	SRP_PERKZ		☐	PERKZ	☐	Period indicator
28	SRP_PERIV	WRPL	SRP_PERIV		☐	PERIV	☐	Fiscal Year Variant
29	SRP_WERKS	WRPL	SRP_WERKS		☐	WERKS_D	☐	Plant
30	SRP_RESWK	WRPL	SRP_RESWK		☐	RESWK	☐	Supplying (issuing) plant in case of stock transport order
31	SRP_LIFNR	WRPL	SRP_LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
32	SRP_MDREL	WRPL	SRP_MDREL		☐	WSRP_DC_MDREL	☐	Flag: Relevance of Merchandise Distribution in RESWK
33	SRP_EKORG	WRPL	SRP_EKORG		☐	EKORG	☐	Purchasing organization
34	SRP_WBTYP	WRPL	SRP_WBTYP		☐	VWWSBTYPVO	☐	Default doc. category, store order inbound - replenishment
35	SRP_ATPFLG	WRPL	SRP_ATPFLG		☐	WSRP_ATPFLG	☐	Run ATP Check
36	SRP_RLTFLG	WRPL	SRP_RLTFLG		☐	WSRP_RLTFLG	☐	Include Replenishment Lead-Time in ATP Check
37	SRP_DYNTS	WRPL	SRP_DYNTS		☐	WSRP_DYNTS	☐	Calculate Target Stock Dynamically
38	SRP_BZTEK	WRPL	SRP_BZTEK		☐	BZTEK	☐	Processing time required by purchasing department
39	SRP_MENGU	WRPL	SRP_MENGU		☐	MENGU	☐	Quantity Updating in Material Master Record
40	SRP_HEAD	WRPL	SRP_HEAD		☐	MATNR	☐	Material Number
41	SRP_IMFLG	WRPL	SRP_IMFLG		☐	WSRP_IMFLG	☐	Store Replenishment: MM-Based Inventory Management Active
42	SRP_WBZFLG	WRPL	SRP_WBZFLG		☐	WSRP_WBZFLG	☐	Include Default Replenishment Lead-Time
43	SRP_VKORG	WRPL	SRP_VKORG		☐	VKORG	☐	Sales Organization
44	SRP_VTWEG	WRPL	SRP_VTWEG		☐	VTWEG	☐	Distribution Channel
45	SRP_SPART	WRPL	SRP_SPART		☐	SPART	☐	Division
46	SRP_INFLS	WRPL	SRP_INFLS		☐	INFLS	☐	Read customer-material info record ?
47	SRP_DEFQTUNIT	WRPL	SRP_DEFQTUNIT		☐	WSRP_DEFQTUNIT	☐	Default Unit of Measure
48	SRP_VENUNITGR	WRPL	SRP_VENUNITGR		☐	WSRP_VENUNITGR	☐	Vendor Unit of Measure Group
49	SRP_BUYUNITGR	WRPL	SRP_BUYUNITGR		☐	WSRP_BUYUNITGR	☐	Recipient Unit of Measure Group
50	SRP_RDPRF	WRPL	SRP_RDPRF		☐	RDPRF	☐	Rounding Profile
51	SRP_MAXQT	WRPL	SRP_MAXQT		☐	MDR1MAXQT	☐	Maximum quantity
52	SRP_MINQT	WRPL	SRP_MINQT		☐	MDR1MINQT	☐	Minimum quantity
53	SRP_MAMIQTUNIT	WRPL	SRP_MAMIQTUNIT		☐	WSRP_MAMIQTUNIT	☐	Unit of Measure for Minimum and Maximum Quantity
54	SRP_VABME	WRPL	SRP_VABME		☐	VABME	☐	Variable Purchase Order Unit Active
55	SRP_BSTRF	WRPL	SRP_BSTRF		☐	BSTRF	☐	Rounding value for purchase order quantity
56	SRP_VAVME	WRPL	SRP_VAVME		☐	VAVME	☐	Variable Sales Unit Not Allowed
57	SRP_SCMNG	WRPL	SRP_SCMNG		☐	WSRP_SCMNG	☐	Increment for SD Rounding Proc. in Sales Document Category
58	SRP_SCHME	WRPL	SRP_SCHME		☐	WSRP_SCHME	☐	Unit of Measure for Increment
59	SRP_PSTYP	WRPL	SRP_PSTYP		☐	PSTYP	☐	Item category in purchasing document
60	*	WRPT	*		☐		☐
61	-	WRPT	MANDT		☐	MANDT	☐	Client
62	-	WRPT	KUNNR		☐	WRKUNNR	☐	Recipient
63	-	WRPT	MATNR		☐	MATNR	☐	Material Number
64	STOCK	WRPT	STOCK		☐	WRSTOCK	☐	Stock level of recipient
65	CHNGE	WRPT	CHNGE		☐	WRCHR1_OLD	☐	- obsolete -
66	PLTIMEPT	WRPT	PLTIMEPT		☐	WRPLTIMEPT	☐	Next planning timepoint
67	PLTIMEZONE	WRPT	PLTIMEZONE		☐	WRPLTIMEZN	☐	Next planning timepoint, time zone
68	GRTIMEPT	WRPT	GRTIMEPT		☐	WRGRTIMEPT	☐	Next goods receipt
69	GRTIMEZONE	WRPT	GRTIMEZONE		☐	WRGRTIMEZN	☐	Next goods receipt, time zone
70	RPLID	WRPT	RPLID		☐	WRPLID	☐	Replenishment run: ID number
71	RPLRQ	WRPT	RPLRQ		☐	WRPLRQ	☐	Replenishment requirement from last replenishment run
72	RPLST	WRPT	RPLST		☐	WRPLST	☐	Replenishment status
73	CHCNT	WRPT	CHCNT		☐	WRCOUNT	☐	Replenishment: Change counter
74	ONORD	WRPT	ONORD		☐	WRONORD	☐	Purchase order stock quantity for customers
75	SRP_NPLDAT	WRPT	SRP_NPLDAT		☐	WSRP_NPLDAT	☐	Next Planning Date from Planning Rhythm
76	SRP_CONSUMPTION	WRPT	SRP_CONSUMPTION		☐	WSRP_CONSUMPTION	☐	Inventory Change Since Last POS Upgrade
77	SRP_RECEIPTS	WRPT	SRP_RECEIPTS		☐	MNG04	☐	ATP quantity
78	SRP_UMLMC	WRPT	SRP_UMLMC		☐	UMLME	☐	Stock in transfer (plant to plant)
79	SRP_ARPLRQ	WRPT	SRP_ARPLRQ		☐	WSRP_ARPLRQ	☐	Changed Replenishment Requirement of Last Replenishment Run
80	SRP_ARPLME	WRPT	SRP_ARPLME		☐	WSRP_ARPLME	☐	Store Replenishment: Unit of Measure in Changed Replen. Req.
81	SRP_ARESWK	WRPT	SRP_ARESWK		☐	WSRP_ARESWK	☐	Store Replenishment: Altern. Plant in Stock Transport Order
82	SRP_ALIFNR	WRPT	SRP_ALIFNR		☐	WSRP_ALIFNR	☐	Store Replenishment: Account Number of Alternative Vendor
83	SRP_AEINDT	WRPT	SRP_AEINDT		☐	WSRP_AEINDT	☐	Store Replenishment: Requested Delivery Date
84	SRP_AUZEIT	WRPT	SRP_AUZEIT		☐	WSRP_AUZEIT	☐	Time of Requested Delivery Date
85	SRP_FFNR	WRPT	SRP_FFNR		☐	WSRP_FFNR	☐	ID Number in Subsequent Function
86	SRP_BRPLRQ	WRPT	SRP_BRPLRQ		☐	WSRP_BRPLRQ	☐	Confirmed Replenishment Requirement
87	SRP_BRPLME	WRPT	SRP_BRPLME		☐	WSRP_BRPLME	☐	Unit of Measure in Confirmed Replenishment Requirement
88	SRP_BRESWK	WRPT	SRP_BRESWK		☐	WSRP_BRESWK	☐	Confirmed Plant in Stock Transport Order
89	SRP_BLIFNR	WRPT	SRP_BLIFNR		☐	WSRP_BLIFNR	☐	Account Number of Confirmed Vendor
90	SRP_OBJTYPE	WRPT	SRP_OBJTYPE		☐	OBJTYPE	☐	Object type
91	SRP_BELNR	WRPT	SRP_BELNR		☐	SWO_TYPEID	☐	Object key
92	SRP_POSNR	WRPT	SRP_POSNR		☐	WVFB_BELP	☐	Document Item in Follow-On Document for Store Order
93	SRP_EINDT	WRPT	SRP_EINDT		☐	EINDT	☐	Item delivery date
94	SRP_UZEIT	WRPT	SRP_UZEIT		☐	UZEIT	☐	Time
95	SRP_BSTYP	WRPT	SRP_BSTYP		☐	BSTYP	☐	Purchasing document category
96	SRP_BSART	WRPT	SRP_BSART		☐	BSART	☐	Order Type (Purchasing)
97	SRP_DC_RQU	WRPT	SRP_DC_RQU		☐		☐
98	SRP_DC_CQU	WRPT	SRP_DC_CQU		☐		☐
99	SRP_DC_CUN	WRPT	SRP_DC_CUN		☐		☐
100	SRP_DC_OBJTYPE	WRPT	SRP_DC_OBJTYPE		☐	OBJTYPE	☐	Object type
101	SRP_DC_BELNR	WRPT	SRP_DC_BELNR		☐	SWO_TYPEID	☐	Object key
102	SRP_DC_POSNR	WRPT	SRP_DC_POSNR		☐	WVFB_BELP	☐	Document Item in Follow-On Document for Store Order
103	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group

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