pricing condition table

[Former Member]

hi all,

i am new into sap sd . i m trying to create condition table in pricing.

but when i enter table no and i m unable to get sales org , dist chennl, division, material, price list, and document currency.

pls any body help me to cretae condition table.

regards

vikas saini

[former_member217082 · Accepted solution]

Hi vikas

First of all go to V/03 and create a condition table with the combination sales orgn , dist channel, division, material, price list and then save it and then assign that condition table in the access sequence and select the condition table you have assigned and double click on the fields and check the fields and then save it .

If the fields are not there then go to OV24 and assign the fields and then create the condition table with those combinations

NOTE : check the fields are there or not before you create the condition table

Regards

Srinath

[Manoj_Mahajan78]

Hi..

You can change and maintain the condition tables in the standard system. You can also create new condition tables to meet the needs of your own organization. You create and maintain condition tables in Customizing.

From the initial screen of Customizing for Sales and Distribution, you reach the condition table screens by choosing Basic functions --> Pricing -->Pricing Control -->Define condition tables. Then select the mode you want to work with (create, change, display).

ou can create new condition tables to meet the pricing needs of your organization. When you create a new condition table, you select a combination of fields from the list of allowed fields. The selected fields define the key for the subsequent condition records.

Before you select the fields for the key, there are two things to consider:

• The sequence (or hierarchy) of the fields

• Which fields you want to appear in the header and item areas of the corresponding fast-entry screens

Important Fields

In sales, the fields you should take into consideration are Sales organization and Distribution channel. The sales organization is nearly always used as a criteria in pricing, because different sales organizations often want to use their own prices, discounts, and surcharges. If you use the sales organization as a criterion in pricing, you should also use the distribution channel. If you do not want to establish different prices, discounts, and surcharges for each distribution channel, use the field anyway. In Customizing for Sales, you can use one distribution channel as a reference for all others (thereby sharing the same pricing data).

Deciding the Sequence of Fields

The order of the fields in a condition table affects the performance of the system during pricing. Two general guidelines will help you create an efficient condition table:

1. If you select fields that are connected to the structure of your organization (for example, sales organization and distribution channel), assign the fields according to the level of general applicability: Put the most general field, for example, the sales organization in the highest position and the most specific field in the lowest.

2. After organizational fields, place fields from the document header before those that come from the item level. (For example, Customer comes before Material)

After you have selected the fields for the key on the screen where you maintain and define condition tables, choose F16 Generate to generate the table in the system. Generation prepares the condition table for storing condition data.

Regds

MM

[Former Member]

Hi there,

Condition tables are created in V/03. Give the table name. you will find 2 columns. The right hand side column is the field catalog. You willahve to select the required fields by double clicking on the fields. They will tehn be copied into the left hand column. Pls make sure that you have to select the tables in the same order for which you want to create the key comkbination.

For eg if you want to create a table with key combination sales org / customer / material, then you will have to select the fields in the same order.

Then click on generate table button. Pls note that customized tables are from 900 - 999. Save it.

Regards,

Sivanand

[Former Member]

Hi,

As to the missed fields you mentioned, before create the condition table, you should define the allowed field of condition, add these fields you want into the field catalog (Pricing Sales/Distribution). Then you can create the new condition table according to your request.

Good luck

Z.T

[Former Member]

Hi,

Double click on the field you want to select from field catelog availble on right side. After double clicking it will come on left side there after you can generate the table accordingly you want.

Rgds

San