Can someone help me with some practical scenarios for which you have used the adhoc query like what type of reports you have generated?
Some example business scenarios:
Personal data list for employees in a particular organizational unit
Birthday list, marital status list, nationality list, etc.
Attendance/Absence list for employees in a particular employee subgroup
Annual leaves of all executive personnel, etc.
Address list for employees in a particular personnel area/subarea
Primary address for the employees residing in personnel area Istanbul, etc.
In addition to these, you can have any flat report from ant infotype of the personnel using Adhoc query.