| Requirements | Description | Comment | Source in transparency | Technical name of the source in transparency | Transformation |
|---|
| Source system |
|
|
|
|
|
| Calendar month |
|
|
|
|
|
| Sold to |
|
| COPA03 |
|
|
| Ship to |
|
| COPA03 |
|
|
Material |
|
| COPA03 |
|
|
| Shipping plant | Plant from which the material is ship to a customer |
| COPA03 |
|
|
| Manufacturing plant | Last plant in the product/material 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 |
|
| Sales order |
| Suggestion is to consider to build another dimension in the target model for sales order (including sales order, sales order line, ....) |
|
|
|
| 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 |
|
| Company | Legal entities owned by Solvay. It can be full ownership or partial ownership | CODE? NAME? |
|
|
|
| Consolidated view | In BW, the consolidation view deals with internal and external sales | Rule based on sales integration rate (console view) the integration rate is between 0 to 100% Integration rate equal to100% means the company is fully owned by Solvay. To calculate measures based on external/internal companies. The measures are multiplied by this integration rate. Fore example, to calculate the external sale, the amount of sale for a company with 50% integration rate will be multiplied by 50% to be counted for the external sale. |
|
|
|
| Company integration rate | It is related to the consolidation view. It specifies the % of ownership of Solvay of a company |
| COPA03 | [C_COMPCDE] Company code\Attributes[K_INTRAT] Company Integ Rate |
|
| 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 | In COPA03, both external and internal sales are available. In some applications both are important but for Leo only external sales is important. | COPA03 | Measures\N8110 - Qty Sold External Measures\N8110 - Qty Sold Internal |
|
| Measures: Actual Sale | The amount of sale per CPC in local currency. It has been calculated by the aggregation of sales transactions per CPC | The transparency dashboard uses the measures in COPA03 that offer the sale with LC (Local Currency). The car3 fx rate will be used for conversion to Euro | COPA03 | Measures\Net sales Internal (Sales+Royalties) - LC Measures\Net sales External (Sales+Royalties) - LC
|
|
| 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 |
|
|
|
|
| Last price | Last month available for CPC with external data, the qty assigned to this month. | Only for external sales and closed months. Filter on the creation date of the last order line in case of many order created in the same day, the last order number which is the biggest one are taken intothe consideration |
|
|
|
| Sales order number | Includes sales orders and corresponding line items |
|
|
|
|