Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

pricing

What all things the SD consultants want to do in pricing?

replied

Hi,

find some document on pricing.

Img menu u2026 sales and distribution u2026 basic functions u2026 pricing u2026 pricing control u2026 define and assign pricing procedures u2026

Define pricing procedure determination

Select new entries

Pricing

Pricing procedure determination rule = sales org.+dist.channel + division + document pricing procedure + consumer pricing procedure + pricing procedure.

Document pricing procedure = as maintained in sales document type example IN, QT, OR the value = A

Customer pricing procedure = As maintained in customer master record. The value =1

Example of assignment = 1000 + 12 +00 A + 1 + RVAA01 and ctype=PR00

u201CEACH PRICING PROCEDURE DETERMINATION ROLE IS UNIQUEu201D

How to maintain condition records

Menu Path :

SAP menu u2026 logistics u2026 sales and distribution u2026 master data u2026 conditions

VK31 create (Option 1)

Same menu path u2026 select using condition type - VK11 (Option u2013 2)

Select prices

Select material price

Select the create button

Fields

A: Sales Organisation u2013 V002

B: distribution channe - VD

C: Material u2013 u201CMaterial Codeu201D

Select condition type as PR00 enter the rate

Ex : Rs.17000 u2026 Continue. System automatically assign all the other values just the validity periods

Valid on u2026u2026 Valid to u2026.

Create the order enter the details.

Select the line item and conditions icon, now the system will show the value Rs.17000/-

Maintain the 2nd level price :

First find what prices can be maintained

T.Code VI31 select price and select price list type

Select create button

Fields

A: Sales organization u2013 V002

B: Dist. Channel u2013 VD

C: Price list type : Whole sale (01)

D: Document currency : INR

Here you maintain scale price

Select the line and select scale

Icon (double click) or F2

Now maintain in the customer record the price list type : 01 (Wholesale)

Create the order and check the price determination

Now maintain specifically for the customer a price for the same material VK31

Selcet prices

Select individual prices

Sales Org : V002

Dist Channel : VD

Customer : BHEL

Material : u201CMaterial Codeu201D

Create the order and check.

Condition technique components + 1. Procedure 2. Condition Type3.Access sequence 4. condition tables 5. Assessment of Procedure

Condition technique = Search and select.

Condition Type :

- The pricing elements considered in the calculation are called as u201CCondition Typesu201D

- So the condition types may be basic price, material discount, tax, freight etc.,

- u201CPR00u201Dis condition type for basic price :

- A condition type is a representation in the system of same aspect of your daily activities

- For example you can define a different discount or surcharge that occurs in your business transaction

Menu Path for condition type :

Img menu u2026 sales and distribution u2026 basic function u2026 pricing u2026 pricing control u2026 define condition types u2026 select maintain condition types.

Position select : PR00

Select details button.

Condition Type Description Condition Class Calculation Type Access Sequen. Condition Table

PR00 PRICE PRICES QTY PR02 305,304,306

K004 MATERIAL DIS/SURCHARGE QTY K004 4

K005 CUSTOMER /MATERIAL DISCOUNT QTY K005 5

K007 CUSTOMER DISCOUNT SURCHARGE %AGE K007 7

KF00 FREIGHT - DO - GR. WEIGHT K007 34,33

MWST OUTPUT TAX TAXES %AGE MWST 78,2,11

Condition Type Properties :

 Condition class

 Calculation type -- IMP

 Plus / Minus effect

 Manual Entries -- IMP

 Item condition / header condition u2013 VVIMP

 MASTER DATA / VALIDATION PERIODS

 SCALES

Automatic Condition Type : For a condition type which is automatic we can expect the system to search for the value at condition type during pricing.

For automatic condition type we can record the value as condition record

It also means a condition type has an access sequence which can search and select the particular condition record value matching with condition of sale.

Access sequence : The aces sequence assigned to an automatic condition type access, the condition records in a predefined sequence.

o The search strategy used for a particular condition type.

o Condition table is identified by a number 1 to 999

o 1 to 500 tables are reserved by SAP

o These are called SAP defined tables

o These tables cannot be changed or deleted

o Any user defined table to have number 501 to 999

Material Price

Sales org. V002

Dist. Channel VD

Material V250

1. Table for Material Price u2013 Table No.304

S.Org. Dist. Channel Materils

V002 VD V250

V002 VR V251

2. Price List Type u2013 Table NO.306

S.Org. Dist. Channel Price list type Doc. Type Materils

V002 VD 01 INR V250

V002 VR V251

3.Customer Material u2013 Table No.305

S.Org. Dist. Channel Customer Material

V002 VD 01 INR

Access No. Table Exclusive

10 305 Yes

20 306 Yes

30 304 Yes

Menu Path :

Img menu u2026 sales and distribution u2026 basic function u2026 pricing u2026 pricing control u2026 define access sequence

Select PR00

Click on access folder

Select first record

Click on fields folder.

DEFINE PRICING GROUP FOR CUSTOMERS

Same Menu path,

Select New Entries

Price group Description

4 Pharma

5 Insurance

6 Telectom

Save.

Pricing Control.

Same Menu Path for pricing control

Define condition tables

Create condition tables

Table 501 continue

Click on change button and maintain description

Ex : Material Price.

Select the fields from catalog and add to the list of select fields

Select the fields from the catalog and double click to add

Sales organization, Distribution channel, material select generate button

Yes to the dialog box.

TABLE FOR PRICE LIST TYPE

Create condition tables

Table 555 continue

Description u2013 price list type

Fields : Sales Organisation, Distribution Channels, Price list type, Material type, Material

MATERIAL INDIVIDUAL CUSTOMER

Same Menu Path :

Table 556 Continue

Description : Customer-Material Price

Fields

Note : for the customer field select fields u2013 Sales organization, Distribution channel, Customer(2), Sales Office.

Tables created 501, 555, 556

Second Activity :

Create the access sequence

Same menu path :

Select define access sequence

Define access sequence

Maintain access sequence

Dialogue : The table is cross client (Cross client means the access sequence what is created here in this client i.e. 800 is simultaneously also created in all the clients existing in the R/3 system i.e. 000,001, clients.

Select new entries

Access Sequence Description

ZPR2 Access Sequence for Price

Enter and Save.

Select ZPR2 and select accesses

Select new entries

Access No. Table Exclusive

10 556 Tick

20 555 Tick

30 501 tick

Enter

Dialogue box : local object continue select access No.10 and select fields

Warning : field assignment not done

Enter

Now the fields are activated

Repeat the exercise for access no.s 20 and 30.

Save and back.

THIRD ACTIVITY : CREATE CONDITION TYPE :

It is recommended thus standard condition type and then copy name with letter u2018Zu2019 and then adjust the control properties.

Same Menu path

Select define condition type

Select maintain condition types

Position and select PR00 (Price)

Change PR00 to ZPR2

Assign u2013 Access sequence u2018PR02u2019 to u2018ZPR2u2019

Master Data

Valid from u2013 blank

Valid to u2013 select 5 (No Proposal)

Manual Entries : Selected B which means automatic determination has priority

Save the condition type.

Now check whether condition type can accept the records

Easy Access u2026 SAP Menu u2026 Logistics u2026 SDu2026 Master Data u2026 Condition.

Select using condition types

VK11 u2013 create

RELATIONSHIP BETWEEN VARIOUS ELEMENTS OF CONDITION TECHNIQUES :

Condition Records u2013 By use in easy access

Condition Tables

Access sequence

Condition type

Procedure

CREATE NEW PROCEDURE :

Create the procedure

Imgu2026 sales distribution u2026 basic functions u2026 pricing u2026 pricing control u2026 define and assign the pricing procedure.

Select maintain pricing procedure

Position and select u201CRVAA01u201D

Select copy as u2013 Z00001 u2013Voltas Standard

Pricing procedure u2013 Enter

Dialog box .. Copy all .. Yes

Use the continue button for all the dialogs till the entries are copied into the new procedure

Save the procedure.

Now assign the procedure to sales ares

Back

Select define pricing procedure determination.

Select new entries

S.org D.C. DIV Doc.Pric. Proced. Cust. Price Procedur. Price Procedure Cond. Type

V002 VD V1 A 1 Z00001 ZPR2

CREATE DOCUMENT PRICING PROCEDURE :

Each pricing procedure determination or assignment is unique. So if it is requires that two procedures may have to used for the same sales area then we can use the option of maintaining either different document pricing procedures or customer

Pricing Procedure

Same Menu Path

a) Define customer pricing

b) Define document pricing procedure

Document pricing procedure Description

S Depot Supplies

T Factory supplies

S.Org DC DIV Doc. Proc Cust. Proc Pric. Proc C.Type

V002 Vd V1 S 1 Z00001 Pr00

V002 Vd V1 T 1 Z00001 Pr00

PRICING PROCEDURE :

The pricing procedure is the heart of the condition technique used for pricing application.

Features of pricing procedure

o The methodology or the rule used for the calculation of pricing in sales document / billing document

o The pricing procedure contains all the condition types that are required for pricing calculations. These condition types are arrange in a logical sequence in which calculation takes place

o Procedure contains controls which can be activated

o In addition the pricing procedure contains account keys which are essential for finding the relevant GL accounts when the bill is saved

Menu path :

Img u2026 sales and distribution u2026 basic functions u2026 pricing u2026 pricing control u2026 define and assign the pricing procedure u2026 select maintain pricing procedure

Position u201CRVAA01 and then select control table

Structure of the pricing procedure

The procedure consists of 16 columns and field value maintained in each column controls the working of the procedure

1. STEP : The sequence number be liberal for selecting steps such a way that you maintain deliberately some gaps so that editing becomes easier. Ex: 10,20,30,etc.,

2. CNTR : Condition counter a mini step within step Ex : Mini steps 1,2,3 within step 30

3. CTYPE: Condition type which is to be accessed or provided value in the teip

4. DESCRIPTION : The description of the condition as maintained in the definition of the condition type

5. FRO : From indicates a particular step whose value is referred for calculation the condition value in another step.

6. TO : To integrates again the step but here both from and to steps will be used from and to when used together system will add the condition values of all the steps within this range example. Fro : 100 To : 299 The value total discount which is appearing in the step number 300 the value is calculated adding the values. These are calculated in steps 101 to 299 (101 to 300)

7. MAN : Manual . The condition value will be entered manually during pricing.

8. MDT : Activate this box for those condition types whose values are critical in the pricing example : Basic price, tax

9. STAT : Statistical : If the condition type is activated as statistical then the condition value will not be after the calculation or will not be used in the calculation

10. P : Print : Select u2018Xu2019 then the value can be printed in the document

11. SUB : Indicates the field which is automatically updated in a particular table (further control purpose / statistical)

12. REQT : Requirement : The requirement specifies a particular condition only when that condition is met this system will use the condition type in the pricing. Ex : Tax, the requirement is 10 which means plantset, if plant is not determined in the order system will not search for tax value

13. ALTCTY : Alternate calculation type : The system can use a predetermined calculation method to calculate the condition value.

14. ALTCBV: Alternate condition base value : The system again uses a equation to re-fix the condition base value (Mostly relevant for header level)

15. ACTKEY : Acount Key : The account key maintained against the condition type will identify the GL a/c for posting (To be discussed in detail during billing)

16. ACCRLS : Accruals : Accruals account keys used for posting rebate accruals /provisions.

Create/build a pricing procedure using new entries.

Menu Path :

Img u2026. Sdu2026 basic functions u2026 pricing u2026 pricing control u2026 define and assign pricing procedures u2026 maintain pricing procedure (VOKO)

Select New Entries :

Procedure Description

ZVL Voltas Pricing Procedure

Enter

Select ZVL and select control tables

Select new entries

Create a pricing procedure which can be used to calculate the pricing to meet following requirements.

The Procedure should include condition types as below.

a) PR00

b) K004

c) K005

d) K007

e) KF00

f) MWST

g) VPRS (COST)

Requirements :

1. Condition values for PR00 and MWST are mandatory

2. Condition value for VPRS is statistical

3. The value for K007 to be calculated on the net value which includes the discounts K004 and K005

4. The system to show the total discount value

5. The tax value to be calculated on the net excluding freight

6. All the condition values are to be automatically determined.

7. Basic price (PR00) after the determination can be changed manually.

Best Regards,

venkataswamy.y

Edited by: yanamadala venkataswamy on Sep 23, 2008 2:19 PM

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question