topic Process internal table in Application Development and Automation Discussions

Process internal table

former_member384574 — Thu, 09 Sep 2010 08:25:06 GMT

Hi experts,

I need help, I don't know how can I do that, I've an internal table like below..

date status hour

06/08/10 01 9:00

06/08/10 03 9:15

06/08/10 01 9:20

06/08/10 02 9:50

07/08/10 01 12:00

07/08/10 02 12:00

08/08/10 01 12:00

From that internal table I need these which the date is unique and has the maxim hour, for that table I will need that entries:

06/08/10 02 9:50

07/08/10 02 12:00

08/08/10 01 12:00

Can anybody help me? I don't know how can I do that

Thanks in advanced,

Regards,

Rebeca

Former Member — Thu, 09 Sep 2010 08:27:32 GMT

Hi,

Please sort and then use delete adjacent duplicates.

Sort itab by date hour descending.

delete adjacent duplicates from itab comparing date.

Regards,

Srini.

guillaume-hrc — Thu, 09 Sep 2010 08:28:35 GMT

Hi,

Use SORT on the date and hour. (It is simpler if the date and hour are in 1st and 2nd position in your table)

Then the LOOP AT ... AT NEW date would allow you to fill a new table with entries that you want.

Best regards,

Guillaume