Can anyone tell me how to generate and change query in SAP. I have one old query and i want to add more fields in it. But after adding fields using T code SQ01 still it is not reflecting in the output. Can anyone give me the complete procedure how to create query and how to change the existing one.
Define Infoset in SQ02 where you can do table joining.
Create user group in SQ03 and assign Info set to User group.
Define input and output in SQ01
While creating / changing th out field in SQ1 check the output requirement like you need only text or only value or value and text , to see this right click on the output field and select the condition.
After you make changes in SQ01 you have to execute the transaction before you go to main screen by clicking on OUTPUT(start output).