Dates Agregation with gaps between days

stepniake73 — Thu, 19 Jan 2023 07:29:12 GMT

Hi, I have itab with 3 columns: pernr, begda, endda. I have also data in itab:

pernr | begda | endda

123 | 01.12.2022 | 01.12.2022
123 | 02.12.2022 | 02.12.2022

123 | 12.12.2022 | 12.12.2022
123 | 13.12.2022 | 13.12.2022
123 | 14.12.2022 | 14.12.2022
123 | 15.12.2022 | 15.12.2022
123 | 16.12.2022 | 16.12.2022

123 | 28.12.2022 | 28.12.2022
123 | 29.12.2022 | 29.12.2022
123 | 30.12.2022 | 30.12.2022

456 | 13.12.2022 | 13.12.2022

789 | 05.12.2022 | 05.12.2022
789 | 06.12.2022 | 06.12.2022
789 | 07.12.2022 | 07.12.2022
789 | 08.12.2022 | 08.12.2022
789 | 09.12.2022 | 09.12.2022

789 | 12.12.2022 | 12.12.2022

789 | 27.12.2022 | 27.12.2022
789 | 28.12.2022 | 28.12.2022
789 | 29.12.2022 | 29.12.2022
789 | 30.12.2022 | 30.12.2022

All i have to do, is to combine adjacent dates for every pernr.
Finally, ja have to get result as below:

123 | 01.12.2022 | 02.12.2022

123 | 12.12.2022 | 16.12.2022
123 | 28.12.2022 | 30.12.2022

456 | 13.12.2022 | 13.12.2022

789 | 05.12.2022 | 09.12.2022
789 | 12.12.2022 | 12.12.2022
789 | 27.12.2022 | 30.12.2022

I can`t find useful function module, or solution of similar problem.
How can i solve this task? Any suggestions?

Re: Dates Agregation with gaps between days

FredericGirod — Thu, 19 Jan 2023 07:32:28 GMT

Code it yourself, it is not so difficult

shantraj6 — Thu, 19 Jan 2023 10:08:55 GMT

Sort the table and delete the adjacent duplicates.

Sort Itab by PERNR begda endda.
Delete Adjacent Duplicate from ITAB Comparing pernr  begda  endda.

FredericGirod — Thu, 19 Jan 2023 10:40:30 GMT

not working 01.12.2022 - 01.12.2022 and 02.12.2022 02.12.2022 should give you 01.12.2022 - 02.12.2022