SOLMAN 7.1 ITSM incident status table

[former_member234833]

Hi,

I am trying to query report to get incident information using SQVI. How do I get current status of an incident. I pulled data from table CRM_JCDS and CRM_JEST but these tables brought all history of an incident like when an set to NEW, when it changed to IN PROCESS, when it goes in an CONFIRMED.

I need only current status of an incident. How do I do that in SQVI.

THanks

[former_member45419]

This message was moderated.

[former_member234833]

SOrry its irelevent to my scenario 

[Former Member]

Hi Bilal,

my exp using crm_jcds, you need to develop code to fetch the current status, thats too complex.

Why you look for SQVI? since We have already lots of opitons for reporting in SAP standard itself.

like interactive reporting, bw reporting, dashboard. refer

SAP ITSM Analytics on SAP Solution Manager 7.1 - SAP IT Service Management on SAP Solution Manager -...

Thanks

Jansi

[former_member234833]

Dear Rani we have been asked to create a report that shows the following:

1) incident no. (Got from table crmd_orderadm_h)

2) raised date and time (Got from table crmd_orderadm_h)

3) incident severity (Got from table crmd_activity_h and SCPRIO)

4) incident solved by whom (Got from table crm_jsto and CRM_JEST)

5) incident close date and time  //

now the problem I am facing is that in table crm_jest I need to sort entries of each incident according to date and time and displays the most current status. Somehow with abap code I have to sort, else it brings all the history of an incident, that creates duplicate entries.

Is there any sap standard report which fulfill my requirement (i am aware of that two service desk message effort calculation reports, I forgot names something like "ia_sdk_effort" )

ALso we didnt configured BW CLIENT in our solman, is this client necessary for interactive reporting ?

thanks

Bilal

Message was edited by: Bilal Z

[Sven]

hi, please check tables:TJ30 and for texts TJ30T columns ESTAT and  TXT30

[former_member234833]

THnx Sven, I already developed this program a year ago, thnx BTW

[Sven]

Hi Bilal, I thought so , it's more if someone interested drops by, Cheers!