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

Create condition table

Can anybody explain how to create a condition table in a detailed manner step by step?

Thanks in advance for the answers.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 04:28 AM

    HI

    You can change and maintain the condition tables in the standard system. You can also create new condition tables to meet the needs of your own organization. You create and maintain condition tables in Customizing.

    From the initial screen of Customizing for Sales and Distribution, you reach the condition table screens by choosing Basic functions --> Pricing -->Pricing Control -->Define condition tables. Then select the mode you want to work with (create, change, display).

    ou can create new condition tables to meet the pricing needs of your organization. When you create a new condition table, you select a combination of fields from the list of allowed fields. The selected fields define the key for the subsequent condition records.

    Before you select the fields for the key, there are two things to consider:

    • The sequence (or hierarchy) of the fields

    • Which fields you want to appear in the header and item areas of the corresponding fast-entry screens

    Important Fields

    In sales, the fields you should take into consideration are Sales organization and Distribution channel. The sales organization is nearly always used as a criteria in pricing, because different sales organizations often want to use their own prices, discounts, and surcharges. If you use the sales organization as a criterion in pricing, you should also use the distribution channel. If you do not want to establish different prices, discounts, and surcharges for each distribution channel, use the field anyway. In Customizing for Sales, you can use one distribution channel as a reference for all others (thereby sharing the same pricing data).

    Deciding the Sequence of Fields

    The order of the fields in a condition table affects the performance of the system during pricing. Two general guidelines will help you create an efficient condition table:

    1. If you select fields that are connected to the structure of your organization (for example, sales organization and distribution channel), assign the fields according to the level of general applicability: Put the most general field, for example, the sales organization in the highest position and the most specific field in the lowest.

    2. After organizational fields, place fields from the document header before those that come from the item level. (For example, Customer comes before Material)

    After you have selected the fields for the key on the screen where you maintain and define condition tables, choose F16 Generate to generate the table in the system. Generation prepares the condition table for storing condition data.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 05:52 PM

    v/03

    give the con table number whcih u want to create ...ex ( 970)

    then select the fields from your right hand side i.e from field catalog.( if u cant find ur field press pagedown )

    ex sales org ( first feild )

    distribution channel ( second feild )

    and then on top menu press generate button ( red n white colour )

    then a mnasage cmes table generated.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      well mate .........this is the reason y i ddint tell u abt adding a field to field catalog coz its very very serious job anyways if u wnt to then here it is how its done

      to add this field, check the structure KOMG, whether you have the relevant field. If you have this field in KOMG, then simply go to field catalog -> say new entries and add your field to it.

      If in case the field you are talking about is not in structure KOMG. then you will have to append this structure with the new field. appending is very simple. If its a header field then you will have to add it to Include KOMKAZ (pls check - i dont remember exactly) and if it is item field then add it to Include KOMPAZ. once they are added to the include, you will have to add them to the allowed fields in field catalog.

      Probably you also have to activate the user exit pricing prepare for KOMP/KOMK, assign a value to your new field.

      .........

      and if u get this pacage problem thers is this local object button in tht window jus tpress it ..

      ur customztion wld b done

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2007 at 04:33 AM

    Dear Hikmet Akcali,

    A small search on SD forum will give you lot of ideas on this.

    I will suggest you to visit http://sap-img.com/sap-sd.htm. It will give you the overview of SAP SD module.

    Moreover there is a separate section of FAQs with answers which will help you in great deal.

    Hope this helps you.

    Do award points if you found them useful.

    Regards,

    Rakesh

    P.S. you can send me a mail at my mail id rakeshsinghchauhan@gmail.com for any specific details

    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.