CRm table list

[Former Member]

Hi,

Does someone have a schematic data model of CRM 4.0, or a list of the most important tables in the application?

Any white paper on working with BW with CRM data will be much appreciated as well.

Thanks,

Xibi

xibitech@gmail.com

[edwin_harpino]

hi Xibi,

i think most important in crm is crmd*, never see schematic model for crm tables, for r/3 tables there is schematic :

http://www.sapgenie.com/abap/tables.htm

http://www.sapgenie.com/abap/tables_sd.htm

http://www.sapgenie.com/abap/tables_mm.htm

http://www.sapgenie.com/abap/tables_fi.htm

http://www.sapgenie.com/abap/tables_ps.htm

[edwin_harpino]

hi Xibi,

if your consideration is to get the tables that datasources extract, you may use help.sap.com, 'search documentation', option 'netweaver', type in datasource name.

e.g datasource 0crm_sales_order_i, you will get this

http://help.sap.com/saphelp_nw04s/helpdata/en/61/ef453d577111d6b21500508b5d5211/frameset.htm

[Former Member]

Tables:

BUT000 - Business Partners

CRMD_ORDERADM_H - Business Transaction Header

CRMD_CUSTOMER_H - Business Transaction Header Extensions

CRMD_CUTOMER_I - Business Transcation Item Extensions

COMM_PRODUCT - Product Header Table

Tables starting with BUT are generally business partner specific.

This may also useful, bw best practice, see CRM parts

http://help.sap.com/bp_biv135/html/bw.htm

Hope it helps.

Regards