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.
i think most important in crm is crmd*, never see schematic model for crm tables, for r/3 tables there is schematic :
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
Hope it helps.