How to export several Service Desk messages to *.txt

[former_member292346]

Hello,

i need to export 2000 service desk messages to a flat file. Is there a possibility to export service desk messages ?

Which tables contains the message informations and descriptions ?

Thank you

Heiko

[Former Member]

Hello Heiko,

you can export the longtexts from transaction crm_dno_monitor. Use the BAdi implementation in crm_dno_monitor and add a new function code (e.g. FCODE_CUS2 "Export message with longtext").

Add the following code to the method and build your own list. That's the way how I did it.

DATA : lt_all_text TYPE comt_text_textdata_t.

DATA : lt_text_data TYPE comt_text_textdata_t.

DATA : lt_error TYPE comt_text_error_t.

DATA : lv_text_procedure TYPE comt_text_det_procedure.

DATA : lt_text_cust TYPE comt_text_cust_struc1_tab.

LOOP AT ct_report_list ASSIGNING <fs_list_entry>.

..

.. cl_gui_frontend_services=>file_save_dialog(..... )

..

..

CALL FUNCTION 'CRM_DNO_READ_ORDER_TEXT'

EXPORTING

iv_header_guid = <fs_list_entry>-header_guid

IMPORTING

et_textdata = lt_text_data

et_alltexts = lt_all_text

et_error = lt_error

ev_text_procedure = lv_text_procedure

et_text_cust = lt_text_cust.

..

...

..

CALL FUNCTION 'GUI_DOWNLOAD' ... "Export to Excel...

...

endloop .

Regards

Marc

[Former Member]

Hi,

What all information you are looking for to be exported,

message number,

creator,

team,

owner

component...etc ???

Regards,

Gaurav

[former_member292346]

Hello,

i need the reporter, the message processor, sold-to party, sap component, description and description long text.

Thank you

Heiko