Skip to Content
0
Former Member
Feb 02, 2007 at 05:53 AM

How to retrieve latest 5 records from Infotype?

34 Views

Regarding IT0023 there might be more than 5 records for each pernr , but we need only the 5 latest records with the ENDDA closer to sy-datum.

For eg:

pernr endda

75000723 31.12.1990

75000723 31.12.1992

75000723 31.12.1994

75000723 31.12.2004

75000723 31.12.2006

75000723 31.12.1995

75000723 31.12.1997

In this case the records with the ENDDA closer to today, meaning the ones ended on 2006, 2004, 1997, 1995 and 1994 should be retrieved.

Can any one of you please help me solve this.