how to "group by" and display in separated table views

[Former Member]

What cloud be the approach to the following scenario:

1) A RFC returns a list of lot of invoices.

2 How to group by "customer code" and display in separated table views for each customer "group of invoices" ?

Is there a way to do this using VC or only using WebDynpro ?

thanks

[Former Member · Accepted solution]

Issac,

you dont hv to do this using dynpro. you can achieve this in vc by using the 'Filter' operator. from the output port of the rfc, feed the results to multiple filters. hv one filter for each segregation (for eg for each customer code). Then feed these filtered entries to the table views.

prachi

[Former Member · Accepted solution]

Hi Prachi,

Thanks for your response.

Maybe I am wrong, but the difficult to use the filter approach is the fact of the filed "customer code" contains unknowables values.

thanks.

[Former Member · Accepted solution]

Isaac,

I don't believe its possible to dynamically display varying no of tables or charts with vc (as of now)..am not sure what your requirement is, maybe you can consider having a drop-down of all customer codes (returned by ur rfc) and based on user selection feed this to the rfc as input and then display the relevant records of invoice.

prachi

[Former Member]

Hi Isaac,

you can definitly using VC. Your business logic must be in your rfc. The best - run businesses, oh sorry, the best is write more rfcs for grouping by "customer code" and so on.

Best Regards,

Marcel