Solution Manager support desk Change Document tables

[Former Member]

Dear ABAPer,

I’m developing a custom report for Solution manager support desk ticket time calculation report.
For that I required change document status (Extra->change document) with Old and New Values.
I can get the change status from table CRM_JCDS, but I required old and new value also.
I find out a table CDPOS and CDHDR for old and new values, but in that table Old and New values column displayed as a blank.

Can you please suggest me a FM or Tables, from where i can find status with Old and New values.

Thanks and regards,
Kaushik Savaliya

[Former Member]

Dear ABAPer,

I’m developing a custom report for Solution manager support desk ticket time calculation report.
For that I required change document status (Extra->change document) with Old and New Values.
I can get the change status from table CRM_JCDS, but I required old and new value also.
I find out a table CDPOS and CDHDR for old and new values, but in that table Old and New values column displayed as a blank.

Can you please suggest me a FM or Tables, from where i can find status with Old and New values.

Thanks and regards,
Kaushik Savaliya

[Former Member]

Got the solution.

FM 'CRM_CDORDER_DISPLAY' is returning all change document with status and old and new values in a dialogue box.

if you want data in an internal table, pass the parameter in FM i_no_dialogue = 'X'.

    DATA: lt_ausg       TYPE crmt_cdorder_alv_tab ,

              ls_ausg       TYPE crmt_cdorder_alv .

    CALL FUNCTION 'CRM_CDORDER_DISPLAY'

      EXPORTING

         iv_object     = object_id               "Ticket number

         iv_bus        = business object     "BUS*

         i_no_dialogue = 'X'

      IMPORTING

         ausg          = lt_ausg.

[Former Member]

We can use table name CRM_JEST and get Object_GUID and then compare it in table CRMD_ORDERADM_H to get other information history about the incident/service desk ticket for reporting purpose.

Hope it helps.