| Requirements | Description | Comment | Source in transparency | Technical name of the source in transparency | Transformation |
|---|---|---|---|---|---|
| Sold to | COPA03 | ||||
| Ship to | COPA03 | ||||
Material | COPA03 | ||||
| Company | it refers to companies owned by Solvay. It can also include the companies for which the ownership by Solvay is lass than 100 | COPA03 | |||
| 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 | The info that the color coding represents in Gsheet is not needed for Leo but the suggestion is to consider when designing the data mart for future applications. | COPA03 There is file to categorize p&l element in transparency dashboard | [C_PLELMN2] P&L Element | ||
| Consolidated view | To ask | ||||
| Company integration rate | It addresses the consolidation view. It specifies the % of ownership of Solvay in a specific legal entity | COPA03 | [C_COMPCDE] Company code\Attributes[K_INTRAT] Company Integ Rate | ||
| Internal sale | Out of scope for Leo | ||||
| Incoterm |