- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Advanced Returns Management (LO-ARM)
- Batches (LO-BM)
- Commodity Management in Logistics (LO-CMM)
- ERP Logistik Integration (LO-INT)
- Engineering Change Management (LO-ECH)
- Global Trade (LO-GT)
- Handling Unit Management (LO-HU)
- Logistics Basic Data (LO-MD)
- Logistics Information System (LIS) (LO-LIS)
- Product Data Management (LO-PDM)
- Retail & Fashion Management in S/4HANA (LO-RFM)
- SAP Agricultural Contract Management (LO-AGR)
- Segmentation (LO-SGT)
- Settlement Management (LO-AB)
- Variant Configuration (LO-VC)
- Variant configuration on HANA (LO-VCH)
- Warranty Claim Processing (LO-WTY)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_MDProductHierarchyQuery
Master Data Product Hierarchy Query
| view: CMDPRDHRYQ
| Extraction:
Not supported
| Component: Material Master
- 🔑 Keys (1)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (3)
- ☰ Categorical
- Other (9)
- 🔗 Relations (7)
| Column Name | Description | |
|---|---|---|
| ProductHierarchyNode | Product Number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| CreationDate | Created On | |
| ProdHierNodeCreationDate | Created On | |
| ProdHierNodeLastChangeDate | Date of Last Change |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| Product | Product Number | MATNR | |
| ProductDescription | Product Description | TEXT40 | |
| CreatedByUser | Name of Person Responsible for Creating the Object | USNAM | |
| ProductStandardID | Global Trade Item Number (EAN/UPC/GTIN) | EAN11 | |
| LastChangedByUser | Name of Person Who Changed Object | USNAM | |
| ProdHierNodeProductDesc | Product Description | TEXT40 | |
| ProdHierNodeProductStdID | Global Trade Item Number (EAN/UPC/GTIN) | EAN11 | |
| ProdHierNodeLastChangedByUser | Name of Person Who Changed Object | USNAM | |
| ProdHierNodeCreatedByUser | Name of Person Responsible for Creating the Object | USNAM |
| Master Data Relations | Join Conditions |
|---|---|
Unit of Measure
| |
Unit of Measure
| |
Material Group
| |
Product Hierarchy
| |
Product Type
| |
Material Group
| |
Product Type
|