Pricing & Condition ________________________________________________________________________
SD PRICING PRICING
_____________________________________________________________________ 1
[email protected]
Pricing & Condition ________________________________________________________________________
Codes Transaction Codes
5 5
Definitions Definitions
7 7
The Condition Technique in Pricing
9 9
Create Condition Table Table
15 15
Create Access Sequence Sequence
21
1. Maintain Access Sequence Sequence
22 22
2. Optimize Access Sequence Sequence
26 26
Create Condition Type Type
29 29
1. Maintain Condition Type Type
31
2. Define Upper/Lower limits for Conditions Conditions
35 35
3. Check Settin Setting g for Condition Types Types
37 37
Record Condition Record
39 39
1. Maintain Condition Record Record
40 40
2. Main for Condition Condition Mai ntain n n tain Scale for
43 43
3. Tracking Cumulative Cumulative Value with Condition Update Update 47 47 Maximum Value Value
48 48
Maximum Quantity Quantity
50 50
Maximum Number of Sales Order Order
53 53
Procedure Pricing Procedure
56 56
1. Maintain Pricing Procedure Procedure
59 59
2. Define Customer Pricing Procedure Procedure
62 62
3. Define Document Pricing Procedure
64 64
4. Assign Document Pricing Procedure to Order Type Type 67 67 5. Assign Document Pricing Procedure to Billing Type Type 68 68 6. De Define fine Pricing Procedure Determination Determination
69 69
7. Check Setting for Pricing Procedure
71
_____________________________________________________________________ 2
[email protected]
Pricing & Condition ________________________________________________________________________
Codes Transaction Codes
5 5
Definitions Definitions
7 7
The Condition Technique in Pricing
9 9
Create Condition Table Table
15 15
Create Access Sequence Sequence
21
1. Maintain Access Sequence Sequence
22 22
2. Optimize Access Sequence Sequence
26 26
Create Condition Type Type
29 29
1. Maintain Condition Type Type
31
2. Define Upper/Lower limits for Conditions Conditions
35 35
3. Check Settin Setting g for Condition Types Types
37 37
Record Condition Record
39 39
1. Maintain Condition Record Record
40 40
2. Main for Condition Condition Mai ntain n n tain Scale for
43 43
3. Tracking Cumulative Cumulative Value with Condition Update Update 47 47 Maximum Value Value
48 48
Maximum Quantity Quantity
50 50
Maximum Number of Sales Order Order
53 53
Procedure Pricing Procedure
56 56
1. Maintain Pricing Procedure Procedure
59 59
2. Define Customer Pricing Procedure Procedure
62 62
3. Define Document Pricing Procedure
64 64
4. Assign Document Pricing Procedure to Order Type Type 67 67 5. Assign Document Pricing Procedure to Billing Type Type 68 68 6. De Define fine Pricing Procedure Determination Determination
69 69
7. Check Setting for Pricing Procedure
71
_____________________________________________________________________ 2
[email protected]
Pricing & Condition ________________________________________________________________________
Define Pricing by Item Categories Categories
7 72 72 2
Maintain Price Price- Field - Relevant Master Data Field
78 78
1. Define Price List Categories For Customer Customer
79 79
2. Define Pricing Groups for Customer Customer
81
3. Define Material Group Group
83 83
Maintain Pricing Reports Reports
86 86
Condition Exclusion Exclusion
93 93
1. Condition Exclusion for Groups Of Condition
93 93
2. Condition Exclusion for Condition Types and Records Records 102 102 Agreements Pricing Agreements
104 104
Promotion Define Promotion
107 107
Deals Set up Sales Deals 1. Define Sales Deals Deals
110 110 110 110
2. Condition Type Group Group •
Condition Group Co ndition Type Group
•
Assign Condition Type/ Table Condition Type Group 116 Group 116
•
Assign Condition Type Groups/Sales Deals Deals
Questions & Answers Answers
114 114 118 118 121
_____________________________________________________________________ 3
[email protected]
Pricing & Condition ________________________________________________________________________
Pricing is on of the important topic of SD module. Once you understand this concept it is been easy for you to grip other SD topic. Go this topic twice and thrice until you are not clear with this concept. Read sap pdf file and Explain each fields of 1. Condition Type 2. Pricing Procedure Gone through the above files and you will have clear idea about pricing.
_____________________________________________________________________ 4
[email protected]
Pricing & Condition ________________________________________________________________________
Transaction T ransaction Code Code T ransaction V/03
Create Condition Table
V/04
Change Condition Table
V/05
Display Condition Table
V/06
Create/Change & Display Condition Type
V/07
Create/Change & Display Access Sequence
V/08
Create/Change & Display Pricing Procedure
VK11
Create Condition Record
VK12
Change Condition Record
VK13
Display Condition Record
OVKP
Define Customer Pricing Procedure
OVKI
Define Document Pricing Procedure
OVKJ
Assign Document Pricing Procedure to Order Type
OVTP
Assign Document Pricing Procedure to Billing Type
OVKK
Define Pricing Procedure Determination
OVSI
Define Price List Categories For Customer
OVSL
Define Pricing Groups for Customer
OVSJ
Define Material Group
OV31
Define Condition Exclusion Groups
_____________________________________________________________________ 5
[email protected]
Pricing & Condition ________________________________________________________________________
OV32
Assign Condition Type to Condition Exclusion group
VOK8
Maintain Condition Exclusion for Pricing Procedure
OVB2
Define Upper and Lower limit for condition
OVK0
Active pricing for item categories
_____________________________________________________________________ 6
[email protected]
Pricing & Condition ________________________________________________________________________
Definition Definition Condition Table: Table: A Condition table defines the combination of fields (the key) that identifies an individual condition record. Access Sequence: Sequence: An access sequence is a search strategy used to find valid data for a particular condition type. Condition Type: Type: It is price element and it has character like value, quantity, surcharge or discounts. Condition Record Record A condition record allows you to store and retrieve dada. All prices, discounts and surcharges for automatic pricing must be stored in condition records. Pricing Procedure: Procedure: A pricing procedure is used to define a group of condition types in a particular sequence. It determines which subtotals appear during pricing. It determines witch bases the system uses to calculate percentage discounts and surcharges. It determines to what extent pricing can be influenced manually. Condition Exclusion: Exclusion: It is best/worst price comparison.
_____________________________________________________________________ 7
[email protected]
Pricing & Condition ________________________________________________________________________
Condition Supplement: Supplement: Several condition types to be accessed together.
_____________________________________________________________________ 8
[email protected]
Pricing & Condition ________________________________________________________________________
The Condition Technique in Pricing Pricing The condition technique refers to the method by which the system determines prices from information stored in condition records. In Sales and Distribution, the various elements used in the condition technique are set up and controlled in Customizing. During sales order processing, the system uses the condition technique to determine a variety of important pricing information. For example, the system automatically determines which gross price the customer should be charged and which discounts and surcharges are relevant given the conditions that apply. The following figure shows how the condition technique works in the background to produce the pricing information. 1 Pricin Procedure ZSCIL1
Sales Order Type ZSOR Customer 17
ZPR0 Price ZPAC Packing Charge ZHA0 Hundi Discount
2 2
Item 10 Qty 10 1217 Price 4,00,000 INR
Condition Type: ZPR0 Access Sequence: PR00
3 3
5 5
Access Sequence: PR00 8 Customer with release status 10 customer/material 15 plant/customer/material
4 4 Condition record for ZPR0 No valid Record found
1 pc = 40,000 INR
Valid Record Found
_____________________________________________________________________ 9
[email protected]
Pricing & Condition ________________________________________________________________________
1. The system determines the pricing procedure according to information defined in the sales document type and the customer master record. 2. The pricing procedure defines the valid condition types and the sequence in which they appear in the sales order. In the example, the system takes the first condition type (ZPR0) in the pricing procedure and begins the search for a valid condition record. 3. Each condition type in the pricing procedure can have an access sequence assigned to it. In this case, the system uses access sequence PR00. The system checks the accesses until it finds a valid condition record. (Although you cannot see this in the diagram, each access specifies a particular condition table. The table provides the key with which the system searches for records). 4. In the example, the first access is unsuccessful. The system moves on to the next access and finds a valid record. 5. The system determines the price according to information stored in the condition record.
Appropriate price. In the example, the system
determines a price of 40,000 per piece. The system repeats this process for each condition type in the pricing procedure determines a final price.
_____________________________________________________________________ 10
[email protected]
Pricing & Condition ________________________________________________________________________
Pricing Pricing The following sections describe how pricing is controlled. Before you set up new control elements, you should check in how far the control elements defined in the standard version of the SAP R/3 system meet your requirements. The following aspects are of significance for controlling pricing •
Condition type Using the condition types, you define which types of prices, discounts, and surcharges exist in the SAP system. The condition types which are pre-defined in the standard SAP delivery system include:
•
o
customer-specific discount
o
freight charge
o
material surcharge
o
price list price
Condition table table In the condition table, you specify the combination of fields for which you want to create a condition record. For example, you can create a condition record for a price which is dependent on: o
sales organization
o
distribution channel
o
division
o
customer
_____________________________________________________________________ 11
[email protected]
Pricing & Condition ________________________________________________________________________ •
Access sequence The access sequence is a search strategy with which the SAP system searches for valid condition records for each condition type during pricing. The access sequence refers to the fields which are relevant for pricing using the condition tables contained in the access sequence. Using the access sequence, you can control that the SAP system first of all searches for a customer-specific price and then for a price list price.
•
Pricing procedure In the pricing procedure you specify the condition types which are to be used in pricing. At the same time, you define the sequence in which the condition types are to be brought into play. Which pricing procedure is valid for a business transaction depends on the following criteria: o
customer
o
sales document type
o
sales area
You also need to take the following points into account: •
Pricing for a document item depends on its item category. You must make the appropriate settings for all item categories for which pricing should be carried out. Pricing is not activated, for example, for free of charge items.
•
Also, check how the copying of pricing data is controlled in the SD documents ( document flow). For example, you specify in the document flow how prices are copied from sales order into a billing document.
_____________________________________________________________________ 12
[email protected]
Pricing & Condition ________________________________________________________________________ •
In addition, you must define master data fields which are relevant for pricing. For example, you must specify a price group for a customer if you want to use this price group for pricing.
•
Define the degree of responsibility your employees have for conditions.
•
If the cost price is to be determined during pricing, you must classify the item categories appropriately.
Note Note You define pricing for each sales area. You can use sales area assignment to apply the same pricing rules to more than one sales area. (see Section "Define common master data"). Transport interface interface In the transport, all objects which were maintained in Customizing for controlling pricing are transported. In the correction which is created for the transport, check the table entries and delete any entries which are not to be transported. Additional information information You will find further information on this subject in the SD "Guide to Pricing and Conditions". Pricing Control Control The following steps describe how you should set up pricing control in the system. You should be familiar with the pricing criteria before making the necessary settings for pricing in the SAP System. _____________________________________________________________________ 13
[email protected]
Pricing & Condition ________________________________________________________________________
Check how prices as well as surcharges and discounts are created. For example,
determine
whether
different
prices
apply
to
individual
customers or customer groups and how surcharges and discounts are calculated. Check whether separate pricing is carried out for individual business transactions. You may levy specific freight surcharges for rush orders, for example. Specify at what point in time prices are determined (e.g. for sales promotions, price increases, etc.). Also clarify who is responsible for determining prices. Afterwards, adjust your pricing dependencies to the pricing criteria in the SAP System. To do this, see the following steps.
_____________________________________________________________________ 14
[email protected]
Pricing & Condition ________________________________________________________________________
Create Condition Table Table You define price dependencies. You can make prices, surcharges, and discounts dependent on almost all the fields in a document. You define these dependencies using the condition tables. In a condition table, you define the combination of fields for which you can create condition records . Recommendation Recommendation Do not change the condition tables in the standard system. Activities Activities 1. Check to what extent you can use the condition tables contained in the standard system. To do this, you can display the condition tables. 2. Before you create a new condition table, you should check whether
the
fields
listed
in
the
field
catalog
meet
your
requirements. If you require a field in pricing which is not intended for this usage in the standard system, you must enter it in the field catalog. You can only enter fields from tables KOMG, KOMK or KOMP. 3. Create new condition tables. Copy a similar condition table and proceed as follows: o
Enter the name of the table you want to create. Bear in mind that you can only choose names between 501 and 999. If you do not make a specification, the system automatically assigns a sequential number.
o
Specify whether you would like to create the table with or without a validity period.
o
Enter a description for the condition table.
_____________________________________________________________________ 15
[email protected]
Pricing & Condition ________________________________________________________________________ o
Select the required fields for the condition table from the list of the permitted fields listed in the field catalog.
o
Generate the new condition table.
Note Note If, for example, you want to make pricing dependent on the ship-to party, you can only select the customer field in the condition table. You cannot specify the ship-to party in the condition tables since only customer master records exist. It is not until you create an order document that you have the specific function 'ship-to party'. When you subsequently define the access, you can assign the ship-to party source field to the customer field. 4. Specify the condition tables in the access sequences. This way, you establish the link between condition type, access sequence and condition record.
Note Note For information on entering fields in the tables KOMK, KOMG, and KOMP, see the System modification section. IMG PATH: Sales and Distribution Basic Function Pricing Pricing Control Define Condition Tables T- T -Code: V/03 T Code:
_____________________________________________________________________ 16
[email protected]
Pricing & Condition ________________________________________________________________________
Click on You will have following screen
Click on
you will have following screen
Enter the number “between” 501-999 and presses enter, you will have following screen.
_____________________________________________________________________ 17
[email protected]
Pricing & Condition ________________________________________________________________________
Field Catalogs you can right side. You can select fields by double clicking on it an it will come on left side.
Click on
you will have following screen
_____________________________________________________________________ 18
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen.
Click on
you will have following screen.
Your table has been saved. 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), _____________________________________________________________________ 19
[email protected]
Pricing & Condition ________________________________________________________________________
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.
_____________________________________________________________________ 20
[email protected]
Pricing & Condition ________________________________________________________________________
Define Access Sequences Sequences You define access sequences in this IMG step. The access sequence is a search strategy which the SAP System uses to search for condition records valid for a condition type. For example, you can define for a price that the SAP System first searches for a customer-specific price and then for a price list price. Recommendation Recommendation •
If you define your own access sequences, the key should start with the letter Z since SAP reserves this letter for the standard system.
•
Do not change access sequences contained in the standard SAP R/3 System.
Actions Actions 1. Check to what extent you can use the access sequences contained in the standard SAP R/3 System. 2. Create new access sequences by copying a similar access sequence and changing it according to your needs. Specify an alphanumeric key which may have up to 4 digits and a textual description. 3. Maintain the accesses for the access sequence by specifying the condition tables in the desired sequence. With the sequence, you define the priority of the accesses. You can display combinations of key fields using possible entries. 4. Generating the accesses is no longer necessary as of 3.0, as this is carried out automatically. You can generate the accesses manually, if required, by choosing "Utilities".
_____________________________________________________________________ 21
[email protected]
Pricing & Condition ________________________________________________________________________
Improved performance by using pre-step for accesses.
Maintain Access Maintain Access Sequence IMG PATH: PATH: Sales and Distribution Basic Function Pricing Pricing Control Define Access Sequence T- T -Code V/07 T Code
Click on You will have following screen
_____________________________________________________________________ 22
[email protected]
Pricing & Condition ________________________________________________________________________
Double click on
you will have following screen
will appear
This message serves to warn you that each change you make will have an effect on all other clients in the system.
Click on
Click on
you will have following screen
you will have following screen
_____________________________________________________________________ 23
[email protected]
Pricing & Condition ________________________________________________________________________
Enter four alphanumerical key and description for your Access Sequences and press enter
Select your Access Sequence by clicking on tab And double click on
Click on
you will have following screen
you will have following screen
Enter require data as shown in above screen _____________________________________________________________________ 24
[email protected]
Pricing & Condition ________________________________________________________________________
1. Access Number: For finding you condition record you can assign access number to your condition table 2. Condition Table 3. Requirement Field: This is use for output determination 4. Exclusive: If you keep this tab tick mark your system spot searching record after first successful access condition type. Press enter you will have following screen
select your access as shown in above screen and double click on
and then press enter you will have following
screen
Click on
you will have change request screen click on
you will
back to above screen Click on
you will have following screen
_____________________________________________________________________ 25
[email protected]
Pricing & Condition ________________________________________________________________________
Optimize Accesses Accesses To improve performance, you can optimize the accesses to a condition type by having the system carry out a pre-step: You use the pre-step to determine whether the system should first only search for condition records using the document header data. If the search is unsuccessful, then this access is not used to search from the individual items. The pre-step can only be used for accesses with header and item data. The greater the average number of items in a document, the more useful pre-step becomes. The less likely it is that you will find a valid condition record, the more useful it is to use pre-step (see the following example). Example Example In pricing, you use a customer-material discount. The condition records you create are based on customer data from the document header and _____________________________________________________________________ 26
[email protected]
Pricing & Condition ________________________________________________________________________
material data from each document item. The discount is only valid for 2% of your customers, however. Normally, this would mean that the system would needlessly search through every available item for 98% of your customers. In this case, pre-step would improve system performance. Double click on
Click on
you will have following screen
you will have following screen
Enter your condition type and your access number of your access sequence as shown in above screen
_____________________________________________________________________ 27
[email protected]
Pricing & Condition ________________________________________________________________________
Press enter and Click on
you will have change request screen click on
you will back to above screen.
_____________________________________________________________________ 28
[email protected]
Pricing & Condition ________________________________________________________________________
Define Condition Types Types Here you define condition types Price elements are represented in the SAP system by condition types. Price elements can be, for example, prices, surcharges, discounts, taxes or, freight, and are stored in the system in condition records. You can, for example, define whether a discount is calculated as a percentage or a fixed amount using the condition type. You specify an access sequence in every condition type. Thus, you define which fields the SAP system checks when searching for a valid condition record. Note Note •
The pricing procedure groups all condition types together which the SAP system is to automatically take into account during pricing for a business transaction (see the section "Define and assign pricing procedures"). Remember that you can only specify manually in a document those condition types which are contained in the pricing procedure.
•
You can change the outcome of pricing in the sales document manually. You can limit options for changing a condition type in this IMG step.
Recommendation Recommendation •
If you define your own condition types, the key should start with the letter Z since SAP reserves these letters for that purpose in the standard system.
•
Do not change the condition types which are contained in the standard SAP R/3 System.
_____________________________________________________________________ 29
[email protected]
Pricing & Condition ________________________________________________________________________
Actions Actions 1. Check to what extent you can use the condition types contained in the standard SAP R/3 System. 2 . Create new condition types by copying a similar conditions type and changing it according to your requirements. One reason for creating a new condition type is you may require a calculation rule for a discount which is not available in the standard system. Specify an alphanumeric key which can have up to 4 digits, and a textual description. Specify an access sequence for the condition types. You do not need to specify an access sequence for header conditions. 3.
Maintain
the
detail
screen
of
the
condition
type.
You can also assign a reference condition type if the condition types you are working with are similar. Then you will only have to maintain condition records for the reference condition type. In addition, you can define the upper and lower limits for the value of a condition at condition type level. This way, you limit the amounts or the scale values in the corresponding condition records. Checking settings settings You can use the SDCHECKT685A report to check the settings for the condition types. This is not a complete check but it does, for example, check the scale type setting for group conditions. For more information, read the report documentation. IMG PATH: Sales and Distribution Basic Function Pricing Pricing Control Define Condition Type T- T -Code V/06 T Code
_____________________________________________________________________ 30
[email protected]
Pricing & Condition ________________________________________________________________________
Click on You will have following screen
Maintain Type Maintain Condition Type Click on
you will have following screen
_____________________________________________________________________ 31
[email protected]
Pricing & Condition ________________________________________________________________________
Select Condition Type PR00
Click on
copy button and you will have following screen
_____________________________________________________________________ 32
[email protected]
Pricing & Condition ________________________________________________________________________
Change the four alphanumerical key for your condition type and name.
_____________________________________________________________________ 33
[email protected]
Pricing & Condition ________________________________________________________________________
Press enter than click on save button
you will have following pop
screen
Click on
Click on
your condition type was saved
you will have your condition type in the list as shown in
below
Click on
you will have following screen
_____________________________________________________________________ 34
[email protected]
Pricing & Condition ________________________________________________________________________
Define upper/lower limits for condition conditions s In this step you define lower and upper limit for your condition type. Up to what extend end-user can change your condition value in a sales order. 1. Before defining limits your condition must be changeable. you can see in your condition type in “ changes which can be made” tab
Tick mark in Amount/percent radio button 2 . For Condition Type Condition record must be maintain IMG PATH: Sales and Distribution Basic Function Pricing Define Condition Type Define upper/lower limits for conditions T- T -Code: OVB2 T Code:
_____________________________________________________________________ 35
[email protected]
Pricing & Condition ________________________________________________________________________
Double click on
you will have following
screen
Click on
Enter your data as shown in above screen. Click on
you will have change request screen
Click on
and you will back to above screen
Click on
you will have following screen
_____________________________________________________________________ 36
[email protected]
Pricing & Condition ________________________________________________________________________
Check setting type settin g for your Condition type IMG PATH: Sales and Distribution Basic Function Pricing Define Condition Type Check setting for your Condition Type In this step you can check setting for your condition type Double click on
you will have following
screen
Enter your condition type and click on
you will have following screen
will appear
_____________________________________________________________________ 37
[email protected]
Pricing & Condition ________________________________________________________________________
Here there was no error so this screen is appear.
_____________________________________________________________________ 38
[email protected]
Pricing & Condition ________________________________________________________________________
Condition Record Record Use Use This section explains how to perform day-to-day pricing activities during sales order processing. The section explains how to create and maintain pricing information by using condition records. Purpose of Condition Records Records Condition records allow you to store and retrieve pricing data in the system. All the pricing elements daily business - the prices, discounts, and surcharges for freight and taxes - that you want to use for automatic pricing must be stored in the system as condition records. You can define as many condition records as you want for the different pricing elements for any validity period. You create condition records for all the pricing elements that the system takes
into
account
during
automatic
pricing.
During
document
processing, the system transfers data from the condition records and determines the amounts for individual pricing elements (prices, discounts and surcharges) and the final amount for the sales document.
_____________________________________________________________________ 39
[email protected]
Pricing & Condition ________________________________________________________________________
SAP
MENU
PATH:
Logistics Sales
and
Distribution Master
Data Conditions Select Using Condition Type Create T- T -Code: VK11 T Code: Double click on
you will have following screen
_____________________________________________________________________ 40
[email protected]
Pricing & Condition ________________________________________________________________________
Enter your condition type for which you want to create condition record Note: You can only create condition record for those conditions that has access sequence. Here I enter ZPR0 for which I want to create condition record
Press enter you will have following screen
_____________________________________________________________________ 41
[email protected]
Pricing & Condition ________________________________________________________________________
In above screen you can see key Combination pop-up screen appear. Here it appear because access sequence has more than one table Select key combination for which you want to create condition record.
And click on
you will have following screen
_____________________________________________________________________ 42
[email protected]
Pricing & Condition ________________________________________________________________________
Enter your Sales Organization, Distribution Channel, Customer, Material, Amount (Material Price), Unit (Currency), Per (Price per unit of measurement), UoM (unit of measurement) After entering necessary data press enter you will have following screen
As shown in above screen validation dates takes from your condition type. Press enter and Click on
Click on
you will back to above screen.
you will have Sap Essay Menu
Maintain Sca Scales les for Condition Condition In this step you define Scale for you price. When you create a condition record for a pricing element, you can define a pricing scale. In the standard system, a pricing scale can be based on any of the following criteria: _ Value _ Quantity _ Gross weight _ Net weight _ Volume _ A formula specific to your requirements
_____________________________________________________________________ 43
[email protected]
Pricing & Condition ________________________________________________________________________
The scale basis is defined in Customizing for Sales for each condition type. Go to your condition record use T-Code: VK12
Enter Condition Type and press enter you will have following screen
Select your key combination and click on
_____________________________________________________________________ 44
[email protected]
Pricing & Condition ________________________________________________________________________
you will have following screen
Enter relevant data as shown in above screen and click on
you will
have following screen.
In this screen click on
you will have following screen.
_____________________________________________________________________ 45
[email protected]
Pricing & Condition ________________________________________________________________________
Here our Scale Base type is Quantity enter data as shown in above screen. Press enter and click on
Click on
you will have following screen
you will have Sap Essay Menu
_____________________________________________________________________ 46
[email protected]
Pricing & Condition ________________________________________________________________________
Tracking Cumulative Values With Condition Update Update Special offers and discounts to customers are frequently offered as part of a sales promotion based on accumulated sales order data. For example, when your customers place orders for a new product, you may offer them an introductory allowance up to a specified total value (for example, up to INR 5 lacs ). As a customer places orders for the new product, the system must be able to keep track of the cumulative discount total. Condition update is controlled by the condition type in setting Customizing for Sales. If you set the condition update for a particular condition type, the system subsequently updates the corresponding condition records whenever you process relevant sales and billing documents.
As shown in above screen for use of this function this tick mark must be there in condition type. Condition update provides the basis for the following pricing functions: _ Maximum Value _ Maximum quantity _ Maximum Number of Sales Orders
_____________________________________________________________________ 47
[email protected]
Pricing & Condition ________________________________________________________________________
For understanding this concept I take condition discount type ZDIC Maximum Values
Provided that the condition update function is active for a particular condition type, you can create condition records that specify a maximum cumulative value. The system uses the condition value of an item as the basis for the cumulative value. T- T -Code VK11 T Code
Enter your condition type and press enter you will have following screen
Here we give customer 2% discount
Now click on
you will have following screen
_____________________________________________________________________ 48
[email protected]
Pricing & Condition ________________________________________________________________________
Here we enter max. condition value 10,000. It is mean As the customer places sales orders for the item, the system keeps track of the cumulative discount value and stores this data at condition record level. Once the cumulative discount value reaches INR 10,000, the system automatically deactivates the discount.
Press enter and click on
you will have following screen
_____________________________________________________________________ 49
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have sap easy menu
After creating sales order you can track cumulative value for condition type
Maximum Quantities Quantities You can create condition records that specify a maximum cumulative quantity. The system uses the condition base value of an item as the basis for the cumulative quantity. In most cases for the condition base, this involves a quantity. It is also possible to enter maximum quantities in weight and volume for a condition record. T- T -Code: VK11 T Code:
_____________________________________________________________________ 50
[email protected]
Pricing & Condition ________________________________________________________________________
Here I use condition ZDIS press enter
Enter all necessary data and click on
you will have following screen
_____________________________________________________________________ 51
[email protected]
Pricing & Condition ________________________________________________________________________
Here we enter Max.cond.base value 200 pc Here, we specify that a customer receives a 50 INR discount for a 1219 (Children Bike) material up to a maximum cumulative order quantity of 200 peaces. As the customer places sales orders for the item, the system keeps track of the cumulative value (in this example, the number of peaces) and stores this data at the condition record level. Once the cumulative
value
reaches
200
peaces,
the
system
automatically
deactivates the discount.
Click on
you will have following screen
_____________________________________________________________________ 52
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have SAP easy menu
Maximum Number of Sales Orders Orders You can specify the maximum number of orders in a condition record. For example, you offer your customers a special discount on a new product. You want the discount to count for the introductory order and for one refill order. The system keeps track of the number of orders the customer
places
and,
after
the
maximum
number
is
reached,
automatically deactivates the condition record. After deactivation the condition type no longer appears on the pricing screen in the order. In addition, the system automatically stores statistical data for condition records where a maximum number of orders are specified. T- T -Code : VK11 T Code
_____________________________________________________________________ 53
[email protected]
Pricing & Condition ________________________________________________________________________
Here we use condition type ZDIS press enter
Enter all necessary data and click on
you will have following screen
_____________________________________________________________________ 54
[email protected]
Pricing & Condition ________________________________________________________________________
Here we enter Maximum Number of orders 2 Customer place for order for particular material system keep track for that order and when customer place order and reach maximum number of order than this condition is automatically deactivate. Note: You can only use one of the following at a time for condition type Maximum Condition Value Maximum Number of Orders Maximum Condition Base Value
_____________________________________________________________________ 55
[email protected]
Pricing & Condition ________________________________________________________________________
Define And Assign Pricing Procedures Procedures You define the pricing procedures in this step. In addition, you assign the pricing procedures to the transactions by defining the following dependencies: •
Customer
•
Sales document type
•
Sales area
In the pricing procedure, you define which condition types should be taken into account and in which sequence. During pricing, the SAP System automatically determines which pricing procedure is valid for a business transaction and it takes the condition types contained in it into account one after the other. The determination of the procedure depends on the following factors: •
Customer determination procedure You specify the customer determination procedure in the customer master record for each sales area.
•
Document pricing procedure You specify the document pricing procedure for each sales document type and billing type.
To determine the procedure, you allocate the customer determination procedure and the document pricing procedure to a pricing procedure within a sales area.
_____________________________________________________________________ 56
[email protected]
Pricing & Condition ________________________________________________________________________
SAP Recommendation Recommendation •
Define your own pricing procedures which contain only those condition types which you use. Otherwise, the system makes unnecessary accesses to conditions.
•
Do not change the pricing procedures contained in the standard SAP R/3 System.
Actions Actions 1. Create new pricing procedures by copying a similar pricing procedure. o
Specify a key with up to 6 characters and a description.
o
For a procedure, specify the condition types in the sequence of their usage. Maintain the lines of the pricing procedure
2. Afterwards define the customer determination procedures for determining the procedure. 3. Define the document pricing procedures for determining the procedure. 4. Assign the procedure to the sales document types and billing types. 5. To determine the procedure, define the allowed combinations of: o
Sales area
o
Customer determination procedure
o
Document pricing procedure
o
Pricing procedure
_____________________________________________________________________ 57
[email protected]
Pricing & Condition ________________________________________________________________________
Check settings settings You can check the settings for your pricing procedures. This is not a complete check. It mainly checks the requirements and calculation formulas for standard condition types. Refer to the report documentation for more information. Basic Function Pricing Pricing IMG PATH: Sales and Distribution Define Define And Assign Pricing Procedures Control
Click on You will have following screen
_____________________________________________________________________ 58
[email protected]
Pricing & Condition ________________________________________________________________________
Maintain Pricing Procedure Procedure T- V/08 T T -Code - Code Click on
Click on
you will have following screen
you will have following screen
Enter 1. up to six alphanumerical key _____________________________________________________________________ 59
[email protected]
Pricing & Condition ________________________________________________________________________
2. Description for your pricing procedure. 3. Indicator whether your procedure is special pricing procedure e.g. inter-company or rebate pricing procedure. 4. Specifies 4. Specifies how the system treats pricing data when copying documents. After entering data press enter select your pricing procedure and Click on
Click on
you will have following screen
you will have following screen
_____________________________________________________________________ 60
[email protected]
Pricing & Condition ________________________________________________________________________
Here I show you one of my clients pricing procedure you can configure pricing procedure as per your requirement. You can read effect of each field of pricing procedure in Explain each field of SAP doc folder. Click on
you will have change request screen click on
you will
back to above screen Click on
you will have following screen
_____________________________________________________________________ 61
[email protected]
Pricing & Condition ________________________________________________________________________
Define Customer Pricing Procedure Procedure
Here you Determines which pricing procedure the system should apply when you create a sales document for the customer. Use Use You can define different pricing procedures for your system. A pricing procedure determines the type and sequence of conditions that the system uses for pricing in, for example, a sales order. IMG PATH: Sales and Distribution Basic Function Pricing Pricing Control Define And Assign Pricing Procedures Define Customer Pricing Procedure T- T -Code: OVKP T Code: Double click on
you will have following screen
_____________________________________________________________________ 62
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Enter one character key and its description as shown in above screen. Click on
you will have change request screen click on
you will
back to above screen Note: Do not forgot to assign your customer pricing procedure to your customer master record _____________________________________________________________________ 63
[email protected]
Pricing & Condition ________________________________________________________________________
IN Customer Master –Sales Area Data- Sales View
As seen in above screen you have to assign here
Click on
Define Document Pricing Procedure Procedure
Here you define the key that specifies the pricing procedure for this type of sales document. Use Use During pricing, the system determines the pricing procedure by taking into account •
The sales area
•
The pricing procedure key in the header of the sales document type
•
The pricing procedure key in the customer master record
_____________________________________________________________________ 64
[email protected]
Pricing & Condition ________________________________________________________________________
The pricing procedure determines how the system carries out pricing for a particular sales document (for example, which pricing condition records it accesses and in which sequence). IMG PATH: Sales and Distribution Basic Function Pricing Pricing efine document Control Define And Assign Pricing Procedures D
Pricing Procedure T- T -Code: OVKI T Code: Double click on
you will have following
screen
_____________________________________________________________________ 65
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Enter one character key and its description as shown in above screen. Click on
you will have change request screen click on
you will
back to above screen
Click on
_____________________________________________________________________ 66
[email protected]
Pricing & Condition ________________________________________________________________________
Assign Document Pricing Procedure to your Order Type T ype ype Here you assign your Document Pricing Procedure to your Sales Document type IMG PATH: Sales and Distribution Basic Function Pricing Pricing Control Define And Assign Pricing Procedures Assign Document Pricing Procedure To Your Order Type. T- T -Code: OVKJ T Code: Double on
you will have following
screen
As shown in above screen assign your document pricing procedure to your sales document type.
Click on
you will have change request screen click on
you will
back to above screen _____________________________________________________________________ 67
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
Assign Document Pricing Procedure to Billing Type : In this step you assign you document pricing procedure to your billing type. IMG PATH: Sales and Distribution Basic Function Pricing Pricing Control Define And Assign Pricing Procedures Assign document pricing procedures to billing types. T- T -Code: OVTP T Code: Double click on
you will have
following screen
_____________________________________________________________________ 68
[email protected]
Pricing & Condition ________________________________________________________________________
As shown in above screen assign your document pricing procedure to your billing type.
Click on
you will have change request screen click on
you will
back to above screen Click on
Define Pricing Procedure Determination :: To determine the procedure, define the allowed combinations of: o
Sales area
o
Customer determination procedure
o
Document pricing procedure
o
Pricing procedure
IMG PATH: Sales and Distribution Basic Function Pricing Pricing Control Define
And
Assign
Pricing
Procedures Define
Pricing
Procedure Determination T- T -Code: OVKK T Code:
Double on
you will have following screen
_____________________________________________________________________ 69
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Enter you Sales Area, Document Pricing Procedure, Customer Pricing Procedure and Pricing Procedure as shown in above screen. Click on
you will have change request screen click on
you will
back to above screen
Click on _____________________________________________________________________ 70
[email protected]
Pricing & Condition ________________________________________________________________________
Check Settings for Pricing Procedures :
You can check the settings for your pricing procedures. This is not a complete check. It mainly checks the requirements and calculation formulas for standard condition types. Refer to the report documentation for more information.
Double on
Click on
you will have following screen
you will have following screen
There is no errors found in customizing
_____________________________________________________________________ 71
[email protected]
Pricing & Condition ________________________________________________________________________
Define Pricing By Item Category Category
You set the following defaults in this step: •
Pricing for each item category Here, you define the item categories for which pricing should be carried out and whether the item value should be taken into account when determining the total value of a sales document.
•
Pricing data when copying (document flow) Via the document flow, you define how the SAP System should handle
the
automatically
determined
and
manually
entered
conditions when copying sales documents and billing documents. For example, you can define that only manual conditions are copied from the reference document into the target document or that the SAP System carries out pricing again in the target document. Default settings settings In the standard SAP R/3 System, the condition type "VPRS" is predefined for determining the cost. Actions Actions 1. Define for each item category whether the SAP System should carry out pricing. In addition, define whether the item value is used for statistical purposes or whether it should be included in determining the total value. 2. Define the type of pricing for the item categories when copying sales documents and billing documents. The copying options allowed for the item categories are defaulted automatically. _____________________________________________________________________ 72
[email protected]
Pricing & Condition ________________________________________________________________________
You define the copying options when defining the sales document types (see the section "Transactions" --> "Define document flow for transactions").
IMG PATH: Sales and Distribution Master Data Basic Functions Pricing Pricing Control Pricing Control Define Pricing By Item Category Click on
you will have following screen
_____________________________________________________________________ 73
[email protected]
Pricing & Condition ________________________________________________________________________
Active Pri Pricing cing for Item Categories Categories T- T -Code: OVK0 T Code:
Double click on
you will have following
screen
Here you can see your Item category is pricing relevant or not if not than must mark as pricing relevant. 1. Carry out pricing It indicates whether the system automatically carries out pricing at the item level. Example The system carries out pricing for standard items in a sales order. In the case of text items, however, pricing would not make sense.
_____________________________________________________________________ 74
[email protected]
Pricing & Condition ________________________________________________________________________
2. Statistical values It indicates whether the system takes the value of an item into account when it determines the total value of a document. After making setting do not forgot to save.
Active Cost Determination for Item Categories Categories Define for each item category whether the cost should be determined during pricing. Bear in mind that the pricing procedure has to contain a condition type (for example, condition type "VPRS") for determining the cost. Use: Use: When processing a sales document, the SAP System can determine the cost for each item. The cost refers to the costs of procurement or production of goods. It is an important indicator for costing a profit margin for the sales of goods.
_____________________________________________________________________ 75
[email protected]
Pricing & Condition ________________________________________________________________________
Double
click
on
you
will
have
following screen
It indicates whether, during pricing, the system determines the cost (stock value) of a sales document item. If you want to determine cost for your item categories than tick mark it. Do not forget to save.
_____________________________________________________________________ 76
[email protected]
Pricing & Condition ________________________________________________________________________
_____________________________________________________________________ 77
[email protected]
Pricing & Condition ________________________________________________________________________
Maintain Price- Price -Relevant Master Data Fields: Fields :: - Relevant In this section you check and define the master data fields relevant to pricing in the customer and material master record. Among other things, you can use the following fields for pricing: •
Price list type in the customer master record r ecord for each sales area
•
Price group in the customer master record for each sales area
•
Material pricing group in the material master record for each sales organization and distribution channel
With these indicators, you can group customers or materials together for which the same conditions are to apply. Furthermore, you can make pricing dependent on all master data fields which are copied into the sales & distribution documents. For example, the following could be master data fields in the documents: •
Customer number
•
Material number
•
Shipping conditions
Actions Actions 1. Check 1. Check whether the master data fields are used for pricing in your company, and if so in what form. 2. Define 2. Define your price list types. Specify an alphanumeric key with up to 2 characters and a description. 3. Define 3. Define your price groups. Specify an alphanumeric key with up to 2 characters and a description. _____________________________________________________________________ 78
[email protected]
Pricing & Condition ________________________________________________________________________
4. Define 4. Define your material pricing groups. Specify an alphanumeric key with up to 2 characters and a description. 5. Make 5. Make sure that the indicators are entered in the customer master records and the material master records.
Price list type type It identifies a price list or other condition type (for example, a surcharge or discount). Use Use You can define price list types according to the needs of your own organization. Price list types can be grouped according to: •
the kind of price list (for example, wholesale or retail)
•
the currency in which the price appears
•
the number of the price list type
You can use price list types to apply conditions during pricing or to generate statistics. Procedure Procedure In the customer master record, enter one of the values predefined for your system. The system proposes the value automatically during sales
_____________________________________________________________________ 79
[email protected]
Pricing & Condition ________________________________________________________________________
order processing. You can change the value manually in the sales document header.
IMG PATH: Sales and Distribution Basic Function Pricing Maintain Price-Relevant Mater Data Fields D efine price list categories for customers
Click on
you will have following screen
Click on
you will have following screen
_____________________________________________________________________ 80
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Specify an alphanumeric key with up to 2 characters and a description Click on Click on
you will have following screen
Price group (customer) (customer) It is a grouping of customers who share the same pricing requirements. Use Use You can define price groups according to the needs of your organization and create pricing records for each group. You can, for example, define a group of customers to whom you want to give the same kind of discount.
_____________________________________________________________________ 81
[email protected]
Pricing & Condition ________________________________________________________________________
You can assign a price group to an individual customer either in the customer master record or in the sales document. Procedure Procedure The system can propose the price group from the customer master record. You can change the proposed value manually in the sales document at both header and item level.
IMG PATH: Sales and Distribution Basic Function Pricing Maintain Price-Relevant Mater Data Fields Define pricing groups for customers
Click on
you will have following screen
_____________________________________________________________________ 82
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Specify an alphanumeric key with up to 2 characters and a description. Click on Click on
you will have following screen
Material Pricing Gro Group up up A way of grouping materials to which you want to apply the same conditions. Use Use You can create condition records for a material pricing group using the following condition types: •
Material pricing group (for example, all non-food products)
_____________________________________________________________________ 83
[email protected]
Pricing & Condition ________________________________________________________________________ •
A combination of customer and material pricing group
•
A combination of price group and material group (for example, all wholesale customers and all non-food products)
IMG PATH: Sales and Distribution Basic Function Pricing Maintain Price-Relevant Mater Data Fields Define material groups Click on
Click on
you will have following screen
you will have following screen
_____________________________________________________________________ 84
[email protected]
Pricing & Condition ________________________________________________________________________
Click on Click on
you will have IMG screen
_____________________________________________________________________ 85
[email protected]
Pricing & Condition ________________________________________________________________________
Maintain Pricing Report Report In this menu option, you define the screen layout for pricing reports. You use pricing reports to analyze condition records according to different criteria. Technically, pricing reports are ABAP/4 programs. Note Note The standard SAP R/3 System contains predefined pricing reports which you can start using the application menu. Actions Actions 1. Display the pricing reports defined in the standard SAP R/3 System to check to what extent you can use them. 2. Create new pricing reports. To do this, proceed as follows: a) Enter a two-digit description (with a character as the first digit) and the title of the pricing report you want to create. b) All key fields which are used in conditions appear in alphabetical order on the following data screen. Select all key fields
which
should
be
used
in
the
pricing
report.
If you choose Edit->Further processing with AND, all condition tables will be evaluated that contain at least one of the
selected
key
fields. If you choose Edit->Further processing with OR, only the condition tables that contain all the selected key fields will c) be evaluated. Select all condition tables which should be analyzed in the next dialog box. d) Choose "Position fields" to define the screen layout of the pricing report. Make sure that all key fields from the selected tables appear on the following data screen. Fields which should not be used as selection criteria later on when displaying the list, can be suppressed by cancelling the check mark in the "Selection" column. _____________________________________________________________________ 86
[email protected]
Pricing & Condition ________________________________________________________________________
You can also indicate fields as obligatory on the selection screen. e)
Click on
you will have following screen
IMG PATH: Sales and Distribution Basic Function Pricing Maintain Pricing Reports
Click on
you will have following screen
_____________________________________________________________________ 87
[email protected]
Pricing & Condition ________________________________________________________________________
Enter name and title for your pricing report
Click on
for selecting fields you will have following screen
_____________________________________________________________________ 88
[email protected]
Pricing & Condition ________________________________________________________________________
Select Sales Organization field and click on
you will have
following screen
_____________________________________________________________________ 89
[email protected]
Pricing & Condition ________________________________________________________________________
Select any one table for which you want to create pricing report click on
you will have following screen
_____________________________________________________________________ 90
[email protected]
Pricing & Condition ________________________________________________________________________
Make tick mark for all check box in default values for the selection screen Click on
you will have following pop-up
_____________________________________________________________________ 91
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
Click on
you will have following massage on status bar
you will have img screen
_____________________________________________________________________ 92
[email protected]
Pricing & Condition ________________________________________________________________________
Condition Exclusion Exclusion In this step, you can set up exclusion procedures for groups of conditions and for individual condition types or records.
Condition Exclusion For Groups Of Conditions Conditions If several condition records are valid for pricing in a document item, you can define rules that specify which condition records are and are not included. You use condition exclusion for this purpose. You control condition record exclusion using exclusion groups. An exclusion group is a list of condition types which are compared with each other during pricing and result in the exclusion of an entire group or individual condition types within a group. Thus, the result of pricing can be influenced with regard to a required criterion (for example, best price) by excluding certain condition types while others are taken into account during pricing. Example Example You can define a condition exclusion which determines the best price for the customer and excludes other less favorable results of pricing. The best price then reverses the priority of condition types which would have been predefined by the access sequence. The tables for condition exclusion are empty when delivered. You therefore have to carry out the following steps if you want to use condition exclusion: •
Define condition exclusion groups
•
Allocate condition types to the condition exclusion groups
_____________________________________________________________________ 93
[email protected]
Pricing & Condition ________________________________________________________________________ •
Enter condition exclusion groups in the pricing procedure and specify a procedure for determining the condition types to be excluded
Actions Actions 1. Create a condition exclusion group by entering an alphanumeric key with a maximum of four characters and a description. 2. Allocate the condition types to a condition exclusion group. A condition exclusion group can contain any number of condition types. 3. Enter the condition exclusion group in the pricing procedure that you use in pricing (Go to -> Exclusion groups ). Note the sequence (sequential number) in which the exclusion groups should be processed. You can use two exclusion groups for condition exclusion. In this case, you must choose the procedure "C" which determines the best price between two exclusion groups.
Click on
you will have following screen
_____________________________________________________________________ 94
[email protected]
Pricing & Condition ________________________________________________________________________
Define Condition Exclusion Groups Groups IMG PATH: Sales and Distribution Basic Function Pricing Condition Exclusion
Condition
Exclusion for Group of Conditions
Define Condition Exclusion Groups T- T -Code: OV31 T Code: Click on
Click on
you will have following screen
you will have following screen
_____________________________________________________________________ 95
[email protected]
Pricing & Condition ________________________________________________________________________
Create a condition exclusion group by entering an alphanumeric key with a maximum of four characters and a description. Click on
you will have change request pop-up screen click on
you will back to above screen
Click on
you will have following screen
_____________________________________________________________________ 96
[email protected]
Pricing & Condition ________________________________________________________________________
Assign condition types to the exclusion groups groups IMG PATH: Sales and Distribution Basic Function Pricing Condition Exclusion
Condition
Exclusion for Group of Conditions
Assign condition types to the exclusion groups T- T -Code: OV32 T Code: Click on
you will have following
screen
_____________________________________________________________________ 97
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Enter your exclusion group and assign your Discount condition type press enter. Click on
you will have change request pop-up screen click on
you will back to above screen Click on
you will have following screen
_____________________________________________________________________ 98
[email protected]
Pricing & Condition ________________________________________________________________________
Maintain condition exclusion for pricing procedures procedures IMG PATH: Sales and Distribution Basic Function Pricing Condition Exclusion
Condition Exclusion for Group of Conditions Maintain
condition exclusion for pricing procedure T- T -Code: VOK8 T Code: Click on
you will have following
screen
_____________________________________________________________________ 99
[email protected]
Pricing & Condition ________________________________________________________________________
Select you pricing procedure as shown in above screen click on you will have following screen
Click on
you will have following screen
_____________________________________________________________________ 100
[email protected]
Pricing & Condition ________________________________________________________________________
Here you maintain that, the procedure according to which the selection is carried out within or between the condition exclusion groups is defined in the pricing procedure. The following options are possible: •
Selection of the most (least) favorable condition type within a condition exclusion group
•
Selection of the most (least) favorable condition record of a condition type, if more valid condition records exist (for example, selection from different condition records of the condition type PR00)
•
Selection of the most (least) favorable of two condition exclusion groups (in this case, all condition types of the two groups are cumulated and the totals are compared)
•
Exclusion procedure: If a condition type in the first group exists in the document, all condition types in the second group are set to inactive.
Enter all relevant data as shown in above screen Click on
you will have change request pop-up screen click on
you will back to above screen Click on
you will have IMG screen
_____________________________________________________________________ 101
[email protected]
Pricing & Condition ________________________________________________________________________
Condition Exclusion for for Condition Types and and Records Records In this step, you define a condition exclusion indicator. You can set this indicator in a condition record or condition type. The indicator is set in the document during pricing and can then be used to query requirements. Requirements are maintained in the pricing procedure and allow you to specify if a condition is to be used in certain situations. Example Example When the system determines a very low price, you want to void all other discounts. Proceed as follows: •
Mark a condition type or an individual record in the condition type with a condition exclusion indicator, for example with 'X' for net price.
•
For all discounts which you want to void when this net price is used, enter a routine for the pricing procedure in the requirements column. This routine reads the indicator and sets the condition to inactive when it is set to 'X'. The standard system includes requirement 2 which has a similar function.
_____________________________________________________________________ 102
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Enter one character alphanumerical key and its description as shown in above screen
It indicates whether the system automatically excludes the discounts that are proposed during pricing. Use Use You can set this indicator in two ways: •
For a particular condition record (the field appears on the Details screen)
_____________________________________________________________________ 103
[email protected]
Pricing & Condition ________________________________________________________________________ •
For all records of a particular condition type (the field appears on the screen where you define the condition type)
Note Note If you set the indicator to exclude conditions, there are several things to consider: •
The system will still take into account any condition supplements that are part of the condition record for the price (condition type PR00, for example)
•
You can allow for exceptions where you want to include discounts in spite of the condition exclusion indicator (for a particular discount condition you can specify a requirement that applies the discount ONLY when the indicator is set)
Click on
you will have change request pop-up screen click on
you will back to above screen Click on
you will have IMG screen
_____________________________________________________________________ 104
[email protected]
Pricing & Condition ________________________________________________________________________
Pricing Agreements Agreements You can group condition records together using agreements for the purpose of sales deals - comparable to rebate agreements. You can define agreement types for promotions and sales deals and specify different condition types and condition tables.
Define Promotions Promotions A promotion is a marketing plan for a certain product line (for example, during the market launch). A promotion can be made up of several sales deals. In
Customizing,
you
have
the
following
options
for
controlling
promotions: •
Define promotion type
•
Set up number ranges for promotions, if necessary The same number range is used for promotions as in rebate processing. If you want to use separate number ranges, make the appropriate setting.
•
Enter the overview screen displayed for the user to create master data
Note Note The same authorization object is used for promotions as for rebate processing (V_KONA_VKO). Actions Actions 1. Enter a numeric key with a maximum of four digits and a description for the promotion type. _____________________________________________________________________ 105
[email protected]
Pricing & Condition ________________________________________________________________________
2. On the detail screen, specify control data, such as: o
Agreement category "P" for promotion
o
Validity period proposed as a default value
o
Overview screen
3. If necessary, create new number ranges (internal or external). Transport Transport You transport number range objects as follows: Choose Interval -> Transport in the accounting document Number Range screen. All intervals for the selected number range object are deleted in the target system first. After the import, only the intervals you export are present. The number statuses are imported with their values at the time of export. Dependent tables are not transported or converted.
Click on
you will have following screen
_____________________________________________________________________ 106
[email protected]
Pricing & Condition ________________________________________________________________________
Maintain Promotion Type Type IMG PATH: Sales and Distribution Basic Function Pricing Pricing Agreement Define Promotion Type Maintain Promotion Types
Click on
you will have following screen
_____________________________________________________________________ 107
[email protected]
Pricing & Condition ________________________________________________________________________
We copy from the standard click on
you will have following screen
_____________________________________________________________________ 108
[email protected]
Pricing & Condition ________________________________________________________________________
Enter four character alphanumerical key for your and its description for your promotion type
Press enter and Click on click on
Click on
you will have change request Pop-Up screen
you will have following screen
you will have IMG screen
_____________________________________________________________________ 109
[email protected]
Pricing & Condition ________________________________________________________________________
Click
on
for
number
ranges
for
agreements
Set up Sales Deals Deals In this unit, make the necessary settings for sales promotions.
Define Deals Defi ne Sales Deals A sales deal defines a marketing deal for a certain product. Depending on the setting, it can be allocated to a higher-level promotion. Special condition records can be allocated to a sales deal. If relevant, the records also contain the number of the promotion allocated to the sales deal. The control of sales deals includes the following options in Customizing: •
Define agreement types for sales deals The agreement type indicates the type of the sales deal, for example, whether it refers to a product or product line. The standard system contains sales deal type 0020.
•
Define and allocate condition type groups A condition type group defines a group of condition types and condition tables which can be used together in the sales deal. Using the condition type group, it is possible to deal with individual products differently in a sales deal and, for example, to grant discounts specific to a customer or material.
Actions Actions Proceed as follows to define your own sales deals:
_____________________________________________________________________ 110
[email protected]
Pricing & Condition ________________________________________________________________________
1. Create an agreement type by specifying a numeric key with a maximum of four digits and a description for the agreement type. 2. Specify the different control data on the detail screen of the agreement type (for example, validity period as default value, overview screen). In the agreement hierarchy, specify whether an allocation to a promotion may, can or must be made. 3. 4. Note 5. Further down in the Pricing chapter in Overviews you can also select a certain overview for sales deals as the default screen for maintenance of master data. For example, you can define an overview that should only be displayed for maintaining payment conditions for certain condition records. IMG PATH: Sales and Distribution Basic Function Pricing Pricing Agreement Set up Sales Deal Define Sales Deals
Click on
you will have following screen
_____________________________________________________________________ 111
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
Select 0020 and click on
you will have following screen
you will have following screen
_____________________________________________________________________ 112
[email protected]
Pricing & Condition ________________________________________________________________________
Enter four character alphanumerical key and its description and Press Enter and Click on click on
Click on
you will have change request Pop-Up screen
you will have following screen
you will have following screen
_____________________________________________________________________ 113
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
if you want to create number
rages for agreements
Condition Type Groups Groups In this IMG activity you define condition type groups which contain a group of condition types and tables and which you can assign to an agreement type.
Define Condition Type Groups Groups In this IMG activity you define condition type groups which determine a group of condition types and tables for a sales deal. Activities Activities 1. First check whether you can copy the condition type groups from the standard release. If not, proceed as follows: 2. Enter a key with the maximum of four digits as well as a description for the condition type group. IMG PATH: Sales and Distribution Basic Function Pricing Pricing Agreement Set up Sales Deal Condition Type Group Define Condition Type Groups
_____________________________________________________________________ 114
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
Click on
you will have following screen
you will have following screen
_____________________________________________________________________ 115
[email protected]
Pricing & Condition ________________________________________________________________________
Enter four character alphanumerical key and description for your condition type group. Here you mention category type for condition whether it is sales deal or rebate.
Click on
you will have change request Pop-Up screen click on
you will have following screen
Click on
you will have IMG screen
Assign Condition Types/Tables to Condition type Groups Groups In this IMG activity you carry out mapping from condition types and condition tables to condition type groups. Activities Activities 1. Enter the key for the condition type group. 2. Enter a sequential number in numerators for the conditions. 3. Assign a condition type as well as a condition table to the condition type group. IMG PATH: Sales and Distribution Basic Function Pricing Pricing Agreement Set up
Sales
Deal Condition Type
ssign Group A
Condition Types/Tables to Condition type Groups
_____________________________________________________________________ 116
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
_____________________________________________________________________ 117
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
Assign your condition type/table to your condition type group press enter Click on
you will have change request Pop-Up screen click on
you will have following screen
Click on
you will have IMG screen
Assign Condition Type Groups/Sales Deals Deals In this IMG activity you can carry out mapping between agreement type and condition type groups. Activities Activities Assign a condition type group to the agreement type by entering a four digit key from the corresponding group.
IMG PATH: Sales and Distribution Basic Function Pricing Pricing Agreement Set up
Sales
Deal Condition Type
Group A ssign
Condition Type Groups/Sales Deals
_____________________________________________________________________ 118
[email protected]
Pricing & Condition ________________________________________________________________________
Click on
you will have following screen
_____________________________________________________________________ 119
[email protected]
Pricing & Condition ________________________________________________________________________
Assign your condition type group to your promotion type as shown above screen press enter Click on
you will have change request Pop-Up screen click on
you will have following screen Click on
you will have IMG screen
_____________________________________________________________________ 120
[email protected]
Pricing & Condition ________________________________________________________________________
Question & Answer Answer
1. Could you explain what condition technique in SAP is? i. Hierarchy of elements defining a data combination which leads to certain actions. ii. In pricing the condition technique refers to the method by which the system determines prices from information stored in condition records. In Sales and Distribution, the various elements used in the condition technique are set up and controlled in Customizing. During sales order processing, the system uses the condition technique to determine a variety of important pricing information.
2. Name three areas/processes which use condition technique in SD? i. Material determination, Output determination, Account determination.
3. What are the four basic elements of condition technique? i. Condition Types, Condition Tables, Access Sequences, Pricing Procedures.
4. Please explain graphically the relationship between the four basic elements in condition techniques? i. Procedures à Condition Types à Access Sequence à Condition Tables à Condition Records.
5. Explain what a pricing procedure is? i. The primary job of a pricing procedure is to define a group of condition types in a particular sequence. The pricing procedure also determines: - Which sub-totals appear during pricing - To what extent pricing can be influenced manually - Which method the system uses to calculate percentage discounts and surcharges _____________________________________________________________________ 121
[email protected]
Pricing & Condition ________________________________________________________________________
- which requirements for a particular condition type must be fulfilled before the system takes the condition into account.
6. Explain what a condition table and an access sequence is and the relationship between them? i. A condition table defines the combination of fields (the key) that identifies an individual condition record. A condition record is how the system stores the specific condition data that you enter in the system as condition records. For example, when you enter the price for a product or a special discount for a good customer, you create individual condition records. ii. An access sequence is a search strategy that the system uses to find valid data for a particular condition type. It determines the s equence 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.
7. What is a condition type? What are the two main groups of condition types? i. A condition type is a representation in the system of some aspect of your daily pricing activities. For example, you can define a different condition type for each kind of price, discount, or surcharge that occurs in your business transactions. ii. Fixed Amount & Percentage.
8. Is SD the only module that uses condition technique? i. No.
_____________________________________________________________________ 122
[email protected]
Pricing & Condition ________________________________________________________________________
9. What is a condition supplement and why would you use it? i. A condition supplement is a supplement for a particular par ticular condition type. For example, you can include a supplement every time you apply a material price. The supplement can contain various discounts. During pricing, the system automatically applies the discounts defined in the supplement every time it accesses a material price. You define for which condition types you want to t o use condition supplements in Customizing for Sales.
10. Which partner function is relevant when it comes to tax calculation in the sales order? i. Ship-to party.
11. Name at least three different condition types in pricing? i. Price, Discounts, Freight. PROO, K007, KF00.
12. You can create scales for prices and discounts. Name the four possible scale basis in R/3. i. Value, Quantity, Gross weight, Net weight, Volume.
13. Where would you specify that a condition type is a discount or a surcharge? i. In Condition Type Details Screen.
14. If somebody adds price elements manually in the sales order or if somebody changes a discount the system s ystem determined automatically, do you have a possibility to see that in the sales order? i. Yes. _____________________________________________________________________ 123
[email protected]
Pricing & Condition ________________________________________________________________________
15. You want to list all condition records for a certain material or a certain sales organization. How would you do that? i. By creating Pricing Reports. 16. Does the pricing procedure apply for the pricing data at item level or for the pricing data at header level? i. Both.
t he sales order the 17. When you create a header condition manually in the system can copy the values in different ways to the items. Where would you specify how the system should process? i. Condition Type.
18. Which data do you have to maintain in SD so that the system can determine the sales taxes in the sales order automatically? i. Tax rate with or without Jurisdiction.
19. What does the condition exclusion indicator do for you? i. The system can exclude conditions so that they are not taken into account during pricing in sales documents.
20. Can you explain what a statistical condition is? Give an example for a statistical condition? i. VPRS.
21. 21. For what do you use customer hierarchies? i. Pricing , Rebate.
22. Can you track cumulative values in R/3? If yes, it could be based on
_____________________________________________________________________ 124
[email protected]
Pricing & Condition ________________________________________________________________________
what? i. Yes. Maximum Value, Maximum Orders, Maximum Quantity.
23. If you want to make sure that conditions records apply for a certain time period only what would you have to do? i. Validity Period to be specified in condition record.
24. What is a group condition? i. Condition which can be used to determine a scale value based on more than one item in a document. The system groups the items using either the condition key for the appropriate condition record or a separately defined condition key.
25. Name the influencing factors for pricing procedure determination during sales order entry? i. Customer, Sales Document Type and Sales Area.
26. Can you copy condition records? If yes, are there any restrictions? i. Yes. Field specific.
27. If you create a new condition type-do you also have to create a new condition table and a new access sequence? i. Yes.
28. Where can you specify that a condition is mandatory? i. In Pricing Procedure.
29. Tax jurisdiction processing is a close link between which two _____________________________________________________________________ 125
[email protected]
Pricing & Condition ________________________________________________________________________
modules? i. FI & SD.
30. Do you have to create a condition record for taxes in the SD application? i. Yes.
31. Where is data about conditions stored? In conditions records
32. What does a condition type do? It determines the category of a condition and how it is used 33. What is an access sequence? It is a search strategy defined for the sequence in which the system reads the condition records for a condition type 34. What is a condition table? It is a combination of fields, which form the key for a condition record 35. At what other stage of COM (Customer Order Management) can pricing be re-determined? At billing time 36. How many condition tables used for each access sequence? One or more 37. Condition records are always created using a ------------Specific key 38. Can new condition records be created w.r.f to existing records? _____________________________________________________________________ 126
[email protected]
Pricing & Condition ________________________________________________________________________
Yes 39. Which condition type override a price or order value at header level? Condition type HM00 40. Which condition type used to create a minimum price for a material? Condition type PMIN 41. What does VPRS condition type in pricing? It gives the standard cost of the material 42. What does commercial rounding mean in rounding rule of condition type? It will round up nearest to the digit 43. Which two condition types are used in determining the customer expected price? EDI1 and EDI2 44. What does a group condition allow user to do? Allows to group items together and give the correct discount or surcharge to the sum or add an item in the group
45. Header conditions have access sequences (T/F) False 46. You can distribute header conditions using different methods T\F True 47. The records are retrieved by access sequence (the search strategy) is general to specific T\F False 48. SKTO is the condition type is used to retrieve the sales tax rate T\F _____________________________________________________________________ 127
[email protected]
Pricing & Condition ________________________________________________________________________
False 49. One condition type can be maintained as header condition and item condition as well T\F True 50. Condition table is the link between condition type and access sequence (T\F) False 51. Please, explain condition records in pricing Condition record is the place where you maintain the specific vale for the particular condition table. And if that condition is met then t he specific value maintained against that record would be pulled by the system The "condition record" is a area where the price or value is maintained for a particular condition. Simply the Condition Records are nothing but the data used by condition types to calculate pricing To put it more simply.... a condition record is nothing but the price of a product.
52. Do header condition type have an access sequence? No
53. What is Cumulative in Condition Records? There is a field: - "condition update" during configuration for a condition type (at v/06).is tick mark than we can see sales order value in cumulative in condition record
54. Where are all condition types permitted.? All condition are permitted in Pricing Procedure (V\08) _____________________________________________________________________ 128
[email protected]
Pricing & Condition ________________________________________________________________________
55. One condition tables can be assigned to how many condition types? None, Condition Table is assigned to access sequence.
56. 56 Which condition type override a price or order value at header level? HM00
57. During automatic calculation of sales taxes than which factors takes into account by the system? During automatic calculation of sales taxes, the system takes following factors into account The business being transacted is domestic or foreign Tax classification of the customer’s (Ship –to-party) Tax classification of material
58. What happens when you do not enter a value for a manual and mandatory condition type? The pricing procedure will reject the conditions in the sales order
59. IF you have 3 different access sequences for one condition record then what will you do? It is not possible
_____________________________________________________________________ 129
[email protected]
Pricing & Condition ________________________________________________________________________
60. What happens in the access sequence when you put all the ticks in the exclusive field? When you put tick in exclusive field of all access sequences, in my opinion, it will try to get available data from the first. Only in case, data is not available, will it move on to the next one.
61. What is meant by condition technique: can we say it is the combination of condition types, access sequence and condition tables? Yes
62. Where do we can find pricing procedure indicator in sd ? Pricing procedure is where we maintain all Conditions (like PR00, K004, mwst, kp00, etc)
63. What is the importance of requirement field in access sequence? System will not go to access condition type system will reply through formula
64. How do you control entry possibility of condition values at order through condition type settings? You can maintain the in condition record maximum and minimum value for all conditions. That will help you control the entry in sales order.
65. What is the standard group condition routine in condition type, what is its importance? It will help you to calculate the basis for the scale value when a group condition occurs in pricing.
_____________________________________________________________________ 130
[email protected]
Pricing & Condition ________________________________________________________________________
66. What are the customizing settings in pricing procedure for tax condition type? Check out the standard pricing procedure RVAA01 - MWST. 67. Condition tables in Pricing are used for storing ……. (fill in the blank) Condition record 68. Defining Access Sequences is an activity which is ……..(fill in the blank) Cross-Client 69. Pricing Procedure is a group of ……..(fill in the blank) Condition types 70. Can you explain condition technique used in SAP? It is a hierarchy of elements defining a data combination, which leads to certain actions. In pricing the condition technique refers to the method by which the system determines prices from information stored in condition records. In Sales and Distribution, the various elements used in the condition technique are set up and controlled in Customizing. During sales order processing, the system uses the condition technique to determine a variety of important pricing information. 71. Name four basic elements of condition technique Condition Types, Condition Tables, Access Sequences, Pricing Procedures. 72. Explain condition table and access sequence and the relationship between them. A condition table defines the combination of fields (the key) that identifies an individual condition record. A condition record is how the system stores the specific condition data that you enter in the system as condition records. For example, when you enter the price for a product or _____________________________________________________________________ 131
[email protected]
Pricing & Condition ________________________________________________________________________
a special discount for a good customer, you create individual condition records. 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. 73. What is a condition type? Which are the two main calculation types in condition types? A condition type is a representation in the system of some aspect of your daily pricing activities. For example, you can define a different condition type for each kind of price, discount, or surcharge that occurs in your business transactions. Fixed Amount & Percentage are two main calculation types used in most condition types. 74. You can create scales for prices and discounts. Name the four possible scales. A: Value, Quantity, Gross weight, Net weight, Volume. 75. What is a group condition? Condition, which can be used to determine a scale, value based on more than one item in a document. The system groups the items using either the condition key for the appropriate condition record or a separately defined condition key. 76. Where would you specify that a condition type is a discount or a surcharge? In Condition type definition screen.
_____________________________________________________________________ 132
[email protected]
Pricing & Condition ________________________________________________________________________
77. Name two header condition types HB00 (Discount-value) and HD00 (Freight) 78. You want to list all condition records for a certain material or a certain sales organization. How would you do that? By usage or creation of pricing reports. 79. What is the function of condition exclusion indicator? The system can exclude conditions so that they are not taken into account during pricing in sales documents. 80. Can you explain what a statistical condition is? Give an example for a statistical condition? Statistical condition is used in pricing for reporting purpose; the amount in the condition is not passed on to accounting. Example of statistical condition type is ‘VPRS – Cost’. 81. Where can you specify that a condition is mandatory? in Pricing Procedure. 82. Explain pricing procedure. The primary job of a pricing procedure is to define a group of condition types in a particular sequence. The pricing procedure also determines: - Sub-totals, which appear during pricing - To what extent pricing can be influenced manually - Method the system uses to calculate percentage discounts and surcharges. - Requirements for a particular condition type, which must be fulfilled before the system takes the condition into account. 83. Name the influencing factors for pricing procedure determination during sales order entry. Customer Pricing Procedure from Sold-to Party customer master record, Document Pricing Procedure from sales document type and Sales Area. _____________________________________________________________________ 133
[email protected]
Pricing & Condition ________________________________________________________________________
84. If you want to make sure that conditions records apply for a certain time period only, how it can be set? The Validity Period for particular condition type to be specified in condition record. 85. In pricing, header-level condition type does not have access sequence. True / False True. It does not need access sequence, as condition record is not required for header-level record 86. A condition record found by an access sequence can always be changed in the sales order pricing. True / False False, It can be changed depending on the settings in the definition of condition type, which allow change of condition in the sales order. 87. Can you post revenues of different types of materials to different G/L accounts? Yes. You can configure revenue account determination using material account assignment group, which is maintained in the material master 89. Which is the standard pricing procedure for US with tax jurisdiction code? RVCXUS 90. Do you have to create a condition record for taxes in the SD application? For determination of tax condition, condition records need to be maintained. Example - condition type ‘UTXJ’. 91. What is a condition type? A condition type is a representation in the system of some aspect of your daily pricing activities. For example, you can define a different condition type for each kind of price, discount, or surcharge that occurs in your business transactions. _____________________________________________________________________ 134
[email protected]
Pricing & Condition ________________________________________________________________________
92. What is the purpose of a condition record? Condition records allow you to store and retrieve pricing data in the system. All the pricing elements of your daily business like -Prices -Discounts -Surcharges for freight and taxes etc. that you want to use for automatic pricing must be stored in the system as condition records. 93. How many pricing screens are there in a sales document? There are to pricing screens in a sales document
item pricing screen, which gives the details of the prices for a particular item
Header pricing screen, which gives the sum total of all the prices applied to all the items and conditions, which are relevant for the whole document.
NOTE: header conditions do not have access sequence
94. What happens if validity periods overlap? If validity periods overlap then the system automatically splits the validity period for the particular rates to be active 95. Set of condition types is termed as condition record. (T/F) False 96. What are the three ways one can mark a condition type in pricing procedure? This are the three way mark in the pricing procedure for defining condition type’s characteristic Manually Mandatory Statistic
_____________________________________________________________________ 135
[email protected]