View Source

Tab explanation:

aa

No attributes

BFC Activity 1	To be defined
BFC BU (Plant)	BU related to the plant site	Ex for a site: GBU = TS BU can be Polymer Additive OR Mining OR Phosphorus
BFC BU (Site)	BU related to the site attribute
BFC GBU (Plant)	GBU related to the plant attribute
BFC GBU (Site)	GBU related to the site attribute
BFC Market (Plant)	Market attached to the plant attribute
BFC Market (Site)	Market attached to the site attribute.
Buyer (Plant)	Buyer's name or ID in charge of the corresponding plant
Buyer (Site)	Buyer's name or ID in charge of the corresponding site

Calendar (Year/Month)	Horizon to define and select in the report through the " Prompt " view. Mandatory in order to display data.
Catalog LT (SAP)	Catalog Lead Time starting from “Order Entry Date” until “Material Availability date". This lead time comes from SAP
City (Plant)	City information attached to the plant attribute
City (Site)	City information attached to the site attribute
Classification (Plant)	TBD
Classification (Site)	TBD
Commercial Product / Material Group	Material group aggregation Can be Commercial Product / Material Group / Product Group, depending on the GBU.
Country (Plant)	Country of the plant attribute
Country (Site)	Country related to the site attribute
CRM Prospect Code	TBD

Division	Division of the product = material aggregation It is used to have another aggregated level of Product type	Example: For PEROX = New Product Type in Dynasys (PAA/H2O2 etc...)

No attributes

Flag prospect	TBD

GBR GBU Mat Group	Material group associated to the Material This information comes from the GBR (GBR = Global Business Repository) ==> database to manage master data not existing in SAP, but used in all reporting tools
GBR GBU Mat Sub-group	Material sub group associated to the Material This information comes from the GBR (GBR = Global Business Repository) ==> database to manage master data not existing in SAP, but used in all reporting tools
GBR Ship-to-KA (Plant)	Ship-to-KA related to the plant dimension. Ship-to-KA = Group of Ship-to (ex : Michelin is a ShiptoKA and Michelin France= Shipto, Michelin Poland= Ship-to) This information comes from the GBR (GBR = Global Business Repository) ==> database to manage master data not existing in SAP, but used in all reporting tools
GBR Ship-to-KA (Site)	Ship-to-KA related to the site dimension. Ship-to-KA = Group of Ship-to (ex : Michelin is a ShiptoKA and Michelin France= Shipto, Michelin Poland= Ship-to) This information comes from the GBR (GBR = Global Business Repository) ==> database to manage master data not existing in SAP, but used in all reporting tools
GBR Ship-to-KA adjusted (Plant)	TBD
GBR Ship-to-KA adjusted (Site)	TBD
Geo Zone (Plant)	Geographical Zone of the plant attribute It is not necessarily = Zone S&OP
Geo Zone (Site)	Geographical Zone of the site attribute It is not necessarily = Zone S&OP

No attributes

Industrial Origin	TBD

No attributes

Key RM (Plant)	TBD
Key RM (Site)	TBD

Last Updated on (Plant)	TBD
Last Updated on (Site)	TBD

Main Production Plant (Plant)	Main Production Plant of the specific Plant (attribute). Is different following the site displayed in the "Plant" dimension
Main Production Plant (Site)	Main Production Plant of the specific Site (attribute). Is different following the site displayed in the "Site" dimension
Main Shipping Plant (Plant)	Main Shipping Plant associated to the specific Plant (attribute). Is different following the site displayed in the "Plant" dimension
Main Shipping Plant (Site)	Main Shipping Plant associated to the specific Site (attribute). Is different following the site displayed in the "Site" dimension
Material	Material code and name to display in the report. One of the most important attribute of the query.
Material group	Material group aggregation used to aggregate Materials and have another level of display
Material type	Type of the material (Raw materials / Semi-finished / Finished goods / Trading goods / others)
Measures	Indicators of the report. Most important attribute. This is where you will be able to add / remove indicators of the report.
Mini zone (Plant)	Mini Zone of the Plant (Can be a country (Brazil/France...), or a zone (e.g. "Eastern Countries")"
Mini zone (Site)	Mini Zone of the Site (Can be a country (Brazil/France...), or a zone (e.g. "Eastern Countries")"
MRP controller	TBD

No attributes

Plant	As reminder, a SKU can be Receiving or Shipping site. This "Plant" attribute will then display the site attached to the SKU, whether it is RECEIVING or SHIPPING. ==> it will depend on the type of indicator that you selected. Example: if you select External Flows ETD in the Measures attribute, the SKU as indicator is a Shipping SKU, meaning that the Site you will see in the "Plant" attribute will be a shipping site.
Price Advisor	TBD
Price Advisor impact	TBD
Prod.hierarchy	Product hierarchy. Used as an aggregration of the material.
Product Category (Plant)	TBD
Product Category (Site)	TBD

No attributes

Reg Sales Manager	TBD
Region (Plant)	Region of a the plant within a country
Region (Site)	Region of a the site within a country

Sales Region	TBD
SHS RLT	Represents the total time between placing a production / replenishment order and the availability date.
Site	The "Site" attribute is the site that is not attached to the SKU. It can be a Receiving or Shipping site, depending on the indicator you selected. Example: if you select External Flows ETD in the Measures attribute, the SKU as indicator is a Shipping SKU, meaning that the Site you will see in the "Plant" attribute will be a shipping site and therefore the site in the "Site" attribute is the receiving site.
SOP Planner (Plant)	S&OP planner in charge of the plant (specific to CH)
SOP Planner (Site)	S&OP planner in charge of the site (specific to CH)
Source System	Source system where the material comes from (WP1/PF1).
Standard cost from S	TBD
Stock Hold. Strategy	Stock Holding Strategy. Can be: MTS / MTO / MTO-FB / MTF PTS / PTO

TRLT (SAP)

Total Replenishment Lead Time from SAP

It is the total period of time required to produce an item.

Type of site (Plant)

Type of site attached to the plant attribute (e.g: prod site / warehouse...)

Type of site (Site)

Type of site attached to the site attribute (e.g: prod site / warehouse...)

No attributes

Valuation Class (Plant)

Valuation class associated to the plant attribute.

A valuation class is a group of materials which have the same account determination. Different materials with similar properties are grouped together by valuation class. Eg Raw material, Finished Goods, Semi-Finished.

Valuation Class (Site)

Valuation class associated to the site attribute.

A valuation class is a group of materials which have the same account determination. Different materials with similar properties are grouped together by valuation class. Eg Raw material, Finished Goods, Semi-Finished.

Work Center	Equivalent to "Resource" in Dynasys

No attributes

Zone SOP (Plant)	Zone S&OP attached to the site in the "Plant" attribute. Sometimes, the S&OP zone is different from the Geo Zone, depending of flows.
Zone SOP (Site)	Zone S&OP attached to the site in the "Plant" attribute. Sometimes, the S&OP zone is different from the Geo Zone, depending of flows.

		GBU LINK
Actual Production	Actual production with no consideration of the ressource	Spec Chem
Actual shipped and final demand (ETD)	Past: Actual shipped in ETD (Good issue date) filtered only to ShipTo destination Future: Customer Demand taken by the DRP to calculate the requirements (after netting process)	Spec Chem
Actual shipped ETD	Actual shipped in ETD (Good issue date) filtered only to ShipTo destination	Spec Chem Novecare
Actuals and projected inventory	Actuals and projected inventory	Spec Chem
Anticipated inventory	Fraction of the inventory used for covering future requirements.
Available capacity	Capacity by ressource per period (opening days x hours per day)	Novecare (Resource settings) Novecare (Heatmap)
Available inventory (Budget)	Projected stock end of month calculated by the tool with the Budget Forecast from DP
Available inventory as validated	End of month projected inventory validated during the S&OP exercise

Backorders in ETD	Orders in a past period in SAP that can't be fulfilled at the moment but still taken into account so it will be fulfilled later
Balance	Difference between demand (or unconstraint production) and Production plan	Novecare (Resource Settings) Novecare (Heatmap)
BFR Forecast from DP ( ETA)	Working Capital Requirements WCR = Besoin en Fonds de Roulement BFR BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year
BFR Forecast from DP ( ETD)	Working Capital Requirements WCR = Besoin en Fonds de Roulement BFR BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year
Blocked stock	Blocked stock from SAP (viewable in transaction MMBE)	Spec Chem
Budget final demand ETD	Final demand after netting calculated by the tool with the Budget Forecast from DP
Budget Forecast from DP (ETA)	Budget Forecast validated in DP for Y+1 / the budget forecast is the quantity planned to be sold in year + 1 (at DFU level)
Budget Forecast from DP (ETD)	Budget Forecast validated in DP for Y+1 / the budget forecast is the quantity planned to be sold in year + 1 (at DFU level)
Budget production Plan	Production Plan validated during the Budget process
Budget Shipping Plan ETD	Shipping plan calculated by the tool with the Budget Forecast from DP
Budget Shipping requirement ETD	Shipping requirement calculated by the tool with the Budget Forecast from DP
Budget Working stock	For Silica: Working stock validated during the last Budget exercice

Constraint demand (ETA)	Receipt plan by customers in the receipt month
Cumulative Balance	Balance cumulated over the entire horizon
Cycle stock	Cycle stock calculated for P&I exercise

Demand Review (ETA)

Demand Review is fed by the sales team forecast and can be amended before final validation.

For Silica: Demand Review validated in DP

External flow detailed (ETD)	Plan to ship to customers in shipping period with destination detailed
External flows (ETD)	Plan to ship to customers in shipping period without the destination detailed

Final Demand as Validated ETD	Customer Demand taken by the DRP to calculate the requirements (after netting process)	Novecare
Final Forecast from DP (ETA)	Final forecast coming from DP defined in ETA
Final Forecast from DP (ETA) M-1	Forecast from DP validated last month
Final Forecast from DP (ETD) M-1	Forecast from DP validated last month
Final forecast from DP ETD	Final forecast coming from DP defined in ETD	Novecare
Final Safety Stock	Safety stock taken in the planning
Firm Receipt ETA	Current orders in SAP (customers, Inter Sites) in delivery date	Spec Chem
Firm Shipments ETD	Current orders in ETD (customer orders, inter site orders)
Firm Shipping Requirements ETD	Need to ship based on firm order book	Spec Chem
Forecast consumption ETD %	=Orderbook / Forecast in percentages SILICA = ratio = Shipped History (GI) + Order Book (ETD) / Gross history and final forecast

Gross Requirements (ETD)

Gross Requirement = Internal Flow+ External Flow+ Dependant Requirement (Internal consumption)

Spec Chem - (DRP Results)

Spec Chem - (Stock Settings)

No indicators

In transit inventory from SAP (ETA)	Stock in transit between two sites diplayed in the received period (coming from SAP)
Initial Inventory	Starting inventory for the current period (last dynamic refresh)	Spec Chem - (DRP Results) Spech Chem - (Stock Settings) Novecare (DRP)
Internal consumption	Dependant requirements for a component consumed in a parent product
Internal flows (ETD)	Plan to ship to other intra GBU site (Inter site) in shipping period

No indicators

Load %

Load%= Production Requirements/ Available capacity x100

Novecare (Ressource Settings)

Novecare (Heatmap)

Maximum Daily Capacity (MDC)	Maximum capacity by product / Ressource in quantity per day

No indicators

Order book confirmed or requested ETD	Sum of the Order book in ETD coming from SAP confirmed and requested	Novecare
Order book requested ETD	Order book coming from SAP in ETD requested	Novecare
Orderbook ( ETD)	Order book coming from SAP in ETD
Overall Equipment Effectiveness (OEE)	The overall equipment effectiveness (OEE) is a measure often used to calculate the return on assets in a business.

Past and future demand	Actual total demand and future demand
Physical inventory	End of month physical inventory (all types / In transit exculeded)
Planned Shutdown	The number of planned shutdown days / Resource
Production capacity	Maximum capacity by product / Ressource in quantity
Production capacity (H)	Maximum capacity by product / Ressource in hour
Production plan as validated	Production plan validated during the S&OP process without taking in consideration the ressources
Production plan by ressource as validated	Production plan validated during the S&OP process taking in consideration the ressources
Production planned (H)	Production plan validated during the S&OP process per hour
Production requirements	What we need to produce, considering the production constraints like batch size, minimum... Could be considered as the Unconstraint production plan	Novecare (Heatmap)
Projected inventory value	End of month projected inventory x CCR ( Unit Standard cost)
Projected transit inventory ETA	Stock in transit between two site, current orders and dynasys planned, displayed in the month not yet arrived ("on the road")	Spec Chem
Purchase plan (ETA)	Receipt plan for products coming from external source (external supplier)

QM Batch	QM Batch is a stock matched with quality inspection coming from SAP	Spec Chem

Receipt plan ETA	Receipt plan by all destination in the receipt month	Spec Chem
Restricted Stock (SAP)	Restricted inventory coming from SAP	Spec Chem

Safety stock (SAP)	Safety stock defined in SAP (MRP view)	Spec Chem Novecare
Safety stock V3	Safety stock calculated in Dynasys, bases on the V3 formula (projected requirements variability, service level, RLT)	Spec Chem Novecare
Scheduled %	Planned production / Available Capacity per Resource	Novecare (Heatmap)
Shipping plan	The shipping plan give you an overview of stock quantity need to be ship for each material and each shipping site	Spec Chem
Shipping plan as validated (ETD)	The shipping plan validated give you the validated quantity of stock need to be ship for each material and each shipping site
Shipping requirements as validated (ETD)	Defined the quantity validated need to be ship in ETD based on Order book and Forecast after netting process
Shipping requirements ETD	Defined the quantity need to be ship in ETD based on Order book and Forecast after netting process	Spec Chem
Shortages (ETA)	Forecast not fulfilled after a given delay Shortages are created when the demand is superior of the actual stock and production capacity => Final stock expected <0	Spec Chem - (Shortage Management) Spec Chem - (DRP Results)

No indicators

Unit Purchase cost in €	For Novecare: Forecasted purchased price calculated by raw material buyer

No indicators

Working Stock	For Silica: In the past: addition of EoM Unrestricted inventory + EoM vendor inventory + EoM QM batch // In the current month + future = available inventory calculated by the tool
Working Stock as Validated	For Silica: Working stock validated during the last validation

No indicators

		VIEW	BW LINK
Actual shipped (ETD)	This is the quantities (in KG) already shipped to the customer.	2-DRP Results ii. Netting at material level iii. Cancel Options	Actual Shipped (ETD)
Actual Production	Today's produced quantity with the information of the resource
Actual Receipt from SAP(ETA)	Past orders in SAP (customers, Inter Sites), in delivery date
Assignment percentage	In sourcing management, this number refers to the part of the volumes that are going to be sourced to another site	0-Sourcing management
Actual and projected inventory	End of month projected inventory validated during the S&OP exercise	2-DRP Results A2 SOP Planning - Inventory report





























		DATA GLOSSARY

BackOrders (ETD)	BackOrders is a quantity confirmed but not shipped in due time.	iv. 1st step : Forecast Consumption
Blocked stock SAP	Past periods = End of month blocked inventory from MB5B transaction Current to future periods ="Blocked" stock from MMBE transaction	A2 SOP Planning - Inventory Report

Distribution multiple
Distribution lead time
Demand still to be shipped	Demand still to be shipped calculate which quantity you still have to shipped.	ii. Netting at material level
Dependant Requirement	Requirements from the BOM / MRP calcul	2-DRP Results
Days of stock	This is the number of days remaining in stock. This datafield is equal to: End of month inventory / (Actuals Shipped + Actuals consumption). If the value is above 30 days of stock, Dynasys highlight the value in red.	2-DRP Results

External Purchase order SAP	Data coming from SAP: Purchase order created with reception planned after the current month

Fixed lot size SAP	The quantity of product produced in one lot/batch. Production plan will be calculated with a multiple off the fixed lot size.
Forecast from DP (ETD)	The forecast data is coming from DP and will be used for the calculation of Independant requirements with the netting.	ii. Netting at material level iii. Cancel Options iv. 1st step : Forecast Consumption v. 2nd step : Delta confirmed vs requested order book
Final Demand (ETD)	Final Demand is the maximum between the forecast and the Actual shipped+ OrderBook. (if you do not delete the forecast or the order)	ii. Netting at material level iii. Cancel Options iv. 1st step : Forecast Consumption v. 2nd step : Delta confirmed vs requested order book
Firm shipping Requirement (ETD)	Confirmed customer orders from departure site	2-DRP Results
Firm Receipt from SAP (ETA)	Current orders in SAP (customers, Inter Sites), in delivery date	2-DRP Results
Force proposed receipt requirement	User can force the proposed receipt plan in order to show to the receipt requirement my oders that are not calculated by DIP
Force shipping plan	User can force the shipping plan in order to show to the shipping plan my needs that are not calculated by DIP

Gross Requirement	Sum of Independant Requirement (shipping requirement) and dependant requirement	2-DRP Results

Initial inventory	Final quantity that will be taken into account in the planning calculations considering the adjustment	ii. DRP (Initial Inventory FROM SAP)
In transit stock from SAP	Stock in transit in SAP, between two sites, displayed in the received period (only current orders)	2-DRP Results

Main Shipping Site	This is a site from where you are receiving the materials	Master data (SKU level)
Minimum lot size

Order Book to be issued (Confirmed - ETD)

OrderBook come from SAP and take into consideration:

The deliveries & sales orders
Open orders (Orders requested or confirmed or blocked)
The goods issue date

ii. Netting at material level

Pending orders (ETD)
Procurement Type	Defines the type of procurement for a material. If it is a produced material, Procurement type must be "E- In house Production" If it is an external procurement, Procurement type must be "F - External Procurement
Pallet size SAP	Quantity of product fixed for a pallet. Lot size must be a multiple of the pallet size number
Proposed receipt plan (ETA)	Calculated production plan by Dynasys for arrivals (ETA)
Proposed production plan	Calculated production plan by Dynasys	2-DRP Results A2 SOP Planning - Unconstrained production
Proposed Receipt Requirement (ETA)	Calculated orders by Dynasys	2-DRP Results

QM batch SAP

QM batch matches with quality inspection from SAP.

You use the Quality Inspection component to determine whether your company's product consistently meets defined quality requirements.

You can find in SAP the data with "MMBE" at "Qual. inspection" colum

ii. DRP (Initial Inventory)

A0 Data Control Cockpit - Stock data (Current)

A2 SOP Planning - Inventory Report

Rounding value SAP
Receipt plan ( ETA)	Receipt Plan by All destination, in the receipt month	2-DRP Results
Restricted Stock SAP	"Restricted-use" stock from MMBE transaction	A2 SOP Planning - Inventory Report

SPK Code	SPK is stored in SAP MRP2. SPK = Special Procurement Key. Special procurement key is use to define the special type of procurement (procurement type more exactly) apart from the standard in-house or external procurement types
Supply Planner
Safety stock SAP
Safety stock as a coverage	Maximum value between safety stock override and safety stock coverage
Safety stock V3	The Safety Stock V3 is calculated by a mathematical model and is implemented in DIP: K = Normal distribution of the service level Sigma = to the future demand variability- It's important because Special Chem is using past demand variability D = Lead time This formula is depending on needs (forecast / orders / dependent requirements from BOMs) and settings (service level, replenishement duration)
Safety stock final	Final safety stock defined in "Stock setting" tab view "Safety stock detailed"	2-DRP Results
Service level
Shipping Requirement (ETD)	Quantities of products needed from departure site	2-DRP Results ii. DRP (Independent Requirement)
Shipping plan (ETD)	Quantities of finished products from departure site
Shortages	[Shipping Requirement as validated - Shipping Plan as validated (to Customers)]	2-DRP Results A2 SOP Planning - Shortage management

Total RLT SAP

The total RLT SAP (Replenishement lead time) is the time to produce / procure the product by a company.

Total Orders

Total Orders is the sum of all orders :

Actual Shipped
Orderbook
BackOrders

Unrestricted stock SAP

This data come from SAP, it give you the actual stock inventory define in SAP.

You can find in SAP the data with "MMBE" at "Unrestricted use" column.

A0 Data Control Cockpit - Stock data (Current)

A2 SOP Planning - Inventory Report

Valuation Class

The valuation class has the following functions:

Allows the stock values of materials of the same material type to be posted to different G/L accounts.
Allows the stock values of materials of different material types to be posted to the same G/L account.
Determines together with other factors the G/L accounts updated for a valuation-relevant transaction (such as a goods movement).

Actuals data (Production)

Vendor stock SAP

This is the stock we have with the seller.

You can find in SAP the data with "MMBE" at "Unrestricted use" column at the row "stock provided to vendor"

A0 Data Control Cockpit - Stock data (Current)

A2 SOP Planning - Inventory Report

BFC Activity 1

BFC BU (Plant)

BFC BU (Site)

BFC GBU (Plant)

BFC GBU (Site)

BFC Market (Plant)

BFC Market (Site)

Buyer (Plant)

Buyer (Site)

Calendar (Year/Month)

Catalog LT (SAP)

City (Plant)

City (Site)

Classification (Plant)

Classification (Site)

Commercial Product / Material Group

Country (Plant)

Country (Site)

CRM Prospect Code

Division

Flag prospect

GBR GBU Mat Group

GBR GBU Mat Sub-group

GBR Ship-to-KA (Plant)

GBR Ship-to-KA (Site)

GBR Ship-to-KA adjusted (Plant)

GBR Ship-to-KA adjusted (Site)

Geo Zone (Plant)

Geo Zone (Site)

Industrial Origin

Key RM (Plant)

Key RM (Site)

Last Updated on (Plant)

Last Updated on (Site)

Main Production Plant (Plant)

Main Production Plant (Site)

Main Shipping Plant (Plant)

Main Shipping Plant (Site)

Material

Material group

Material type

Measures

Mini zone (Plant)

Mini zone (Site)

MRP controller

Plant

Price Advisor

Price Advisor impact

Prod.hierarchy

Product Category (Plant)

Product Category (Site)

Reg Sales Manager

Region (Plant)

Region (Site)

Sales Region

SHS RLT

Site

SOP Planner (Plant)

SOP Planner (Site)

Source System

Standard cost from S

Stock Hold. Strategy

TRLT (SAP)

Type of site (Plant)

Type of site (Site)

Valuation Class (Plant)

Valuation Class (Site)

Work Center

Zone SOP (Plant)

Zone SOP (Site)

Actual Production

Actual shipped and final demand (ETD)

Actual shipped ETD

Actuals and projected inventory

Anticipated inventory

Available capacity

Available inventory (Budget)

Available inventory as validated

Backorders in ETD

Balance