Basic Information

Application	PP - Production Planning
Query Name	BW - Stock Movement Production (Core Query)
Query Technical Name	BW_QRY_MPR_IC001_0013
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	Controllers, Supply chain, Production Manager, Demand manager, Scheduling Manager , Planning manager.
Related workbooks	BW - Stock Movement Production (Core workbook) (BW_WBK_PP_0001) BW - Stock Movement All types (Core workbook) (BW_WBK_PP_0006)

Purpose of this query

This query allows to follow the past inventory movements with a supply chain view, to follow monthly, weekly or daily evolution of :

Production
Consumption
Procurement
Sales
inventory (Qty, Value)

Neutralisation – How does it work ?

What is neutralisation

Neutralisation is a calculation which avoids to aggregate some key figures for which a simple sum is not relevant

Why do we neutralise

Neutralisation is required when a process order produces and consumes material which belong to the same group of material.
Example : group of material = LIP00, where LIP00 is a code which defines the chemical product of a material

- Packaging process orders
- Unpacking process orders (Silica « Craquage », Salicylic acid in Roussillon)
- Recycling or Rework process orders (only net qty needs to be counted)
- Relotification process order

$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2017-3-29 15:20:48.png$

How do we neutralise ?

First: Neutralized consumption = consumption into a material of another group
Second: Neutralized production = Production – Consumption + Neutralized consumption

Selection Screen

Example:

Calendar Year/Month is mandatory (MM.YYYY) as well as Company Code (due to authorization)
Other prompts are optional.

$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2017-4-3 13:43:47.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 Movement Production (Core Query) /!\ Obsolete /!\ > image2017-4-3 13:42:10.png$

Key Figures : Production

Name	Description
Global Production	Internal Production + Sub Contacting Production
Internal Production	Principale Production + Co-product Production + By-product Production
Principale Production	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:17:41.png$
Co-product Production	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:18:5.png$
By-product Production	$TECHNO - BI TEAM > BW - Stock Movement Production (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 Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:20:20.png$
Sub contractor Production PP	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:20:43.png$
Sub contractor Co product Production	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:21:9.png$
Sub contractor By-product Production	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:21:28.png$

Key Figures : Transfert

Name	Description
Transfert Debit	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:22:39.png$
Transfert Credit	$TECHNO - BI TEAM > BW - Stock Movement Production (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 Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:24:31.png$
Sub contracting consumption	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:25:13.png$

Key Figures : Neutralized Production and Consumption

Name	Description
Neutralized production (LIP00)	Principale Production + Co-product Production + By-product Production + Sub contractor Production PP + Sub contractor Co product Production + Sub contractor By-product Production - (Internal consumption + Sub contracting consumption) + Neutralized consumption (LIP00)
Neutralized consumption (LIP00)	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 11:27:4.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 Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:25:3.png$
Procurement External ( - )	$TECHNO - BI TEAM > BW - Stock Movement Production (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 Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:38:41.png$
Procurement Inter Company ( - )	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:39:8.png$
Procurement Intraco	Procurement Intraco ( + ) - Procurement Intraco ( - )
Procurement Intraco ( + )	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:40:40.png$
Procurement Intraco ( - )	$TECHNO - BI TEAM > BW - Stock Movement Production (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 Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:42:34.png$
Procurement Consignment (with order)	$TECHNO - BI TEAM > BW - Stock Movement Production (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 Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:48:15.png$
Sales External ( - )	$TECHNO - BI TEAM > BW - Stock Movement Production (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 Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:49:1.png$
Sales Inter Company ( - )	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:49:31.png$
Sales Intraco	Sales Intraco ( + ) - Sales Intraco ( - )
Sales Intraco ( + )	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:50:22.png$
Sales Intraco ( - )	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:50:49.png$
Sales Consignment	Sales Consignment ( + ) - Sales Consignment ( - )
Sales Consignment ( + )	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:51:15.png$
Sales Consignment ( - )	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:51:39.png$

Key Figures : Quantity and Valuation Total Stock

Name	Description
0TOTALSTCK	Quantity Total Stock
Unrestr.-use stock (Unrestr + Quality Inspection)	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:56:28.png$
Unrestr.-use stock	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2015-10-2 16:57:1.png$
0QMSTOCK	Stock in Quality Inspection
0BLOCKEDSTK	Blocked Stock
0VALSTCKVAL	Valorised Stock Value
Unrestr.-use stock (Unrestr + Quality Inspection) (Value)	Unrestr.-use stock (value) + Q stock (value)
Unrestr.-use stock (value)	Valorised Stock Value * Unrestr.-use stock / Quantity Total Stock
Q stock (value)	Valorised Stock Value * Stock in Quality Inspection / Quantity Total Stock
Blocked stock (Value)	Valorised Stock Value * Blocked Stock / Quantity Total Stock

Related Queries

Application	PP - Production Planning
Query Name	BW - Stock Mmvt with conversion (Core query)
Query Technical Name	BW_QRY_MPR_IC001_0063
Content	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2017-4-3 13:34:12.png$
Mandatory Prompt	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2017-4-3 13:35:56.png$
Application	PP - Production Planning
Query Name	BW - Stock Movement All Types (Core query)
Query Technical Name	BW_QRY_MPR_IC001_0014
Content	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2017-4-3 14:5:30.png$
Mandatory Prompt	$TECHNO - BI TEAM > BW - Stock Movement Production (Core Query) /!\ Obsolete /!\ > image2017-4-3 14:6:2.png$