General presentation
Objective of the application
This application is not really a BW application, but a collection of DSO to provide data to an external tool nammed pVelocity.
pVelocity is a tool which help the Novecare GBU to optimize their Assets.
In BW, we extract the data from RCS and then generate flat files on a WBP folder and it is the pVelocity tool which is transfering the file from BW to pVelo.
IT Learder is now Nathalie Manirakiza in the IS-RtR team
The Tool Leader is in the Novecare GBU.
The reporting coordinator is Sandrine Micollet
Usage information
There is around 50 users on pVelocity tool WW, all working in the Novecare GBU.
They are Asset Manager, Industrial manager and also financial controlers.
History
This project was launch using BW as Hub because the pVelocity team was not allowed to extract data directly from RCS (WP1).
It was a kind of shadow project.
Roles & Access
There is no direct usage of the BW infoproviders, so no roles nor authorizations.
Dataflow overview
The data flow is very simple because in the main cases, it re-use existaing DSO which are already loaded for other applications.
Then an abap program generates the files in a text format.
The namming rule for the files is a prefix represented the content of the file, then "–" and then a timestamp, which is the dateTime (YYYMMDDHHMMSS)
| File name | File description | BW Source | Type of data |
|---|---|---|---|
| CD | Distribution Channel | 0DISTR_CHAN | Text |
| CDSA | CD x SA | C_CDSA | Master Data |
| COAREA | Controlling Area | 0CO_AREA | Text |
| COMP | Companies | 0COMP_CODE | Master data & Text |
| CURR | Exchange rate | TCURR table | Transactionnal |
| IECRA | IECRA | 0G_CWWE01 | Master Data |
| MARM | Material Alternative unit of measure | ODS_MARM | Master Data |
| MATNR | Material | C_MATNR C_MATPLNT | Master data & text |
PBOM | Standard production cost | ODS_PCP1 | Transactionnal |
| PLANT | Plant | 0PLANT | Master Data & Text |
| PROD | Produced quantity | ODS_PP01 | Transactionnal |
| PROFITCTR | Profit Center | 0PROFIT_CTR | Master Data & Text |
| RAWP | Raw material costs | ODS_PCP3 | Transactionnal |
| RESOURCE | Resources Unit price | ODS_PCP8 | Transactionnal |
| RSAL | Resales of the month | ODS_PA06 | Transactionnal |
| SA | Division | 0DIVISION | Text |
| SHIP | Sales of the month | ODS_PA06 | Transactionnal |
| STDCOST | Standard cost by cost Elements | ODS_PCP7 | Transactionnal |
| TRANSFER | Transfer movement between plants | ODS_IC01 | Transactionnal |
| TVAPT | Sales documents item category | 0ITEM_CATEG | Text |
| TVFKT | Sales billing type | 0BILL_TYPE | Text |
| UOM | Unit of Mesure | T006 table | Master Data |
| VALSTR | Value Stream | C_VALSTR | Master Data & Text |
| VC | Standard Variable costs | ODS_PCP3 | Transactionnal |
| ZSECT | Global Business Unit | C_ZSECT | Master Data & text |
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Text Files:
The text files are using the text of the info object and the target is to provide the description of some master data to pVelocity.
The structure of them is the following one:
CD: This file is given the short descriptions of the Distribution Channel
Interface File Field | Source table | Field / Data element | Type | Length | Description |
DISTR_CHAN | /BI0/TDISTR_CHAN | /BI0/OIDISTR_CHAN | CHAR | 2 | Distribution Channel |
TXTSH | /BI0/TDISTR_CHAN | RSTXTSH | CHAR | 20 | Short Description |
COAREA: This file is given the medium descriptions of the Controlling Area
Interface File Field | Source table | Field / Data element | Type | Length | Description |
CO_AREA | /BI0/TCO_AREA | /BI0/OICO_AREA | CHAR | 4 | Controlling area |
TXTMD | /BI0/TCO_AREA | RSTXTMD | CHAR | 40 | Medium Description |
SA: This file is given the short descriptions of the Division
Interface File Field | Source table | Field / Data element | Type | Length | Description |
DISTR_CHAN | /BI0/TDIVISION | /BI0/OIDIVISION | CHAR | 2 | Distribution Channel |
TXTSH | /BI0/TDIVISION | RSTXTSH | CHAR | 20 | Short Description |
TVAPT: This file is given the short descriptions of the Sales document item category
Only English language (=EN) is extracted
Interface File Field | Source table | Field / Data element | Type | Length | Description |
| LANGU | /BI0/TITEM_CATEG | LANGU | LANG | 1 | Language key |
ITEM_CATEG | /BI0/TITEM_CATEG | /BI0/OIITEM_CATEG | CHAR | 4 | Sales document item category |
TXTSH | /BI0/TITEM_CATEG | RSTXTSH | CHAR | 20 | Short Description |
TVFKT: This file is given the short descriptions of the Billing type
Only English language (=EN) is extracted
Interface File Field | Source table | Field / Data element | Type | Length | Description |
| LANGU | /BI0/TBILL_TYPE | LANGU | LANG | 1 | Language key |
BILL_TYPE | /BI0/TBILL_TYPE | /BI0/OIBILL_TYPE | CHAR | 4 | Billing type |
TXTSH | /BI0/TBILL_TYPE | RSTXTSH | CHAR | 20 | Short Description |
Master Data files:
CDSA
COMP
IECRA
MARM
MATNR
PLANT
PROFITCTR
UOM
VALSTR
ZSECT
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
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
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution