Access sequence

[Former Member]

Hi All,

If i have six tables,all with two field entries.How would i get to know which table is most specific and which is most general.

For eg

Customer/Material

Division/Customer

Price group/Material

Customer/Incoterms

Thanks in advance

Rishi Balani

[Former Member]

First of all in real time you will not maintain the condition records in all the 6 tables

The rule of most specific to most general is more for configurators and consultants like us rather than to the system

We should maintain condition records in the most specific tables according to the business scenario

Usually the most specific table is kept in the first step and exclusive indicator is marked so that we get most precise condition

Alligning of steps will make the system performance better with exclusive marked so that it need not waste more time in executing unnecessary accesses

In your case the record in the last table will only get picked up for calculation as the system rule of most specific to most general is applied here

But the system doesnot know which is most specific and most general because all tables you have treated with equal importance