Filter a Second Table View based on Values contained in First Table View

[Former Member]

Hello Forum Members,

I am trying to delete values in a Table View that are not contained in another Table View.

First table view contains master data values filtered by an attribute value selection (Say Company Code by Country ).

Second Table View contains a larger list of Company Codes.

I want to Filter the Second Table View to values only contained in First Table View (i.e. Delete them ) .

I have tried the various Operators (Filter, Union, Aggregate) but none seem to allow me to filter as I want. IOW, I would like to see an Operator that provides the Intersection of two tables. How can I accomplish this?

Another thought, can the Select and Delete events be configured to delete the unwanted records?

I appreciate all your ideas!

ATC

Edited by: Alan Clark on Nov 4, 2010 7:18 PM

[Former Member · Accepted solution]

Hi Alan,

To get the data for Second Table View contains a larger list of Company Codes, I would write query/bapi for which the input parameter would be the values selected in first table. (If you are working with BI as backend, it would much simpler to give filter values to bi query and get only required data for second table view)

Regards,

Vinay

[Former Member · Accepted solution]

Yes,

Two Methods:

1) Write Bapi that accepts two tables and returns a table with the intersection

2) Filter one query with the values of another.

Sorry for the late response.