Custom Report for Pricing Conditions Master

[Former Member]

Hi Everyone,

We know that Pricing Conditions Master Data is stored in KONH and KONP. If a condition is populated in a document then transactional data can be obtained from KONV with 'condition record number' as the foreign key.

The requirement is to design a custom report that lists for order items the pricing conditions (basic price) that are not populated in the sales orders. The pricing is not carried out in these orders as these are not chargeable orders, but the user wishes to know in an existing custom report the price from the conditon master data.

The idea is that the sales order has no pricing calculated but how much Sales Price the material has as per the price condition master record.This can be known by the custom report.

Visiting the standard prcing preports like V/LD is laborious for the user and wishes to add a column in an exisitng report of order item list for the price of each order item.

The challenge here is that in KONH there is no field for material exlusively. It gets stored as a text and hence fetching data from this table for a given material seems difficult. Let us remember that we are not refering to any sales order while accessing data from KONH or KONP.

Any thoughts / views on how this can be achieved are most welcome.

Thanks,

Hemant

[Former Member]

You will have to work on exact condition table in access sequence instead of KONH. For eg: If condition table in access sequence is 601 then you will have fetch the condition number KNUMH from table A601 (prefix A before the condition table number). With the KNUMH you can get the condition value from KONP.

Regards,

GSL.

[Jelena]

You'll need a custom ABAP report for this.