| 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 | Material is a product packaged. It provides the lowest granularity level. One product can be packaged differently that is identified with different material ID | C_MATNR2 C_MATCLS | ||||||
| Product group/Product | Non packaged material | See comment above | |||||||
| 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 or one. | ||||||||
| Business line | |||||||||
| GBU product family | |||||||||
| HPAM | |||||||||
| 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 KVG | ||||||||
| Product brand | Only available in Leo |