Name and adress extracted from SD invoices ?

[former_member989431]

Hello

I need to extract Name, adress, country of Sold To and Payers in SD invoices directly.

I can't collect them from Customer Master data tables, because it has to be the exact image of the data invoice.

Do you know in which Invoice table we can find these data ?

Cécile

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

-Alex

[Lakshmipathi]

For complete address, you need to consider table VBPA where you have ADRNR field. So pass the billing document in VBELN and get ADRNR value. One more advantage using this VBPA for address is sometimes, users would have changed the address in master data for which, a new ADRNR would have been triggered. While creating billing document, system always considers the latest ADRNR value and hence, you will get the right data.

Next again pass the ADRNR to ADRC (not KNA1 as this table don't store full address) table to get the full address. Of course, the Sold-To and Payer code is already in VBPA table

[former_member11064]

From VBRK table you need to fetch the KUNRG & KUNAG and pass it to KNA1 table to fetch Name address and country.

While passing the KUNRG & KUNAG in the KNA1 table you will get the exact details as requested from the invoice.