Skip to Content
avatar image
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 SD pricing procedure?

Regards

venu gopal

Edited by: venu kk on Jun 18, 2008 11:18 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 18, 2008 at 09:23 AM

    Hi,

    Condition table means group of fields which plays a crucial role in maintianing condition records for condition types..

    When standard condition tables are not fulfilling your requirement then u can create your own condition table...

    Regards

    sankar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2008 at 09:25 AM

    Hi,

    A condition table defines the combination of fields (the key) that identifies an individual condition record.

    When your requirement is for different fields and combinations which are not in the standard then you need to create Condition tables. e.g. If you want pricing procedure wrt Purchase group/sales organization wise, which may not be in standard condition table. so you can make your own condition table with this combination.

    Hope this will help.

    reward Point if helpful.

    thanks,

    raja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2008 at 09:27 AM

    Hi,

    A condition table defines the combination of fields (the key) that identifies an individual condition record.

    Example of a Condition Table

    A sales department creates condition records for customer-specific material prices. The standard R/3 System includes condition table 005 for this purpose. The key of table 005 includes the following fields: Sales organization , Distribution channel, Customer, Material.

    005 - Custmer / Material

    004 - Material

    006 - Pricelist/ Currency / Material

    007 - Div / Material.

    These are some of the standard condition tables.

    PRase

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 18, 2008 at 09:28 AM

    Dear venu gopal

    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 R/3 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.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Take an example If you want to sell a product to a specific customer say XYZ in specific Sales Org. say 1000 and Distribution channel 10, then you want to charge him 1000 Rs.

      and to the customer ABC, for Sales Org, 1000 and Distr. Channel 10, you want to charge 980 Rs,

      So what you will Do.?

      In your pricing procedures You will make one condition table with Following combination Customer/ Sales Org/ Distr. channel. and maintain the record like this

      Cutomer Sales Org Distribution Channel Price

      XYZ 1000 10 1000

      ABC 1000 10 980

      These are Condition records.

      Hope this will help you.

      Reard point if helpful.

      Thanks,

      Raja

  • Jun 18, 2008 at 11:40 AM

    Dear venu

    If you are satisfied with the suggestions given, please close the thread with suitable points to the contributors to say thanks to them. If still you need any clarification, please come out with our further questions.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded