We can maintain the condition records in mass VK31.
Path:
Logistics
Sales and Distribution
Master data
Conditions
VK31 – Create
You can make changes for prices, discounts / surcharges, freights and taxes conditions.
Copying Condition Records
The copying function allows us to create multiple condition records at a time. We can copy either one or more existing condition records into a new condition record or we can create a new condition record and use it as a base for copying condition records all in one step. We can copy condition records even when source and target records have different condition type‟s condition table‟s key field values.
Pre – Requisites: Only one table may differ between two condition fields. The condition table must contain same number of fields.
Copying Rules
The rules are defined in IMG for sales and they must need the pre – requisites listed above.
Path:
IMG
Sales and Distribution
Basic functions
Pricing
Copy control for conditions
Copying rule for condition type Copying rule for condition Examples of different scenarios:
Scenario 1: Same condition types and same condition tables Special discount to a particular price group.
(A group of customers in VD01) in this case condition type “K020 – Condition table 20” are identical for both source and condition records.
Scenario 2: Same condition types and different condition tables
If PR00 has access sequence of PR02 to which number of tables are assigned.
It means condition records with same condition type can have different keys. We can copy condition records where condition type is the same but condition tables are different.
Ex: Material specific discount to a particular price group (K032 is the condition type – 32 is the condition table) we can copy this condition record for a specific customer [K032 – 5] (K032 is the condition type – 5 is the condition table).
Scenario 3: Different condition types different condition tables
Ex: K020 – 20 (K020 is the condition type – 20 is the condition table) to another price group but to a new customer specific discount K007 – 7.
Configuration Steps:
In VD01 for two customers maintain the data like below:
Customer No. Customer Group Price Group (for K020)
X 01 01
Y 02 02
Maintain the condition record for K020 for 01 – 01 combination in VK31
SD Material
121
Go to VA01 and raise the sales order for customer “X” (01 – 01 combination) and Go to item condition screen
Check whether K020 value has been accepted or not (system accepts because already we maintained the condition record)
Go to VA01 and raise the sales order for customer “Y” for (02 – 02 combination) Go to pricing condition screen and check K020 value has been taken or not (System does not take it) because we did not maintain condition record
Go to VK32
Select discount / surcharges By price group
Specify K020 and price group as 01 Click on copy condition / select rule button Then system copies it to the new group Save it
If you want to delete the condition
Go to VK12
Select the condition item
Click on delete row icon
Click on undo icon
Condition Index: We can create condition index to maintain the condition records for prices, surcharges and discounts.
In SAP standard condition indexes are 0001 for Material 0002 for Customer
By using these two indexes we can select the condition record for a specific customer & specific material.
We can define our own condition indexes for each condition type and before using condition index must be activated in IMG.
We can create the condition index by copying the existed condition index.
We can choose the fields from field catalog to create condition indexes and we can include new fields into the field catalog.
Create condition indexes by using condition tables 501 to 999.
Generated condition index (system automatically activates it)
In the field condition index on the details screen of the respective condition type, select the condition types to be taken into account for the condition index.
Re – Organization of Standard Indexes
We must reorganize condition indexes in the following cases:
We must create a new condition index and we want to set it up for existing condition records. If we want to change an existing condition index and we want to set it up with current condition records.
Steps: Enter a condition index or interval of indexes.
And then enter the date and time when the condition indexes are updated.
Pre – Requisite: In V/06 condition type condition index option should be activated.
Transaction code: OV09 Path:
IMG
Sales and Distribution
SD Material
122
Basic functions
Pricing
Maintain condition index
Maintain condition tables for index
Choose condition tables from field catalog Ex: Sales Org, Distribution Channel, and Division
Click on generate icon
Click on local object
Come back
Save and Exit
Transaction code: V/I1
Click on activate of condition index
Check whether system has activated condition index or not Save and Exit
Go to V/07
Choose access sequence Ex: K004 Go to new entries
Include our condition index Save and Exit
Go to V/06 Choose K004
Check condition index and condition update has been activated or not
Go VK11
Choose our condition table Maintain condition record Save and Exit
Go to VK12
Click on select using index option Select our condition table
Click on execute icon Do the changes accordingly Click on details icon
Maintain the lower limit and upper limit, if we want to maintain the limits Go to button Additional data
Maintain limits for pricing like below:
Maximum condition value INR
Maximum number of orders
Maximum condition base value EA
Maximum Condition Value: We can specify the maximum condition value for this condition type. So that when system reaches that maximum value, then automatically it terminates the condition type.
Maximum Number of Orders: We can specify maximum number of orders E.g. 3; system will accept this condition type only for first 3 sales orders. 4th sales order onwards system world not take this condition type.
Maximum Condition Base Value: We can specify the maximum condition base value for the condition record.
SD Material
123
Ex: If certain discount offer to the customer with a limited number of cases, then we can specify the number of cases in this field. When the systems reach this value, system automatically terminate this condition type.
Cumulative Values: When system updates the values according to the limits for pricing fields, we can see the status of updating by going to Extras Cumulative values option Save and Exit.
Go to VA01 and raise the sales order for 3 times.
Check whether system has taken K004 or not
Go to VA01 for 4th time and check whether system has taken K004 or not.
Pricing Condition Report
We can generate report for prices, discounts, freights, and taxes.
Pre – Requisites: For respective condition type, condition update and index should be activated in definition of condition type. That means condition table for condition index should be defined and maintained.
Configuration Steps Transaction code: V/LA
Path:
Maintain pricing report
Create pricing report
Specify the name of List [ ] and Description [ ]
Choose the fields that we have selected to create condition index
Ex: Sales organization, Distribution channel, Division, Material, Customer, etc.
Go to edit
Choose continue with AND
Select our condition table that we have created for condition index
Click on continue arrow
Choose report header level, item level layer
Select default values for the selection screen Ex: Display scales and display validity period
Save and Exit
Run the Pricing Report Transaction code: V/LD
Path:
Logistics
Sales and Distribution
Master data
Information Systems
Condition & Pricing
Pricing Reports
Specify pricing report [A1]
Click on execute icon
Again click on execute icon
Specify the values in the selection screen
Execute
SD Material
124