Convert SRT_MMASTER-MESSAGE_DATA field data (Byte String) to readable string format

[chandan-jha29]

Requirement: To convert SRT_MMASTER table's MESSAGE_DATA field data into readable string format or in internal table.

I have tried different FM's to convert Byte String (Blob) data stored in SRT_MMASTER table's MESSAGE_DATA field but none of it returned readable string format or at least generate an XML file in return.

Have tried Function modules like -

SCMS_BINARY_TO_STRING

SDIXML_XML_TO_DOM

SDIXML_DOM_TO_DATA

SMUM_XML_PARSE

and methods like -

cl_soap_xml_parser=>get_data

cl_soap_xml_parser=>get_formatted_data

cl_bcs_convert=>raw_to_string

and more but none were able to convert it to correct readable format. Any help or suggestion on FM or class/method that can be used to solve the purpose?

My actual requirement is mentioned in the link. However as that couldn't be done I am creating a custom report to do the job.

Thanks,

Chandan

[Markus_Ebel]

  DATA: conv          TYPE REF TO cl_abap_conv_in_ce,
        lv_text       TYPE string,
        lt_property_list  TYPE srt_persistency_property_t,
        ls_property_list like line of lt_property_list,
        not_found	    TYPE xsdboolean,
        error_text    TYPE string.


  conv = cl_abap_conv_in_ce=>create( encoding = 'UTF-8' ).


  CALL METHOD cl_soap_db_moni=>get_message_properties
    EXPORTING
      persist_id    = 'CFA9EBEE39C91EEE8B8B827CE1AF680B'
*     version       =
*     original_data =
    IMPORTING
      property_list = lt_property_list
      not_found     = not_found
      error_text    = error_text.


  READ TABLE lt_property_list index 1 into ls_property_list.
  conv->convert( EXPORTING input = ls_property_list-PROTOCOL_DATA
    IMPORTING DATA = lv_text ).


  WRITE: / 'Result:', lv_text.