The new wiki link for this data flow is here:
Please update the doc there and no longer here.
Basic Information
Application | PP - Production Planning |
|---|---|
Query Name | BW - Stock and Planning Month Snapshot (Core query) |
Query Technical Name | BW_QRY_MPR_IC001_0017B |
Multi-Provider Name | Material Stock/Movement |
Multi-Provider Technical Name | MPR_IC001 |
Names & Technical Names of | Material Stocks (CUB_IC001) |
Usage type | Direct execution in Analysis |
Expected users | Supply chain, Demand manager, Scheduling Manager , Planning manager. |
| Related workbooks | BW - Stock and Planning Month Snapshot (Core) (BW_WBK_PP_0007) BW - Stock Movement All types (Core workbook) (BW_WBK_PP_0006) |
Purpose of this query
This reports is providing a synthesis of the stock and planning elements.
You can find Actual from past inventory movements :
- Production
- Consumption
- Procurement
- Sales
- inventory
and Future planning from MRP elements :
- Planned Production
- Planned Consumption
- Planned Procurement
- Future Demand : Sales Orders + remaining Sales Forecast
- Projected Stock
Link to MD04:
Selection Screen
Example:
- Company Code (due to authorization)
- Calendar Year/Month will always be the current month (by default)
- Other prompts are optional.
Characteristics and Key Figures available for Display and Drilldown
Characteristics
Name | TechName | Description |
|---|---|---|
Plant | 0PLANT | Displays Plant Code and Name |
MPR Controller | C_MATPLNT__0MRP_CONTRL | Displays MPR Controller Code and Name |
| Work Center | 0WORKCENTER | Displays Work Center Code and Name (Medium text) |
| Material Plant | C_MATPLNT | Displays Material Plant Code and Name |
| Key Figures |
|
Future Key Figures (Planned)
| Name | Description |
|---|---|
| Production - Future | Sum of all MRP elements related to production of the period from MD04:
|
| Consumption - Future | Sum of all MRP elements related to consumption of the period from MD04:
|
| Procurement - Future | Sum of all MRP elements related to Procurement of the period from MD04:
|
| Future Demand | Sales Orders on MD04 + remaining Forecast as in MD04
|
| Projected Stock | Projected Stock at the end of the period as in MD04 |
| Other Flows | Other flows in the future as in MD04 |
Actual (from Stock Movements)
Key Figures : Production
| Name | Description |
|---|---|
| Production | Internal Production + Sub Contacting Production + Co-product Production + By-product Production |
| Principale Production |  |
| Co-product Production |  |
| By-product Production |  |
| Sub contracting production | Sub contractor Production MM + Sub contractor Production PP + Sub contractor Co product Production + Sub contractor By-product Production |
| Sub contractor Production MM |  |
| Sub contractor Production PP |  |
| Sub contractor Co product Production |  |
| Sub contractor By-product Production |  |
Key Figures : Other Flows
| Name | Description |
|---|---|
| Transfert Debit |  |
| Transfert Credit |  |
Key Figures : Consumption
| Name | Description |
|---|---|
| Global consumption | Internal consumption + Sub contracting consumption |
| Internal consumption |  |
| Sub contracting consumption |  |
Key Figures : Procurement
| Name | Description |
|---|---|
| Global procurement | Procurement External + Procurement Inter Company + Procurement Intraco + Procurement Consignment |
| Procurement External | Procurement External ( + ) - Procurement External ( - ) |
| Procurement External ( + ) |  |
| Procurement External ( - ) |  |
| Procurement Inter Company | Procurement Inter Company ( + ) - Procurement Inter Company ( - ) |
| Procurement Inter Company ( + ) |  |
| Procurement Inter Company ( - ) |  |
| Procurement Intraco | Procurement Intraco ( + ) - Procurement Intraco ( - ) |
| Procurement Intraco ( + ) |  |
| Procurement Intraco ( - ) |  |
| Procurement Consignment | Procurement Consignment (without order) + Procurement Consignment (with order) |
| Procurement Consignment (without order) |  |
| Procurement Consignment (with order) |  |
Key Figures : Sales
| Name | Description |
|---|---|
| Global Sales | Sales External + Sales Inter Company + Sales Intraco + Sales Consignment |
| Sales External | Sales External ( + ) - Sales External ( - ) |
| Sales External ( + ) |  |
| Sales External ( - ) |  |
| Sales Inter Company | Sales Inter Company ( + ) - Sales Inter Company ( - ) |
| Sales Inter Company ( + ) |  |
| Sales Inter Company ( - ) |  |
| Sales Intraco | Sales Intraco ( + ) - Sales Intraco ( - ) |
| Sales Intraco ( + ) |  |
| Sales Intraco ( - ) |  |
| Sales Consignment | Sales Consignment ( + ) - Sales Consignment ( - ) |
| Sales Consignment ( + ) |  |
| Sales Consignment ( - ) |  |
Key Figures : Total Stock
| Name | Description |
|---|---|
| 0TOTALSTCK | Quantity Total Stock |
| Unrestr.-use stock (Unrestr + Quality Inspection) |  |
| Unrestr.-use stock |  |
| 0QMSTOCK | Stock in Quality Inspection |
| 0BLOCKEDSTK | Blocked Stock |
Related Queries
Application | PP - Production Planning |
|---|---|
Query Name | BW - Stock and Planning report by week (Core query) |
Query Technical Name | BW_QRY_MPR_IC001_0068 |
Content |
|
Mandatory Prompt |
|
Trouble shooting:
- Actual data in the report but no planned data in the future :