Skip to Content
avatar image
Former Member

SAP CRM Read Partners and appointments with out CRM_ORDER_READ

Hi Experts,

How to get the partners and appointments with out using CRM_ORDER_READ.

If I use CRM_ORDER_READ , having some performance issue, so would like to read the partners and appointments using tables.please suggest me.

Regards,

Kiran

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 23, 2017 at 11:27 PM

    Hi Reddy,

    usually, crm_order_read does not have any performance unless the document has too many items.

    you may read specific part of document with crm_order_read rather than the whole document.

    to do it, you need to put the object in it_object_requested.

    if you want to read partners from db tables,

    for partner

    1, retrieve the header or item guids.

    2, get the partner set guid from crmd_link

    3, read bp from crmd_partner using partner set guid

    but this might be complicated if you want to read item partners when item does not have a partner set. this is described in partner inheritance note 1008458.

    for appointments, i bet you mean dates, dates are stored in the table 'SCAPPTSEG'.

    1, retrieve the header or item guids.

    2, read date set guide from crmd_link for example CRMD_ORDERADM_H- guid = crmd_link-guid_hi

    3, read date from SCAPPTSEG like crmd_link-guid_set = SCAPPTSEG-APPL_GUID.

    spencer

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2017 at 10:28 AM

    Hi Spencer,

    Thanks for your help.

    Regards,

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 08, 2017 at 10:01 AM

    There is a difference in two approaches.

    The select on database tables will always get the persisted data whereas the function module checks the buffer before hitting database.

    If the requirement is to read this information in any of the PPF action processing , the recommended way will be to use the function module with requested objects specified.

    Regards,Parveen

    Add comment
    10|10000 characters needed characters exceeded