General presentation
Objective of the application
The objective of the application is to extract from Dynasys Forecast & Booking data and also Dynasys Master data (ShipTo, SpecID, Market...).
Then these data are used for the application BW - DPS - Forecast Vs Booking / Component.
Tool Leader: Lei Shen
IT leader of the application: Lei Shen (PP), Romain Clerc (Dynasys) Craig Wanamaker (BW)
Name of project: Solstice
PMO Project: 8612 Solstice AERO
Reporting Coordinator: Lei Shen
Usage information
Number of users: tbd
Critical period: none
Geographical perimeter: worldwide
InfoArea:
History
This application is linked to the Solstice global project and this specific need was named "DEV47- Other MiniBW request for planning team".
MiniBW (CPX) dedicated platform was created for Aero Requirements about Solstice project.
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/1Y2OmoBqD6VWwpmUPnuiQ6ZFm0hwlPruA
Dataflow overview :
DynaSys database
Dynasys is a MSSQL tool, the connection with CPX system is done with SAP Hana Smart Data Access.
Dynasys main servers :
Dynasys Development server => wdcslvbd31\slv1_dbdev
Dynasys Testing server => wdcslvbt31\slv1_dbtst
Dynasys Production server => wdcdyap21\dy_dbprd
DynaSys source view used
| DynaSys View | MasterData/Transactionnal | Content | Associated Datasource | Comments |
| EXP_MFB_V1_BW | Transactionnal | Forecast and Sold & Booking data (Quantity and Amount) by month | DTS_ZBW_V_EXP_MFB_V1_BW | Forecast data from current month to current + 17 months => 18 months of forecast data |
| EXP_MFB_V2_BW | MasterData | Specification, Market, Program Master Data | DTS_ZBW_V_EXP_MFB_V2_BW | |
| EXP_MFB_V3_BW | MasterData | ShipTo Master Data | DTS_ZBW_V_EXP_MFB_V3_BW | |
| EXP_MFB_V4_BW | MasterData | Forecast Customer Master Data | DTS_ZBW_V_EXP_MFB_V4_BW |
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Specification document
Sheet "Dim_Forecast&Booking" :
Quantity conversion
There are two fields with currency coming from Dynasys :
- Forecast quantity (FF_QTY)
- Sold & Booked quantity (SOB_QTY)
Both are extracted from Dynasys in KG and stored respectively in following key figures :
- Forecast quantity (K_FFQTY)
- Sold & Booked quantity (K_SOBQTY)
There are also converted in Base Unit of Measure linked to the material record in following key figures :
- Forecast quantity (K_FFQTYB)
- Sold & Booked quantity (K_SOBQTYB)
Determination of Base Unit of Measure (by reading C_MATNR Master Data) and conversion in Base unit of measure are done in the end routine of transformation between ADSO APDPDY01 and ABDPDY01.
See below the link to have more explanations on ABAP rules applied :
BW OTC - Supply Chain- DPS (WBP) /!\ Obsolete /!\#SupplyChain-DPS(WBP)-ConversioninKGunit
Dependencies with other applications
Dynasys data are used in application BW - DPS - Forecast Vs Booking / Component.
Data loadings
Info providers and objects loaded
Master Data
Master data are loaded by the process chain DICO_PC_DPS_MD :
Dynasys Master Data Process chain are part of global chain RSP_DAILY_GLOBAL :
Transactionnal Data
There are 3 process chain (one by Layer) to load transactionnal data :
- Acquisition Layer : PC_DPS_DYNASYS_03
- Propagation Layer : PC_DPS_DYNASYS_04
- Business Layer : PC_DPS_DYNASYS_05
These process chain are part of global chain RSP_DAILY
There is also a global process chain to load master data and transactionnal data : PC_DPS_DYNASYS_06
Loading frequency
Daily loading
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Record Keeping
Reporting
Queries End User Documentation
Main queries
There is a query BW_QRY_CPDPDY01_0001 (Dynasys - Dynasys Data Reporting) based on composite provider CPDPDY01 (Dynasys Virtual).
This query was used for testing data coming from Dynasys source system but it is not used and accessible by key users.
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution