Basic Information

BW Server	WBP
Application	PP - Production Planning
Query Name	BW - Capacity planning - Monthly (Core Query)
Query Technical Name	BW_QRY_CUB_CAPM_0001
Core/Specific Scope	Core
Specific Reason
Provider Name	CUB_CAPM
Usage type	Direct execution in Analysis
Expected users	Supply Chain, Production Planner, Capacity Planner, Demand Planner, Scheduleur
Related queries	BW - Capacity planning – Weekly (Core Query) BW_QRY_CUB_CAP_0001

Purpose of this query

This report in BW is showing in a period until 5 years the load of production resources depending on their working hours, and on the production plan (planned orders & process orders) in place. The load is expressed in hours and % and Qty Produced is based on phase in Recipe.

Monthly view :

Weekly View

Context

There are two transactions in SAP that can be used for capacity analysis:

CM01 – shows capacity planning for active planning version
CM38 - shows capacity planning for any planning version

In each case,

You can look at capacity by week, month, qtr, etc.
You can view hours and quantity

However,

If a planned order starts in one period and ends in another, qty is shown in both periods
The quantity displayed is based on the planned order quantity, NOT the quantity on the phase of recipe
Difficult to work with

Two Capacity Planning reports were developed in BW:

BW - Capacity planning - Monthly (Core Query)
BW - Capacity planning - Weekly(Core Query)

Benefits: Reliability

Source of information comes right from SAP ECC
Available capacity based on intervals defined on the resource master
Information is updated daily (during night)

Functionalities comparaison with SAP reports

	CM01	CM38	BW	ZWPP31A
Shows Both Hours and Qty	X	X	X
Shows past Due Elements	X			X
Scaled to display hours within period	X	X	X
Qty Produced is shown in Start Period, Finish Period or Both Periods	Both	Both	Finish	Finish
Qty Produced is based on Planned order Qty	X	X		X
Qty Produced is based on phase in Recipe			X
Multi-step Recipe Resource is accommodated	X	X	X
Allows for 5 years of capacity review	180 days	180 days	X	X

Further considerations

BW capacity report displays total plant throughput and hours by reactor
BW capacity report may not agree with the standard SAP reporting or ZWPP31A

Variables screen

Variable Name	Authorization Object	Description
Convert Unit	No	To convert to a single quantity unit
Plant	Yes

Enter a Unit of Measure, plant and Date range

The standard planning scenario is #
Other Long Term Planning Scenarios could also be selected

Filters

Object	Filter Value	Explanation
None

Characteristics

Characteristic Name	Characteristic code	Explanation
Work Center	0WORKCENTER	Displays Work Center Code and Name (Medium text)
Material		Display material code and name

Key Figures

Key Figure	Description	Calculation rule detail
Capacity	Number of hours available in the period
Stream (85%)	Indication of 85% of capacity, typical OEE	capacity * .85
Cap. Con	How many hours are allocated to that resource
Capa cons %	% of capacity utilisation	Cap.con/Capacity * 100
Prod	qty planned to be produced in the resource in that period

Unit Conversion

Unit : Variable

The full explanation on how the quantity conversion works can be found in the Quantity Unit Conversion page.

FAQ

Question : How Data Gets Populated into this query?

Each night AFTER MRP completes, a job runs to extract the MRP results. These jobs are linked

MRP Jobs here

Data Extract Jobs here

The data then is loaded into BW

Question : Why there's no data for my plant ?

In case of new plant, post an IS request to include your plant on the Data Extract Jobs in SAP

Page tree

BW - Capacity planning - Monthly (Core Query)