2023 Jan 19 7:29 AM
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?
2023 Jan 19 7:32 AM
2023 Jan 19 10:08 AM
Sort the table and delete the adjacent duplicates.
Sort Itab by PERNR begda endda.
Delete Adjacent Duplicate from ITAB Comparing pernr begda endda.
2023 Jan 19 10:40 AM
not working 01.12.2022 - 01.12.2022 and 02.12.2022 02.12.2022 should give you 01.12.2022 - 02.12.2022