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 ALL DYN (Core query) |
|---|---|
| Technical Name | BW_QRY_MVSDSO01_0001 |
Application | DYNASYS + OBAS |
Info-provider | MVSDSO01 |
Usage type | Sales Follow-Up Workbook |
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
| Tab | Screenshot | Comment |
|---|---|---|
| Display | Insert screenshot | |
| Rows/Columns | Insert screenshot | |
| Value Display | Insert screenshot | |
| Planning | Insert screenshot | |
| Extended | Insert screenshot |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
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__0COUNTRY | Selection Option/Optional/Variable ready for Input | No | Reuse of existing variable |
| Conversion Unit (Single, Required) => VBASE_UOM_05 | 0UNIT | Single/Mandatory/Variable ready for Input | Yes | Reuse of existing variable. Necessary to quantity conversions |
| Sold-to (Several Single, Optional) => V_SOLDID_0003 | C_SOLDID | Several Single values/Optional/Variable ready for Input | No | Reuse of existing variable |
| Company code (Selection Opt, Authorization) => C_COMPCDE_04 | C_COMPCDE | Selection Option/Optional/Variable ready for Input | No | Reuse of existing variable Axis not available for Dynasis |
| Sales Organization (selection option, optional) => ZSALESV2 | C_SAL_ORG | Selection Option/Optional/Variable ready for Input | Reuse of existing variable Axis not available for Dynasis | |
| Sales office (Selectioin option, Auth) => VAR_C_SAL_OFF_002 | C_SAL_OFF | |||
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| 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 |
Add screenshot if relevant
Key figures
| Description | type | Restricted or Calculated KeyFigure | Calculation rule | Conversion |
|---|---|---|---|---|
Billed QTY | 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 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 Days | Used 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 today | Used 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 Month | Used in rules | BW_RKF_MVSDSO01_0052 | BW_CKF_MVSDSO01_0100 Limited to Current Month (0CALMONTH/variable 0CMONTH) | |
| Nb of Working Days until today of Mth | Used in rules | BW_RKF_MVSDSO01_0053 | BW_CKF_MVSDSO01_0101 Limited to Current Month (0CALMONTH/variable 0CMONTH) | |
| M Extrapol Delivered (PUQ) | Display | BW_CKF_MVSDSO01_0102 M Extrapol Delivered | RKF_0051 * RKF_0052 / RKF_0053 | no conversion |
| Final Forecast | Used 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 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 Qty | Shadow | 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 Budget | Shadow | BW_RKF_MVSDSO01_0059 Y Budget | Ratio K_DYBUD 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 Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +1) | Inherited conversion | |
| M+2 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +2) | Inherited conversion | |
| M+3 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +3) | Inherited conversion | |
| M+4 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +4) | Inherited conversion | |
| M+5 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +5) | Inherited conversion | |
| M+6 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +6) | Inherited conversion | |
| M+7 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +7) | Inherited conversion | |
| M+8 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +8) | Inherited conversion | |
| M+9 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +9) | Inherited conversion | |
| M+10 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +10) | Inherited conversion | |
| M+11 Final Forecast | Shadow | RKF_0055 Limited to Current Month (0CALMONTH/0CMONTH, Offset +11) | Inherited conversion | |
| M-1 Final Forecast | Shadow | 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 Forecast | Shadow | 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 Extrapol | Shadow | RKF_0057 * 12 / (VF_MONTH - 1) For January, the result must be a division by zero. Same formula in PQ1 version. | Inherited conversion | |
| YTD | Shadow | 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 Forecast | Shadow | 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 Month | Shadow | BW_CKF_MVSDSO01_0105 No of Cur Month | Formula Variable VF_NBMONTH (Current Month) | no conversion |
| Nb of Working Days Current Month | Shadow | BW_RKF_MVSDSO01_0052 | CKF_0100 Limited to Current Month (0CALMONTH/variable 0CMONTH) | Number of decimal place 0 |
| Nb of Working Days until today of Mth | Shadow | BW_RKF_MVSDSO01_0053 | CKF_0101 Limited to Current Month (0CALMONTH/variable 0CMONTH) | Number of decimal place 0 |
Key Figure 1
Description
Text/name of the variable and explanation
Calculation rule detail
Quantity x Price
Text Replacement Variable
If relevant, add the text replacement rule used for the key figure
Currency Conversion
Exchange Rate Type : Ex ZRH0
Currency : Variable, or fixed currency used
Time Reference : Current date / Based on infoobject X / Variable
Unit Conversion
Unit : Variable or fixed unit
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Free/Row/Column | 0COUNTRY | Country | Country of the customer |
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) | Operator | Value | Characteristic 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 | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Ex : Red if <=10 | Yes/No | Bad 3 | Lesser Than | 10 | |