cancel
Showing results for 
Search instead for 
Did you mean: 

Condition tables

p391977
Contributor
0 Kudos

If in a access sequence if three condition tables are there. And in that if for all i have maintained condition records which one it will take into consideration.

Accepted Solutions (1)

Accepted Solutions (1)

Shiva_Ram
Active Contributor
0 Kudos

Hi,

The system will go through all the tables.

Depending on how the access sequence is set-up with exclusive indicator, the system will fetch the values.

For example, if the first row is set with this indicator, and if there is a value for this table, the system fetch this value and it will not go to the next table in the sequence.

If there is no exclusive indicator is set at any tables, then the system will pull the last record as it goes to the third row also.

Regards

Answers (2)

Answers (2)

former_member550050
Active Contributor
0 Kudos

HI

If three condition tables are there and if no exclusive indicator is set all three records will be displayed by the system and the last one that is third one will be taken for calculation

You can see that by the active record third one in green indicator and the previous two records with yellow indicator with a note that these two are not considered because of the subsequent record

Raja

Edited by: ramanathan raja on Sep 4, 2008 12:35 PM

former_member184555
Active Contributor
0 Kudos

Hi

There is every chance that all the three condition tables may have valid condition records. That is the reason why while arranging the tables we are supposed to follow 'most specific to most general' policy and also using the exclusion indicator functionality.

The system searches for the valid condition record in the first access(first table) and it has a valid record and if the exclusion indicator is set, then it stops searching and determines that record in the order. If the exclusion indicator is not set, then it continues to search in the next access also.

Thanks,

Ravi

p391977
Contributor
0 Kudos

but which one it will choose for pricing procedure calculation