CPC

Sum (Measure\N8110 - Qty Sold External

CPC

Sum (Measures\Net sales External (Sales+Royalties) - LC)

This is calculated in the transparency dashboard:

Actual unit price = Actual sale/Actual volume

To calculate the unit price per CPC, In the transparency dashboard, the calculation first is performed at the  order/Line item level. 

see the table below for the calculation 

[C_DOCNUMB] Sales document

[C_ITM_SD] Sales document item

Sum (Measure\N8110 - Qty Sold External/Sum (Measures\Net sales External (Sales+Royalties) - LC)

The price for the last sales order item per CPC.

For that the closing month is considered, the creation date of the last order line, and the  latest sales order/order line in that day is considered

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 

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

To ask 

[C_MATNR2] Material\Attributes\[C_PLANT] Plant

For forcast COPC07

Manufacturing_Plant_Key

----------------------------------

Not relevant in this Q (planned for q4) → COPC04→ WP1 : C_PLANT     PF1: ORIGIN PLANT

[QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[C_MANPLNT] Manufacturing Plant

WP1: [4CPCOPA03-MAP2_PRPLANT] Production plant in Material_W → key

PF1: Origin_Plant_Key

[C_ZZWWE41] Origin Plant

Include sales order and line item

Each sale order might includes multiple line items 

Suggestion is to consider to build another dimension in the target model for sales order (including sales order, line item, ....)

Confirm which date is considered for the last creation date of the last invoice

[C_ITM_SD] Sales document item\Attributes\[C_CDATE2] Order Line Creation date

[C_ITM_SD] Sales document item\Attributes\[C_LSTREQ] Cust last req del dt

[C_DOCNUMB] Sales document (Key & name)

[C_DOCNUMB] Sales document\Attributes\[C_DOCTYP2] Order document type (key and name)

[C_DOCNUMB] Sales document\Attributes\[C_SHIPCD2] Shipping conditions (core)

[C_ITM_SD] Sales document item (key & name)

[C_ITM_SD] Sales document item\Attributes\[C_CDATE2] Order Line Creation date

[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_PLELMN2] P&L Element

[C_PLELMN2] P&L Element

 and use the Gsheet to group based on the records in COPA03

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. 

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 ask if customer related 

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