How to Add Custom Fields to a Condition Table

 In SAP condition records are stored in condition tables.
Condition tables name has three digits. From 1 to 500 are reserved by SAP and from 501 to 999 are given to customer 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.
 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.
Activate the structure.
Add the new field to field catalog.
Create the condition table.
Adding the field to field catalog and condition table creation can be done 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.

 2. Open the program RV60AFZZ using SE38 transaction.

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

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

 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.

0 Response to "How to Add Custom Fields to a Condition Table"

Post a Comment