Few tips on adding new fields in
Pricing Field Catalog:
To use fields in pricing producer,
we need to creates a condition table. This condition table can be created by
using the allowed fields from the field catalog. we can add the fields from the
list of available fields. However, we may find that a new field may not be in
the list of available fields. For this reason, we must be specify new fields
for pricing. The document and item data in SD is stored in data tables, such as
VBAK (sales Order header)and VBAP (Sales order item). Many of the fields from
these tables are available in the field catalog.
The field catalog is a a basically structure (KOMG) that consists of
two tables (KOMK -header and KOMP-Item ).
Structure KOM “x” since they are communications structures used to communicate
the transactional data with the pricing procedure. Table KOMG contains the
fields of tables KOMK & KOMP. If you require a field that is not in KOMG,
that means it is not in KOMK or KOMP. This means that the field you require
cannot be used in pricing because there was no communication structure in the pricing.
To use a field not defined in the field catalog, we need to add this field to
the KOMK or KOMP structures, and then write the ABAP code to transfer the data
in the field from the transaction tables to the communication structure.
Follow these steps:
1. firstly ,we can Create the field in the KOMK (header data..)
and KOMP (item data…) tables using the standard includes provided for this type
requirement
2. Secondly, Write some code in the user exit to read the
transaction data and transfer data it to the KOM “x” structures.
Menu Path The menu path here is IMG--- Sales and distribution--
System modification--Create new fields by using SAP Condition technique
This process requires some
knowledge of the ABAP dictionary and how to use the ABAP dictionary to create
and change fields and tables. You may have to use an ABAP technical skill to
help you.
If the field is from the header
table (Eg, the order table VBAK), we will need to add it to the include table KOMKAZ in
table KOMK. If the field is from the item table (eg, the order item table
VBAP), we will need to add it to the include table KOMPAZ in table KOMP.
Let’s say you need to use the “base price of
the material” to define a price & the base of the material is not in the
pricing field catalog. The base material is a field on the material master
basic data screen and is defined as MARA-WRKST. Since this relates to the
material, it is at the item level, so we would add the field to the KOMPAZ include
table. Note When you add a field to these tables, it must start with “ZZ.”
& follow the basic coding standard. Therefore, you will be able to add field
on ZWRKST.
In ABAP, when we add any field, we use the
same domain as in the field in the original table MARA-WRKST. After adding those
fields, regenerate the structure KOMP
