Skip to Content
avatar image
Former Member

Enhancement of CRM Extractor 0CRM_OPPT_H with field from CRMD_ORDER_INDEX


We have a requirement to enhance BW extractor 0CRM_OPPT_H in CRM with the field DATE_1 from the table CRMD_ORDER_INDEX. To lookup the field our CRM "guys" has described a lookup going from the GUID of the extractor to table CRMD_LINK where field GUID_SET is used to lookup in table CRMD_PARTNER. The result of the lookup in CRMD_PARTNER is used to select from table BUT000 where the partner number is used to look up the field DATE_1 in the CRMD_ORDER_INDEX table.

This select statement is so heavy from a performance perspective that it simply does not work. A full load of (60.000 records) takes more than a week.

Do you have any suggestions to improve the performance of this logic? is there an easier way from the GUID of the extractor to the DATE_1 field in CRMD_ORDER_INDEX?

I look forward to your help.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 05, 2017 at 12:24 AM

    Hi Chris,

    GUID of the extractor should be transaction guid of the opportunity. The crmd_order_index should stores multiple lines with this transaction guid in field header and the partner id.

    I do not understand why you read partner set (crmd_partner) and the BP master data (but000).

    Actually, the date_1 in these lines for this opportunity contains the same value.

    I would suggest this select.

    Assuming opportunity guids from extractor are stored in lt_oppt_guid, and the result is stored in lt_oppt_date_1.

    select single header date_1 from crmd_order_index

    for all entries in lt_oppt_guid

    where header = lt_oppt_guid-guid

    into corresponding fields of table lt_oppt_date_1.

    Let us know if you have any reason to consider the partner function and BP during this search.


    Add comment
    10|10000 characters needed characters exceeded