| Target (Transparency) data model | Requirements | Descripting | Comment | Existing transparency source (Query in BW, table in SF or AP) | Technical name in the transparency source (BW, SAP, SF,..) | Transformations for transparency dashboard | SF source | SAP source | Comments |
|---|---|---|---|---|---|---|---|---|---|
| Product | material ID (target model) | Generated by Datalake by referring to C_MATNR2 Material is a product packaged. It provides the lowest granularity level. One product can be packaged differently that is identified with different material ID Important note: In various source tables, product/material are available in various hierarchy. To think how to model in data lake to be manipulated/distinguished easily for various applications. | C_MATNR2 C_MATCLS | ||||||
| Material name | Medium name | C_MATNR2 . TXTMD | |||||||
| Material code | It is finished product/material | To check the exact attribute technical name Currently is used in COPA03 but to explore the right source | COPA03 | C_MATNR2 | |||||
Material group/Product (both code & name) | Non packaged material | Depend on the sources such as PF1 and WP1 there are two attributes in the BW query which are not aligned There are two attributes in COPA03 that are merged in one field in the transparency dashboard. One refers to SpP and the other refers to other GBUs. To decide later how to design in data lake. | C_MATNR2 C_PROD | ||||||
| Product H4 | in the dashboard H4 and L4 is merged. H4 is for SpP and L4 for other GBUs. To decide if it is two separate field in data lake. | 1qRE12ZhXjZI9Aq85CSeMDs2QuKA2NBvHngyzZ7qPRHs Using material group as an input to map, the output H4 | |||||||
| Business line | In transparency dashboard: It is coming from icare (it is only for SpP). there is no corresponding concept in CORE → it will be empty | Product2 . Business_Unit__c | |||||||
| GBU product family | Business rule: Franck will provide: Separate meeting | ||||||||
| HPAM | Product H4 and HPAM are both linked via material group using googlesheet made by transparency team | This info is not available in BW (H4 is available in iCare but HPAM is not available to the analyst knowledge) | 1qRE12ZhXjZI9Aq85CSeMDs2QuKA2NBvHngyzZ7qPRHs
Using material group as an input to map, the output HPAM Exact same mapping product H4 | ||||||
| Product manager | |||||||||
| Product hierarchy | |||||||||
| Product birth | |||||||||
| Product line (0 to X) | |||||||||
| GBU material group | |||||||||
| Product line E2E | |||||||||
| Packaging type | |||||||||
| Product hierarchy PIM | |||||||||
| Unite conversion rate | The current requirements in transparency dashboard is only to converting into VKG. | ||||||||
| Product brand | Only available in Leo |