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

Compare with Current View Page History

« Previous Version 44 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 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


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

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

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