Hello SAP community,
This blog post aims to cover the process to create and activate custom hierarchies and data sources which can be used by the BW (Business warehouse) for SAP MDG to SAP BW data extraction for reporting.
We can see this information in SAP standard SET tables: SETHEADER, SETGROUP and SETLEAF.
Like we visualize profit center hierarchy structure using KCH3 and cost center hierarchy structure using KSH3 transaction codes, similarly we can visualize newly created custom hierarchy structure using transaction code GS03 by giving the newly created setname.
RSA3 transacion code to extract the data from data source:
NOTE: BW07 is only for hierarchy sets constructed using GS01 transaction code.
Hope you will find this information useful.
Please like, share and comment.
If you have anything else please feel free to ask any question or add points.(https://answers.sap.com/index.html)
Happy Learning !!
Thanks & Regards,
SAP MDG consultant