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

Compare with Current View Page History

« Previous Version 5 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 - Budget Review (Core query)

Technical NameBW_QRY_MVDYN11_000X

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_GBR6_0001

GBR Customer Group (Select Option, Optional)

C_GBR13__C_GBR6SelectionOption/Optional/ManualEntryNo

Ship-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

V_C_PLANT_0010

Plant (Selection Option, Optional)

C_DYN_018__C_MPPLANTSelectionOption/Optional/ManualEntryNo 

V_C_PROSP_0001

SF Prospect ( 'X' only prospects, <> 'X' exclude prospects)

C_DYN_024__C_PROSPSelectionOption/Optional/ManualEntryNo 

V_C_ZONE_0005

BFC Geo/Zone (Selection option)

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

KeyFigures of the Demand Review + following ones

 

DescriptiontypeRestricted or Calculated KeyFigureSourceCalculation ruleConversionComments

Sales Team Forecast ETD

Display 

DynaSys

Table EXP_FORE_DR

field SALES_TEAM_FOREC

Ratio K_DYN_044QCT_MATNR5

 


Sales Team Price

Display 

DynaSys

Table EXP_FORE_DR

field SALES_TEAM_PRICE

Ratio K_FFEURCTK_ZRHO3Mvoir conversion CURR/UOM

Sales Team Forecast Value ETD

Display 

DynaSys

Table EXP_FORE_DR

field SALES_TEAM_FOREC => doublon à corriger

Ratio K_DYN_031

CTK_ZRHO3M 

Sales Team Contribution Margin ETD

Display 

DynaSys

Table EXP_FORE_DR

field SALES_TEAM_CONTR

Ratio K_DYN_045

CTK_ZRHO3M


Sales Team Gross Margin ETDDisplay 

DynaSys

Table EXP_FORE_DR

field SALES_TEAM_GROSS

Ratio K_DYN_033

CTK_ZRHO3M 
Final Forecast ETDDisplay 

DynaSys

Table EXP_FORE_DR

field FINAL_FORECAST

Ratio K_DYN_034

QCT_MATNR5 
Final Forecast Contribution MarginDisplay 

DynaSys

Table EXP_FORE_DR

field FINAL_FORECAST_C

Ratio K_DYN_046

CTK_ZRHO3M 
Final Forecast Gross MarginDisplay 

DynaSys

Table EXP_FORE_DR

field FINAL_FORECAST_G

Ratio K_DYN_047

CTK_ZRHO3M 
Budget Contribution MarginDisplay 

DynaSys

Table EXP_FORE_DR

field BUDGET_CONTRIBUT

Ratio K_DYN_048

CTK_ZRHO3M 
Budget Gross MarginDisplay 

DynaSys

Table EXP_FORE_DR

field BUDGET_GROSS_MAR

Ratio K_DYN_030

CTK_ZRHO3M 
BFR6 Contribution MarginDisplay 

DynaSys

Table EXP_FORE_DR

field BFR6_CONTRIBUTIO

Ratio K_DYN_032

CTK_ZRHO3M 
BFR6 Gross MarginDisplay 

DynaSys

Table EXP_FORE_DR

field BFR6_GROSS_MARGI

Ratio K_DYN_020

CTK_ZRHO3M 

 

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_SHIPTIDSAP Ship-to

Key + Text

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

Previous 30/10/2017, the description was 'Ship-to'

RowsC_DYN_024Ship-to (including Prospects)

Will be available soon

Available for DynaSys since 30/10/2017

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 (APO)

Key + Text

Since 30/11/2017, only for APO (new axis for Dyn). Old description 'Enterprise Customer Group'

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 City

Since 30/10/2017, for DynaSys info it 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) (APO)

RCS notion

Text in MD C_GRCUST

Available since 14/03/2017

Since 30/10/2017, For DynaSys/Logility, 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_GBR14__C_GBR1Application

Previous to 30/10/2017, field was C_GBR5__C_GBR1

FreeC_GBR14__C_GBR2MarketPrevious to 30/10/2017, field was C_GBR5__C_GBR2
FreeC_GBR14__C_GBR3SegmentPrevious to 30/10/2017, field was C_GBR5__C_GBR3
FreeC_GBR14__C_GBR4Corporate End UsePrevious to 30/10/2017, field was C_GBR5__C_GBR4
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 (hierarchy

Key and Text => Dyn Only

FreeC_GBUZONE__C_ZONEH2GBU zone (hier. 2)

Key and Text =>Dyn Only

Free0G_CWWE01IECRAAPO Only
FreeC_GBR18__C_GBR19GBU Material Group

Key and Text


The notion of GBU material group exists only for WP1.
Available since since 30/10/2017
FreeC_GBR13__C_GBR9GBR Customer Sub Group

Key and Text

Available since since 30/10/2017

FreeC_GBR13__C_GBR6GBR Customer Group

Key + Text

Available since since 30/10/2017, for Dyn/Log , it replaces 'Enterprise Customer Group'

Free C_GBR15__C_SHIPKAShip-to KA (GBR)

Key and Text

Available since since 30/10/2017

Free C_SHTCTRY__C_ZONEBFC Geographie/Zone

Key and Text

Available since since 30/10/2017

FreeC_DYN_024__C_PROSPFlag Prospect

Key and Text

Available since since 30/10/2017

 

'X' Prospect

 

' ' Ship-to

Free0INFOPROVInfoProvider

Key and Text

Available since 30/10/2017

FreeC_GBR18__C_GBR20GBU Material Sub-grp

Key and Text

Available since 28/11/2017

FreeC_MATNR2__C_LIP05Product line 05

Key and Text

Available since 28/11/2017

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