Skip to Content
Author's profile photo Jerry Wang

How to delete attachments belonging to a business object via code

For a complete list of my blogs regarding content management in CRM, please see here.

In the beginning I consider it is very easy to delete attachments via code, just like below.

I have defined one method with following two importing parameters and one returning parameter:

  • iv_bor_type type string – the BOR type of your business object
  • iv_uuid type raw16 – the guid of your business object instance
  • rv_successful type abap_bool – indicates whether the deletion is successful
DATA:     ls_bo          TYPE SIBFLPORB,
          lt_loios    TYPE SKWF_IOS,
          ls_loios    TYPE SKWF_IO,
          ls_error    TYPE SKWF_ERROR,
          lt_badios   TYPE SKWF_IOERRS,
          lv_del_flag TYPE ABAP_BOOL.
    ls_bo-instid = iv_uuid.
    ls_bo-typeid = iv_bor_type.
    ls_bo-catid  = 'BO'.
    rv_successful = abap_false.
    CALL METHOD cl_crm_documents=>get_info
        business_object = ls_bo
        loios           = lt_loios.
    LOOP AT lt_loios INTO ls_loios.
      CALL METHOD cl_crm_documents=>lock
          is_bo    = ls_bo
          is_loio  = ls_loios
          es_error = ls_error.
      IF ls_error IS NOT INITIAL.
    CALL METHOD cl_crm_documents=>delete
         business_object = ls_bo
         ios             = lt_loios
         bad_ios         = lt_badios
         error           = ls_error.
    IF ls_error IS INITIAL. " deletion failed
       rv_successful = abap_true.

Through testing I found it works perfectly well with most of BOR type like product, IBASE, BP, and one order.

However, it does not work for my new BOR type CRMSOCPOST in CRM7.0 EHP3 – the relationship between my BO and the attachments is not really deleted until an explicit call COMMIT WORK is written in the report. However, for any other standard CRM BOR type, the COMMIT WORK is not needed. Why?

After some debugging finally I find answer. Have you already observed the comments below? It is written quite clearly: if the business object exists in the database, the COMMIT WORK is not needed.


Back to my case, since CRMSOCPOST is a new BOR type created in CRM7.0 EHP3, the function module does not recognize it, so the code reached line 225, and

then the BO instance is regarded as non-exist in DB. So an explicit COMMIT WORK is always necessary to make deletion work.


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Faisal PC
      Faisal PC

      Hi Jerry,

      Thanks. This blog is really helpful. However, I was trying to delete some attachments from an incoming file. I believe I can use the FM SDOK_PHIO_DELETE for the same. But I am not getting on how to derive the object id to pass to this FM. My email is not a one order object. Could you please shed some light if you have any clue.