CRM_ORDER_READ is very slow

94 Views

Hi Team ,

We are using CRM_ORDER_READ to get complaint details. We are passing complaint GUID to this FM and getting the relevant data.

Now we have 33000+ complaint . This FM is taking too much time . Please find below code with the internal table for which we want data.

CALL FUNCTION 'CRM_ORDER_READ'
EXPORTING
it_header_guid = lt_guid
IMPORTING
* et_orderadm_h = lt_orderadm_h
et_orgman = lt_orgman
et_appointment = lt_appointment
et_text = lt_text
et_partner = lt_partner
et_subject = lt_subject
et_status = lt_status
et_chngproc_h = lt_chngproc_h
et_sales = lt_sales
EXCEPTIONS
document_not_found = 1
error_occurred = 2
document_locked = 3
no_change_authority = 4
no_display_authority = 5
no_change_allowed = 6
OTHERS = 7.
IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.

Please suggest me how to optimize its performance , and we do not have other option to get data .

Thanks & Regards,

Akhilesh Bhagat.