ProductHierarchiesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - ProductHierarchiesMD
Overview
This reporting view provides a hierarchical structure of product hierarchies 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 and their descriptions in reports and analysis.
- Understand the structure and organization of product categories.
Query Logic
The view joins the t179 and t179t tables on the mandt and prodh fields to retrieve product hierarchy data and its corresponding descriptions in the specified language.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM03 | Create/Change Material Master |
| MM02 | Change Material Master |
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 ID | |
| Language_SPRAS | Language Code | |
| Description_VTEXT | Description Text |