You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 58 Next »

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


Workbook/Query General Description

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_0CURRENCY_0006

Currency

    

VBASE_UOM_05

Conversion Unit (Single, Required)

 SingleYes 

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/ManualEntryNo

Previously it was C_SHIPTO but description were not daily updated.

No filter possible on SF Prospects


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__GBR6)

V_C_GBR6_0001 / GBR Customer Group (Select Option, Optional)

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_ZRHO3M

Available since August 2017

Dynasys only

FF QuantityDisplay Ratio K_FFQTYQCT_MATNR5 
FF valueDisplay Ratio K_FFEURCTK_ZRHO3M

Available since August 2017

Dynasys 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_ZRHO3M

Available since August 2017

Dynasys only

BFR06Display Ratio K_DYBFR6QCT_MATNR5 
BFR06 valueDisplay Ratio K_BFR6EURCTK_ZRHO3M

Available since August 2017

Dynasys only

BFR09Display Ratio K_DYBFR9QCT_MATNR5 
BFR09 valueDisplay Ratio K_BFR9EURCTK_ZRHO3M

Available since August 2017

Dynasys only

BudgetDisplay Ratio K_DYBUDQCT_MATNR5 
Budget ValueDisplay Ratio K_BUDEURCTK_ZRHO3M

Available since August 2017

Dynasys only

Upside Forecast

Display Ratio K_UPSIDEQCT_MATNR5

Available since 14/03/2017

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 

Available since August 2017

Dynasys only

Sales Price ValueHidden Ratio K_SALPEKGCTK_ZRHO3M

Available since August 2017

Dynasys only

Qty - 1 KgHidden RAtio K_QTY1KGQCT_MATNR5

Available since August 2017

Dynasys 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.

Description Ship-to will change to SAP Ship-to soon

RowsC_DYN_024Ship-to (including Prospects)

Will be available soon

Only available for DynaSys

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 remain only for APO (new axis for Dyn)

FreeC_SHTCTRYShip-to CountryText
FreeC_SOLDIDSold-to

Key + Text

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

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_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 CityFor DynaSys info will comes from C_DYN_024 to get city for both SAP Ship-to and Sales Force Prospects
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

For DynaSys/Logility, now use Ship-to KA (GBR) (C_GBR15__C_SHIPKA)

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

FreeC_DYN_019__C_DYN_020Planning ZoneDYN Only
FreeC_GBR5__C_GBR1ApplicationWill be replace by GBR: Application (C_GBR14__C_GBR1) soon
FreeC_GBR5__C_GBR2MarketWill be replace by GBR: Market (C_GBR14__C_GBR2) soon
FreeC_GBR5__C_GBR3SegmentWill be replace by GBR: Segment (C_GBR14__C_GBR3) soon
FreeC_GBR5__C_GBR4Corporate End UseWill be replace by GBR: Corporate end use (C_GBR14__C_GBR4) 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 (hierarchyKey and Text => Dyn Only
FreeC_GBUZONE__C_ZONEH2GBU zone (hier. 2)Key and Text =>Dyn Only
Free0G_CWWE01IECRAAPO Only
FreeC_GBR18__C_GBR19GBR Material GroupKey and Text => will be available soon
FreeC_GBR13__C_GBR9GBR Customer Sub GroupKey and Text => will be available soon
FreeC_GBR13__C_GBR6GBR Customer Group

Key + Text

Will replace Enterprise Customer Group for Dyn

Free C_GBR15__C_SHIPKAShip-to KA (GBR)Key and Text => will be available soon
Free C_SHTCTRY__C_ZONEBFC Geographie/ZoneKey and Text => will be available soon

Cells

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
      

Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No 
      
  • No labels