2.1 Flat file interface design
In the graph below is highlighted the main steps of the data flow going through BW.
1. Data acquisition from the 2 ECC systems and from the GBR for some sales master data, is done mainly through Core BW structures, which are shared widely with other applications: sales orders, deliveries, material master, customer master,...
2. The data extracted for the DynaSys interface is then loaded in a 1st level of DSOs, filtered by functional rules: only sales order types reliable for forecasting, horizon limitation to last 3 years, orders not rejected,...
3. Then the data is filtered through a 2nd level of DSOs depending on the perimeter definition: BUs, plants,...
4.Finally, the flat files are created using the APD function of BW.
DyS - BW => DynaSys flat file interface
Archives :
Files sent to DynaSys datahub are archived in SAP WBP. We can see them in AL11 transaction, folder /exploit/BW/archive/DYNASYS/.
2.2 Detailed BW flow
In the document below is detailed the BW flow:
- tab Dataflow: are indicated all the BW data structures (DSOs, cubes, Master Data) of the flow from the flat files back to the data source of BW.
- tab Filter: all filters between each data structure are defined in details.
- tab Variables: some filters use some variables so that they can easily be reused for several filters. Content of these variables is maintained in characteristic C_GLBFILT.
DYN - Dataflow
2.3 Specifications of each file
In the spreadsheet below are listed all the files of the interface.
Detailed definition of the files are spread in 3 spreadsheets: Master Data, DP Dynamic Data, DiP-PP Dynamic Data.
File | Description | Target system | Type |
BW_DYN_COMPLETE | Flag "End of dyn data" | Flag | |
BW_MASTER_COMPLETE | Flag "End of master data" | Flag | |
DYS_BW_AM.csv | Account Manager description (partner VE) | DP | Master data |
DYS_BW_ARC.csv | Sourcing data (assignment %, lead time,...) | DiP | Dyn data DiP-PP |
DYS_BW_AS_DELDAT.csv | Actual Shipments at Delivery date (ETA) | DiP-PP | Dyn data DiP-PP |
DYS_BW_AS_GI.csv | Actual Shipments at Goods Issue date (ETD) | DiP-PP | Dyn data DiP-PP |
DYS_BW_CCSR.csv | CSR description (partner VW) | DP | Master data |
DYS_BW_CSO.csv | CSO description (partner ZI) | DP | Master data |
DYS_BW_CURR.csv | Currency exchange rates history | DP+DiP | Master data |
DYS_BW_DC.csv | Distribution Channels description | DP | Master data |
DYS_BW_DFU.csv | Material+Shipto+DC combinations | DP | Master data |
DYS_BW_DH_DELDAT.csv | Demand History at Delivery Date (ETA) | DP | Dyn data DP |
DYS_BW_DH_GI.csv | Demand History at Goods Issue date (ETD) | DP | Dyn data DP |
DYS_BW_DSITE.csv | Plant site data | DiP | Master data |
DYS_BW_ECG_TXT.csv | Coreporate Customer group description (shipto KA) | DP+DiPP | Master data |
DYS_BW_ECG2.csv | Enterprise Customer group description | DP+DiPP | Master data |
DYS_BW_EMAT.csv | Determination of Enterprise Material Group | DP+DiPP | Master data |
DYS_BW_ENDUSE.csv | End Use hierarchy | DP | Master data |
DYS_BW_EPO.csv | External purchase order (MD04) | DP+DiPP | Dyn data DiP-PP |
DYS_BW_FD_DELDAT.csv | Demand Order Book at Delivery date (ETA) | DP | Dyn data DP |
DYS_BW_FD_GI.csv | Demand Order Book at Goods Issue date (ETD) | DP | Dyn data DP |
DYS_BW_FPO.csv | Firmed planned orders (MD04) | DP+DiPP | Dyn data DiP-PP |
DYS_BW_FS_RECEIPT.csv | Firm shipment in receipt date (MD04) | DP+DiPP | Dyn data DiP-PP |
DYS_BW_FS_SHIPPING.csv | Firm shipment in shipping date (MD04) | DP+DiPP | Dyn data DiP-PP |
DYS_BW_ITI_RECEIPT.csv | In transit inventory in receipt date | DP+DiPP | Dyn data DiP-PP |
DYS_BW_M3_PARTNER_DATA.csv | SD partner from M3 orders (PF1 only) | DP | Master data |
DYS_BW_M3_SD_DATA.csv | Default data in M3 orders (PF1 only) | DP | Master data |
DYS_BW_MATERIAL.csv | Material data | DP+DiPP | Master data |
DYS_BW_MATGRP_DESC.csv | Material Group description | DP+DiPP | Master data |
DYS_BW_MATSH.csv | Sales price | DP | Master data |
DYS_BW_MRPGroup.csv | MRP group | DiP | Master data |
DYS_BW_PO.csv | Process orders (MD04) | DP+DiPP | Dyn data DiP-PP |
DYS_BW_PRCOMSHIPTO.csv | Determination of Shipto KA | DP | Master data |
DYS_BW_PRICE_HIST.csv | Sales price history | DP | Dyn data DP |
DYS_BW_PROD_HIST.csv | Production history | DP+DiPP | Dyn data DiP-PP |
DYS_BW_PRODFAM.csv | Product Family description | DP+DiPP | Master data |
DYS_BW_QM.csv | QM inspection lots (MD04) | DP+DiPP | Dyn data DiP-PP |
DYS_BW_SH_DELDAT.csv | Shipped History at Delivery date (ETA) | DP | Dyn data DP |
DYS_BW_SH_GI.csv | Shipped History at Goods Issue date (ETD) | DP | Dyn data DP |
DYS_BW_SHIPTO.csv | Ship-to info + determination of Sold-to | DP+DiPP | Master data |
DYS_BW_SKU_PW.csv | SKU at plant sites | DiP | Master data |
DYS_BW_SOB.csv | Sales Order Book at delivery date | DP+DiPP | Dyn data DiP-PP |
DYS_BW_SOLDTO.csv | Sold-to inf + determination of Industrial group | DP+DiPP | Master data |
DYS_BW_SREP.csv | Sales Rep desc (sales rep = Sales Group) | DP | Master data |
DYS_BW_STDC.csv | Determination of CSO & Sales Rep | DP | Master data |
DYS_BW_STGBU.csv | Determination of Enterprise Customer Group | DP | Master data |
DYS_BW_STOCK_HIST.csv | Stock History | DiP-PP | Dyn data DiP-PP |
2.3.1 Master Data
DyS Master Data files - Specification
2.3.2 DP Dynamic Data
DyS DP Dynamic Data files - Specification
2.3.3 DiP-PP Dynamic Data
- the red tabs specify the selection rules applied from the extraction of the MRP Elements (MD04 transaction of ECC) to produce the DiP-PP dynamic data files.
- the blue tabs specify the mapping and calculation rules for each file.
DyS DiP-PP Dynamic Data files - Specification
2.4 Examples of DiP Source of Data in SAP
Source of Data in SAP.pptx
2.5 BW files : further details
For additional details, go directly in the wiki page of BW team : BW DPS.
3. ECC => DynaSys
3.1 Flat file interface design
Most of DiP-PP dynamic data interfaced in DynaSys is based on the MD04 extraction of the MRP elements.
For the stock (MRP Element 'WB'), transaction OPPI defines what type of stock is taken into account: Unrestricted Use, Quality Inspection, Blocked, etc.
DyS - ECC => DynaSys flat file interface
Archives :
Files with stock extracted from WP1 are archived under /exploit/DM/archive/DYNASYS/
4. SalesForce.com (CRM) interface
SFDC Opportunities interface to DynaSys - specification
https://docs.google.com/document/edit?hgd=1&id=18chSRbj0iZZcp2O_-NKFUJt7LqZOKTWWMYsxFfk4_FA
5. DynaSys => ECC manual interface
Old version for interfface can be made with ZWPP13R based on files found in dynaysys datahub.
This interface can be used as a workaround for MRP planned independant requirements and for Long term Planning also.
procedure to be used for WP1 :
https://docs.google.com/presentation/d/1_ywoplx5_CoYFvSb39xc6LLXq92lkB1kGAlQfmvuGbw/edit#slide=id.g285e2b07d6_1_76