Pricing Difference Report

[Former Member]

HI,

1. My client want the report like At the time of Sale order my price is 100 Rs and at the time of billing documents they will change the price like 120 Rs so my Coordinators want to the 20 Rs different based on the Customer and also the Sale order wise , Billing wise and some times it may be decrease the price also

is it possible in Standard SAP or we have to go for Enhancment if yes please guide me ?

2. From the Consultant point of View where we can see the Price Difference ?

Regards

Anuradha

[madhu_vadlamani]

Hi Anu,

I think there is no standard report for this. Use tables vbak,vbap,konv,vbrk,vbrp.Use knumv and join the tables.Check with Abap people they will made it easily. Check and post if need help.

Regards,

Madhu.

[Former Member]

Thansk for reply Madhu,

But i couldn't able to find out the Field KNUMV in VBAP and VBRP

please guide me

Regards,

Anu

[Former Member]

Hi you'll find KNUMV in VBAK and VBRK respectively.

For this KNUMV, you'll find transaction data i.e. condition values in table KONV.

Regards

Raghu.

[madhu_vadlamani]

Hi Anu,

From header table take that Knumv field and from item level use item no. Actually header knumv is enough to get all the data.Check this and post if need help.

Regards,

Madhu.

[Former Member]

Thanks for Reply

can you please calrify which i have to consider KONH or KONV

Regards,

Anu

[Former Member]

KONV contains transaction data i.e. document data.

KONH/KONP are master data for condition header/item respectively.

Regards

Raghu.

[madhu_vadlamani]

Hi Anu,

KONV Is enough.

Regards,

Madhu.

[prasanna_kumar4]

For Report

Regards

[Former Member]

Thanks for Reply ,

Thanks for every once giving valuable Information

I will check and get Back

Regards,

Anu

[Former Member]

Hi,

there is no standard report for the price difference , you need to develop Z report pricing conditions will be save in KONH table,

Link between VBAK and KONH is VBAK-KNUMV=KONH-KNUMH, same as VBRK-KNUMV=KONH-KNUMH, in this way you can give logic to your abaper

Thanks

seshu

[former_member303858]

Hi,

There are various standard SAP reports mentioned below, check if they help you.

MCTA, MCTC , MCTE, MCTI, MCTG

MC(A

MC+A

MC+E

MC+I

MC+U

MC+Y

MC+2

MC+6

MCSI

You can check this reports and try to find a way out. If not then thinkof a query etc.

Regards,

SB