cancel
Showing results for 
Search instead for 
Did you mean: 

BRFPlus Feasibility

Former Member
0 Kudos

Hi All,

I need to know if the following requirement can be catered using BRFPlus or not. Trying to check the feasibility from last few days

1.Need to retrieve the 3 fields for one key field from a database table,

Key FieldField1Field 2Field 3
125AA
136BB
147CC

Table 1

Now need to fetch the highest priority field value from Field 3 and the priority table is as follows

Field 3Priority
AA1
BB2
CC3

Table 2

Now considering that AA is having the highest priority , it should be fetched from table 1.

Can it be catered using BRFPlus at all?

Thanks in advacne

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

in general you can use the DB lookup expression to fetch the data from the DB.

Concerning the second part of your question: it depends on how you determine the priority. Is this a field in the DB or is this determined within rules? Some more info would be appreciated

Cheers Christian

Former Member
0 Kudos

Hi Christian,

Thanks for the reply.

Field 3Priority
AA1
BB2
CC3

This part is decided within the rule.

Can you please guide how to achive it in BRFPlus?

Thanks in advance

0 Kudos

Hi,

ok now I understand your requirement completly: then I would determine the relevant priorities based on a decision table in multiple match mode that returns the Field -priority combinations as result columns which will result in a table.

In the next step you can use this table in order to determine the relevant entries you have to fetch from the database. I would guess that for some fields not all entries according to your priority might be available e. g. a prio 1 field (AA) might be missing in the database. So you have to iterate really all entries in the result table from your decision table. This is quite cumbersome using the DB lookup  and might lead to an performance issue as you have to do several selects in sequence. Hence, I would propose that you solve the requirement by using a procedure call and implement the selection logic itself in ABAP (class or function module). As Input parameter to that call you hand over the table with the priorities and as output of the call you return the desired data entry.

Cheers Christian

Answers (0)