Define Access Sequences

In this activity you define access sequences.

An access sequence is a strategy the system uses to search for valid condition records for a condition type.

For example, you can specify that the system should first look for a record for a specific material, plant and profit center, and then for a combination of plant and profit center.

Example

Access sequence Z001 for condition type KA01:

No.    Table       Name                          Condition    Exclusive
-----------------------------------------------------------------------
01     501         Plant/Material/Profit center                   X
02     502         Plant/Profit center                            X

Access sequence Z001 first looks for condition records stored with the key consisting of the combination "Plant/Material/Profit center". If no record is found for that combination, the system then searches for a record for the combination "Plant/Profit center".

If a record is found for a line where the field "Exclusive" is selected, the system stops reading data records.

Recommendation

If you define your own access sequences, you should give them a key that begins with the letter "Z". The standard R/3 system contains no access sequences in this name range.

To ensure that the first condition record found is used, set the "Exclusive" flag for each line. If you do not set this flag, the system adds the values for all the condition records found, which usually is not desirable for transfer pricing.

Activities

    1. Create new access sequences. Enter a key of up to four characters and a description.
    2. Enter the condition tables that you want to access using this access sequence in the order in which you want them to be accessed. Using the "Fields" function, you can display the field combinations for the individual condition tables.
    If you want the system to stop searching as soon as the first valid condition record is found for a particular condition type, select the "Exclusive" indicator. If you want to specify other conditions, you can make an entry in the "Condition" field.
    3. Save your access sequence.

Further notes

You must define and save your access sequence before you can assign it to a condition type and define condition records for it.