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
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 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.	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			[C_COMPCDE] Company code\Attributes[K_INTRAT] Company Integ Rate
Consolidated view	In BW, the consolidation view deals with internal and external sales
Company integration rate	It is related with 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		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