Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Remove multiple records for one field in alv

0 Kudos

I have an ALV report that displays Start date based on employee number like

emp num | start date | end date|

1 |12.10.1995|20.12.2020|

|05.10.1995|10.12.1998|

2 |12.12.2020|11.10.2020|

3 |......

For emp num 1 I have two records , of which I need to display only the latest start date I have to make one record per one field. Can anyone help me how can I do that?

2 REPLIES 2

Sandra_Rossi
Active Contributor

You mean this, formatted correctly:

emp num | start date | end date |
--------|------------|----------|
1       |12.10.1995  |20.12.2020|
        |05.10.1995  |10.12.1998|
2       |12.12.2020  |11.10.2020|
3       |......

So do you expect that, below?

emp num | start date | end date |
--------|------------|----------|
1       |12.10.1995  |20.12.2020|
2       |12.12.2020  |11.10.2020|
3       |......

Do you know "SORT" and "DELETE"? You can search in the ABAP documentation.

I have done that using max(date) so that i got the latest date Thank You.