Skip to Content
avatar image
Former Member

ad hoc query - column not row

Dear all,


I have big problem in extracting report from ad hoc query.

The case is:

When I extract report from ad hoc query it will bring for example (passport and ID) in row wise not column wise. Also, I have this problem for: 1) basic salary, 2) transportation, and 3) housing. They are exporting in a row-wise, which makes it difficult for management to make analysis.

Is there a way to have all information to become in column wise not in a row-wise.

Your response is very much appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 04, 2015 at 07:03 AM


    It is possible but you have to play with complex rules and Inner and outer Join of table. Also, use of Alias table.

    Suggestion, Develop custom report with help of Abaper. However, still you want to know how to achieve in Ad hoc query let me know.

    Best Regards,

    Ketul Patel

    Add comment
    10|10000 characters needed characters exceeded