In what dbtabs are BRF+ decision tables stored?

[Former Member]

I'm trying to determine in what dbtabs BRF+ decision tables are stored. I have tried performing a SQL trace while loading the decision tables, but all of the queries involved seem to be pulling from dbtabs related to administration and the data dictionary. Why is this so, and where are these decisions stored then?

I understand that part of the reason for BRF+ is to avoid using dbtabs for business logic, but I'm partly curious and partly would like to know should there ever be a need to do so. For example, perhaps I'd like to create a query that involves the decisions tables outside of the BRF+ application.

[carsten_ziegler · Accepted solution]

You should never work with the DB tables directly. The DB schema of BRFplus is very complex and usually people have no chance to understand how it works without hours of debugging. Also, we may change the DB layout at any time without prior notice. Use the API instead of the DB.

[kakshat]

You can try looking through the objects in the associated transport request (of course, if your BRF+ application is not local). I think the database tables have the string FDT in them.

Also, I think I remember a similar question asked some time ago on SCN. Maybe you can try to search again.