changing email address

[former_member635029]

Hi all,

If I change email address of ship-to-party of any particular sales order , then in which standard tables can I retrieve older and newer value of email address.

Thanks in advance

[former_member635029]

Hi all,

If I change email address of ship-to-party of any particular sales order , then in which standard tables can I retrieve older and newer value of email address.

Thanks in advance

[Former Member]

You can view the change in the log table CDHDR and CDPOS.

Also try comparing the ship to party ADRNR in tables KNA1 and VBPA.

One should show the original address and the other the changed address.

[former_member635029]

this solution does not work..give me another sol.  if you can

[Former Member]

you need to get the ADRNR field of the correct partner from KNA1

the correct partner is determined by the sales view of a given order - KNVV / KNVP

Once you have the correct ADRNR you can read the CAM tables and use function to get the info you want

u can get email from ADR6

[Former Member]

Hi Rahul,

you can get all details by executing this standard prog RSSCD100 with object class.

Here you will get each and every change of that PO like old value and new value

Hope this helps you

Regards

Sathish

[yogendra_bhaskar]

Hi Rahul ,

Find the sales order in table VBPA , get VBPA-ADRNR ,

pass this adrnr in table ADR6.

you will get the email address.

Regards

Yogendra Bhaskar