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

Compare with Current View Page History

« Previous Version 21 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_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/ManualEntryNoShip-to info

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

Variable Sequence

Filters

ObjectFilter ValueExplanation
InfoProvider (0INFOPROV)= DYN Reporting (CRDYN11) 
Concerned Period (C_FLGMTH)= 'M'Only current values are requiered

 

Key figures

All keyfigures without decimals as in Dynasys

DescriptiontypeRestricted or Calculated KeyFigureCalculation ruleConversion

GH Quantity

Display Ratio K_GHQTYQCT_MATNR5
FF QuantityDisplay Ratio K_FFQTYQCT_MATNR5
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
BFR06Display Ratio K_DYBFR6QCT_MATNR5
BFR09Display Ratio K_DYBFR9QCT_MATNR5
BudgetDisplay Ratio K_BUDGETQCT_MATNR5

 

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_SHIPTOShip-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 GroupKey + Text
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_MATGR2Material Group 2 
FreeC_MATNR2__C_DIVISNDivision 
FreeC_DYN_010BU 
FreeC_DYN_018__C_MSHCONDMain Shipping Cond.Development in progress
FreeC_DYN_018__C_INCOTRMIncotermsDevelopment in progress
    
    

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