Skip to Content
0
Former Member
Jan 11, 2008 at 03:00 PM

has to recheck the select query or suggest new

51 Views

Hi,

I had to display aggrement numbers starting vth 46 and 56 based on material no . Aggrements numbers has to display from today (check the validity).Agrements expired should not be displayed.

aggreement numbers : ebeln in table ekpo

valid dates: begin date:KDATB table EKKO

end date:KDATE table EKKO

material no: mara-matnr

deletion indicator:ekko-loekz

i wrote the select query as

SELECT ekpo~ebeln matnr

INTO corresponding fields of table i_ebeln

from ekpo inner join ekko

on ekkoebeln = ekpoebeln

WHERE ekkokdate >= sy-datum and ekkoloekz <> 'L' and

ekkoebeln LIKE '46%' AND ekkoebeln LIKE '56%'.

but it is not working i cant able to see agrrements vth validity

plz check it and suggest me the appropriate query.