topic Re: changing email address in Application Development and Automation Discussions

changing email address

former_member635029 — Tue, 10 Jun 2014 06:21:10 GMT

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

Re: changing email address

Former Member — Tue, 10 Jun 2014 06:26:50 GMT

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.

Re: changing email address

former_member635029 — Tue, 10 Jun 2014 11:45:15 GMT

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

Re: changing email address

Former Member — Tue, 10 Jun 2014 11:53:05 GMT

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

Re: changing email address

Former Member — Tue, 10 Jun 2014 12:02:41 GMT

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

Re: changing email address

yogendra_bhaskar — Tue, 10 Jun 2014 12:05:00 GMT

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