Table & field- line item wise Old net value and new net value

[Former Member]

Hi Gurus,

I created a Sales order, in that i have changed the qty from VA02 for one line item. and the line item net value has been changed.

from which table& field can i get old net value, net net value and the changed date against the line item.

Regards,

Sumith

[Former Member]

Hi Sumith,

Good Day,

NetValue will be Dynamic Calculation. you will not get Old Netvalue directly from the table but you have workaround.

In table CDHDR and CDPOS those are change history tables.

in that you will have Changes history related to SalesOrder.

We have to pass

Objectclas = VERKBELEG

Objectid = Sales Order Number then

you can pass value into CDPOS

Objectclas = VERKBELEG

Objectid = Sales Order Number then

changenr = CDHDR-CHANGENR

then find changes relevent to Netvalue and obtain the Old Net value.

All the best.

Best Regards,

KSK

[Former Member]

Hi,

from the CDPOS , i can get Old qty and new qty , but iam unable to get old net value against the line items.

So how can i get the change hostory of net values.

Regards,

Sumith

[Former Member]

Dear Sumith,

Good Day.

As i told before Netvalue is Dynamic Calculation. in my knoledge Change history is When we change any value of perticular field then we can get history of that field.

In our case we are not changing NetValue field..

May be u can try this to get Old Net Value

example : Old Quantity 90

New Quantity 100

Current Net Value is 2000

Old Net Value = ( 2000 / 100 ) * 90

Note : Consider Unit Of Measurement also.

Best Regards,

KSK

[former_member184555]

Hi

You can see the changes from the Change log also. VA02 - menu - environment - changes.

Thanks,

Ravi

[Former Member]

Hi,

Please have a look into tables CDHDR and CDPOS tables where u can see old values and new values for changes..

Regards

sankar