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

[naimkhans_babi]

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

[Former Member · Accepted solution]

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.

[naimkhans_babi]

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.

[yasemin_kilinc]

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...

[Loed]

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