![SAP SD Tutorial](/sap_sd/images/sap-sd-mini-logo.jpg)
- SAP SD Tutorial
- SAP SD - Home
- SAP SD - Introduction
- Customer & Material Master Data
- SAP SD - Create Partner Function
- SAP SD - Create Material Stock
- SAP SD - Create MM For Sales View
- SAP SD - Customer Account Groups
- SAP SD - Pre-Sales Activities
- SAP SD - Create Quotations
- SAP SD - Sales Support
- SAP SD - Sales Order Processing
- SAP SD - Creation of Sales Order
- SAP SD - Defining a Sales Document
- SAP SD - Item Categories
- SAP SD - Schedule Lines Categories
- SAP SD - Copy Control
- SAP SD - Log of INComplete Items
- SAP SD - Pricing
- SAP SD - Condition Record & Table
- Condition Techniques & Types
- SAP SD - Access Sequence
- Prices, Surcharges & Discounts
- SAP SD - Product Proposals
- Listing, Determination & Exclusion
- SAP SD - Sales Order Types
- SAP SD - Free of Charge Deliveries
- SAP SD - Outline Agreements
- SAP SD - Quota Arrangement
- SAP SD - Special Business Process
- SAP SD - Shipping
- Shipping Point & Route Determination
- SAP SD - Define Routes & Stages
- SAP SD - Outbound Delivery
- SAP SD - Delivery Processing
- Picking, Packing & Post Good Issue
- SAP SD - Introduction to Billing
- SAP SD - Billing Methods
- SAP SD - Credit Management
- Mapping Enterprise Structure
- SAP SD Useful Resources
- SAP SD - Questions Answers
- SAP SD - Quick Guide
- SAP SD - Useful Resources
- SAP SD - Discussion
SAP SD - Condition Record & Table
A Condition table is defined as a combination of keys to identify an individual condition record. A condition record is defined as how system stores the specific condition.
Example of a Condition Record − Entering the price of a product or to specify the discount for a privileged customer.
Example of a Condition Table − Condition records for a customer specific material prices are stored by a sales department. SAP system contains a conditional table 005 for this purpose. Key of table 005 includes the following field −
- Customer
- Material
- Sales Organization
- Distribution Channel
In the first two fields, the customer and material determines the relationship between customers and specific materials. The last two fields are used to identify organization data in a SAP system. Now, if sales department in an organization enters a condition record for discount to one privileged customer, the system will automatically make use of the condition table 005 to store the record and define a key. Any standard SAP system contains predefined condition tables and specifies for each access in a predefined access sequence.
Creating Condition Tables
In a SAP system, you can create or change existing condition tables. As per the new business requirement in an organization, you can create new condition tables.
Go to SPRO → IMG → Sales and Distribution → Basic Functions → Pricing → Pricing Control → Define Conditional Tables
![Condition Tables](/sap_sd/images/condition_tables.jpg)
A new window will open and then you can select from create, change or display field as per the requirement. To create a new table, you have to select create and click on Choose.
![Choose Activity](/sap_sd/images/activity.jpg)
Enter condition table in table field and then you can enter the existing table to copy the condition.
![Pricing sales/distribution](/sap_sd/images/sales_distribution_pricing.jpg)
Once data is copied, you can modify the table as per the business requirement.