Skip to Content
avatar image
Former Member

condition table

hi gurus,

while making condition table can i add new table in to the existing table,

how it can be don.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 21, 2010 at 06:28 AM

    [Adding New Table|]

    [Adding New Field|]

    One request-Kindly search for topics before posting on SDN

    Thanks & Regards


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 07:05 AM


    You can create a new table in V/03 transaction code for pricing

    Please check and revert



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 07:12 AM


    For adding field into Field catalogue:

    I shall give an example. But you should first identify the field for Profit Center (Design ID) and then do as follows:

    For example if you want to use field PSTYV ('Sales document item category') that is included in structure KOMP ('Pricing Communication Item') as a key for a condition table.

    When you create a condition table (Transaction V/03), however, the system does not propose the field in the field catalog.


    For technical reasons, field PSTYV was included in structure KOMP, however, not in structure KOMG ('Allowed Fields for Condition Structures').

    To solve the problem, proceed as follows:

    1. Call up the ABAP Dictionary (Transaction SE11) and create data type ZZPSTYV. Choose PSTYV as a domain.As a short text, you can use, for example, 'ZZ - sales document item category' and as a field label, you can use the field labels of PSTYV.Save, check and activate your entries.

    2. Call up structure KOMPAZ in the ABAP Dictionary (Transaction SE11) in the change mode and make the following entry:

    Component Component type


    Save, check and activate the change you made.

    3. Note:Because of the change in structure KOMPAZ, field ZZPSTYV is now known in structures KOMG and KOMP because structure KOMPAZ is included in both structures.

    4. Call up Transaction SPRO. Navigate to 'Sales and Distribution -> Basic Functions -> Pricing -> Pricing Control' and execute 'Define Condition Tables'. Choose 'Conditions: Allowed fields' and include ZZPSTYV as a new entry.

    5. Note:Now you can use field ZZPSTYV as a key field when you create a condition table Axxx.

    6. Supply the new field you defined by including the following source code line in USEREXIT_PRICING_PREPARE_TKOMP:


    In order processing you find the user exit in Include MV45AFZZ, and in billing document processing you find it in Include RV60AFZZ.

    Consider that you can also use this note as a help if you want to use other customer-specific fields as key fields in a condition table.For header fields, use structure


    For more information, see Transaction SPRO via the path 'Sales and Distribution -> System Modifications -> Create New Fields (Using Condition

    Technique) -> New Fields for Pricing' and Note 21040.

    For creating a condition Table:

    1) There are almost all the regularly used Conditon Table predefined in the system from 001 to 500.

    See what best you can use the Standard Tables to avoid further errors.

    2) In case you should define the new condtion Table,

    a) Goto TCode: V/03

    b) Give a Table any number from 501-999

    Press execute and reach to next screen.

    c) Check up whether the field you are looking is already added in Field catalogue.

    d) Double click on the fields you want to make a by one. Note that the sequence here is important in higher hierarchical to lower..

    Eample : Sales Org, DC, Division, Customer and then Material etc..,

    e) After selecting, click on the Techincal View buttin (redone) and reach to next screen.

    7) Check which key should be in header and which key should be footer. Use check and uncheck functionalities there..

    8) Once you are through with all the above steps on generate button.

    Check the Table is generated or not.

    You can check it at V/04 or V/05 or in SE11.

    Add comment
    10|10000 characters needed characters exceeded