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

Compare with Current View Page History

« Previous Version 42 Next »

 

This Query is based on Dynasys data and Obas data.

This Query is part of the WorkBook Sales Follow-Up

Description

BW - Sales Follow-Up (Core WorkBook)

Technical Name

Workbook : BW_WBK_SD_DYN_001

Query 1 : BW_QRY_MVSDSO01_0001

BW - Sales Follow-Up ALL DYN (Core Query)

Query 2 : BW_QRY_MVSDSO01_0002

BW - Sales Follow-Up Excl. Intra GBU DYN (Core Query)

Query 3 : BW_QRY_MVSDSO01_0003

BW - Sales Follow-Up Excl. Intra Group DYN (Core Query)

Application

DYNASYS + OBAS

Info-provider

MVSDSO01

Usage type

Sales Follow-Up Workbook

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

GBU (Select Optional, Optional, Auth)

V_CPFCTR1_2_0006

CPFCTR1_2Selection Option/Optional/Variable ready for Input/Authorization  

Business area (Selection Option, Optional)

V_0BUS_AREA_0001

C_TECHBA__C_REST_BASelection Option/Optional/Variable ready for Input 

Axis not available for Dynasis (was available for APO)

 => 06/04/2017 Remove the prompt

Company code (Selection Opt, Authorization)

C_COMPCDE_04

C_COMPCDESelection Option/Optional/Variable ready for Input/Authorization Authorization
Sales Organization (selection option, optional) => ZSALESV2C_SAL_ORGSelection Option/Optional/Variable ready for Input 

Reuse of existing variable

Axis not available for Dynasis (was available for APO)

Sales office (Selection option, Auth) => VAR_C_SAL_OFF_002C_SAL_OFFSelection Option/Optional/Variable ready for Input/Authorization 

AUTHORIZATION !!

Axis not available for Dynasis (was available for APO)

Plant (Selection Opt, Optional)

C_PLANT02

C_PLANTSelection Option/Optional/Variable ready for Input  

Product Hierarchy (Selection option, optional)

VPROD_HIER

C_MATNR2__0PROD_HIERSelection Option/Optional/Variable ready for Input  

Sales group (selection, optional

VAR_C_SAL_GRP_001

C_SAL_GRPSelection Option/Optional/Variable ready for Input Available for SD+DYN (was not available for APO)
Sold-to (Several Single, Optional) => V_SOLDID_0003C_SOLDIDSeveral Single values/Optional/Variable ready for InputNoReuse of existing variable

Ship-to (Selection Option) => V_CUSTID_0002

C_SHIPTID

Selection Option/Optional/Variable ready for Input

No

Reuse of existing variable

Ship To Country (Selection, optional)

V_0COUNTRY_001

C_SHIPTID__0COUNTRYSelection Option/Optional/Variable ready for Input  

Intra-Group Flag (Selection Option)

V_C_FLGINT_0009

C_SOLDID__C_FLGINTSelection Option/Optional/Variable ready for Input  

Intra-GBU Flag (Selection option, Optional)

VAR_C_INGBUF2_001

C_INTGBU1__C_INGBUF2Selection Option/Optional/Variable ready for Input Axis not available for Dynasis (was available for APO)
Conversion Unit (Single, Required) => VBASE_UOM_050UNITSingle/Mandatory/Variable ready for InputYesReuse of existing variable. Necessary to quantity conversions

Variable Sequence

Filters

Common filters to 3 queries

ObjectFilter ValueExplanation
Sales document type (C_DOCTYP2)<> KE, R1, R4, R4IE, REA, RM, RTTC, RTTR, RZ, TDR, KR, KRZU, ZREB, ZREN, ZROB, KL, T1, RK, B1, CRV, DRV, DRVT, G2, L2 
InfoProvider (0INFOPROV)

= From SO - Deliveries and Invoices (CRDYN12)

= DYN - Reporting (CRDYN11)

Historical of Invoice + Deliveries

Current Forecast from Dynasys

PRS Comp Conso Meth

(C_COMPCDE__C_CSMETH)

<> 90 (Sold) 
Sales unit (0SALES_UNIT)
 
Reason for rejection (C_ITM_SD__C_REASREJ)= # 

 

Additional filters for the 3 tab

ObjectFilter ValueExplanation
Sales Document Type

DYN, KA, KB, KBCC, RE, SB, TD, ZORB, ZRAG, ZSAM

instead of APO => # for Dynasys => DYN for Dynasys (since 24/01/2017, default value DYN has been set for DynaSys records)

 

Sold-to

<> SISECAM

307728 (SISECAM BULGARIA EOOD),

253609 (SISECAM-BULGARIA LTD),

201943 (SOLVAY SISECAM HOLDING AG)

 

Additional filters for query => BW - Sales Follow-Up Excl. Intra GBU DYN (Core Query)

ObjectFilter ValueExplanation

Sold-to party

(C_SOLDID)

 

 

Additional filters for query => BW - Sales Follow-Up Excl. Intra Group DYN (Core Query)

ObjectFilter ValueExplanation

Sold-to party

(C_SOLDID)

Exclusion of AGC Soda Ash (2107178) asked by Medina, Krystle / Célia the 10/01/2017

 

 

 

 

Key figures

DescriptiontypeRestricted or Calculated KeyFigureCalculation ruleConversion

Billed QTY
(PUQ)

Display

BW_RKF_MVSDSO01_0050

Billed Qty  (Current year, w/o Current Month)

Ratio ZINV_QTY

Limited to Current Year (0CALYEAR/variable 0CYEAR)

and exclusion of Current Month (0CALMONTH/0CMONTH)

and InfoProvider CRDYN12

and exclusion of Billing Type (C_BILLITM__C_BILLTYP)

F2KB, IG, IV, IVS

 

 

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

M Delivered
(PUQ)		Display

BW_RKF_MVSDSO01_0051

Delivered Qty  (Current Month)

Ratio ZDLV_QTY
Limited to Current Month (0CALMONTH/variable 0CMONTH)

and InfoProvider CRDYN12

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

Nb of Working DaysUsed in rules

BW_CKF_MVSDSO01_0100

No of WD current Mth

Formula Variable VF_NBWDMONTH / No of WD current Mth

Replacement Path / C_PLANTWD__K_MWDAY

Aggregation Maximum on C_PLANT

 
Nb of Working Days until todayUsed in rules

BW_CKF_MVSDSO01_0101

No of WD until today

Formula Variable VF_NBWDTODAY / No of WD until today of Mth

Replacement Path / C_PLANTWD__K_MWDAY

Aggregation Maximum on C_PLANT

 
Nb of Working Days Current MonthUsed in rules

BW_RKF_MVSDSO01_0052

BW_CKF_MVSDSO01_0100

Limited to Current Month (0CALMONTH/variable 0CMONTH)

No decimal place
Nb of Working Days until today of MthUsed in rulesBW_RKF_MVSDSO01_0053

BW_CKF_MVSDSO01_0101

Limited to Current Month (0CALMONTH/variable 0CMONTH)

No decimal place
M Extrapol Delivered
(PUQ)		Display

BW_CKF_MVSDSO01_0102

M Extrapol Delivered

Caution : the total has to be the summation of line, otherwise, the calcul table into account nb of working days of whole displayed plant...

RKF_0051 * RKF_0052 / RKF_0053

 

no conversion
Final ForecastUsed in rules

BW_RKF_MVSDSO01_0055

Final Forecast (Converted)

Ratio K_FFQTY

Limited to InfoProvider CRDYN12

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

M Final Forecast
(PUQ)		Display

BW_RKF_MVSDSO01_0054

M Final Forecast

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH)

Inherited conversion

M Ordered
(PUQ)		Display

BW_RKF_MVSDSO01_0058

M Ordered

Ratio ZORD_QTY
Limited to Current Month (0CALMONTH/variable 0CMONTH)

and InfoProvider CRDYN12

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

M Delta Extrap - M FForec
(PUQ)		Display

BW_CKF_MVSDSO01_0103

M Extrapol Delivered - M Final Forecast

CKF_0102 - RKF_0054

 

no conversion
Y-1TD Billed QtyShadow 

Ratio ZBILL_QTY

Limited to Previous Year, Period 001 to current (0CALMONTH/variable 0CMLYTLM)

and InfoProvider CRDYN12

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

Y BudgetShadow

BW_RKF_MVSDSO01_0059

Y Budget

Ratio K_DYBUD
Limited to Current Year (0CALYEAR/variable 0CYEAR)

and InfoProvider CRDYN11

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

M+1 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +1)

Inherited conversion
M+2 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +2)

Inherited conversion
M+3 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +3)

Inherited conversion
M+4 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +4)

Inherited conversion
M+5 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +5)

Inherited conversion
M+6 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +6)

Inherited conversion
M+7 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +7)

Inherited conversion
M+8 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +8)

Inherited conversion
M+9 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +9)

Inherited conversion
M+10 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +10)

Inherited conversion
M+11 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset +11)

Inherited conversion
M-1 Final ForecastShadow 

RKF_0055

Limited to Current Month (0CALMONTH/0CMONTH, Offset -1)

Inherited conversion
M Extrap vs FF (%)Shadow

BW_CKF_MVSDSO01_0104

M Extrap vs FF (%)

CKF_0102 %A RKF_0055

M Extrapol Delivered

Final Forecast (all available FF)


no conversion
Y Customer ForecastShadow

BW_RKF_MVSDSO01_0060

Y Customer Forecast

Ratio Customer Forecast (K_DYCUSTF)

 

Limited to Current Year (0CALYEAR/variable 0CYEAR)

 

and InfoProvider CRDYN11


Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

Y ExtrapolShadow 

RKF_0057 * 12 / (VF_MONTH - 1)

For January, the result must be a division by zero. Same formula in PQ1 version.

Inherited conversion
YTDShadow

BW_RKF_MVSDSO01_0057

Billed Qty YTD till previous month

Ratio ZBILL_QTY

Limited to current year, up to pervious month (0CALMONTH / variable 0CYTLM)

and cube CRDYN12

Displayed in Kunit, scaling factor 1000

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

M Customer ForecastShadow

BW_RKF_MVSDSO01_0061

M Customer Forecast

Ratio Customer Forecast (K_DYCUSTF)

Limited to Current Month (0CALMONTH/variable 0CMONTH)

 

and InfoProvider CRDYN11

Conversion type : QCT_MATNR4 / Qty Conversion Unit (based on C_MATNR2)

Target Currency : variable VBASE_UOM_05 / Conversion Unit (Single, Required)

No of Cur MonthShadow

BW_CKF_MVSDSO01_0105

No of Cur Month

Formula Variable VF_NBMONTH (Current Month)

no conversion

no decimal place

     

Key Figure 1

Description

Calculation rule detail

Text Replacement Variable

Currency Conversion

Exchange Rate Type : 

Currency : 

Time Reference : 

Unit Conversion

Unit : 

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource System
RowC_SHIPTID__0COUNTRYShip-to countryKey & Text
Column0CALMONTHCalendar Year/MonthText
FreeC_TECHBA__C_REST_BARestated Business ArText
FreeC_DYN_011Tactical Material

Text

A revoir?????

C_DYN_011 was available for APO

For Dynasys C_DYN_005__C_TACTIC2?

FreeC_MAT_GRPMaterial group

K+T

Not made available for DynaSys, because was not in place for APO

FreeC_MATNR2MaterialK+T
FreeC_MATNR2__C_MATGR2MaterialGroup 2K+T
FreeC_COMPCDECompany codeK+T
FreeC_SAL_ORGSales OrganizationK+T
FreeC_SAL_OFFSales OfficeK+T
FreeC_CUSTSAL__C_SALEMPSales emplyee

Key

Axis not available for DynaSys

FreeC_SAL_GRPSales groupK+T
FreeC_SOLDID__0CUST_CLASSCustomer Classific.

K+T

Nav Attribut for DynaSys (was direct mapping for APO)

FreeC_SHIPTID__C_GZONEGeographie/Zone

Text

=> voir si ok car pour le reporting Dyn c'est l'attribut du Country qui a été pris

FreeC_PLANTPlantK+T
FreeC_MATNR2__C_MATGR1MaterialGroup 1K+T
FreeC_SOLDID__0COUNTRYCountry keyK+T
FreeC_APOLOCLocation

K => provient d'APO

Exemples : 50SC, 51KC, 51MC, 51WC, 52BC, 52EC, 52JC, 52KC, 52MC

 

FreeC_DOCTYP2Sales document type

K+T

Axis not available for DynaSys

FreeC_CUSTSALCustomer

Text

Axis not available for DynaSys

FreeC_TECHBA__CPFCTR1_2BFC Global Business Unit

Text

Axis not available for DynaSys

FreeC_SOLDID__C_FLGINTFlag IntercompanyText
FreeC_INTGBU1__C_INGBUF2Intra-GBU FlagText
FreeC_INTGBU1Technical PBA (Intra flag)

Key

Axis not available for DynaSys

FreeC_TECHBATechnical Business A

Key

Axis not available for DynaSys

Free0INFOPROVInfoProviderText
FreeC_GBUZONEGBU Spec. zone (ship-to)Key
FreeCPFCTR1_2BFC Global Business UnitText
FreeC_SOLDIDSold-to partyText
FreeC_MATNR2__0PROD_HIERProd.hierarchyK+T
FreeC_SHIPTIDShip-to partyText
FreeC_SOLDID__C_GRCUSTCustomer GroupText
FreeC_GBUZONE__C_ZONEH1GBU Ship-to zone 1Text
FreeC_GBUZONE__C_ZONEH2GBU Ship-to zone 2Text

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