Material
[C_MATNR2] Material\Attributes\[C_PLANT] Plant
[QVSBS_BW_QRY_CPCOPA03_0001] QV - BW P&L & Integrated Margin Query (CAR3)\[CPCOPA03P] Further Characteristics\[C_PLANT] Plant
WP1: [4CPCOPA03-MAP2_PRPLANT] Production plant in Material_W (Key)
[C_ZZWWE41] Origin Plant (Key)
Marged based on the PF1 and WP1 sources
WP1: [4CPCOPA03-MAP2_PRPLANT] Production plant in Material_W (Key)
PF1: Origin_Plant_Key
[C_ZZWWE41] Origin Plant
Each sale order might include multiple line items
Suggestion is to consider to build another dimension in the target model for sales order (including sales order, line item, ....)
Note: the following fields in COPA03 are used in transparency dashboard but less priority because they are not relevant for CS price optimization
[C_DOCNUMB] Sales document\Attributes\[C_SHIPCD2] Shipping conditions (core)
[C_ITM_SD] Sales document item\Attributes\[C_LSTREQ] Cust last req del dt
[C_ITM_SD] Sales document item\Attributes\[C_PO_ITM] Purchase Order Item
[C_DOCNUMB] Sales document (Key & name)
[C_DOCNUMB] Sales document\Attributes\[C_DOCTYP2] Order document type (key and name)
[C_ITM_SD] Sales document item (key & name)
[C_ITM_SD] Sales document item\Attributes\[C_CDATE2] Order Line Creation date
COPA03
There is file to categorize p&l element in transparency dashboard
[C_PLELMN2] P&L Element
[C_PLELMN2] P&L Element
and use the Gsheet to group based on the records in COPA03
In BW, the consolidation view deals with internal and external sales
Consolidation view in transparency dashboard provides consolidated measures. To calculate consolidated measures, the external-related measures of COPA03 are multiplied by company integration rate. measures related to external sales.
The integration rate is available in COPA03 and ranged between 0 to 100%.
Integration rate equal to100% means the company is fully owned by Solvay. to calculate a consolidated view of the external sales in transparency for a company with 50% integration rate, the amount of externals sale offered by COPA03 will be multiplied by 50%.
One product (or material) belongs to a product family per GBU.
It is unique per combination of GBU and product/material
Currently in the transparency dashboard there are various rules based on the GBUs to populate this field. Using COPA03 for this field, the data has been populated at sales level where both product code and GBU are available to return the GBU product family. The challenge is that, there is one product/material sold by more than one GBU that might be given various GBU product family from one GBU to another . It makes it difficult to keep the GBU product family as an attribute of product dimension in the target model to be designed.
Aligning between all the GBUs might be considered
If GBU = SP then Mapping based on PRODUCT_KEY (from icare)
mapping is : input Product2 . Material_Group__c output Product2 . Family
if either GBU= CS or TS AND SOURCE_SYSTEM_KEY= PF1_020
Material_Product_Hier__LIP03___Key_
[C_MATNR2__C_PRDHIER] Product Hier (LIP03)
Else
if GBU is PA GBR__GBU_Material__Group__Ship_to_ Else Material_Product_Family_Code__Medium_Name_i
It is unique per combination of GBU and product/material
To find out if there is any relation with customer
Measures\N8110 - Qty Sold External
Measures\N8110 - Qty Sold Internal
Measures\Net sales Internal (Sales+Royalties) - LC
Measures\Net sales External (Sales+Royalties) - LC
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
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