Skip to Content
avatar image
Former Member

Sales document download filter

Hi experts,

I need to download salesdocuments from ERP 60 to CRM 70 based on an enhanced filter criteria.

I've enhanced the filters for object SALESDOCUMENT as described in note 570625. To be concrete, i've set as filter criteria the field vbak-KVGR5 (customer group 5).

When i create an order with this field properly filled and matching the filter everything goes ok and the order is properly distributed. But this field value will never be set during creation. So when i change the document in change mode, i fill the field to match the filter criteria, the download is raised, but a delta load comes into CRM, creating a dummy and empty order.

Is there any way to detect that the order hasn't been previously sent to CRM and send a complete load during an order change?

Thanks in advance and regards,

Javier

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 10:31 AM

    Hi Javier,

    I guess you can query the CRM function module (which would check whether the order is in crm ) on the R/3 side by a RFC call.(CALL function has a variant in this).am nt aawre of the exact function module in CR which willgive you this details.. For this you need to knw the CRM server where your order is going to and then make an RFC call and check whther the order is present..

    If the order is present then you can go ahead and cancel the call made to the middleware function module which is resp for transferring the data to CRM.the fn module ic CRS_SEND_TO_SERVER, you can stop the call to this module and data will not be sent out of R/3.

    Alternatvely if you want to stop the entire delta load from happening you just need to remove the entry in CRMRFCPAR table for this adapter object. There will be a entry for this adapter object with the "download" field either having a * or D. if it is *

    means all loads are possible, change it to 'I'( only initial load). if there is a 'D' then remove this entry,then delta load will not happens.Hope this helps

    Thanks

    Abishek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Abisekh,

      Thanks for your answer. I was debugging the adapter and everything is based on the update flags of the respective segments. Finally i decided to create an alternative solution by creating a report to create and execute periodic download request of the recent downloaded orders. It's not 100% online but it works!

      Regards,

      Javier