Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 25, 2008 at 02:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Aug 25, 2008 at 01:52 PM

    Hi,

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

    Regards

    sankar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 25, 2008 at 02:00 PM

    Hi

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

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded