Skip to Content
0
Jun 29, 2020 at 07:06 AM

SAP BW 7.4 SP14 How generate hierarchy from transactional Data ?

89 Views

Hey Specs !

We usually create hierarchy manually from ECC and excel/csv source from time to it would be nice to create hierarchy from transactional data (like in Oracle SQL server with connect by or MS SQL Serverrecursive call).

I am wondering what is/are the best approach to generate BW hierarchy from transactional data.
Is there any function module for it or some kind of approach that would do the trick ?