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

In our CRM social integration project we extract the picture of one tweet from twitter website  and store them in CRM system as attachment.

We are creating attachment in CRM via the approach described in this blog.

However, we found the Create by property for an attachment is always hard coded with sy-uname, even we explicitly specify the created_by property when calling

cl_crm_documents=>create_with_table. However our requirement is it should be filled by the screen name in twitter website who posts the tweet.

/wp-content/uploads/2013/12/clipboard1_337188.png

/wp-content/uploads/2013/12/clipboard2_337189.png

After some debugging I found the created_by property could only be modified after the attachment is created.

First I query all attachments of a given tweet:

     DATA(ls) = VALUE SIBFLPORB( INSTID = iv_guid typeid = iv_bor_type catid = ‘BO’ ).

     CALL METHOD CL_CRM_DOCUMENTS=>get_info

       EXPORTING

          BUSINESS_OBJECT = ls

       IMPORTING

          LOIOS = LOIOS

          phios = phios.

Then I use FM SDOK_PHIO_PROPERTIES_SET to change the property

  DATA(ls_property) = VALUE SDOKPROPTY( name = iv_attr_name value = iv_new_value ).

  APPEND ls_property TO lt_properties.

  LOOP AT phios ASSIGNING FIELD-SYMBOL(<ios>).

       ls_header-class =  <ios>-class.

       ls_header-objid = <ios>-objid.

      CALL FUNCTION ‘SDOK_PHIO_PROPERTIES_SET’

        EXPORTING

          object_id = ls_header

        TABLES

          properties = lt_properties

        EXCEPTIONS

          NOT_EXISTING = 1

          BAD_PROPERTIES = 2

          NOT_AUTHORIZED = 3

          EXCEPTION_IN_EXIT = 4.

ENDLOOP.

I have put the code into a utility class and test it:

/wp-content/uploads/2013/12/clipboard3_337199.png

And that’s done:

/wp-content/uploads/2013/12/clipboard4_337200.png

Never forget to activate internal mode, or else you will fail with an error message that created_by field is read only.

/wp-content/uploads/2013/12/clipboard5_337201.png

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply