The SQL requestors do not allow you to define multi-level inquiries and drill up/down within them. The characters based and graphical one do provide this feature. The SQL one should provide equivalent functionality.
Idea Origin: Sage Summit - C-0179 Influencing the Design session
by: Jeff L. | over a year ago | Technical
Comments
Hi! There is a way you can get SQL code inside a requester and retain the multi-level functionality. You create a SQL view inside Dictionary Of Views (GESAVW), then use that view as a table in your regular requester. If you do this, then you can achieve SQL coding, as a requester, with the multi-level functionality. Hope this helps.