Skip to Content
0

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

Jan 28 at 06:42 AM

99

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Christian Lechner Moderator SAP Mentor Jan 31 at 09:31 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded