Get all addresses from Partner in a Delivery

[Former Member]

Hi

I need to find the address numbers ADRC for all the Partners in a delivery and i do not know in what table to search for them.

So i need the address number for

Ship-to-party

Sold-to-party

Payer

Bill-to-party

You can see them in Delivery->Header Details (F8)->Partner Tab.

All i have is the structure VBDKR which i got by calling the "RV_Billing_Print_View" where i only have one address number.

thank you

[Former Member · Accepted solution]

Hi,

By kreditor, if you asking about the vendor address then you can check table LFA1.

Here you can find the number of Vendor.

Regards,

MT

[Former Member · Accepted solution]

And the address of the debitor can be found also in LFA1?

thank you

[Former Member · Accepted solution]

Hi Seba,

Exactly, try it and revert back with your findings.

Regards,

MT

[Former Member · Accepted solution]

Thank you very much.

[Former Member]

Give your delivery number in VBPA and there you can find the address number of partners.

Regards,

MT

[Former Member]

So LIPS-VBELN = VBPA-VBELN ,right?

Many many thanks for the fast respone.

[Former Member]

I would have one more question.How can i find the address number of the Kreditor.I have found it in the table VBPA but i can only read VBPA with key kreditor number which is not a primary key and the query lasts too long and i get an timeout.

thanks