Requirements | Description | Comment | Source in transparency | Technical name of the source in transparency | Transformation |
|---|---|---|---|---|---|
| Sold to | COPA03 | ||||
| Ship to | COPA03 | ||||
Material | COPA03 | ||||
| Company | COPA03 | Integration rate from BW | |||
| Shipping plant | Plant from which the material is ship to a customer | COPA03 | |||
| Manufacturing plant | Last plant in the product production process | For sale transactional data (COPA03) → WP1: Production_plant_in_Material_W_Key PF1: Origin_Plant_Key For forcast COPC07 Manufacturing_Plant_Key ---------------------------------- Not relevant in this Q (planned for q4) → COPC04→ WP1 : C_PLANT PF1: ORIGIN PLANT forecast→ copa07 Depends on what transactional data we want to use in the fact table we use various queries. For example | |||
| Sales order | need analysis by franck and Ayoub | ||||
| P&L element | There is file to categorize p&l element in transparency dashboard | to ask Franck which field in the COPA03 is the one used | [QVSBS_BW_QRY_CPCOPA03_0001] QV - BW P&L & Integrated Margin Query (CAR3)\[CPCOPA03P] Further Characteristics\[C_PLELMN2] P&L Element | ||
| Incoterms | Incoterm will change the price. | It is transactional data (It is a component of the CPC so it is a transactional data). for Novecare CPC is ship to + material + incoterm Notes: CPC itself can be a table but risk (the CPC table has GBU associate) Suggestion to find a master data in BW→ Designing the dimension may be for next PI | Incoterm in the COPA03 | ||
| Internal sale | Out of scope for Leo | ||||
| Consolidated view | There are companies that are not 100% Solvay. Console view is low | To ask Leo if he use consolidation view in the transparency dashboard If he uses consolidated, internal sales are excluded from the reports |
| Rule based on sales integration rate (console view) Company Dimension in BW: Company Integration rate → sales, ICM, and quantity multiply by the integration rate =0 → between =100 → it is 100 % Solvay | |
| Forecast query | COPC07 | ||||
| Fcst Sales [Est Act] (€) | quantity of the product sold net price is per kg | ||||
| Fcst Volume [Est Act] (KG) | |||||
| Fcst Unit Price [Est Act] (€/KG) | |||||
