cancel
Showing results for 
Search instead for 
Did you mean: 

changing the ABAP query

Former Member
0 Kudos

hi all gurus.

how shud i change the ABAP query that is already created. i wana add a new field in the query. please guide

Prashant

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You can change/modify an existing query in SQ00 or SQ01.

If you want to add, new local field , then you can modify only in SQ00. There is no need to add field in the Infoset.

On the contrary, if you want to add a new database table field, then you need to modify the Infoset. For this use SQ02 t-code.

You can refer the below link to get a clear picture on this

<a href="http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_FunctionalAreas_WithoutLogicalDB.asp">ABAP Query - A guide to create and modify abap queries.</a>

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

go to SQ02(INFO SET)-SELECT UR INFOSET THEN PRESS CHANGE BUTTON

INTHIS SELECT WHAT EVER THE NEW FIELD U WANT AND DRAG INTO UR LIST.THEN SAVE.

AGAIN GOTO SQ01THEN EXECUTE UR QUERY.U WILL GET THE REPORT.

IF IT HELPS PLS DO GIVE REWARD POINTS.

THANKS&REGARDS

VEERA.