- 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
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.
Enter condition table in table field and then you can enter the existing table to copy the condition.
Once data is copied, you can modify the table as per the business requirement.