Skip to Content

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

How to filter hierarchy node in BEX query designer

Dear experts

We are working on FI balance sheet with hierarchy infoobject 0GLACCEXT. Example of our balance sheet is as follow:

Parent Node A = 20

     Sub-parent Node A1 = 10

         Leaf A11 = 5

             Leaf A12 = 5

Parent Node B = 20

     Sub-parent Node B1 = 10

               Leaf B11 = 5

               Leaf B12 = 5

We require only:

    Sub-parent Node A1 = 10

    Leaf B12 = 5

So I filter those out in BEX restriction;  however, after we examine the report in tcode RSRT, "Sub-parent Node A1" is not shown in BEX Report, and the result is as follow:

Parent Node B = 5

     Sub-parent Node B1 = 5

             Leaf B12 = 5

Are there solutions for us to show merely A1 and B12 ?

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