Simple Tables in BRF+

[former_member584734]

Hi,

We developing rules using BRF+ and as part of the rules we have requirements to store tables with more than 5000 rows.

These tables are simple data tables - key and value combinations.

In BRF+ we are having model these as decision tables. Since the access/read technique for decision tables seem to be sequential , the performance of the table read varies significantly based the location of the particular entry/key. Keys in the end of the table take longer than keys/data elements at the beginning.

The queries we have are as follows

Is there a data object which resembles a simple table ? or Are Decision tables the only data object which can be used to model tables in BRF+ ?

We also find that in cases where we use a simple ABAP table and use DBLOOKUP in BRF+ , the performance is significatly better. So is this the recommended approach or are there other options sing which we can store and read data efficiently in BRF+ ?

Thanks in advance!

Cheers

SS

[carsten_ziegler]

In case it is just lookup (no cell range logic) and given the number of entries I recommend to do this with a DB table and a DB lokkup (using buffering).

A decision table also has some optimization. So it is not purely sequential. It depends on your SP to what degree you can use those features (will be used automatically, no manual config required).