select Problem

Hi All,

I have a requirement in which i have to select belnr field from EKBE table on basis of ebeln and ebelp,but there are multiple records in EKBE table.i have to select the latest belnr number on basis of date field.how can i do that?

For ex

ebeln ebelp belnr date

45 10 001 07/10/2007

45 10 002 09/10/2007

45 10 003 10/10/2007

i want the third record with belnr 003.

thanks in advance