CRM BP Related Tables

[Former Member]

Dear Friends Can anyone please send me BP related Tables to me? either here or by E-mailing me plzz...

My e-mail ID is lathareddy13@yahoo.com

Many thannks and regards,

Lata.

[Former Member]

Sent to your id.

Thanks,

Atin

[Former Member]

Hi,

Sent the document to your mail for database tables and other technical stuff.

Regards,

Srini

[Former Member]

Hi Latha,

The important BP tables are :

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

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

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

Plz reward points for helpful.

Regards

Sourabh Verma

[Former Member]

Hi Lata,

There are multiple BP related table in CRM. Below is a list of the table with some descriptions.

BUT000 BP: General data I

BUT000_BCS Persistence of a BAS Address

BUT000_EBP_G able for Lock Object EBP_G

BUT000_TD BP: General Data I, Shadow Table Time Depe

BUT001 BP: General data II

BUT010 GP: old, do not use ==> BUT020

BUT020 BP: Addresses

BUT021 BP: Address usages

BUT021_FS Time-Dependent Address Usage

BUT030 BP Where-Used List: Usages

BUT030G BP Where-Used List: Generic Nodes

BUT030GT BP Where-Used List: Generic Nodes, Text

BUT030T BP Object Usage: Application Table, Texts

BUT050 BP relationships/role definitions: General

BUT050_CD BP Rel./Role Determination:Index Table for

BUT051 BP Relationship: Contact Person Relationsh

BUT052 BP Relationship: Addresses

BUT053 BP Relationship: Company Interest

BUT054 BP Relationship (not used yet)

BUT0BANK Business Partner: Bank Data

BUT0BK BP: Bank Details

BUT0BK_SHD Shadow table for BUT0BK (IBAN only)

BUT0BKU BP: Bank Details Usages

BUT0CC BP: Payment Cards

BUT0ID BP: ID Numbers

BUT0ID_BIP_NOHIT Business Information Provider: Logging of

So it is not the complete list. You can search for more tables in SE11 using the search key as BUT*.

Thanks,

Samantak.

Rewards points for useful answers.