IMPORTANT Note: Only for composite material until jun2021, there was a file (file from Cognos), the rest from COPA03
| 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 | [C_COMPCDE] Company code\Attributes[K_INTRAT] Company Integ Rate | ||
| Company integration rate | It addresses the consolidation view. It specifies the % of ownership of Solvay in a specific legal entity | ||||
| 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. | [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 | |||||
| Measures: Actual Volume | The quantity of material sold per CPC. It has been calculated by the aggregation of quantities in sales orders transactions per CPC | ||||
| Measures: Actual Sale | The amount of sale per CPC in local currency. It has been calculated by the aggregation of sales transactions per CPC | ||||
| Measure: Actual Unit price | This is the average price of a CPC per unit of measurement( s. This is calculated in the transparency dashboard: Actual unit price = Actual sale/Actual volume |