Pricing Tables

[Former Member]

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]

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]

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]

Look at KONV,KONP Table

also use search in SE11 like A0*

Thanks

Seshu

[naimesh_patel]

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]

Thanks ALl. I will look at it.

Ster

[Clemenss]

Hi Ster,

VBAK VBAP KONH KONP

Regards,

Clemens

[Former Member]

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