The new wiki link for this data flow is here:

Technical Documentation - Production Planning Report

Please update the doc there and no longer here.

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)

Table of Contents

indent	Contents

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 :

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

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

Image Modified

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

Example:

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

Image Modified

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			Image Modified

Name	Description
Global Production	Internal Production + Sub Contacting Production
Internal Production	Principale Production + Co-product Production + By-product Production
Principale Production	Image Modified
Co-product Production	Image Modified
By-product Production	Image Modified
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	Image Modified
Sub contractor Production PP	Image Modified
Sub contractor Co product Production	Image Modified
Sub contractor By-product Production	Image Modified

Name	Description
Transfert Debit	Image Modified
Transfert Credit	Image Modified

Name	Description
Global consumption	Internal consumption + Sub contracting consumption
Internal consumption	Image Modified
Sub contracting consumption	Image Modified

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)	Image Modified

Name	Description
Global procurement	Procurement External + Procurement Inter Company + Procurement Intraco + Procurement Consignment
Procurement External	Procurement External ( + ) - Procurement External ( - )
Procurement External ( + )	Image Modified
Procurement External ( - )	Image Modified
Procurement Inter Company	Procurement Inter Company ( + ) - Procurement Inter Company ( - )
Procurement Inter Company ( + )	Image Modified
Procurement Inter Company ( - )	Image Modified
Procurement Intraco	Procurement Intraco ( + ) - Procurement Intraco ( - )
Procurement Intraco ( + )	Image Modified
Procurement Intraco ( - )	Image Modified
Procurement Consignment	Procurement Consignment (without order) + Procurement Consignment (with order)
Procurement Consignment (without order)	Image Modified
Procurement Consignment (with order)	Image Modified

Name	Description
Global Sales	Sales External + Sales Inter Company + Sales Intraco + Sales Consignment
Sales External	Sales External ( + ) - Sales External ( - )
Sales External ( + )	Image Modified
Sales External ( - )	Image Modified
Sales Inter Company	Sales Inter Company ( + ) - Sales Inter Company ( - )
Sales Inter Company ( + )	Image Modified
Sales Inter Company ( - )	Image Modified
Sales Intraco	Sales Intraco ( + ) - Sales Intraco ( - )
Sales Intraco ( + )	Image Modified
Sales Intraco ( - )	Image Modified
Sales Consignment	Sales Consignment ( + ) - Sales Consignment ( - )
Sales Consignment ( + )	Image Modified
Sales Consignment ( - )	Image Modified

Name	Description
0TOTALSTCK	Quantity Total Stock
Unrestr.-use stock (Unrestr + Quality Inspection)	Image Modified
Unrestr.-use stock	Image Modified
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

Application	PP - Production Planning
Query Name	BW - Stock Mmvt with conversion (Core query)
Query Technical Name	BW_QRY_MPR_IC001_0063
Content	Image Modified
Mandatory Prompt	Image Modified
Application	PP - Production Planning
Query Name	BW - Stock Movement All Types (Core query)
Query Technical Name	BW_QRY_MPR_IC001_0014
Content	Image Modified
Mandatory Prompt	Image Modified