Skip to Content
0
Former Member
Dec 06, 2006 at 10:15 AM

problem in select statement

84 Views

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.