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 DYN V2 (Core WorkBook)

Technical Name

Workbook : BW_WBK_SD_DYN_002

Query 1 : BW_QRY_MVSDSO01_0006

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

TabScreenshotComment
DisplayInsert screenshot
Rows/ColumnsInsert screenshot
Value DisplayInsert screenshot
PlanningInsert screenshot
ExtendedInsert screenshot

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

Axis not available for Dynasis. Default DYN

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. Default DYN

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


ObjectFilter ValueExplanation
Sales document type (C_DOCTYP2)<> KBCC / CC Consign.Sto.
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)= #
Sold-to (C_SOLDID)

<> 307728 / SISECAM BULGARIA EOOD

<> 253609 / SISECAM-BULGARIA LTD

<> 201943 / SOLVAY SISECAM HOLDING AG



Additional filters for tab : Excl. Intra GBU

ObjectFilter ValueExplanation

Sold-to party (C_SOLDID)

65SOLVAY MINERALES S.A.

4071INOVYN ESPANA S.L.

114885INOVYN FRANCE SAS

115958RHODIA OPERATIONS SAS

118254INOVYN FRANCE SAS

118261INOVYN FRANCE SAS

118593SOLVIN FRANCE S.A.S.

122770RHODIA OPERATIONS

161350RHODIA OPERATIONS

300011NIPPON SOLVAY K.K.

301433UNIPAR INDUPA DO BRASIL S.A.

315117SOLVAY ADVANCED POLYMERS, LLC

323138SOLVAY SPECIALITIES INDIA

325320SOLVAY SPECIALITIES INDIA

325540SOLVAY SPECIALTY POLYMERS USA, LLC

334498RHODIA SILICES DE VENEZUELA, C.A.

408397RHODIA ITALIA SPA

410424SOLVAY FLUOR ITALIA S.p.A.

419195SOLVAY SOLUTIONS ITALIA S.P.A.

419788SOLVAY SPECIALTY POLYMERS ITALY S.p

458127SOLVAY SOLUTIONS ITALIA S.P.A.

703581INOVYN MANUFACTURING BELGIUM SA

703751INOVYN MANUFACTURING BELGIUM SA

802844SOLVAY INTEROX LIMITED (DET)

1020395SOLVAY FLUOR GMBH

1024316INOVYN DEUTSCHLAND GMBH

1026480SOLVAY CHEMICALS GMBH

2020027SOLVAY & CPC BARIUM STRONTIUM

3006325RHODIA ARGENTINA SA

3008004SOLVAY DO BRASIL LTDA.

3300201RHODIA SILICES DE VENEZUELA C.A.

4501750SOLVAY PEROXYTHAI LIMITED


Additional filters for tab =>Excl. Intra Group

ObjectFilter ValueExplanation

Sold-to party (C_SOLDID)

65SOLVAY MINERALES S.A.

3931SOLVAY QUIMICA, S.L. (RAOS)

5024SOLVAY CHEMICALS INTERNATIONAL S.A.

5048SOLVAY CHEMICALS INTERNATIONAL S.A.

23914SOLVAY QUIMICA, S.L.

57762SOLVAY CHEMICALS INTERNATIONAL SA

57812SOLVAY CHEMICALS INTERNATIONAL SA

58107SOLVAY CHEMICALS INTERNATIONAL SA

118924RESOLEST

121437SOLVAY CHEMICALS INTERNATIONAL S.A.

251659DEVEN AD

251660PROVADSOL EAD

253684SOLVAY BULGARIA EAD

300011NIPPON SOLVAY K.K.

301433UNIPAR INDUPA DO BRASIL S.A.

305008SOLVAY CHEMICALS, INC.

307276SOLVAY BULGARIA EAD

307728SISECAM BULGARIA EOOD

315726SOLVAY SPECIALTY POLYMERS USA, LLC

318018SOLVAY CHEMICALS INTERNATIONAL S.A.

318021SOLVAY CHEMICALS INTERNATIONAL S.A.

318396SODA SANAYII A.S.

318671SOLVAY CHEMICALS, INC

319605SOLVAY VOSTOK LLC

319703SOLVAY QUIMICA Y MINERA SERVICIOS

319964SOLVAY CHEMICALS, INC.

325253SOLVAY CHEMICALS, INC.

325320SOLVAY SPECIALITIES INDIA

325485SOLVAY CHEMICALS, INC.

325624SOLVAY CHEMICALS, INC.

325631SOLVAY CHEMICALS, INC.

325635SOLVAY CHEMICALS, INC.

325637SOLVAY CHEMICALS, INC.

325640SOLVAY CHEMICALS, INC.

325659SOLVAY CHEMICALS, INC.

326197NIPPON SOLVAY K.K.

330656SOLVAY ALEXANDRIA SODIUM CARBONATE

332676SOLVAY ALEXANDRIA TRADING LLC

337715SOLVAY ALEXANDRIA TRADING LLC

400002SOLVAY CHIMICA ITALIA S.P.A.

408680SOLVAY CHIMICA ITALIA S.P.A.

409059BICARJET SRL

409330SOLVAY CHIMICA ITALIA S.P.A.

409491SILYSIAMONT SPA

411100SOLVAY CHIMICA ITALIA S.P.A.

411555SOLVAY CHIMICA ITALIA S.P.A.

420578INOVYN PRODUZIONE ITALIA S.p.A.

420938SOLVAY CHIMICA ITALIA S.p.A.

554534SOLVAY CHEMICALS INTERNATIONAL S.A.

700071SOLVAY CHEMICALS INTERNATIONAL SA

700072SOLVAY CHEMICALS INTERNATIONAL SA

700073SOLVAY CHEMICALS INTERNATIONAL SA

700074SOLVAY CHEMICALS INTERNATIONAL SA

700076SOLVAY CHEMICALS INTERNATIONAL SA

700077SOLVAY CHEMICALS INTERNATIONAL SA

700078SOLVAY CHEMICALS INTERNATIONAL SA

700080SOLVAY CHEMICALS INTERNATIONAL SA

700081SOLVAY CHEMICALS INTERNATIONAL SA

707552SOLVAY CHEMICALS INTERNATIONAL SA

804233SOLVAY CHEMICALS INTERNATIONAL S.A.

1023434SOLVAY CHEMICALS GmbH

2032071SOLVAY USA INC

2033986SOLVAY QUIMICA Y MINERA SERVICIOS

2106486SOLVAY CHEMICALS, INC.

2106497SOLVAY CHEMICALS, INC.

2107178AGC SODA CORPORATION

2107912SOLVAY CHEMICALS, INC

2108850SOLVAY CHEMICALS, INC.

2112698SOLVAY CHEMICALS, INC.

2117185SOLVAY CHEMICALS, INC.

2117454SOLVAY CHEMICALS, INC.

2500450SOLVAY & CPC BARIUM STRONTIUM

2501100SOLVAY MEXICANA S. DE R.L. DE C.V.

2501105SOLVAY MEXICANA S. DE R.L. DE C.V.

3008004SOLVAY DO BRASIL LTDA.

3031938UNIPAR INDUPA DO BRASIL S.A.

3034882RHODIA POLIAMIDA E ESPECIALIDADES

3034889TEGMA CARGAS ESPECIAIS LTDA

3040740SOLVAY CHEMICALS INTERNATIONAL S.A.

3040811SOLVAY CHEMICALS INTERNATIONAL S.A.

3041270RHODIA POLIAMIDA E ESPECIALIDADES S

3511808SOLVAY CHEMICALS INTERNATIONAL

4006499SOLVAY CHEMICALS (SHANGHAI) Co.,Ltd

4500070VINYTHAI PUBLIC COMPANY LIMITED

4501535SOLVAY PEROXYTHAI LIMITED

4501750SOLVAY PEROXYTHAI LIMITED

4502057SOLVAY PEROXYTHAI LIMITED


Key figures

DescriptiontypeRestricted or Calculated KeyFigureCalculation ruleConversion

Billed QTY
(PUQ)

Display

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)

  • F2SR / Invoice for Services
  • G2CC / Commission Credit
  • G2CS / Cancelat. G2CC
  • G2SS / Cancelat. G2VS
  • G2VS / Credit Mem Serv.
  • L2CC / Commission Debit
  • L2CS / Cancelat. L2CC
  • L2SS / Cancelat. L2VS
  • L2VS / Debit Memo Serv
  • ZL2A / Downpayment
  • ZL2S / Cancelat. ZL2A
  • IV / Intercompany Billing


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

No decimal place
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

No decimal place
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

(temporarely using ZINV_QTY in sales unit due to an issue on ZBILL_QTY. Global Sales team (Mathieu) will correct the flow and data in WBP)

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

and InfoProvider CRDYN12

and exclusion of Billing Type (C_BILLITM__C_BILLTYP)

  • F2SR / Invoice for Services
  • G2CC / Commission Credit
  • G2CS / Cancelat. G2CC
  • G2SS / Cancelat. G2VS
  • G2VS / Credit Mem Serv.
  • L2CC / Commission Debit
  • L2CS / Cancelat. L2CC
  • L2SS / Cancelat. L2VS
  • L2VS / Debit Memo Serv
  • ZL2A / Downpayment
  • ZL2S / Cancelat. ZL2A
  • IV / Intercompany Billing

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_0064

Billed Qty YTD till previous month

Ratio ZBILL_QTY

(temporarely using ZINV_QTY in sales unit due to an issue on ZBILL_QTY. Global Sales team (Mathieu) will correct the flow and data in WBP)

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

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

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource SystemCountry of the customer
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

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)

OperatorValueCharacteristic 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

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10