Lay out for Adoque Query

Dear Expert,

In SAP,we use Adoque query to generate report. Kindly find attached screenshot having standard layout for the report.

I want the format of report generated by Adoque query given below

Emp No Basic Hra cola others transport allowances per diem advances 11 100 100 100 100 100 100 100 100 12 100 100 100 100 100 100 100 100

Please provide guidelines to complete this solution