Only for composite material until jun2021, there was a file (file from cognos), the rst from COPA03
| Requirements | Description | Comment | Source in transparency | Technical name of the source in transparency | Transformation |
|---|---|---|---|---|---|
| Sold to | COPA03 | ||||
| Ship to | |||||
Material | |||||
| Company | |||||
| Shipping plant | |||||
| Manufacturing plant | 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 | to ask Franck which field in the COPA03 is the one used | [QVSBS_BW_QRY_CPCOPA03_0001] QV - BW P&L & Integrated Margin Query (CAR3)\[CPCOPA03P] Further Characteristics\[C_PLELMN2] P&L Element |