This chapter is a sample excerpt from The Ultimate SAP Pricing Guide by 20-year SAP Pricing expert Matthias Liebich, which is now available on Amazon.com. For more info, check out SAP Pricing Guide reviews on Amazon.

The Access Sequence represents a search strategy for finding a valid Condition Table. In Chapter 1.1 we defined the key combinations by which prices, discounts or surcharges are set up. A price can be set up by a number of different key combinations.

The Access Sequence determines the order in which the pricing Condition Technique looks up valid pricing Condition Tables.

In order to review existing Access Sequences, access IMG path SPRO-> Sales and Distribution-> Basic Functions-> Pricing-> Pricing Control-> Define Access Sequences. In the following pop-up, select "Maintain Access Sequences." On the next screen (see Figure 1.2.1), all available Access Sequences in the standard SAP system are displayed with their description.

To create a new Access Sequence, click on the "New Entries" button and enter a new four-character Access Sequence name. The first letter of the Access Sequence should be a "Z" to protect it from being overwritten during system upgrades. Enter "ZR01" for the Access Sequence and a description in field "Description." The "Ty" field should be left blank for pricing Access Sequences (see Figure 1.2.2).

Select the line for "ZR01" and double-click on the "Accesses" folder in the left window pane. Since we are creating a new Access Sequence, no Condition Tables will be displayed initially in Figure 1.2.3. Click on the "New Entries" button on that screen and enter the Condition Tables for this newly created Access Sequence.

Column "No." (called "AcNo" in prior SAP release ECC 6.0) indicates the sequential number of the Condition Table in the Access Sequence. The most specific Condition Table key should always be listed first, going from the most specific to the most generic one. In case of the "ZR01" Access Sequence (see Figure 1.2.3), the Condition Table including customer and material determines a more specific price than the last Condition Table in the sequence, which is material.

Enter the Condition Table number in the "Tab" column. By entering the number here, all fields of the Condition Table will be pulled into the Access Sequence. The description of the Condition Table is automatically displayed in column "Description." The same Condition Table can be listed more than once. This is useful when a Condition Type can be priced by different partner types, like Sold-to, Ship-to or Payer. There is no need to create separate Condition Tables for that. Different partner types can be assigned in the next configuration step.

The "Requirement" column allows the addition of pieces of ABAP code that controls whether a Condition Table can apply under certain circumstances or not. I will go into more detail about requirements in Chapter 1.4.

The use of the "Exclusions" column improves system per-formance by selecting it for each Condition Table in the Access Sequence. The system will stop looking for valid Condition Records after finding a valid one in its Access Sequence search, if this field is selected.
For our example, enter the Condition Tables as indicated in Figure 1.2.3.

To see which fields are populating the Condition Table in the Access Sequence, select one Condition Table (for our example, table "663") and double-click the "Fields" folder in the left window pane.

The DDIC field names of the source fields of the Condition Table are displayed in Figure 1.2.4. DDIC table "KOMK" indicates fields from the document Header, "KOMP" from the document line item. If you would like to change the source of a field, select the respective line of the field you want to change and click on the "Field Catalog" button. The Field Catalog, as discussed in Chapter 1.1, is displayed in Figure 1.2.5 where you can select the desired field.

For example, the field in the Condition Table is "Customer." The default source field is "Sold-to." If you want to change the source to be the "Ship-to" number, select field "KOMK-KUNWE" (see the framed fields in Figure 1.2.5). Of course, the selection of the source field has to make sense: you don't want to select material number as the source for the customer number.

If a value is entered in column "Spec. Val. Source" (see Fig-ure 1.2.4), it becomes the default value for this Condition Table field during pricing on a document. This default value over-writes the value that would normally originate from the source field.

It is important to get to the field level for every single Condition Table in the Access Sequence, even if no source fields are being changed. The Access Sequence will not work if this step is missed.

After going through the field level step for all Condition Tables, save the Access Sequence.

<Previous   Back to main   Next>

This chapter is a sample excerpt from The Ultimate SAP Pricing Guide by twenty year SAP Pricing expert Matthias Liebich, which is now available on Amazon.com. For more info, check out SAP Pricing Guide reviews on Amazon. You can also check out Jon Reed's video interviews with Matthias on SAP Pricing careers and his podcast on how to use the Ultimate SAP Pricing Guide to become a successful SAP Pricing consultant.