Lookup with BRM Decision Table - Maximum size

[former_member189240]

Hi All,

We are planning to move all the lookups from Database table to BRM Decision Table. We have several lookup tables currently, each having several 1000s of entries. Wondering whether BRM is the right choice for our case.

Is there any maximum size for Decision Table and limit on the no of decision tables in BRM.?  Both PI and BRM on same instance.

Locating and editing a value in a large decision table of 2000+ entries may be difficult for the business user in Rules Manager perspective. As far as I explored, I dont think there is a search/filter option in Rules Manager Decision table to locate the value. Is there any easy way for it?

Regards,

Bibin

[Former Member]

Hi,

If a ruleset contains a big Decision Table, then it is suggested that you only have one Decision Table per Ruleset

as, when a ruleset is invoked then the whole ruleset will be loaded into the memory and if we have more than one

huge Decision Tables in that ruleset, all those Decision Tables are loaded which might affect the performance.

check Gguide lines in link: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0c2010e-49ca-2e10-1eab-f64fab153...

Also while checking maximum size for Decision Table, we also need to consider

the maximum size of the generated ABAP class.The class will hold not just the DT but the entire contents of the function.

Also check DSM option for your requirement.

Regards,Prasanth