CRM Marketing Campaigns not going to BW

Try CRM_MKTPL_BW_UPDATE to pass campaigns to BW

To find Partners for orders in CRM

Get Guid from CRMD_ORDER_ADM_H and put that in CRMD_ORDER_INDEX.

To get Appointment data for a transaction

SCAPPTSEG table contains Appointment data for transactions

CRMD_ORDER_ADM_H -> CRMD_ORDER_ADM_I -> CRMD_LINK -> with 06 – 30 (for order) 05 – 30 (for contract) -> SCAPPTSEG (get appointment details)