BRFplus DB Lookup with Multiple Conditions (WHERE... IN)

[former_member348835]

I have a set of entries in internal table A.

Due to performance issues, I now want to make a single DB Lookup of table B with one column in table A as a filter. In SQL:

• SELECT attributes FROM TABLE_B WHERE attribute1 IN TABLE_A

How do I make the "WHERE IN" condition or a workaround enabling a single lookup?

[christianlechne · Accepted solution]

Hi Sune,

unfortunately, it is not possible to model the IN condition in the DB look up expression. I do not know what table A and B look like and how the data in table A is retrieved, but I see two options:

• Do the select in ABAP (class with static method) and use a procedure call expression to call the ABAP code in BRFplus
• Model an ABAP CDS View to do the select and then query the CDS view with a simple DB look up expression

Hope that helps

Best regards

Christian