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.
Shiva Ram replied
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.