cancel
Showing results for 
Search instead for 
Did you mean: 

Lay out for Adoque Query

Former Member
0 Kudos

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 BasicHracolaotherstransportallowancesper diemadvances
11100100100100100100100100
12100100100100100100100100

Please provide guidelines to complete this solution

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Rohan ,

Please go through below link , U will get an idea how to use Adoque Query ,

http://www.saptechnical.com/Tutorials/SAPQuery/Adhoc/Index.htm

Regards ,

Zuby Chakravorty

Former Member
0 Kudos

Go to T-Code SQ01 and select your query and you will have all your field in colum wise. you can drag the coloum and make the layout according to you.

Former Member
0 Kudos

Hi Shan,

Thanks for the reply.

But can you please explain in more depth.

I believe, by drag drop we can shuffle the field.

But here is the point of lay out.

Former Member
0 Kudos

you can do drag and drop or can create a layout varient and that varient can be called when you execute this report.

SQ01

click on PA cloum and drag it and place where you want and generate the query again and save it.


Former Member
0 Kudos

Hi Shan,

Thanks again for reply.

In Sq01: Info set query is not coming.

Please find attached screen shot.

regards,

Former Member
0 Kudos

Hi Sharma,

I dont know where you make mistake, i wil give you the way how to confic the query report in a highlevel.

first you need to decide the query area whether its "standard query area or "Global query area".

then using T-Code SQ03 create an user group there after using T-code SQ02 create Infoset (pick infotypes what all your going to use for this report)

now assige the  user group into inforset using T-code SQ03.

finaly create the query report (including the layout) using t-code SQ01.here you can drag n drop the row (fields) as i mentioned earlier)

if your not getting the query .pls check whether your searching the query in a coreect query area (standard area or global area)

Thanks,

Dinesh