Development report with Pricing conditions and subtotal

[ravi_kumar100]

Dear Gurus,

I do have a Pricing Procedure in which the Pricing conditions are entered manually at Sale Order level.

There exists subtotal value which is a calculated value for Specific Prices.

We need to capture these prices in a Development report for every Transaction.

Is there any possibility to get these values in SIS?

I have checked the SIS structure and there is a need to maintain the Pricing Conditions with a Subtotal to store the values in

an information structure for reporting.

Kindly advise.

Regards,

RK

[Former Member · Accepted solution]

Hi ,

Try this :

Take value of knumh - doc condition field from vbak table and query konv / komv table pass key as knumh and see the values . kzwi1 wtc could be in this place else using the same link from vbak , try query konp , komp tables.

[ravi_kumar100]

Solved

[Former Member]

Hi,

Get the condition record number (VBAK-KNUMV) from header table of sales order ( VBAK) and pass it to KONV table.

In KONV, you can get all the condition types and values. Apply the logic to sum up what are all the conditions that are needed in the your custom report.

Thanks,

Sai

[Lakshmipathi]

You can check in KONP and KONV

thanks

G. Lakshmipathi

[Former Member]

Hi Ravi ,

I am not having access to SAP right now. But table VBAK / VBAP contains these subtotal values. field names are KZWI1,KZWI2.... etc.

Please search in any of the above 2 tables.

Hope this will help you.

Regards,

Nikhil