Skip to Content
avatar image
Former Member

Drill down ( Collapsible Row ) Report in BEx query designer ?

Dear Friends!

   I am supoosed to create a report drill down report for Purchasing History to be precise,  I know that we can have drill down feature using heirarchy but is it possible for Us to have PO & PO item heirarachy ? or any other way to do drill down reporting in SAP BEx Query designer ?

like my current report is : -

| Vendor | Purchasing Organisation | Purchasing Group | Plant | PO Number | Item | Material / Service | Description | .... ( keyfigures) |

Now I am supposed to create a report  in which

normal view

| Vendor | Purchasing Organisation | Purchasing Group | Plant | |> PO Number| .... ( keyfigures) | Payment |

drill down or collapsible view ( please consider the heading as data I am not talking about dynamically change of  headings ).

| Vendor | Purchasing Organisation | Purchasing Group | Plant | V PO Number | Item | Material / Service | Description | .... ( keyfigures) |

is there anyway to design the report in above mention manner ? you any input will be appreciated greatly.

Thank you so much!

Regards

Naim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 07, 2014 at 03:03 PM

    Hi Naim,

    usually we don't do the transactional data as hierarchy.  not sure the reason behind your requirement.

    we can do one of the below :-

    1. To have the default view as

    | Vendor | Purchasing Organisation | Purchasing Group | Plant | | PO Number| .( keyfigures) | Payment |

    and then user can drill down on rest of the characteristics for detailed view later on.

    2. or if they don't want to drill down on characteristics;-

    we can build 2 reports , one for header level information and then jump to second query for detailed information(item level) using RRI.

    first query:

    | Vendor | Purchasing Organisation | Purchasing Group | Plant | | PO Number| .( keyfigures) | Payment |

    second query:

    | Vendor | Purchasing Organisation | Purchasing Group | Plant |  PO Number | Item | Material / Service | Description | .... ( keyfigures) |

    Let us know if this works out?

    Regards,

    Sakthi.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2014 at 07:03 AM

    WIth Hierarchy I was able to do that,, and with RRI too... but I had to maintain Heirarchy seperatly and RRI two report have help me without doing much...  I am thanking you all who helped me. both the approaches are perfect in their own nature but in my case RRI have helped me more and I learned more interesting thing that we can attached URLs to the report and possible to trigger ITS Based SAP transaction.

    Thank you so much once again.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 07, 2014 at 11:00 AM

    Hi Naim,

    I don't know if understand your question correctly but you can make a hierarchy for drilldown for your PO and PO item using tcode RSH1..Did I understand your query?

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 08, 2014 at 05:11 AM

    Hi Naim,

    I am not sure if that will work as you want, but you can try creating a structure on rows (Name it as Plant), Then add a selection for plant, add a selection for PO Number (don't restrict with anything only add the characteristic) and put the po number selection to a lower level of plant selection in the structure. Hope it hleps.

    Regards

    Yasemin...

    Add comment
    10|10000 characters needed characters exceeded