Infoset with sap query

[Former Member]

Hello.
I would like to ask about using sap query to extract data from table in infoset. Is it possible to write an abap code and get data from certain table? I ask because I do not have any experience in that. Tried to find any examles, but nothing find.

My question is simple- how to extract data using simple abap program, then creatу an infoset with this query and then how to create attribute list based on infoset?

Thanks a lot.

[Former Member]

Hi Aryat,

Yes it is possible to include code in infoset and fetch data from database tables.

Go to tcode- SQ02, and change query area from global->standard and click change.

Now click on Extras,it will enable all the custom fields on right hand side.

Now select the field from the row and click coding for addition symbol as mentioned in below screen shot, it will take you to the program line screen and you can code here.

After completing coding save and generate the infoset and adjust the query again otherwise new changes will not reflect.

Hope it will solve your issue.

[Former Member]

Unfortunatelly, I cant change query area from global to standart, it is always global regardless of mandant

[Former Member]

Hi,

You can change query area by doing like below.

It will generate a pop-up and you can change query area by that:

Hope it will solve your proble.

Reward if helpful.