| 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/code | It is finished product/material | ||||||||
Product group/Product | Non packaged material | See comment above (code and name) | |||||||
| 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 VKG. | ||||||||
| Product brand | Only available in Leo |
Overview
Content Tools
Tasks