Merge of records in internal table

Hi,

I have this question for you:

I have a problem with some data in an internal table that is to be shown in a view in a special way.

As it is, the data is read directly from the table into an internal table and outputs from that internal table.

Data can look like this:

ID Valid From Valid To

B000001 30.11.2009 10.12.2009

B000001 11.12.2009 21.12.2009

B000001 22.12.2009 27.02.2010

B000001 28.02.2010 13.04.2010

B000001 14.04.2010 31.12.9999

This dataset has no breaks in the interval as it can happen. But this data has to be viewed only as ONE line like this for the whole time interval:

ID Valid From Valid To

B000001 30.11.2009 31.12.9999

On the other hand we can have records for the view with a break in the date interval like this:

ID Valid From Valid To

B000001 01.01.2009 31.03.2009 Here is the gap from 31.03.2009 to 02.05.2009

B000001 02.05.2009 31.08.2009

B000001 01.09.2009 31.12.2009

This data has to be shown like this:

ID Valid From Valid To

B000001 01.01.2009 31.03.2009

B000001 02.05.2009 31.12.2009

One record for each interval when we have a time interval break.

All data is in the lt_mdm internal table.

Any ideas ?