SAP Note 968624 - Extraction: Marketing attributes performance issue

Component : Data Extraction for BW - Extractors

Solution : https://service.sap.com/sap/support/notes/968624 (SAP Service marketplace login required)

Summary :
This SAP Note addresses an issue with prolonged execution times when extracting marketing attributes from CRM to BW using the datasource 0CRM_MKTATTR_ATTR. The problem is linked to the delta procedure (still E) leading to excessive extraction due to large change pointer table sizes, potentially causing runtime errors or job failures. The extraction design sends deletion records before actual attribute data, which are processed by the ODS as such. To resolve the issue, implementation of provided corrections is recommended to enhance performance and avoid unnecessary attribute extractions.

Key words :
symptom long run time, allowed range table size, change pointer range table, business partners' marketing attributes, standard datasource 0crm_mktattr_attr, marketing attributes, change pointers, terms 0crm_mktattr_attr, extractor 0crm_mktattr_attr, bps' attributes

Related Notes :

766967PVBW:FAQ for Marketing attributes extraction from CRM to BW.
739544CRM marketing characteristic: delta extraction too slow