Product Information
How to Use Product Hierarchies in Design Studio or Web Dynpro Apps
Background
Product hierarchies are an effective way of organizing materials or products along multiple levels, for uses such as pricing or analytics. This allows the system to analyze data at a higher level, rather than examining hundreds of materials or products individually.
Data model of Product Hierarchies
This section describes how product hierarchies are implemented from the technical perspective.
The data model of product hierarchies builds upon transaction data, master data (I_Product), and hierarchy data. Transaction data refer to data generated during business transactions. As a collective dataset of products and via association with transaction data, master data (I_Product) empowers the dimensioning of transaction data by product. Such dimensioning can be mapped to a hierarchy, which contains hierarchical relationship among various nodes.
The following example presents the data model behind product hierarchies for sales quotations.
Data |
CDS view |
Description |
Transaction data |
C_SalesQuotationItemQry |
Transaction data related to business objects, such as sales quotations, sales orders |
Master data |
I_Product |
Collective dataset of products |
Hierarchy data |
I_ProdUniversalHierarchy |
Hierarchical relationship of nodes, which map to dimensions of transaction data |
Manage Product Hierarchies
You can create or edit product hierarchies in the Manager Product Hierarchies app.
Note: Before using the app, add the business role “SAP_BR_PRODMASTER_SPECIALIST” to your user ( sap help ).
Use Product Hierarchies in Design Studio or Web Dynpro Apps
The following example describes how to use product hierarchies in Sales Quotations – Flexible Analysis, a Design Studio app.
Prerequisite
Before using product hierarchies in transactional or analytical apps, add the business catalog SAP_CMD_BC_PRODUCT_DSP_PC to your user.
Procedure
1.In the Sales Quotations – Flexible Analysis app, add the Product dimension to columns.
2. In the analysis result area, right-click on Product and choose Hierarchy > Select Hierarchy.
3. Select a desired hierarchy.
Analysis results are organized by the product hierarchy.
4. You can also expand or collapse the hierarchy as required.
Other Notes
When you select a hierarchy, product hierarchies available for selection differ between Design Studio and Web Dynpro apps. In Design Studio apps, only product hierarchies within their validity period are available. In Web Dynpro apps, all product hierarchies are shown regardless of their validity.
• Select product hierarchy in Design Studio app
• Select product hierarchy in Web Dynpro app
Thanks for Sharing.
Hey Joey - Another very detailed post 🙂 Thank you for adding this useful info to the S/4HC Community.
Please continue to share valuable content with our members and help to build a stronger Community.
If you feel that this content should be provided with the standard documentation, please use the [Feedback] and [Comments] features within the related portal.