After creating a BP( Person or Or),Where the data gets store in CRM system?

[Former Member]

Hi,

I am new to this field and would be thankful if you guys can answer me.

Thanks

Zen

[CarstenKasper · Accepted solution]

Hi,

there are several tables storing business partner information.

I would consider the table BUT000 as leading.

If you are interested where a specific detail is getting stored check out the function module BUPA_CREATE_FROM_DATA. With some debugging you should be able to identify the correct SELECT/MODIFY statements.

I am positiv that there is a data model for the SAP tables, but I do not know how or were to purchase it.

cheers Carsten

[Former Member]

Hello Friends,

I appriciate for your assistance but i know what the answer is with respectb to the table in CRM "BUT*" in transaction code "SE11".I would, like to know if any other place in the CRM system it gets store or where it gets store.I do thank you for your response.

Regards,

Zen

[CarstenKasper]

As mentioned: There are several tables. Too many to write them all down here.

The leading table is BUT000. The BUT* contain data. ADR* contain data and there are some special ones for contact persons and employees afaik.

However, if you want to know all tables SAP considers important for BP storing have a look at SE38 report: BUPA_TEST_DELETE.

It will erase a business partner from the system. Thus touching every table that might be in question. Maybe SQL trace?

cheers Carsten

[stephenjohannes]

Jatin,

The answers so far are correct, but let me further clarify. When you create a business partner of type person or organization, the header / central record is stored in table BUT000. On the central segment of the business partner(BUT000) there is a field called "TYPE" that indicates whether a business partner is a person, organization, group. This primarily controls the "form of address" for the business partner and has no other control.

If you want to view the entire data model for the business partner, you need to go to transaction SD11 and look at the data model PRM_BP. It will give you a graphical model of all the segments of the business partner, plus links to the underlying tables that represent each segment.

Take care,

Stephen

[amarnath_kathi]

Hi Jatin,

Some other tables include BUT050, BUT051 and BUT100.

regards,

Amar.