Report on customers setup as ship to party

[Former Member]

Hi,

Is there a report which I can execute to get customer details including e-mail address which are setup as Ship-to Party only.

If there is no standard report how can I achieve this.

Thanks in advance

[Former Member]

Thanks

[Former Member]

I am still unable to find the e-mail address details of all Ship to Party customers setup in the system.

[Former Member]

Hi,

To find Email of the Ship to Party follow as below:

Customer Name (Ship to Party):Read VBAK-VBELN pass VBELN in VBPA table fetch PARVWu2014SH partner function and get ADRNR.Pass this ADRC-ADDRNUMBER.Now Read ADRC-ADDRNUMBER in ADR6 to get E-Mail Address.

Regards

Vadiraj

[former_member183879]

Hi,

Just use the table KNA1 in SE16 and mention the account group as the account group relevant for ship to party (0002 in standard) and get the address number.

Using this address number you can find out the email using the table ADRC.

[Former Member]

Thanks CM and GL but I am still unable to get the desired out.

If possible can I please have the steps.

[Lakshmipathi]

You can try in TCode VCUST

thanks

G. Lakshmipathi

[Former Member]

Dear

You may check it from ov50/ xd99.or se16

Thanks

Chandra