Skip to Content

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

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

Tags:
Former Member
Former Member replied

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.

0 View this answer in context

Helpful Answer

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