topic Re: Reg:SAP Query in Application Development and Automation Discussions

Reg:SAP Query

Former Member — Mon, 18 May 2009 11:37:39 GMT

Hi ALL,

I have displayed the output in SAP QUery ... i want to change the output position from 1 coloum to another coloum in SAP Query how we can do this can any suugest me

Regards,

Manoja

Moderator message - duplicate post locked.

Edited by: Rob Burbank on May 18, 2009 12:48 PM

Re: Reg:SAP Query

Former Member — Mon, 18 May 2009 11:41:23 GMT

Hi.

Suppose your internal table itab has the structure of =>

column1 column2

and you have written the SAP Query to display the output in same format as your internal table structure .

loop at itab.

Write: itab-column1, itab-column2.

endloop

Output:

column1 column2

Now to swap the columns

you have to code in this way

Loop at itab.

write: itab-column2, itab-column1.

endloop.

Output:

Column2 column1

That's it.

Edited by: Anup Verma on May 18, 2009 1:41 PM

Re: Reg:SAP Query

Former Member — Mon, 18 May 2009 12:51:42 GMT

I did`t write any of the codings to display automatically it will create the program ..

for this how we can write the coding to display .... there it is not creating the internal table .. so for this how we can write this can u help me ...

Manoja

Re: Reg:SAP Query

Former Member — Mon, 18 May 2009 13:10:27 GMT

Hi,

Go to SQ01 Transaction than click on the infoset query. There you will find options like

field/field groups selections and output.

You need to click on the check buttons which columns you want to select first.

Hope this will solve your query.

Regards,

Nikhil

Re: Reg:SAP Query

KK07 — Mon, 18 May 2009 16:43:14 GMT

Hi,

For changing the order of columns in the output in SAP query in the output just drag and drop the filed which ever needed.first drag the column which you want to change and then drop in the postion where you want to change.There is no need of coding for this.

Cheers,