SD Pricing Condition Table

light111SD Pricing Condition Table Creation

 


In SD, pricing in order or billing, etc is calculated by the pricing procedure. The condition types in the pricing procedure may have a access sequence and the access sequence contains a sequence of condition tables. Each condition table contains a list of fields against which the condition record is created and the price is determined.

By standard SAP provides many condition tables whose number line between (001-500). And number from 501 to 999 can be used by the customer to create their own pricing condition table. 

The required fields which can participate in pricing, must be first added to the pricing field catalog and this can be done by enhancing 3 pricing structures: KOMG, KOMK and KOMP. Once the field appears in the pricing field catalog, then this can be added to the new condition table. 

The below post shows how to create SD condition table and generate it.


From below highlighted path, choose Define Condition tables.

19

Here 4 options appear. First one is to add pricing relevant fields to the field catalog and then 3 are for create/change/display condition table.

We can use this or we can use Tcodes for this:

OV24- Add fields to the pricing field catalog

V/03 , V/04, V/05- Create /Change/Display   Condition Table

20


 

Step 1- Execute tcode- OV24, Already few fields are added to the field catalog if new one required choose New Entries.

1

Press F4.

2

All fields from structure- KOMG, KOMK  & KOMP are listed below. If any one identified, just double click on it and it gets added to the pricing field catalog.

345


 

Step 2- Use tcode- V/03 to create a new condition table. Provide a number from 501 to 999 ( customer number range).

6

Here we will use- 989 and press ENTER key.

7

On the right side, all fields display from the field catalog. Double click on the field which are required for this condition table and it appears on the left side pane.

8

For this condition table : lets add: sales org, distribution channel, material and material group.

910

Once added, a developer can see the technical details by selecting the button Technical View.

11

Go Back.

12

Now time to generate the condition table.

13

Hit YES.

14

The log displayed. When a condition table is generated, in the backend a DB transparent table is created and this table is used to store the condition records. 

The log shows a table : A898 is generated.

15

The same table can be viewed from – SE11

16

 


The condition table created can be viewed from Tx- V/05 .

1718


 

Advertisements

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s