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 |
| Table of Contents |
|---|
| Related queries | BW - Capacity planning – Weekly (Core Query) BW_QRY_CUB_CAP_0001 |
|---|
| Table of Contents |
|---|
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 to mirror the existing reports in APO:
- 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