Extracting manually entered ship-to address

[Former Member]

Hello,

When an order is entered, the delivery address defaults to that given by the Ship-To partner. In our business, we occasionally change the default delivery address by double-clicking on the Ship-To partner. This brings up the address screen to allow changes. These are then keyed in and the order is saved.

We need to extract this changed delivery address from SAP. Any idea if there's a table I can access to do this?

Thanks for your support.

Mike

[Former Member · Accepted solution]

Hi

you can develop a report using the following logic

1) select VBPA-ADRNR for VBELN=order number and PARVW=SH

2) select KNA1-ADRNR for KUNNR=ship to party in order

3) compare VBPA-ADRNR with KNA1-ADRNR and if they are different then address has been changed

4) select address details from ADRC by passing ADRC-ADDRNUMBER=VBPA-ADRNR

regards

[Former Member]

Hello,

When you enter a different address in any partner in the sales order a number will be saved in table VBPA, field ADRNR (CHAR 10). With this number You must go to table ADRC (depends on the version....but normally this is the table) and access with the number retrieved from VBPA in field ADDRNUMBER, and there you have !!

Let me know if this helped you !

Thanks,

Alcides Fialho