| 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 |
|
|
|
| Sales order number | Includes sales orders and corresponding line items |
|
|
|
|