Reduction of records in WD view

[former_member210563]

Hi,

Question 1:

I have a View that shows data like this:

Cust.No Valid From Valid To

P000333 30.11.09 10.12.09

do. 11.12.09 21.12.09

do. 22.12.09 27.02.10

do. 28.02.10 14.04.10

This is 4 records for the same customer and I only want the view to show ONE record like this:

Cust.No Valid From Valid To

P000333 30.11.09 14.04.10 (just one record for the whole time interval)

How can I do that in a WD View ?

Question 2:

I also have more records shown where I have a break in the date interval like this:

P000333 30.11.09 10.12.09

do. 11.12.09 17.12.09 Here is a break of 5 days to the next one on the 22.

do. 22.12.09 27.02.10

This shoul be only 2 records:

P000333 30.11.09 17.12.09

do. 22.12.09 27.02.10

Any suggestions to how to Modify the Web Dynpro View is appreciated.

Thanks.

[Former Member · Accepted solution]

Hallo Peter,

if i were you , i wouldnt attempt to do that in WebDynpro (view). i rather use the model (Class/Function module) to supply the necessary data to the webdynpro.

In your case, you probably receive the data from function module or class to populate the data.

You can write a new abap class which would implement your logic after retrieval of the data and supply the data to webdynpro for presentation.

For example:

Cust.No Valid From Valid To

P000333 30.11.09 10.12.09

do. 11.12.09 21.12.09

do. 22.12.09 27.02.10

do. 28.02.10 14.04.10

Your newly implemented method should loop through the original table and create a local table with your logic applied.

new table contains a row

P000333 30.11.09 14.04.10

go on like this appending the table rows for all customers and later bind this newly created table to your context node on which Table UI has binding.