Access sequence

[Former Member]

Hi!

I have some problem with the following customizing settings.

SPRO - Sales and distribution - Basic functions - Pricing - Pricing control - Define access sequences - Maintain access sequences.

Select first access sequence A001 - choose Accesses from the left side. In this table, which appears, there are 5 columns: AcNo, Tab, Description, Requirement, Exclusive.

What is AcNo and where does it come from??

[Former Member · Accepted solution]

hi Jaideep,

Ac no. is nothing but access no., you can give 10, 20 30..etc depending upon the no. of enteries you are making in access sequence.

thanks

[Former Member · Accepted solution]

Can you kindly explain the use of all the components of this screen?

[Former Member · Accepted solution]

Hi,

An access sequence is a search strategy that the system uses to find valid data for a particular condition type. It determines the sequence in which the system searches for data.

The access sequence consists of one or more accesses. The sequence of the accesses establishes which condition records have priority over others. The accesses tell the system where to look first, second, and so on, until it finds a valid condition record. You specify an access sequence for each condition type for which you create condition records.

There are some condition types for which you do not create condition records

(header discounts that you can only enter manually, for example). These condition

types do not require an access sequence.

A sales department may offer customers different kinds of prices. The

department may create, for example, the following condition records in the system:

A basic price for a material

A special customer-specific price for the same material

A price list for major customers

During sales order processing, a customer may, in theory, qualify for all three prices. The access sequence enables the system to access the data records in a particular sequence until it finds a valid price. In this example, the sales department may want to use the most favorable price for a certain customer. For this reason, it ensures that the system searches for a customer-specific

price.

As you are aware of the fields AcNo, Tab, Description, Requirement, Exclusive.

we need to first create the condition tables as shown below and include them in our access sequence such as:

10 Table no customer/material

20 Table no pricelist/currency/material

30 Table no. material

(check the relevant table no. and enter the no),

Requirement= this is a field to enter the routine no., which is developed by Abaper depending on your requirement.

Exclusive = Check this box, this will ensure that when these tables are accessed for price, the system will come out and not check the price of below tables if a valid condition record is found.

All the relevant tables are listed in the access sequence. they should be assigned in the sequence = Most specific to general. as shown above. table material is a general table which is applicable to all, where as table customer/material is more specific to a particular customer so its listed on top.

So, now suppose you have a pricing condition type PR00, and you maintain the above three table nos. ,then you need to go to VK11 and maintain the condition records for these tables. Now the system will search the first table and if record is found it will take the price else it goes to the next table.

Thanks.

[Former Member · Accepted solution]

Hi

Access Number is notheing but the serial number in which the tables should be read

Tab is the table for the condition table

Requirement is the requirement for the Pricing or for the Rebates

Eclusive sequence is the option where u can set the indicator where the access sequence will try to find the record for the table for that access number

[Former Member]

HI jaideep,

By Now u wud ve been pretty clear about the 'access sequence'. Only more thing that can be added here is use of 'requirement' field.

'Reqmt' in the access sequence acts as a pre-condition that shud be satisfied first and then only system can read the corresponding access(condition table entered in the access sequence). If that requiremnet is not satisfied, then system will exclude that access.

So the system wont read the access n wont search for the valid condition record for that access. Hence this field is used for the faster system responcse as the unnecessary reading ofthe data is avoided by it.

Hope this helps.

Regards,

Prashant

[Former Member]

AC No is access No. This is the sequence in which the tables will be accessed. Access Sequence is made up of Acesses & the last column is Exclusion Tick. If the Tick is maintained & once the condition record is found, then it will not check further access (tables). If the Exclusion Tick colunm is left Blank, whichever is last record found will be taken into consideration.

Regards,

Rajesh Banka