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.