Skip to Content
0
Former Member
Jul 31, 2012 at 09:52 AM

how to select overlaping rows in table ?

150 Views

hi,

i have the following request:

there is a table with 3 fields:

date from

date to

text

i have the following rows for example:

20120101 20120115 ABC

20120504 20120505 XXX

20120801 20120820 ABC

20120103 20120105 ABC

i have to find out overlaping date-ranges within the same text.

so i the example i need to 'mark' (put it into an list-output) row number 1 and 4. there i have the text ABC and

the date from and date to is overlaping. So i have to now where AT LEAST one day is overlapping.

How to achieve this in abap ?

br, Manfred