ProductHierarchiesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - ProductHierarchiesMD
Overview
This reporting view provides a hierarchical structure of products and their descriptions in multiple languages.
Data Sources
| Source Table/View | Description |
|---|---|
| t179 | Product Hierarchy Header Table |
| t179t | Product Hierarchy Text Table |
Key Use Cases
- Display product hierarchies in reports and dashboards.
- Analyze product relationships and structures.
- Translate product descriptions into different languages.
Query Logic
The view joins the t179 and t179t tables on the mandt and prodh fields to retrieve product hierarchy data and corresponding descriptions in the specified language.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM01 | Create Material |
| MM02 | Change Material |
| MM03 | Display Material |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| Hierarchy_PRODH | Hierarchy ID | |
| Level_STUFE | Level within the hierarchy | |
| Language_SPRAS | Language code | |
| Description_VTEXT | Description of the hierarchy level |