In the spreadsheet below, we get the list of BW files.
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_CM_SKU.csv | |||
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 |
| DYS_SF_CRM_TEMP.csv |
In the document below, some additional information on BW flows :
- 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.
*** this document is not anymore up to date ***
DYN - Dataflow
For additional details, go directly in the wiki page of BW team : BW DPS.