Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

table that maintain business partner's address data

Former Member
0 Likes
34,235

Hi,

I am wondering what is the table that keeps Business Partner's address. I use the BAPI Code through SAP.Net connector to add address but I want to check it out. Can anyone help me out?

Thanks in advance,

Sunny

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
16,511

Are you referring to Business Partner as in FI side or is it the SD partners?

On the FI side they are store in the table BP000 and on the customer partners, it is stored in KNA1. If it is vendors it is LFA1. But in case you are using central address fields(additional address fields) for customers and vendors, then the addresses are stored in ADRC and you need to look at this table with address number obtained from KNA1 or LFA1 as the case may be.

Srinivas

Hi,

I am wondering what is the table that keeps Business Partner's address. I use the BAPI Code through SAP.Net connector to add address but I want to check it out. Can anyone help me out?

Thanks in advance,

Sunny

7 REPLIES 7
Read only

Former Member
0 Likes
16,512

Are you referring to Business Partner as in FI side or is it the SD partners?

On the FI side they are store in the table BP000 and on the customer partners, it is stored in KNA1. If it is vendors it is LFA1. But in case you are using central address fields(additional address fields) for customers and vendors, then the addresses are stored in ADRC and you need to look at this table with address number obtained from KNA1 or LFA1 as the case may be.

Srinivas

Read only

0 Likes
16,511

Thanks for your reply.

I am referring to Business partner in CRM.

sunny

Read only

0 Likes
16,511

Which BAPI are you using?

Read only

0 Likes
16,511

BAPI_BUPA_ADDRESS_CHANGE.

Sunny

Read only

0 Likes
16,511

Then your table is BUT000.

Read only

0 Likes
16,511

BUT000 contains Business Partner info but not address of Business Partner.

I checked ADRC but ADRC contains other addresses beside Business partner address as well.

Sunny

Read only

16,511

The link from BUT000 to ADRC is the table BUT020.