Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to do dynamic selection of hierarchies during query execution based on cost center ?

Hi Gurus,


Cost center- User selection

Based on this should dynamically select hierarchy for cost element.(there are multiple hierarchies maintained for cost element)

Also cost center to hierarchy is one to one, the relationship is maintained in DSo- 'ZXXXXX'

Eg: CostCenter1   Hierarchy1

       Costcenter2    Hierarchy2

       Costcenter3    Hierarchy1

       Costcenter4    Hierarchy3

So during query run time, when user key in 'costcenter1' the query should pick up 'hierarchy1' and diplay.

Is it possible? how to achieve this?

Thanks in advance.

Former Member
Not what you were looking for? View more on this topic or Ask a question