Skip to Content
0
Former Member
Dec 01, 2006 at 07:43 PM

select statement

32 Views

Hello friends,

I amusing this select statement.

In my selection screen i have material number and the material number i am putting in the selection screen does not exist in my data base. So i am excepting it would not pull any results. However it is pulling all records. any suggestions,

SELECT awerks abudat agrund aism03 aaufnr arueck a~rmzhl

astzhl aerzet

bmatnr cverid INTO CORRESPONDING FIELDS OF TABLE itab FROM

afru AS a INNER JOIN afpo AS b ON

aaufnr = baufnr INNER JOIN

mkal AS c ON bmatnr = cmatnr

FOR ALL ENTRIES IN it_blpk

WHERE c~verid = it_blpk-verid

AND a~budat = it_blpk-budat

AND a~erzet = it_blpk-uzeit

and a~werks = it_blpk-werks

and b~matnr = it_blpk-matnr

and a~grund IN s_grund

and ( abudat >= cadatu

and abudat <= cbdatu )

and a~ism03 <> 0

and a~ile03 EQ 'STD'.

thanks ,

shejal.