Skip to Content
avatar image
Sune Vadsholt Lyster

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

Jan 28, 2017 at 06:42 AM | 400 Views

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?

brfplus-db-lookup-options.png (43.0 kB)
NW ABAP Business Rule Framework (BRFplus)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Christian Lechner
    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

    Add comment
    10|10000 characters needed characters exceeded