How to create new condition table and access sequence

[Former Member]

Hi Gurus,

I'd like to ask for the steps on how to create condition table and access sequence and transport it to production box or quality box. I've been getting missing condition table whenever I transport their workbench requests to different clients.

Thanks,

Paul

[Former Member]

you should make sure that the assignment of condition table and access sequence is correct. dont disregard the warning message that it is not yet assigned.just continue pressing enter until the line is gray.

[Former Member]

Hi John

Check out in this link

http://help.sap.com/erp2005_ehp_03/helpdata/EN/dd/5616b2545a11d1a7020000e829fd11/frameset.htm

Regards

Srinivas.

[Former Member]

Hi,

Check for condition type which you are transporting is Man/Manul ? Best practsie it should be mandetory.

Use Tcode v/06 , check access sequence for the same.

Use t code V/07 for same access seuence , to check for access no condition table is present.

Use t code v/05 to create condition table as per required fields.

If any issue, pl communicate.

Rajesh

[Former Member]

Hi there,

Ofr pricing go to T-code V/03 to create a condition table. On the right hand side you will have a field catalog. Select the required fields. For eg you want to create a condition table with the combination sales org / customer / material.

In V/03 from the right hand side, select sales org, customer, material in the same order. Then click on generate table button to create the button. To create the table you need to have the acess keys. So when you save it, system willl ask for an access key. Keyin the access key & save the TR transport request.

Likewise create the tables customer / material as per your requirement.

Then in V/07, create the access sequnece. Access sequence is nothing but the search criteria how the system checks the various condition tables.

For eg in the above eg you have defined 3 tables sales org / customer / material, sales org / customer & sales org / material. Access sequence is always be default from most specific to more general. So in V/07, put the condition tables in that order. So your access sequnece Z001 will have the below tables:

1. sales org / customer / material

2. sales org / customer

3. sales org / material.

Against each sequenec there is a field called exclusive. If you select that field, system will not check the next condition table if it finds the records in the current table. For eg if the system finds valid condition records in sales org / customer / material, it will not check in sales org / customer table. If exclusive is not checked, then it will check in the next table as well. In the above case if condition records are maintained for all the above table combinations, then it will take the value from the last table sales org / material. So it is always advised to check the exckusive indicator.

After you create the acess sequnece do the field initialization. On the left side of the access seq screen, you will have an option "Fields". Click that sothat condition table fields will be initialized.

Then you will get a TR after you save the changes.

In SE09, 1st release the lower level task. Against every TR press the + button which will take to the lower level task. 1st release that & then release the main TR. You will find a tick mark after the TR is successfully released.

Then in STMS, select the relevant SAP box to go to the inport queue. Select the TR from the list & click on release button to release the TR into the TEST box. This process is if consultants themselves transport the TRs.

In many companies you will give a list of TRs to the BASIS people who will inturn release them into the TEST server. Once the TR is transported, in STMS import list, you will find a green color tick mark. It will indicate that the TR is successfully imported into TEST system / PROD system.

Regards,

Sivanand

[Former Member]

hi

you can create tables and access sequence through T-code V/03 and V/07.

after transfering the request for condition table to different servers click on generate tables tab in T-code v/03 in respective servers .

hope thiss will resolve ur problem

in case of any doubt do revert back.

regards

chander

[Former Member]

Hi,

thanks for the input but it's not working still. even after creating condition record for a condition type (Z001), during order entry, its not picking up the value. when I checked the analysis tab, I get this message: Fields for access Z001 11 missing (Pricing Sales/Distribution).

Any idea?

Thanks,

Paul

[Former Member]

Hi there,

After defining the access sequence, you have to initialise the fields. On the left side screen in V/07, you will find a filed called "Fields" Click that & initialise the fileds. Only then your access sequence works.

Regards,

Sivanand

[Former Member]

Hi,

please go through,

Pricing Procedure

In SD, Pricing Procedure is determined based on Sales Area (Sales Organization + Distribution Center + Division) + Customer Pricing Procedure + Document Pricing Procedure. Sales Area is determined in Sales Order Header Level. Customer Pricing Procedure is determined from Customer Master. Document Pricing Procedure is determined from Sales Document Type / Billing Type (if configured). Once the pricing procedure is determined, Condition records are fetched. If appropriate condition records are found, the price is determined. If Mandatory pricing condition is missing, system will through an error message.

In SD, the steps to configure Pricing procedure are as under:

Step 1:

Condition table: If existing condition table meets the requirement, we need not create a new condition table. Considering the requirement for new condition table, the configuration will be done in spro as follows:

IMG u2013> Sales & Distribution u2013> Basic Function u2013> Pricing Control u2013> Condition Table (select the required fields combination, which will store condition record).

Step 2:

Access Sequence: If existing access sequence meets the requirement, we need not create a new access sequence. Considering the requirement for new sequence, the configuration will be done in spro as follows:

IMG u2013> Sales & Distribution u2013> Basic Function u2013> Pricing Control u2013> Access Sequence (Access sequence is made up of Accesses (Tables) & the order of priority in which it is to be accessed. Here we assign the condition table to access sequence.

Step 3:

Condition Type: If existing condition type meets the requirement, we need not create a new condition type. Considering the requirement for new condition type, the configuration will be done in spro as follows:

IMG u2013> Sales & Distribution u2013> Basic Function u2013> Pricing Control u2013> Condition Type. It is always recommended to copy an existing similar condition type & make the neccessary changes. Here we assign Access sequence to Condition type.

Step 4:

a. Pricing Procedure: It is recommended to copy a similar pricing procedure & make the necessary changes in new pricing procedure. Pricing Procedure is a set of condition type & arranged in the sequence in which it has to perform the calculation. Considering the requirement for new Pricing Procedure, the configuration will be done in spro as follows:

IMG -> Maintain Pricing Procedure.

b. Pricing Procedure: After maintaining the pricing procedure the next step will be determination of pricing procedure. Configuration for determining pricing procedure in SPRO is as follows:

IMG -> Determine Pricing Procedure.

5. Condition record: Condition record is a master data, which is required to be maintained by Core team / person responsible from the client. During new implementation, the condition records can be uploaded using tools like SCAT, LSMW, etc.

Best regards,

venkataswamy.y