Skip to Content
author's profile photo Former Member
Former Member

Condition Table

Dear all

Wht is the purpose of the condition table, when we need to create new condition table, wht are the diffrent standard condition table available for our MM pricing procedure?

Regards

venu gopal

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 09:15 AM

    hi,

    condition records are stored in condition table.

    for defining the access sequence one has to have the condition tables....

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 09:18 AM

    Hi,

    A condition table defines the combination of fields (the key) that identifies an individual condition record. A condition record is how the system stores the specific condition data that you enter in the system as condition records. For example, when you enter the price for a product or a special discount for a good customer, you create individual condition records.

    Example of a Condition Table

    A sales department creates condition records for customer-specific material prices. The standard version of the SAP System includes condition table 005 for this purpose. The key of table 005 includes the following fields:

    - Sales organization

    - Distribution channel

    - Customer

    - Material

    The first two fields identify important organizational data and the last two fields express the relationship between customers and specific materials. When the sales department creates a condition record for a material price or discount that is specific to one customer, the system automatically uses condition table 005 to define the key and store the record.

    The following figure illustrates the connection between the condition table and the subsequent condition records.

    Condition Tables from 001 to 500 are SAP Standard and you can create Ur own from 501 to 999

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 09:18 AM

    hi

    table that defines the structure of condition record keys.

    The key consists of a variable part that represents one or more fields, and a fixed part that is identical for all condition records.

    Diff Condition Tables are

    001 Not Used in Standard

    015 Not Used in Standard

    016 Contract Item

    017 Material Info Record (Plant-Specific)

    018 Material Info Record

    019 Contract Header

    025 Info Record for Non-Stock Item (Plant-Specific)

    028 Info Record for Non-Stock Item

    043 Material Type

    044 Vendor

    045 Vendor Condition Group

    046 Material Group Prices

    047 Material Group Prices (Plant-Specific)

    048 Incoterms (Plant-Specific)

    049 Market Price for Material

    050 Incoterms

    051 Invoicing Party

    052 Invoicing Party (Specific to Info Record)

    054 Market Price for Material Group

    066 Info record per order unit

    067 Plant Info Record per Order Unit

    068 Outline Agreement Item: Plant-Dependent

    069 Vendor Subrange

    080 Taxes: Material

    085 Metal Prices

    086 Taxes: Material, Plant and Origin

    087 Taxes: Plant, Account Assignment Origin and Region

    088 Taxes: Material, Plant, Acc. Assignment, Origin and Region

    094 Taxes: Material, Plant, Origin and Region

    107 Vendor Hierarchy

    108 Vendor Hierarchy / Material

    109 Vendor hierarchy: vendor sub-range

    118 "Empties" Prices (Material-Dependent)

    160 Plant Info Record: Variants

    161 Info Record: Variants

    162 Invoice recipient

    181 TaxIndPlnt/Tax type

    182 Region/PlntRegion/Plant/Tax ind.

    300 Statistical value of subcontracting components

    301 Info record type and Incoterms

    310 Duty rate customs exemption: Importing ctry/Code/Material

    315 Cust.duty anti-dumping: Import/Code/Orig.ctry/Manu./Exp./Mat

    316 Anti-dumping Duty Rate: Imp.Ctry/Code/Orig.Ctry/Anti-d. Code

    317 Anti-dumping Duty Rate: Imp.Cntry/Code Number/Cntry of Orig.

    320 Third country Duties: Import ctry/Code/Orig.ctry/Ship.ctry

    321 Third Country Duty Rate: Import Country/Code

    325 Duties Pharma. Products: Import country/Code/CAS/Material

    326 Pharm. Products Duty Rate: Import Country/Code/Pharma. Code

    330 Preferential Cust.Duties: Imp.ctry/Orig.ctry/Ship.ctry/Matl

    331 Preference Duty Rate: Import Ctry/Code/Orig.Ctry/Pref. Type

    335 Quota Duty Rate: Imp.ctry/Code/Orig.ctry/Proc./Mat/Quota

    336 Quota Duty Rate: Import Country/Code/Orig.Ctry/Quota Number

    338 Purch.doc./Plant

    345 Ceiling Duty Rate: Import Country/Orig.Country/Ceiling No.

    365 Trading contract/vendor/material

    412 Vendor/Plant/Material/Base Product

    442 Full Rate Excise Duty Company/Plant/Tax Group

    443 Red Rate Exc Duty Comp/Plant/Tax Group/Handling Type

    444 Two-step transfer with tracking sign

    445 Material

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 09:27 AM

    Hi,

    Condition Table:

    The key consists of a variable part that represents one or more fields, and a fixed part that is identical for all condition records

    To display discount , tax , fright , insurance ,excise item wise in PO output and in the table these condition will be stored

    These are the tables which stores pricing conditions:

    KONH Conditions Header data

    KONV Conditions for Transaction Data

    KONP Conditions for Items

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.