Versions Compared

Old Version 2

changes.mady.by.user PAMELA VALERIA DE FARIA

Saved on

compared with

New Version Current

changes.mady.by.user GIRAUD-ext, Mickael

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

Technical Documentation - Production Planning Report

Please update the doc there and no longer here.

(warning)    (warning)     (warning)     (warning)



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)

Table of Contents

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

Image Modified

 

 



Link to MD04:

Image Modified

Selection Screen

Example:

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

Image Modified

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 Center0WORKCENTER

Displays Work Center Code and Name (Medium text)

Material PlantC_MATPLNT

Displays Material Plant Code and Name

Key Figures 

Image Modified

Future Key Figures (Planned)

NameDescription
Production - Future

Sum of all MRP elements related to production of the period from MD04:

Image Modified

Consumption - Future

Sum of all MRP elements related to consumption of the period from MD04:

Image Modified

Procurement - Future

Sum of all MRP elements related to Procurement of the period from MD04:

Image Modified

Future Demand

Sales Orders on MD04 + remaining Forecast as in MD04

Image Modified

Projected StockProjected Stock at the end of the period as in MD04
Other FlowsOther flows in the future as in MD04

Actual (from Stock Movements)


Key Figures : Production

NameDescription 
ProductionInternal Production + Sub Contacting Production + Co-product Production + By-product Production
Principale Production
Image Modified
Co-product Production
Image Modified
By-product Production
Image Modified
Sub contracting productionSub 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

Key Figures : Other Flows

NameDescription 
Transfert Debit
Image Modified
Transfert Credit
Image Modified

Key Figures : Consumption

NameDescription 
Global consumptionInternal consumption + Sub contracting consumption
Internal consumption
Image Modified
Sub contracting consumption
Image Modified

Key Figures : Procurement

NameDescription 
Global procurementProcurement External + Procurement Inter Company + Procurement Intraco + Procurement Consignment
Procurement ExternalProcurement External ( + ) - Procurement External ( - )
Procurement External ( + )
Image Modified
Procurement External ( - )
Image Modified
Procurement Inter CompanyProcurement Inter Company ( + ) - Procurement Inter Company ( - )
Procurement Inter Company ( + )
Image Modified
Procurement Inter Company ( - )
Image Modified
Procurement IntracoProcurement Intraco ( + ) - Procurement Intraco ( - )
Procurement Intraco ( + )
Image Modified
Procurement Intraco ( - )
Image Modified
Procurement ConsignmentProcurement Consignment (without order) + Procurement Consignment (with order)
Procurement Consignment (without order)
Image Modified
Procurement Consignment (with order)
Image Modified

Key Figures : Sales

NameDescription 
Global SalesSales External + Sales Inter Company + Sales Intraco + Sales Consignment
Sales ExternalSales External ( + ) - Sales External ( - )
Sales External ( + )
Image Modified
Sales External ( - )
Image Modified
Sales Inter CompanySales Inter Company ( + ) - Sales Inter Company ( - )
Sales Inter Company ( + )
Image Modified
Sales Inter Company ( - )
Image Modified
Sales IntracoSales Intraco ( + ) - Sales Intraco ( - )
Sales Intraco ( + )
Image Modified
Sales Intraco ( - )
Image Modified
Sales ConsignmentSales Consignment ( + ) - Sales Consignment ( - )
Sales Consignment ( + )
Image Modified
Sales Consignment ( - )
Image Modified

Key Figures : Total Stock

NameDescription 
0TOTALSTCKQuantity Total Stock
Unrestr.-use stock (Unrestr + Quality Inspection)
Image Modified
Unrestr.-use stock
Image Modified
0QMSTOCKStock in Quality Inspection
0BLOCKEDSTKBlocked 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

Image ModifiedImage Modified

Mandatory Prompt

Image Modified

 


Trouble shooting:

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