Skip to Content

BRFPlus Feasibility

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 Field Field1 Field 2 Field 3 1 2 5 AA 1 3 6 BB 1 4 7 CC

Table 1

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

Field 3 Priority AA 1 BB 2 CC 3

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 18, 2015 at 11:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.