SAP Tech Pro

SAP Technical Blog
Topprice Price Comparison

SAP - Sales and Distribution – Pricing Configuration – Lesson 6

SAP - Sales and Distribution – Pricing Configuration – Lesson 6

Previous Lesson

1. Configuring Pricing Control

1.1. Define Condition Tables

This configuration setting enables creation of new pricing tables, which contain the fields used for price dependencies. Condition tables contain the fields, for the combination of which condition records are maintained.

It is recommended that system predefined condition tables are not modified; the following options are then available.

  • Copy existing condition table and change it to new requirements.
  • Create a new condition table. Number of table has to start between 501 and 999, if not specified system will automatically assign a sequential number.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define Condition tables

1. Click clip_image001

Following pop-up is displayed

Condition Tables

First the Field Catalogue needs to be checked for the fields that are required in a condition table

Condition Tables

The List of allowed fields by system in Pricing is displayed in this Field Catalog.

New Fields can be added in this catalog which also require system modifications to get the values populated in these additional fields during sales document processing.

Click clip_image006 andclip_image007.

2. Click on clip_image008 and clip_image009

For explanation let’s create a table with following fields Sales Organization, Distribution Channel, Division, Sold-to Party and Material.

Create Condition Table

Table no to be created is specified in field ‘table’ and if it is to copied from existing table enter the table number in field ‘Copy from condition table’ and click on clip_image012.

 
  Create Condition Table

Following screen is displayed

 
  Create Condition Table

By Default clip_image017 and clip_image018 are check marked. If the condition records that are to be maintained in this table do not require validity or release status they can be unchecked.

Enter the Description of table by clicking on icon clip_image019, which will open an editor.

Next the Fields are to be selected from the Field Catalog, the whole list can be scrolled up or down by clicking on any field and using the ‘Page up’ & ‘Page down’ buttons on keyboard.

First Search for ‘Sales Organization’ in Field Catalog, double click on the field when found. It will get transferred to Selected Fields as below.

 
  Create Condition Table

In a similar way select fields Distribution Channel, Division, Sold-to Party & Material in that order.

Create Condition Table

It is important to Check whether fields selected are the correct fields of table where data would be stored. To check this click on clip_image024

 
  Create Condition Table

Following fields are available:

Field Name

Field Description and Value

Short text

Displays the description of field selected

Key

This indicates which field is ‘Key’ field of table, i.e. for the combination of key fields there can be only a single condition record maintained.

If some field is not key that can be unchecked here. Also all the key fields are at start of table there cannot be non-key fields between two key fields.

Footer fld.

Indicates which field appears on Fast entry screen while maintaining the condition record

Text Field

Determines if text of field appears on fast screen. Here ‘Description’ of Material would appear on fast screen

Field Name

Technical field name of field selected in table

Data element

Data element of field which has attributes for that field like data type, field length etc.

Domain

Domain defines the value range for data fields

No of

Characters

The number of characters for field

Data Type

Data type of field like character, date etc.

Click clip_image012[1] andclip_image027.

Field attributes of each individual field can be checked by clicking

Create Condition Tableonclip_image029.

On checking of all fields in table, next step is to generate the table.

Click clip_image030.

There will be a system prompt whether you want to generate the table click on ‘Yes’.

Following pop-up is displayed

Create Condition Table

Following fields are maintained

Field Name

Field Description and Value

Package

Package is grouped related objects in ABAP workbench, it determines the transport layer. These are maintained by Technical Basis team and package created by them for storing Pricing condition tables needs to be taken and entered here.

Person Responsible

User name of person creating table, is usually copied.

Click on clip_image006[1] to generate and save table in a transport. A log is displayed after table is created.

Here table created is A956 Click clip_image006[2] andclip_image007[1].

3. Click on clip_image032 to modify existing condition tables.

4. Click on clip_image033 to display created condition tables.

Effect of Configuration

Condition tables are created and ready to be assigned to be assigned to access sequence so as to have pricing condition records stored in them.

1.2. Define Access Sequences

BACKGROUND

This configuration setting enables creation/modification of Access Sequence, which is a search strategy used by SAP to search for condition records.

It is recommended that system predefined Access Sequence is not modified; the following options are then available.

▪ Copy existing access sequence and change it to new requirements.

▪ Create a new access sequence; key should start with ‘Z’ as it is reserved for user requirements.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define Access Sequences

1. Click clip_image001[1]

Following pop-up is displayed

Define Access Sequence

clip_image035Click on clip_image036 and select .

 
  Define Access Sequence

Click clip_image038.

Define Access Sequence

Here the options explained in background are applicable.

a. If existing Access Sequence is to be modified, choose from list and double click on clip_image041 to get into details

b. For copying existing Access Sequence to new one select the access sequence to be copied and click on clip_image042 or F6.

c. For creating a new Access Sequence click on clip_image043

Here we will follow option ‘a’ and select order type PR00 and click on image. To search for correct Access sequence, click onimage

and enter the key.

Following screen is displayed

Define Access Sequence

2. To add on new accesses click on clip_image043[1]. Depending on where access is to be maintained access no is selected

Following Fields are maintained

Field Name

Field Description and Value

AcNo.

Indicates number of access within access sequence. Search is based on sequence of this number, here 10 is highest access no.

Tab

Condition table number to be entered here.

Description

Description of table number is displayed.

Requirement

Requirement for a particular access is maintained here. It’s an ABAP code.

Example ‘3’ here checks for foreign currency document.

Exclusive

Controls whether the system stops searching for a record after the first successful access for a condition type within an access sequence.

3. Next Select each individual access and double click on

clip_image049

 
  Define Access Sequence

No entries are to be made here, unless a particular field has to be changed here.

This is important for field assignment of particular access. Click clip_image006[3] andclip_image007[2].

Effect of Configuration

Access Sequence is created which has relevant search strategy to search for condition records for a condition type during pricing in sales documents.

1.3. Define Condition Types

BACKGROUND

This configuration setting enables creation/modification of Condition Types, which represent price elements of business environments in system.

It is recommended that system predefined Condition Types are not modified, the following options are then available.

  • Copy existing Condition Types and change it to new requirements.
  • Create a new Condition Type; key should start with ‘Z’ as it is reserved for user requirements.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define Condition Types

1. Click clip_image001[2]

Following pop-up is displayed

Define Condition Type

Click on clip_image053and selectclip_image035[1].

Condition type

Here the options explained in background are applicable.

a. If existing Condition Type is to be modified, choose from list and click on clip_image057 to get into details.

b. For copying existing Condition Type to new one select the Condition Type to be copied and click on clip_image042[1] or F6.

c. For creating a new Condition Type click on clip_image043[2]

Here we will follow option ‘a’ and select Condition Type ‘PR00’ and click on image. To search for correct Condition Type click on image

and enter the key.

Condition typeFollowing screen is displayed

The screen continues and further controls are observed by scrolling.

The controls are grouped in blocks and explanation provided is block-wise.

 
  Condition type

Following fields are maintained:

Field Name

Field Description and Value

Condit. Type

4 character key identifying Condition type

Access seq.

Access sequence defined earlier is assigned here.

Cond. Class

Preliminary structuring of condition types,

Condition type

Plus/minus

Controls whether condition results in a

 

amount which is positive, negative or both amounts are possible.

Condition type

Calculat. Type

Determines how system calculates prices, discounts in condition, like a fixed amount or percentage based on weight, volume etc. Many options are provided in system.

Cond. Category

Classification of conditions based on predefined categories like Freight, Cost etc.

Rounding Rule

Rule that specifies how system rounds off condition values during pricing.

Condition type

StrucCond.

Used in BOM items for duplication or cumulation of conditions.

 
  Condition type

Following fields are maintained:

Field Name

Field Description and Value

Group cond.

Mark field if it’s a group condition type

GrpCond. Routine

ABAP routine that can be used to identify scale basis in case of group conditions

RoundDiffComp

On indicator being set, system compares the condition value at header level with the total of the condition values at item level. The difference is then added to the largest item

Manual Entries

Indicator which controls the priority within a condition type between a condition entered manually and a condition automatically determined by the system

Condition type

Header Condit.

Mark this if Condition type is Header condition

Item Condition

Mark this if Condition type is Item condition

Delete

Indicates if condition can be deleted from document

Amount/Percent

Specifies if amount or percent can be changed in document for condition.

Value

Specifies if value of condition type can be changed in document.

Qty relation

Specifies if conversion factors can be changed.

Calculat. Type

Specifies if calculation type of condition type

can be changed in document.

 
  Condition type

Following fields are maintained:

Field Name

Field Description and Value

Valid from

Proposed validity start date

Valid to

Proposed validity end date

RefConType

Condition types which can be used as reference so that records can be maintained only once.

RefApplicatio

Reference application from other applications

Pricing Proc

Predefined pricing procedure is entered here for allowing condition supplements

Delete fr. DB

Allows deletion of condition record from database

Condition index

Specifies whether system updates one or more condition index when maintaining records.

Condit. Update

Limit values relevant for condition record.

Scale Basis

Determines how system interprets scale while calculating, eg Weight or Quantity scale.

Check Value

Indicates whether scale values are maintained in ascending or descending order

Scale Type

Validity of scale value is set here, like Base- scale or To-scale

Scale formula

Routine can be assigned here for calculation of scale

Unit of meas

Unit of measure used by system to determine scales, proposed while maintaining records.

 
  Condition type

Following important fields are maintained:

Field Name

Field Description and Value

Currency conv.

Currency varies from document currency, set here.

Accruals

Amount posted as accruals for this condition

 

type

Variant cond.

Mark if condition is used in variant pricing

Qty conversion

Quantity conversion is allowed in condition

Exclusion

If system excludes discounts proposed in pricing

Pricing date

Default Pricing date in system

Rel. Acc. Assig

Controls account assignment for condition type

Click clip_image006[4] andclip_image007[3].

2. Click on clip_image070 and click clip_image035[2].

Here entries are maintained if upper or lower limits for condition types need to be maintained, especially for Discount condition types.

Click on clip_image043[3]

 
  Condition type

Following fields are maintained

Field Name

Field Description and Value

CType

Condition type to be entered here

Condition type

Description of condition type gets copied.

CalTy

Calculation type, if percentage or fixed amount.

Unit

Unit of condition record

Lower limit

Enter lower limit if required for condition

Upper limit

Enter upper limit if required for condition.

Click clip_image006[5] andclip_image007[4].

Effect of Configuration

Condition Types for price elements are created to be used in pricing procedure and maintaining of condition records.

1.4. Define and Assign Pricing Procedures

1.4.1 Maintain Pricing Procedures

BACKGROUND

This configuration setting enables creation/modification of Pricing procedures, which are collection of condition types in particular, order for processing of Pricing in sales documents in system.

It is recommended that system predefined Pricing Procedures are not modified, the following options are then available.

▪ Copy existing Pricing Procedures and change it to new requirements.

▪ Create a new Pricing Procedure; key should start with ‘Z’ as it is reserved for user requirements.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define and Assign Pricing Procedures

1. Click clip_image001[3]

Following pop-up is displayed

Pricing Procedures

Click on clip_image073 and click on clip_image074

 
  Pricing Procedures

Here the options explained in background are applicable.

a. If existing Pricing Procedure is to be modified, choose from list and click on clip_image057[1] to get into details.

b. For copying existing Pricing Procedure to new one select the Pricing Procedure to be copied and click on clip_image042[2] or F6.

c. For creating a new Pricing Procedure click on clip_image043[4]

clip_image078Here we will follow option ‘a’ and select Pricing Procedure ‘RVAAUS’ and double click on . To search for correct Pricing Procedure click on and enter the key.

Following screen is displayed

Pricing Procedures

As explained Pricing procedure contains the condition types assigned in the sequence for correct pricing calculation to take place.

There are 16 columns containing important fields in Pricing procedure, these are explained below:

Field Name

Field Description and Value

Step

Step no in pricing procedure. Each condition type is calculated step wise and the relative positioning of each condition type is determined by step number.

Counter

Further subdivision of step no, multiple conditions can be maintained in same step number.

CTyp

Condition Type entered here

Description

Description of condition types

From

From reference step for percentage conditions.

To

To reference step for percentages, condition step up to which values of previous step are totaled.

Manual

If this is checked the condition can be entered manually in sales document.

Mdt

Mandatory, if this is checked, condition type is mandatory in sales document.

Stat

Statistical, if this condition is flagged the value of condition is not considered for pricing, it is displayed for information purpose. Eg. Cost condition type VPRS.

Print

Controls print issue of condition lines in document output of invoices or orders.

Following values are allowed:

Pricing Procedures

SubTo

Controls in which field and whether conditional values or subtotals amount are copied and stored. Example the cumulative taxes can be stored in a field. There are many fields provided by system to store these subtotals to.

Reqt

Requirement ABAP routine can be assigned here to check specific requirements are met for condition type, if not system marks them inactive.

AltCty

Alternate Calculation type, ABAP routine can be assigned here for alternative calculation than the one done by system. Example for Cash Discount minus tax calculation routine is available.

AltCBV

Formula for deriving Alternate Condition Base value can be assigned here as an ABAP routine.

ActKy

Account Key, identifier that is used as an input to select appropriate G/L account in revenue determination.

Accrls.

Accrual Key, identifier that is used as an input to select appropriate G/L account in accrual postings.

Click clip_image006[6] andclip_image007[5].

clip_image082

1.4.2 Define Customer Pricing Procedure

BACKGROUND

This configuration setting enables creation of Customer Pricing procedure key, which is then assigned to Customer Master and forms a part of logic for pricing procedure determination in sales document.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define and Assign Pricing Procedures

1. Click clip_image001[4]

Following pop-up is displayed

Customer Pricing Procedure

 
  Customer Pricing Procedure

System has provided for relevant entries, however if additional customer pricing procedure need to be created click on

clip_image043[5]

Following fields are maintained:

Field Name

Field Description and Value

Customer Pricing Procedure

1 Character key identifying Customer pricing procedure

Description

Description of customer pricing

 

proc.

Click clip_image006[7] andclip_image007[6].

1.4.3 Define Document Pricing Procedure

BACKGROUND

This configuration setting enables creation of Document Pricing procedure key, which is then assigned to Sales Document types and forms a part of logic for pricing procedure determination in sales document.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define and Assign Pricing Procedures

1. Click clip_image001[5]

Following pop-up is displayed

 
  Document Pricing Procedure

clip_image074[1]Click on clip_image086 and click on

 
  Document Pricing Procedure

System has provided for relevant entries, however if additional customer pricing procedure need to be created click on

clip_image043[6]

Following fields are maintained:

Field Name

Field Description and Value

Document Pricing Procedure

1 Character key identifying Document pricing procedure

Description

Description of document pricing proc.

Click clip_image006[8] andclip_image007[7].

1.4.4 Assign Document Pricing Procedure to order types.

BACKGROUND

This configuration setting enables assignment of Document pricing procedure key created to Sales Order types.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define and Assign Pricing Procedures

1. Click clip_image001[6]

Following pop-up is displayed

 
  Document Pricing Procedure to order types

clip_image089and click on

 
  Document Pricing Procedure to order types

Order Types created in Customizing are available here. The Document Pricing Procedure created earlier is assigned to correct order type.

Click clip_image006[9] andclip_image007[8].

1.4.5 Assign Document Pricing Procedure to Billing types

BACKGROUND

This configuration setting enables assignment of Document pricing procedure key created to Billing Document types. This activity is done for those Billing types that require a separate pricing procedure determined than one copied from Sales Order.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define and Assign Pricing Procedures

1. Click clip_image001[7]

Following pop-up is displayed

Document Pricing Procedure to Billing types

click on image and click on image

Document Pricing Procedure to Billing types

Billing types created in Customizing are available here. The Document Pricing Procedure created earlier is assigned to correct billing type.

Click clip_image006[10] andclip_image007[9].

1.4.6 Define Pricing Procedure Determination

BACKGROUND

This configuration setting enables determination of Pricing procedure in Sales document. The Pricing Procedure is determined based on the combination of following factors:

Sales Area (Sales Organization, Distribution Channel, Division), Document Pricing Procedure from Sales document or Billing Document types, & Customer Pricing Procedure from Customer Master.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define and Assign Pricing Procedures

1. Click clip_image001[8]

Following pop-up is displayed

Pricing Procedure Determination

Click on clip_image098 and click on clip_image074[2]

 
   

Field Name

Field Description and Value

SOrg.

Enter Sales Organization

DChl

Enter Distribution Channel

Click on clip_image043[7] to maintain for a new combination. Following fields are maintained

Dv

Enter Division

DoPr

Enter Document Pricing procedure key

CuPp

Enter Customer Pricing procedure key

PriPr.

Enter Pricing Procedure to be determined for above combination.

Pricing

Procedure

Description of Pricing procedure

Ctyp

Enter Default condition type to be seen in double line entry screen in order processing

Condition type

Description of condition type entered.

Click clip_image006[11] andclip_image007[10].

1.4.7 Define Pricing by Item Category

BACKGROUND

This configuration setting enables pricing for items in Sales document by activating pricing at item category level. It also activates Cost determination for specific item categories.

Instructions

Follow Menu Path: IMG –> Sales and Distribution –> Basic Functions –> Pricing –> Pricing Control –> Define Pricing by Item Category

1. Click clip_image001[9]

Following pop-up is displayed

Click on clip_image103 and click on clip_image074[3]

Item Categories created in customizing are available here.

For Item categories to have Pricing enabled following options are available in field ‘Pricing’

Field Statistical values has following values

Pricing by Item Category

Click clip_image006[12] andclip_image007[11].

2. Click on clip_image109 and click on clip_image074[4]

Item Categories created in customizing are available here.

Item categories that need to have cost determined are checked in the box provided here.

Click clip_image006[13] andclip_image007[12].

Effect of Configuration

Pricing Procedure is configured and is set for automatic determination in Sales document for Pricing to be done.

Add comment

Before Buying, Compare Prices at Topprice.in

Topprice.in