ad hoc query - column not row

[Former Member]

Dear all,

Greetings..

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.

[Former Member]

Hi,

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