Usages of ‘Exclusive’ Indication in SAP Access Sequence

What is an Exclusive Indicator in SAP Access Sequence?

Basic Understanding Pricing Condition Technique.

With an Exclusive indicator and how does the system behave?

Without an Exclusive Indicator and how does the system behave?

What is an Exclusive Indicator in SAP Access Sequence?

The exclusive flag is an indicator that instructs the condition technique whether it should stop searching condition records after finding the first successful records for a condition type within an access sequence.

Basic Understanding Pricing Condition Technique in SAP SD.

• When we create a sales order in SAP before entering any material code system determine the Pricing procedure at the header level. 

• After filling the material code and quantity in that sales order, the system accesses that pricing procedure and checks each and every condition type whether any applicable condition value is available or not. 

• To get the condition value system finds the Access Sequence of that condition type tries to read tables of that access sequence. 

• Once it finds a condition record for any condition type, the condition technique works for subsequent or next condition type. 

After finding a successful record for PR00, the system tries to find the next condition type. 

With an Exclusive indicator and how does the system behave?

If the exclusive indicator is activated in the access sequence, the system will not consider subsequent remaining table 406, 304 records once it found a matched valid condition record from 305.

For condition type PR00 we have condition records for the below three condition tables. 

You can see the system only displays the first condition table condition record value. 

You can see the system only consider the condition record value of the first condition table.

But the condition technique did not access the next table condition record. 

Without an Exclusive Indicator and how does the system behave?

Now against these tables remove or uncheck Exclusive Indicator. 

For this case, the condition technique will validate or check all tables against an exclusive indicator not activated of that access sequence even though successfully any condition record is already found. 

In another case of Discount Access Sequence, Exclusive is unchecked against all tables. 

For the K007 condition type, you can see it appears twice with different discount percentages. 

From the above example, we can see the exclusive check box in the access sequence plays a vital role to determine the valid most suitable condition record for any condition type and improve system performance. 

Details Vlog of this article:- Usages of Exclusive Indicator in SAP Access Sequence

Join Our SAP SD LinkedIn Group