How to filter results that are retrieved in SQ01 query?
Currently I am working on a sq01 query that use material number as the input. Quantity of the materials will be shown across all the plants. Now I want to remove the entries which quantity is equal to zero. Should I do ths filtering in the infoset or is there any other ways to do it? Thanks a lot for your help.
Shafiq Rehman replied
one simple way would be to put that quantity field MNG01 on the selection screen.
Then run the query and click in the box of the field MNG01 and hit F4 (or click the drop down help icon), then a small window will pop-up, you will see exclude single value tab there, enter 0 there. Thats it.
Now your query will exclude all records where it will find the MNG01 = 0.
Hope it helps.