topic Re: Pricing Tables in Application Development and Automation Discussions

Pricing Tables

Former Member — Fri, 16 Nov 2007 16:55:48 GMT

Hello friends,

I have a request to develop a report where the requirement is to display if any change is done to a sales order(VA02).

The report should have the changes releated to the pricing.

Pricing Type , Pricing Descripton, Pricing rate. Also the person who changed this details.

What are the tables and the fields of intrest.

ANy suggestions,

Ster.

Former Member — Fri, 16 Nov 2007 17:02:45 GMT

Hi,

All the changes will be logged in the table CDHDR(Header table for Change log) and CDPOS(item).

The tables for pricing will be A***, the condition number KMUNH, will he there in KONP.

All the best for your program

Regards,

Baburaj

Former Member — Fri, 16 Nov 2007 17:07:07 GMT

Look at KONV,KONP Table

also use search in SE11 like A0*

Thanks

Seshu

naimesh_patel — Fri, 16 Nov 2007 17:08:22 GMT

You can check the field CDHDR and CDPOS in that regards.

Access CDHDR with

OBJECTCLAS  =  'VERKBELEG'
OBJECTID    =  Order_NO

Now access CDPOS with

OBJECTCLAS =  'VERKBELEG'           
OBJECTID      =  Order number
CHANGENR    = CDHDR-CHANGENR
TABNAME      = 'KONVC'

Check fields..

UNIT OLD     
UNIT NEW     
CUKY OLD     
CUKY NEW     
VALUE NEW    
VALUE OLD

Regards,

Naimesh Patel

Former Member — Fri, 16 Nov 2007 17:14:32 GMT

Thanks ALl. I will look at it.

Ster

Clemenss — Fri, 16 Nov 2007 17:15:16 GMT

Hi Ster,

VBAK VBAP KONH KONP

Regards,

Clemens

Former Member — Fri, 16 Nov 2007 17:17:00 GMT

You can see VL22 Transaction which is change documents for delivery.

you can implement same logic for sales order ,just change the where condition in query about CDHDR Tables..

Thanks

Seshu