Skip to Content
0

Enhancement of CRM Extractor 0CRM_OPPT_H with field from CRMD_ORDER_INDEX

Jan 03, 2017 at 12:56 PM

110

avatar image
Former Member

Hi

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.

/Chris

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Spencer Liang
Jan 05, 2017 at 12:24 AM
0

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.

Spencer


Share
10 |10000 characters needed characters left characters exceeded