Regarding Tables in CRM

[Former Member]

Can any one help me to find the Tables in CRM for all the master data

(Product, Business Partner, IBASE, Partner Relationship)?

[Former Member]

A few extras, please reward points.

Tables

Access to table information is controlled across the system by GUID values. These are Global Unique Identifiers.

In general:

CRMCxxxx = Customising

CRMTxxxx = Customising

CRMDxxxx = transactional

BUT* = Customer Master

CRMD_ORDERADM_H = Document Header Table

CRMD_ORDERADM_I = Document Line item Table

CRMD_LINK = Lists various ‘link’ GUIDs, to

access order Information

CRMD_PARTNER = Partner Table

BUT000 = ~KNA1 Customer Master General Data

BUT020 = Address Link Table

ADRC = Address Details (Master Data)

ADRV = Address Details (unique to orders)

CRMC_PARTNER_FT = Partner function Description

PRCD_COND = Pricing Conditions

CRM_JEST = Status Table

COMM_PRODUCT = Materials General Table

SCATTSEG = Valid from/ Valid to

CRMD_SALES = Sales Data

(reference data)

CRMD_SCHEDLIN = Schedule Line item

CRMD_ORGMAN = Organisational Data

CRMD_PRODUCT_I = Line item product detail

PROCESS_QTY_UNIT (EUR)

Example: You want to list all complaints that partner no 31 appears as a header partner, and the partner functions:

Select PARTNER_GUID from the table BUT000.

Get all instances of that partner in the order/partner table:

Select GUID PARTNER_FCT from CRMD_PARTNER

Where PARTNER_NO = BUT000-PARTNER_GUID.

Then get the order guid from the link table:

Select GUID_HI from CRMD_LINK

Where GUID_SET = CRMD_PARTNER-GUID.

Get the Order No:

Select OBJECT_ID from CRMD_ORDERADM_H

Where GUID = CRMD_LINK-GUID_SET.

Link Table:

_HI refers to a Order Header or Order Line Item

GUID_HI = Header/ Line item Guid

OBJTYPE_HI = ‘05’ = Header

‘06’ = Line item

_SET refers to the subset of data

GUID_SET = Subset GUID

OBJTYPE_SET = ‘07’ = Partners

‘11’ = Sales

‘21’ = Orgman

‘29’ = Subject

[Former Member]

Hi Glenn Michaels ,

Thanks for your reply........

I want some more depth answer.

for example,

You have given me the only one table for Product. COMM_PRODUCT which maintains the General Infomation. But i need other table also.

If you go to CRM Tcode for Product, You can find the Category, description, Relationship etc., of the Product.

The above details will be stored in which/what tables?

Thanks.........