DataBase Tables for BP's

Former Member — Sun, 17 Jun 2007 14:02:12 GMT

Hi Everyone,

In Which Database Tables, Business Partner (BP's) and Organisational Units are stored.

I would appreciate if anyone would provide this information.

Regards,

Varun Reddy.K

Re: DataBase Tables for BP's

amit_khare — Sun, 17 Jun 2007 14:38:21 GMT

HRP1000.

Select the appropriate value of OTYPE by pressing F4.

Former Member — Sun, 17 Jun 2007 14:55:19 GMT

Hi,

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 Person’s Address data

BUT0BK Business Partner: Bank Data & Details

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

BUT100 BP: Roles

ADR2 Telephone Numbers (Business Address Services)

ADR6 SMTP Numbers (Business Address Services)

Contains Email – Id of the BP.

ADRC Addresses (Business Address Services)

BP’s Complete Address Details- City, Country, Post Code, District, Street, Title No Etc

Hope this will help.

Regards,

Srilatha.