Dear Gurus,
I am using a select statement wherein I donot mention DISTINCT but still the result is Distinct where as I need non-distinct values.
The statement is
SELECT KNUMV KBETR KWERT
FROM KONV
INTO TABLE WS_IT_KONV
FOR ALL ENTRIES IN WS_IT_VBRK
WHERE KNUMV = WS_IT_VBRK-KNUMV AND KSCHL = 'ZST1'.
Only distinct values of KWERT are picked up where if all the values are taken then that gives the desired output.
I collected data from KONV using SE16 by giving in KUMNV all values mentioned in WS_IT_VBRK , say 461 to 462 and KSCHL ='ZST1'.
Pls correct me if I have understood the query wrong.
Regards,
Shweta Soni.