cancel
Showing results for 
Search instead for 
Did you mean: 

CRM document - how to get status duration?

Former Member
0 Kudos

Dear all,

I extract data CRM -> BI using standard datasources: 0CRM_SRV_PROCESS_H, 0CRM_COMPLAINTS_I, etc

I need build a report with status duration of documents

For example, if document was processed 4 days in statuses OPEN > IN PROCESS > VALIDATION > CLOSED report should be following:

OPEN - 1 day

IN PROCESS - 2 days

VALIDATION - 1 day

Each CRM datasource has start date and last change date of the document

But there is no fields which stores date or duration of intermediate status change

Could you please give an advice - how to get status duration?

Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

former_member186445
Active Contributor
0 Kudos

don't know CRM that well, but i suppose there should be table to hold all the status changes (like JCDS in R/3).

you need to use this info to calculate the number of days per status

M.

Former Member
0 Kudos

yes, there is a table containing status history JEST

but first of all i'd like to use standard datasource. Maybe it is possible to extend datasource with a field

Answers (2)

Answers (2)

york_wang
Explorer
0 Kudos

Hi Oleg,

Please check whether following standard datasources could meet your requirements:

0CRM_TSS_DTRACK CRM Tracking of Document Processing Lifecycles

0CRM_TSS_PKYF Timestamp Service: Performance Key Figures

You can find the documents in transaction code SBIW, through IMG path

Settings for Application-Specific DataSources (CRM)

-> Settings for Extracting CRM Objects

-> Define Extraction to Track the Document Processing Life Cycle

-> Define Performance Key Figures for Time Stamp Service Analysis

Best Regards,

York

Former Member
0 Kudos

Hi

Please check the tables CRM_JCDS and CRM_JEST to get the status related information.

Thanks

former_member186445
Active Contributor
0 Kudos

can't help you there then. but anyway, it would surprise me if there is such a datasource. Change history is normally stored as a vertical structure, whereas datasources are setup to have a horizontal setup.

M.