on 05-26-2011 8:18 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Please check the tables CRM_JCDS and CRM_JEST to get the status related information.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.