Ship to Party (Address) Extract

[Former Member]

Hello All,

I have  delivery# s and need to extract ship to party address(es) from all deliveries and I have SE16N access as a super user.

I followed below process:

1) Used LIKP and LIPS - using delivery#  > extracted all ship to party IDs

2) Used KNA1 --Using Customer# (Ship to party id#)  got address id #

3) Used ADRC - using address id# from KNA1 got name, street, region , ctry and zip codes.

The issue is this address from ADRC is not the one showing up in /n VL03N next to ship to party id#. So please before you provide an answer run the query for atleast one record and provide solution to me.

This is needed URGENTLY (in a day or 2  from posted date) and will  Text Removed

Thanks,

Mike Pete.

Message was edited by G. Lakshmipathi

Please don't offer points which is against SCN rules.  Go through that before posting further queries

[jignesh_mehta3 · Accepted solution]

Hello Mike,

I would suggest to pick the Delivery document address number from Table VBPA - Sales Document: Partner, ADRNR Field by passing the Delivery number and then pass this VBFA - ADRNR to ADRC to fetch the address from database.

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Thank you Jignesh, it worked.

[Former Member]

This message was moderated.