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

Compare with Current View Page History

« Previous Version 27 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 :

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  

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

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

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

 

 

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

RKF_0051 * RKF_0052 / RKF_0053no 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_0054no 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
     

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

FreeC_MAT_GRPMaterial groupK+T
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 emplyeeKey
FreeC_SAL_GRPSales groupK+T
FreeC_SOLDID__0CUST_CLASSCustomer Classific.K+T
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 typeK+T
FreeC_CUSTSALCustomerText
FreeC_TECHBA__CPFCTR1_2BFC Global Business UnitText
FreeC_SOLDID__C_FLGINTFlag IntercompanyText
FreeC_INTGBU1__C_INGBUF2Intra-GBU FlagText
FreeC_INTGBU1Technical PBA (Intra flag)Key
FreeC_TECHBATechnical Business AKey
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