Listing in CRM

[Former Member]

Hi

can somebody tell me where I can find the listing material for customers which is stored in the CRM-system. I need the table name.

Maybe someone also knows in what relationship stands the table.

On the end I want to extract the data into the BW-System. I want to see what materials are listed for a special Customer.

Hope someone can help me.

Greetings

Robert

[Former Member · Accepted solution]

Hi Robert,

Check Partner Product table BBP_CT_PPRODUCT where you will find relationship of Product and Partner.

You will get Partner product GUID from Table - CRMM_PRPADM_H.

Hope this helps.

Regards,

Chandrakant

[Former Member]

Thank you for your help Chandrakant.

but I have no entries in the BBP_CT_PPRODUCT table.

I saw that the system uses a conditions technic for listing.

I used the trace (st05) to get the info whitch tables are used when I´m reading the listingdata in the WEB UI.

the result is:

CRMM_PRPADM_I

CRMM_PRPADM_H

CRMM_PRP_PROD_IH

CRMM_PRP_PRVP_I

LSTC_PRP_MAP_CND

/1CN/ALIZ00001

/1CN/CLIZ00001

CRMM_PRP_DESCR

CRMM_PRP_BUPA_I

CRMM_PRP_BUPA_IH

CRMM_PRP_TS_IH

Do you know in what relationship the tables standing? And maybe someone knows the logic behind this.

Greetings

Robert