Prcing Procedure,Condition Update,Currency
Prcing Procedure,Condition Update,Currency
• SAP SD Pricing elements such as list price, discounts or surcharges,freight and taxesare used to
determine the final price that is charged to the customer. In this article, we will cover SAP SD pricing
• It automates pricing
calculations by applying
predefined condition records
based on several factors like
customer, product, and sales
organization.
Condition Techinique
Access Pricing
Conditio Conditio
Sequenc procedur
n Table n Type
e e
Condition Tables
• A condition table in SAP SD (Sales and Distribution) is a combination of fields used to maintain
condition records. These tables are essential for pricing, as they define the structure for storing and
retrieving condition records.
• This is a three-digit numeric code. Custom pricing conditions are usually Started by a 5 (i.e.,
501,502, etc.).
• Why Choose Condition Table Numbers Above 500 :
SAP reserves numbers below 500 for standard tables. Custom condition tables should use numbers
500 and above to avoid conflicts with SAP’s standard tables and for easier maintenance.
•T code : v/03
•Conf: Go to the IMG path: SPRO -> SAP Reference IMG -> Sales and Distribution -> Basic
Functions -> Pricing -> Pricing Control -> Define Condition Tables.
Field catalogue
• A field is a single piece of information, like a customer or product, used to organize
data in a table.
• The fields chosen from the catalog impact how the system applies pricing conditions
• The maximum number of fields that can be assigned to a condition table is 20 fields.
This includes both key fields and non-key fields. Out of these, up to 4 fields can be
defined as key fields
• The system checks whether the condition is relevant for the entire document (header) or for each line
item.
Text Field :
• It is used for entering descriptions and notes related to pricing conditions.
• It provides additional context or explanation about the condition, which can be helpful for reporting
or
Why A before Table no.
• When you create a new condition table, SAP assigns an internal technical name
starting with "A" to uniquely identify that table within the pricing functionality.
• SAP uses "A" for all condition tables to easily identify them as pricing-related
tables in the system.
Menu Path: IMG >> Sales and Distribution >> Basic functions >> Pricing >> Pricing
Control >>Define Access Sequence.
• T-code: V/07
If you go to utilities
The same usage and
application will be seen in
Pricing procedure Tab (v/08)
Generate Access Sequence in V/07
1. Usage:
Defines the type of conditions: (A = Pricing B = Output)
2. Application:
Specifies the functional area:(V = Sales & Distribution M = Materials Management)
3. Access Sequence:
Defines the number of the access sequence, which determines the search strategy.
Example: 001
4. Online Generation:
• Checked: Access sequence generated immediately
• Unchecked: Generated later (background/batch job)
• Purpose:
Automates access sequence creation based on predefined settings.
• Example Use Case:
Generate a new access sequence for pricing (Usage: A, Application: V) with predefined settings,
ensuring consistency and efficiency.
• Access Sequence Requirements are more about controlling the selection of condition records, which is a prior
step before pricing calculation.
• In Pricing Procedure Requirements are related to conditions (such as discounts, surcharges, etc.) applied during
the calculation phase.
Key Difference :
• Placement in Access Sequence: Controls the condition records that will be considered during pricing (access to
condition records).
• Placement in Pricing Procedure: Controls if and how the condition types should apply once the condition
records are found.
600 usd
400 usd
500 usd
1.Const. Value Source:
Specifies a constant value for the field, instead of fetching it dynamically from the transaction.
2.Init (Initial Indicator):
If it is checked, the field is initialized to a blank/default value when no data is found. This allows the
condition lookup to proceed.
3.Access Control:
Defines how the field is handled during condition lookup:
B: Allows blanks during lookup.
C: Field must have a value, or the lookup fails.
4.Priority:
Search order for fields:
Lower numbers (e.g., 0) mean higher priority.
System checks higher priority fields first in the access sequence.
Condition Type
• A condition type is a pricing element like discounts,
surcharges, or taxes. It defines how pricing will be
calculated in the system
• This is a four-digit alphanumeric code condition.
• Condition Type Configuration
It defines at which point in the pricing procedure the system should consider the condition type during the sales
document creation
Indicates if the condition is applied at the group Defines a formula routine to apply the
level condition in group contexts (Weight)
Manages rounding differences for group conditions
Specifies if manual entries are allowed
Condition
• Tracks Discounts & Rebates: Keeps track of
Update & cumulative discounts or rebates to ensure limits aren’t
exceeded.
Its Importance • Quota Management: Ensures that conditions with
in OTC quotas (e.g., discounts) are enforced during pricing.
• Accurate Pricing: Condition updates keep pricing
accurate by recalculating values for each order or
invoice.
• Rebate Settlements: Tracks rebates retroactively for
correct payout during settlements.
Example - Discount for First 5 Orders
Step 1: Create Discount Condition Type (ZDIS)
Step 2: Set Up Condition Table (Track Customer and Order Count)
Step 3: Assign to Pricing Procedure (V/08)
Step 4: Apply Discount to First 5 Orders (Condition Update Active)
Step 5: After 5th Order, Discount Stops
Overview
T-code: OVKK
• The Document Pricing Procedure
(DoPr) code from the document type
T-Code: V/08
16 Fields in Pricing Procedure
1) Step :
2) Counter :
• This flag determines whether the condition type should be printed on the customer's invoice or
other relevant documents.
• This is used for some condition types (like internal costs) are marked not to be printed on
customer-facing documents.
11) Sub total:
• This field is used to store the result of a pricing step in a specific subtotal. The subtotal field allows the system
to reuse or refer to the result in later steps (e.g., calculating taxes based on a subtotal).
• This helps in accumulating pricing values for further calculation. For instance, a subtotal could be used to store
the cumulative value of all discounts applied.
12) Requirements
Specifies conditions that must be met for a condition type to be applied, ensuring certain criteria (e.g.,
customer region or order value) are fulfilled before applying the condition.
Types of routines :
• Pricing Routines: Used to calculate the value of conditions (e.g.,
discounts, surcharges, etc.).
• Access Routines: Control whether a condition type is applied based
on certain criteria.
Note : Routines integrate with other modules like Sales and
Distribution (SD) and Financial Accounting (FI) to implement complex
business rules.
Exclusion
pricing conditions should be excluded from the
pricing calculation. It ensures that specific
conditions are bypassed when exclusion criteria are
Net Value + Tax (4): Adds both net value and taxes for condition
calculation.
Expected Price (9): Ensures the price matches the customer's expected
price, often derived from agreements or contracts.
Best Price (14): Selects the lowest possible price for the customer by
comparing different conditions.
Actual Metal Price (32): Bases the price on the actual, up-to-date price
of metal commodities.
Net Value, Gross Weight, Net Weight (2, 3, 12, 13): Use net value or
weight to calculate the condition base, affecting freight or cost calculations.
Cash Discount Base (11): Sets the base for cash discount eligibility.
Step 4: Pricing
Step 5:
Calculation (System
Rounding/Adjustme
converts all values
nts (Adjust for
to the document
differences after
currency for final
conversion)
pricing)
Currency’s Impact on Pricing Procedure
A flow of how currency impacts pricing:
Sales Order Creation ➜ Currency Determination ➜ Condition Records in Different Currencies
➜ Pricing Calculation in Local and Document Currency