General presentation
Objective of the application
The goal of the application is to extract data from BW WBP to Anaplan.
This solution is based on flat files automated generation.
Anaplan documentation is available on the following wiki page : https://wiki.solvay.com/x/cwBvKg
Tool Leader + IT leader of the application: Guillaume.THEVENET@solvay.com
Usage information
N/A
History
N/A
Master Data extraction
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Original User requirements are available in the following document: BW requirements - Basic master data and Exchange rates for Anaplan F2G models
Flat files are generated using '.txt' extension and comma separator ','.
All extracted description is done using english language EN.
All generated files are stored in AL11 folder /exploit/BW/Anaplan_outbound:
These are generated by OpenHubs located in InfoArea IA_FMCO_CO_CT_VIRTUAL:
Generated file's names and location are set up using logical file (Transaction FILE):
In order to generate header lines in flat files, an ABAP specific solution has been implemented in all extraction data flow.
Concerning this solution, the dedicated documentation is available : OpenHub for APD CSV File interface.docx
1) Region (Com); Country (Com)
Name of the flat file: Region_country.txt
Heading columns:
Country code | Country description | Zone code | Zone description |
2) Site
Name of the flat file: Site.txt
Heading columns:
Geography / Geographic site CODE from C_SITE | Geography / Geographic site Description |
3) Function
Name of the flat file: Function.txt
Heading columns:
4 Sub-function code | 4 Sub-function description |
4) BU
Name of the flat file: BU_BFC_Group_of_activities.txt
Heading columns:
/BIC/C_FACUBU code | /BIC/C_FACUBU description |
5) Currency List
Name of the flat file:
Heading columns:
Local Currency | Description local currency |
6) Legal Entity
Name of the flat file:
Heading columns:
Company Code - PRS Company code | Description of company code |
7) BSA
Name of the flat file:
Heading columns:
BSA code | BSA description |
8) Exchange rates
Name of the flat file:
Heading columns:
Unique ID | Currency Type | Currency | Year | Month | Conversion Rate |
9) BSA
Name of the flat file:
Heading columns:
GBU code | GBU Description |
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 |