SAP SD Pricing – How to Add Custom Fields to a Condition Table

Related Trainings

SAP Training

SAP SD Training

SAP Access


SAP® Copyright & Trademark Notices

SAP®, SAP® R/3®,SAP® R/3® Enterprise, ABAP®, BAPI®, SAP® ERP are the trademarks or registered trademarks of SAP AG in Germany and several other countries. This publication contains references to the products of SAP AG.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer, StreamWork, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company.
Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP company.
SAP AG is neither the author nor the publisher of this publication and is not responsible for its content. SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.


In SAP, condition records store the pricing values. These records are stored in condition tables. Condition table names’ have three digits. From 1 to 600 are reserved by SAP name space and from 601 to 999 are given to customer name-space. In the actual database a persistent data base table is created with “A” prefixed to the table number .i.e. condition table 980 creates a table with name A980.

During the condition table creation required fields can be selected. Only the fields present in the field catalogue are available for selection in the condition table. Fields present in the KOMG table can be added to the field catalogue. By default SAP does not add all the fields of KOMG to field catalogue. KOMG table is a union of KOMP, KOMK tables. KOMK table contains the header information of the document (Sales order or Billing), KOMP contains item level information of the document (Sales order / Billing). New fields can be added to the KOMP, KOMK structures. To add the new fields to these structures, an append structure should not be created. To add a field to KOMP structure, field should be added to KOMPAZ structure, which is an include in KOMP structure. Similarly fields should be added to KOMKAZ structure.

If  it is required to create a condition table with a custom field the following steps should be followed.

  1. Add the field in KOMKAZ or KOMPAZ structure. If the field is at the header level, add the field to KOMKAZ, and if the field is at the item level add to KOMPAZ structure. This step should be done SE11 transaction.
  2. Activate the structure.
  3. Add the new field to field catalog.
  4. Create the condition table.

Adding the field to field catalog and condition table creation can be done in VOK0 transaction.

At run time the custom field should be filled with the appropriate value. To to this the following user exits should be used.

USEREXIT_PRICING_PREPARE_TKOMK in RV60AFZZ .

USEREXIT_PRICING_PREPARE_TKOMP in RV60AFZZ.

Below is an example to add sales representative , who is a partner at item level to KOMP structure.

1. Go to Se11, and add the field WWSR1.

KOMPAZ Structure of KOMP

© Copyright SAP AG®. All rights reserved

2. Open the program RV60AFZZ using SE38 transaction.

RV60AFZZ User Exit© Copyright SAP AG®. All rights reserved

3. Add the field to field catalog. To do this go to VOK0 transaction. Then environment -> condition table -> field catalog.

Field Catalog© Copyright SAP AG®. All rights reserved

4. Create the condition table. To do this go to VOK0 transaction. Goto environment-> condition table create. Enter the condition table number 980 .

Create Condition Table© Copyright SAP AG®. All rights reserved

Once the condition table is created, this table can be used in the access sequence. Access sequence is assigned to the condition type. Condition type is inserted in the required pricing procedure. Condition records can be created in VK11 transaction. All the condition records are created with reference to the condition type. As the condition type is linked to access sequence, and access sequence to condition table, system displays all the condition table assigned to access sequence , in the initial screen. User should select one table, and enter condition records.

Advertisements

10 thoughts on “SAP SD Pricing – How to Add Custom Fields to a Condition Table

  1. Ray says:

    Exactly what I needed. Thanks for taking the time to share this. We are trying to decide whether to use the sales rep in the pricing condition access sequence or another value and this helped us see that it can be done rather simply.
    Cheers

    Like

  2. Tai game danh bai says:

    Thank you for some other informative website. The place else may just I get that kind of information written in such a perfect method? I have a venture that I am simply now running on, and Ive been at the glance out for such info.

    Like

  3. chandra mohan says:

    I am adding a filed at condition table a715 and field is matkl, after generating getting error is ‘too many fields selected (greterthan 200 bytes ) how to solve it.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s