Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 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


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question