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.