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 Main Sub-Providers Used	Material Stocks (CUB_IC001) Material Movements (CUB_IC002)
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

$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 16:30:51.png$

Link to MD04:

$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-10-9 13:49:32.png$

Selection Screen

Example:

Company Code (due to authorization)
Calendar Year/Month will always be the current month (by default)
Other prompts are optional.

$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 16:9:17.png$

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		$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 16:23:48.png$

Future Key Figures (Planned)

Name	Description
Production - Future	Sum of all MRP elements related to production of the period from MD04: $TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 18:3:8.png$
Consumption - Future	Sum of all MRP elements related to consumption of the period from MD04: $TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 18:5:13.png$
Procurement - Future	Sum of all MRP elements related to Procurement of the period from MD04: $TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 18:5:38.png$
Future Demand	Sales Orders on MD04 + remaining Forecast as in MD04 $TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 18:6:17.png$
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	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:17:41.png$
Co-product Production	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:18:5.png$
By-product Production	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:18:31.png$
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	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:20:20.png$
Sub contractor Production PP	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:20:43.png$
Sub contractor Co product Production	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:21:9.png$
Sub contractor By-product Production	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:21:28.png$

Key Figures : Other Flows

Name	Description
Transfert Debit	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:22:39.png$
Transfert Credit	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:23:16.png$

Key Figures : Consumption

Name	Description
Global consumption	Internal consumption + Sub contracting consumption
Internal consumption	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:24:31.png$
Sub contracting consumption	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 11:25:13.png$

Key Figures : Procurement

Name	Description
Global procurement	Procurement External + Procurement Inter Company + Procurement Intraco + Procurement Consignment
Procurement External	Procurement External ( + ) - Procurement External ( - )
Procurement External ( + )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:25:3.png$
Procurement External ( - )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:25:31.png$
Procurement Inter Company	Procurement Inter Company ( + ) - Procurement Inter Company ( - )
Procurement Inter Company ( + )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:38:41.png$
Procurement Inter Company ( - )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:39:8.png$
Procurement Intraco	Procurement Intraco ( + ) - Procurement Intraco ( - )
Procurement Intraco ( + )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:40:40.png$
Procurement Intraco ( - )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:40:18.png$
Procurement Consignment	Procurement Consignment (without order) + Procurement Consignment (with order)
Procurement Consignment (without order)	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:42:34.png$
Procurement Consignment (with order)	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:43:24.png$

Key Figures : Sales

Name	Description
Global Sales	Sales External + Sales Inter Company + Sales Intraco + Sales Consignment
Sales External	Sales External ( + ) - Sales External ( - )
Sales External ( + )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:48:15.png$
Sales External ( - )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:48:37.png$
Sales Inter Company	Sales Inter Company ( + ) - Sales Inter Company ( - )
Sales Inter Company ( + )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:49:1.png$
Sales Inter Company ( - )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:49:31.png$
Sales Intraco	Sales Intraco ( + ) - Sales Intraco ( - )
Sales Intraco ( + )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:50:22.png$
Sales Intraco ( - )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:50:49.png$
Sales Consignment	Sales Consignment ( + ) - Sales Consignment ( - )
Sales Consignment ( + )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:51:15.png$
Sales Consignment ( - )	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:51:39.png$

Key Figures : Total Stock

Name	Description
0TOTALSTCK	Quantity Total Stock
Unrestr.-use stock (Unrestr + Quality Inspection)	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:56:28.png$
Unrestr.-use stock	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2015-10-2 16:57:1.png$
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	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 16:10:53.png$ $TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 16:11:15.png$
Mandatory Prompt	$TECHNO - BI TEAM > BW - Stock and Planning Month Snapshot (Core query) /!\ Obsolete /!\ > image2017-4-4 16:9:17.png$

Trouble shooting:

Actual data in the report but no planned data in the future :