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?
Best Answer
Jan 31, 2017 at 09:31 AM
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