Skip to Content
avatar image
Former Member

Extracting manually entered ship-to address

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 24, 2008 at 05:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 24, 2008 at 05:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded