ticket related view in solman

[Former Member]

Hello all

can anyone please give me the name of the VIEW, used for ticket status in solution manager.

thanks

Kaushik

[Former Member]

Hi,

You can view all the service transactions status using "crm_dno_monitor" tcode, hope this is what your requirement is.

if not, give me more information.

Thanks,

Jansi

[Former Member]

Hello,

actually my requirement to get total time.

i mean to say, how much time ticket was 'IN PROCESS', how much time ticket was in 'Customer Action' etc....

so for that i want a view or function module that give me all this detail...

any idea regarding to this?

Thanks

Kaushik

[Former Member]

Hi,

you can get the change documents with function module CRM_STATUS_READ_MULTI.

Set get_change_documents to 'X' and put your guid in table OBJNR_TAB, the result is in table JCDS_TAB.

With the result you can calculate the durations.

Regards,

Christoph

[Former Member]

Dear Christoph,

thanks for your valuable replay.

but this function module still return NULL value in internal table of JCDS_TAB.

can you have a code for this?

Thanks and regards

Kaushik Savaliya

[Former Member]

Hi,

example:

DATA lt_objnr_tab            TYPE STANDARD TABLE OF crm_jsto_pre.
DATA ls_objnr_tab            LIKE LINE OF lt_objnr_tab.
DATA lt_status               TYPE STANDARD TABLE OF crm_jest.
DATA lt_jcds_tab             TYPE STANDARD TABLE OF crm_jcds.

ls_objnr_tab-objnr = ' '. "your GUID
APPEND ls_objnr_tab TO lt_objnr_tab.

CALL FUNCTION 'CRM_STATUS_READ_MULTI'
  EXPORTING
    get_change_documents = 'X'
  TABLES
    objnr_tab            = lt_objnr_tab
    status               = lt_status
    jcds_tab             = lt_jcds_tab.

Regards,

Christoph