cancel
Showing results for 
Search instead for 
Did you mean: 

The general data for Business partner is stored in which table?

Former Member
0 Kudos

Hi Champs,

I would like to know the answer for the above stated quest.It will be good if you guys respond it fast.

Accepted Solutions (1)

Accepted Solutions (1)

former_member202474
Contributor
0 Kudos

Hi,

You can see the following tables for business partner:

BUT000,

BUT100,

BUT0ID,

BUT020,

BUT051,

BUT051.

U can search on BUT*.

  • Reward if useful *************************

Regards,

Ruby.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Jatin,

Please check the following tables for BP general Data.

BUT000 BP: General data

Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

BUT020 BP: Addresses

BUT050 BP relationships/role definitions: General data

Contains Relationship, Partner Number (PARTNER1), Relationship Category

BUT051 BP Relationship: Contact Person Relationship

Similar to BUT050 , additionally contains Contact Personu2019s Address data

BUT0BK Business Partner: Bank Data & Details

BP Number, Bank Key, Bank Country Key, Bank Account Number

BNKA Bank Master Data

BUT100 BP: Roles

Regards

Apoorva

Former Member
0 Kudos

Hi

BUT000 : Customer details

BUT001:BP General data II

BUT100: BP Roles

BUT150: BP relationship: Attribute table (test different

BUT_HIER_TREE Business Partner Group Hierarchy

Regards

Manohar

srikantan_j
Contributor
0 Kudos

Hi Jatin,

Some of the most important BP tables are listed below:

- BUT000 : BP: General data - Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

- BUT020 BP: Addresses

- BUT050 BP relationships/role definitions: General data - Contains Relationship, Partner Number, Relationship Category

- BUT051 BP Relationship: Contact Person Relationship Similar to BUT050 additionally contains Contact Person's Address data

- BUT0BK Business Partner: Bank Data & Details BP Number, Bank Key, Bank Country Key, Bank Account Number

- BNKA Bank Master Data

- BUT100 BP: Roles

regards

Srikantan