The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description

BW - DP - Demand Review (Core query)

Technical NameBW_QRY_MVDYN11_0006

Application

DP - Demand Planning

Info-provider

MultiProvider MVDYN11

Usage type

Direct execution via Analysis

Expected users

Ex: GBU zone and WW controllers

Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

TabScreenshotComment
Display
 
Rows/Columns
 
Value Display
 
Planning
 
Extended
 

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

CALMONT2

Calendar Month/Year (Interval, Mandatory)

0CALMONTHInterval/Mandatory/ManualEntryYes 

V_CPFCTR1_2_0008

Global Business Unit (Selection Option, Optional, Auth)

CPFCTR1_2SelectionOption/Optional/Authorization/ManualEntryNo 

V_C_MATNR2_0001

Material (Selection option)

C_MATNR2SelectionOption/Optional/ManualEntryNo 

CPROD01

Commercial Product (Select option, Optional)

C_MATNR2__C_PRODSelectionOption/Optional/ManualEntryNo 

VPROD_HIER

Product Hierarchy (Selection option, optional)

C_MATNR2__0PROD_HIERSelectionOption/Optional/ManualEntryNo 

V_CUSTID_0002

Ship-to (Selection option)

C_SHIPIDSelectionOption/Optional/ManualEntryNoPreviously it was C_SHIPTO but description were not daily updated.

V_0DISTR_CHAN_0001

Distribution Channel (Selection option, Optional)

0DISTR_CHANSelectionOption/Optional/ManualEntryNo 

V_C_CUSTGP2_0001

Enterprise Customer Group (Section option, Optional)

C_CUSTGP2SelectionOption/Optional/ManualEntryNo

Ship-to info

Will be replaced by GBR Customer Group (C_GBR13)

V_0COUNTRY_0003

Ship-to Country (Selection option, Optional)

C_SHTCTRY

SelectionOption/Optional/ManualEntry

No

 

 

V_C_GRCUST_0001

Industrial Group (Selection option, Optional)

C_SOLDID__C_GRCUSTSelectionOption/Optional/ManualEntryNo

Sold-to info

V1 => Ship-to info (C_CUSTOMR__C_GRCUST)

V_C_SAL_GRP

Sales Group (Selection option, Optional)

C_DYN_017__C_SAL_GRP

SelectionOption/Optional/ManualEntryNoSales Group = Sales Rep = only for RCS

V_C_GZONE

Geo Zone (Selection option, Optional)

C_SHTCTRY__C_GZONESelectionOption/Optional/ManualEntryNoFrom Ship-to Country

V_C_PLANT_0010

Plant (Selection Option, Optional)

C_DYN_018__C_MPPLANTSelectionOption/Optional/ManualEntryNo 

Variable Sequence

Filters

ObjectFilter ValueExplanation
InfoProvider (0INFOPROV)

= DYN Reporting (CRDYN11)

+ APO


 
Concerned Period (C_FLGMTH)= 'M'Only current values are requiered

 

Key figures

All keyfigures without decimals as in Dynasys

DescriptiontypeRestricted or Calculated KeyFigureCalculation ruleConversionComments

GH Quantity

Display Ratio K_GHQTYQCT_MATNR5 
GH valueDisplay Ratio K_GHEURCTK_ZRHO3MDynasys only
FF QuantityDisplay Ratio K_FFQTYQCT_MATNR5 
FF valueDisplay Ratio K_FFEURCTK_ZRHO3MDynasys only
Demand Review ForecastDisplay Ratio K_DREVTQCT_MATNR5 
Statistical ForecastDisplay Ratio K_DYSTATFQCT_MATNR5 
Customer ForecastDisplay Ratio K_DYCUSTFQCT_MATNR5 
CSR ForecastDisplay Ratio K_DYCSRFQCT_MATNR5 
Demand Order BookDisplay Ratio K_DOBQTYQCT_MATNR5 
Sales Team ForecastDisplay Ratio K_DYSTFQCT_MATNR5 
BFR03Display Ratio K_DYBFR3QCT_MATNR5 
BFR03 valueDisplay Ratio K_BFR3EURCTK_ZRHO3MDynasys only
BFR06Display Ratio K_DYBFR6QCT_MATNR5 
BFR06 valueDisplay Ratio K_BFR6EURCTK_ZRHO3MDynasys only
BFR09Display Ratio K_DYBFR9QCT_MATNR5 
BFR09 valueDisplay Ratio K_BFR9EURCTK_ZRHO3MDynasys only
BudgetDisplay Ratio K_DYBUDQCT_MATNR5 

Upside (+ DELTA)

Display Ratio K_UPSIDEQCT_MATNR5

Available since 14/03/2017

New name with Solstice (previous Upside Forecast)

Downside (- DELTA)Display Ratio K_DOWNSIDQCT_MATNR5Solstice Only
Forecast AmountDisplay Ratio K_FCSTAMTCONVERSIONSolstice Only
Estimated Actuals (Qty)Display Calcul : GH quantity + FF quantity
Caution GH quantity has to be only for past, FF only for Future)		QCT_MATNR5Solstice Only
Estimated Actuals (Amount)Display Calcul : GH quantity + FF quantity
Caution GH amount has to be only for past, FF only for Future)		 

Solstice Only

Amount part not available yet

Constrained ForecastDisplay Ratio K_CONFORQCT_MATNR5

APO only

Will be available for DynaSys soon

Sales PriceDisplay Formula: Sales Price Value / Qty - 1 Kg Dynasys only
Sales Price ValueHidden Ratio K_SALPEKGCTK_ZRHO3MDynasys only
Qty - 1 KgHidden RAtio K_QTY1KGQCT_MATNR5Dynasys only

 

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0CALMONTHCalendar Year/MonthText
Rows0LOGSYSSource SystemNo display to avoid the display of the prefix for compound characteristics.
RowsC_MATNR2Material

Key + Text

RowsC_SHIPTIDShip-to

Key + Text

Previously, the Ship-to was C_SHIPTO, but description were not daily loaded.

Rows0DISTR_CHANDistribution Channel

Key + Text

Available for RCS only. For SOLVAY it corresponds to the 2 first characters of the BU.

FreeCPFCTR1_2BFC Global Business Unit

Key + Text

From DSO DBDYN02 to get the BU (C_DYN_010), then MasterData C_DYN_010 to get the GBU

FreeC_MATNR2__0PROD_HIERProd. HierarchyKey + Text
FreeC_MATNR2__C_PRODCommercial Product

Key + Text

Commercial Product is only available for RCS WP1. Do not exists for SOLVAY PF1.

FreeC_CUSTGP2Enterprise Customer Group

Key + Text

Will be replaced by GBR Customer Group (C_GBR13__C_GBR6)

FreeC_SHTCTRYShip-to CountryText
FreeC_SOLDID__C_GRCUSTIndustrial Group

Text

V1 = C_CUSTOMR__C_GRCUST

For V2 it has been changed for C_CUSTID. The field KONZS is taken from PRS Customer. PRS seems not contains all customers (only payer?). If Customer Group (C_GRCUST) are missing, the masterdata will have to be upgraded to get missing ones.

FreeC_SOLDIDSold-to

Key + Text

Previously, the Sold-to was C_SOLDTO, but description were not daily loaded.

FreeC_DYN_017__C_SAL_GRPSales GroupSales Group = Sales Rep = Only for RCS
FreeC_SHTCTRY__C_GZONEGeo ZoneNo description available
FreeC_DYN_005__C_TACTIC2Tactical MaterialDescription are available since 08/12/2016
FreeC_DYN_017__C_ZIPARTCSO

Customer Service Officer (CSO)

Only filled for RCS

FreeC_CUSTOMR__0REGIONShip-to Region 
FreeC_CUSTOMR__0CITYShip-to City 
FreeC_DYN_018__C_MPPLANTMain Shipping Plant 
FreeC_MATNR2__C_MAT_GRPMaterial Group 
FreeC_MATNR2__C_MATGR2Packaging Type

Previous name : Material Group 2 (Release March 2017)

For Solvay PF1 only

FreeC_MATNR2__C_DIVISNDivision 
FreeC_DYN_010BU 
FreeC_DYN_018__C_MSHCONDMain Shipping Cond.

Available since 07/02/2017

Shipping Condition of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)

FreeC_DYN_018__C_INCOTRMIncoterms

Available since 07/02/2017

Incoterms of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)

FreeC_DYN_018__C_DYN_016

Key Account

(Ship-to KA)

RCS notion

Text in MD C_GRCUST

Available since 14/03/2017

FreeC_MATNR2__C_MAGRVPackaging Materials

Only for RCS

Available since 14/03/2017

FreeC_DYN_018__C_VEPARTAccount Manager

PF1 notion

Release April 2017

FreeC_DYN_018__C_VWPARTCCS Rep

PF1 notion

Release April 2017

Free0G_CWWE01Sub-activityAPO only
FreeC_DYN_019__C_DYN_020Planning ZoneDYN Only
FreeC_GBR5__C_GBR1ApplicationWill be replace by C_GBR14__C_GBR1 soon
FreeC_GBR5__C_GBR4Corporate End UseWill be replace by C_GBR14__C_GBR4 soon
FreeC_GBR5__C_GBR2MarketWill be replace by C_GBR14__C_GBR2 soon
FreeC_GBR5__C_GBR3SegmentWill be replace by C_GBR14__C_GBR3 soon
FreeC_DYN_021__C_DYN_022ABC Class (auto)DYN Only
FreeC_DYN_021__C_DYN_023ABC Class (manual)DYN Only
FreeC_MATNR2__C_LPRODLIP00Since Solstice
FreeC_MATNR2__C_LIP04LIP04Since Solstice
FreeC_MATNR2__C_FMPRDProduct Group (family)Since Solstice
FreeC_PGMI__C_GRPPGMIItem ClassSince Solstice
FreeC_GBUZONE__C_ZONEH1GBU zone (hierarchyDyn Only
FreeC_GBUZONE__C_ZONEH2GBU zone (hier. 2)Dyn Only
FreeC_GBR18GBR Material GroupKey and Text => will be available soon
FreeC_GBR13__C_GBR9GBR Customer Sub GroupKey and Text => will be available soon

Cells

If you have 2 structures and special cells calculations, explain here.

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
Ex : Excl if <=10 Yes/No Sales Value Greater Than 10 Ex : All Independently
      

Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10