How to use BW Infoobject hierarchy in ABAP CDS views

[former_member205880]

Hi, in this post I would like to consider a case where you need to use in ABAP CDS Analytical Reporting hierarchies from BW Infoobject master data.

In previous posts I have considered creation of custom hierarchy based tables similar SAP HR and annotations used in query to consume it:

https://blogs.sap.com/2017/02/22/how-to-build-a-custom-hierarchy-in-abap-cds-views/

https://blogs.sap.com/2017/02/21/how-to-consume-a-hierarchy-in-cds-view-analytical-query/

Introduction

• Hierarchies could be loaded or maintained manually in BW embedded in S/4HANA system.


• Considered approach is particularly relevant in case in S/4HANA there is embedded planning solution and you need to reuse existing hierarchy in analytical reports based on ABAP CDS views.


• Considered example will work correctly in case of simple parent-child hierarchies based on one characteristic, without text nodes or linked nodes.

Step-by-step

1. Consider infoobject MFICOCP04 "Reporting Section" and existing hierarchy in RSH1 t-code:

2. Create ABAP CDS views Dimension, Text, Hierarchy:









 

3. Analyse dimension VDM in RSRTS_ODP_DIS t-code and notice that hierarchy metadata is presented here.





4. Test of hierarchy display in RSRT:



5. Use annotations in analytics query to display hierarchy:

Below ABAP CDS view is needed to derive hierarchy name based on reporting year parameter, in example we had several hierarchies maintained for characteristic.





Analytical query code:



Note that derivation of hierarchy guid based on a hierarchy name may be not required in your case, just simplify solution (if needed)

Result

We considered creation of hierarchy ABAP CDS view based on BW Infoobject master data tables.

 

I would like to thank ekaterina.makaryants for her help with BW part of this example! Thank you!

 

Thank you for attention!