Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Query - Adding new fields to SAP query

Former Member
0 Likes
688

Hi experts,

I got an issue to work on SAP query.

I have Transaction code and need to know the infoset to add additional two fields to the existing output.

Please let me know how to find infoset/ Query for the specfic transaction and how to add fields.

Regards,

Venkata

Hi experts,

I got an issue to work on SAP query.

I have Transaction code and need to know the infoset to add additional two fields to the existing output.

Please let me know how to find infoset/ Query for the specfic transaction and how to add fields.

Regards,

Venkata

2 REPLIES 2
Read only

Former Member
0 Likes
558

Hi,

Go to se93 and add the t-code.

Go to display.

in the program name you'll see something like this.

AQZZMM_USERS====ZMATLIST======

MM_USERS is the user group.

ZMATLIST is the info-set.

Go to info-set and then go to the queries under it and you can narrow down the query.

Read only

Former Member
0 Likes
558

first check the transaction code given to you.. if it is report transaction (check using SE93), then get the report name for example AQFKTES_SGS_IV==MMIV0003======, then after aQFK,TES_SGS_IV woulbe be your user group and MMIV0003 would be your query. Now go to SQ03 with the user group (you need to check the query areas also which would be Environment---> query areas) because some can be client depended some can be just cross client. and then go to sq01 from user group. It will direct you to the queries of the user group you mentioned in SQ03. Now you should be able to find the query you are looking for. The infoset will also be displayed linked to the query. The infoset can be displayed via SQ02 transaction.

If it is parameter transaction code, you need to check the parameter values to find the query details. Rest of the approach is same as mentioned above.