CRM Service Request Processing Times Data

DataSource Transactional Data: 0CRM_SRV_REQ_SRCL

This DataSource extracts data from the processing times that are assigned to transactions such as incidents/service requests or problems/master requests. For more information about the processing times, see Management of Processing Times.

Technical Data

Application Component	CRM Service (0CRM_SERVICE)
Available as of Release	SAP enhancement package 2 (SP05) for SAP CRM 7.0
Shipment	CRM 7.07 SP03
Content Versions	No content versions exist.
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Prerequisites

You have activated the business function Management of Processing Times (CRM_ITSM_PROCESS_TIMES_MGMT).

You have made the necessary settings in Customizing for Customer Relationship Management under Start of the navigation path Transactions Next navigation step Settings for Service Requests Settings for Management of Processing Times. End of the navigation path

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
GUID	GUID for a Transaction	CRMD_ORDERADM_H	ORDERADM_H_GUID
OBJECT_ID	Transaction ID	CRMD_ORDERADM_H	OBJECT_ID
PROCESS_TYPE	Business Transaction Type	CRMD_ORDERADM_H	PROCESS_TYPE
POSTING_DATE	Posting Date for a Business Transaction	CRMD_ORDERADM_H	POSTING_DATE
DESCRIPTION_UC	Transaction Description (Upper Case)
DESCR_LANGUAGE	Language Key of Description
LOGICAL_SYSTEM	Logical System	CRMD_ORDERADM_H	LOGICAL_SYSTEM
OBJECT_TYPE	Business Transaction Category	CRMD_ORDERADM_H	OBJECT_TYPE
CREATED_AT	Transaction Was Created at This Time	CRMD_ORDERADM_H	CREATED_AT
CREATED_BY	User that Created the Transaction	CRMD_ORDERADM_H	CREATED_BY
CHANGED_AT	Time of Last Change to the Transaction	CRMD_ORDERADM_H	CHANGED_AT
CHANGED_BY	Transaction Last Changed By	CRMD_ORDERADM_H	CHANGED_BY
RECORDMODE	BW Delta Process: Record Mode	CRMD_ORDERADM_H	TASK
NUM_OF_HEAD	Order Header Number	CRMD_ORDERADM_H	CRMD_ORDERADM_H_GUID
OCCURRENCE	Counter: Document Cat. Appears at Least Once in Document	CRMD_ORDERADM_I	GUID
SCENARIO	Scenario Identity	CRMD_ORDERADM_H	SCENARIO
TEMPLATE_TYPE	Template Type of CRM Transaction	CRMD_ORDERADM_H	TEMPLATE_TYPE
OCCURR_QUOT	Counter: Document Cat. Appears at Least Once in Document
OCCURR_CONT	Counter: Document Cat. Appears at Least Once in Document
REF_UPDATE	Flag: Ref. Update (Extract Structure Only Partially Filled)
INPUT_CHANNEL	Input channel	CRMD_ORDERADM_H	INPUT_CHANNEL
CREATED_TS	Created At (Output in User Time Zone)
CHANGED_TS	Changed At (Output in User Time Zone)
REC_PRIORITY	Recommended Priority	CRMD_SRV_REQ_H	REC_PRIORITY
URGENCY	Urgency	CRMD_SRV_REQ_H	URGENCY
IMPACT	Impact	CRMD_SRV_REQ_H	IMPACT
ESCALATION	Escalation	CRMD_SRV_REQ_H	ESCALATION
CHANGE_CATEGORY	Change Category	CRMD_SRV_REQ_H	CHANGE_CATEGORY
RISK	Risk	CRMD_SRV_REQ_H	RISK
PROBLEM_CATEGORY	Problem Category	CRMD_SRV_REQ_H	PROBLEM_CATEGORY
LAST_UPDATED_AT	Last Updated On	CRMD_SRV_REQ_H	LAST_UPDATED_AT
OBJECTIVE	Goal of an Activity	CRMD_ACTIVITY_H	OBJECTIVE
DIRECTION	Direction of an Activity	CRMD_ACTIVITY_H	DIRECTION
SOLD_TO_PARTY	Sold-To Party	CRMD_PARTNER	PARTNER_NO
SHIP_TO_PARTY	Ship-To Party	CRMD_PARTNER	PARTNER_NO
BILL_TO_PARTY	Bill-To Party	CRMD_PARTNER	PARTNER_NO
PAYER	Payer	CRMD_PARTNER	PARTNER_NO
SOLD_FROM	Salesperson
SALES_EMPLOYEE	Employee	CRMD_PARTNER	PARTNER_NO
PERSON_RESP	Employee Responsible	CRMD_PARTNER	PARTNER_NO
CONTACT_PERSON	Customer Contact Person	CRMD_PARTNER	PARTNER_NO
SALESPARTNER	Sales Partners	CRMD_PARTNER	PARTNER_NO
RESP_GROUP_RFW	Responsible Group
PLANNING_ACCOUNT	Planning Account
EXECUTING_CC	Executing Interaction Center	CRMD_PARTNER	PARTNER_NO
RESP_GROUP	Responsible Group
SALES_ORG_RESP	Object ID	CRMD_ORGMAN	SALES_ORG_RESP
SALES_ORG	Object ID	CRMD_ORGMAN	SALES_ORG
SALES_OFFICE	Object ID	CRMD_ORGMAN	SALES_OFFICE
SALES_GROUP	Object ID	CRMD_ORGMAN	SALES_GROUP
DIS_CHANNEL	Distribution Channel	CRMD_ORGMAN	DIS_CHANNEL
DIVISION	Division	CRMD_ORGMAN	DIVISION
SERVICE_ORG_RESP	Object ID	CRMD_ORGMAN	SERVICE_ORG
SERVICE_ORG	Object	CRMD_ORGMAN	SERVICE_ORG
ID PURCH_ORG_RESP	Object
ID PURCH_ORG	Object ID
PURCH_GROUP	Object ID
IC_BD_CCODE	Company Code for a Business Transaction
IC_BD_LOGSYS	Logical System for a Business Transaction
SRCL_GUID	GUID of a CRM Order Object
SRCL_ID	Processing Time ID	CRMD_SRCL_H	ID
SRCL_STATUS	Status of Processing Time	CRMD_SRCL_H	STATUS
PLAN_START_DATE	Processing Times: Planned End Date	CRMD_SRCL_H	PLAN_START_DATE
PLAN_END_DATE	Processing Times: Planned End Date	CRMD_SRCL_H	PLAN_END_DATE
PLAN_RESP_DURA	Processing Times: Planned Response Duration	CRMD_SRCL_H	PLAN_RESP_DURATION
PLAN_DURATION	Processing Times: Planned Duration	CRMD_SRCL_H	PLAN_DURATION
ACT_START_DATE	Processing Times: Actual Start Date	CRMD_SRCL_H	ACT_START_DATE
ACT_END_DATE	Processing Times: Actual End Date	CRMD_SRCL_H	ACT_END_DATE
ACT_DURATION	Processing Times: Actual Duration	CRMD_SRCL_H	ACT_DURATION
ACT_DURATION_RT	Processing Times: Actual Duration Real Time	CRMD_SRCL_H	ACT_DURA_REAL_TIME
PAUSE_DURATION	Processing Times: Pause Duration	CRMD_SRCL_H	PAUSE_DURATION
SRCL_TRH_*LVL	Processing Times: * Level Threshold (* = 1–10)	CRMD_SRCL_H	SRCL_TRH_*LVL
ACT_THRESHOLD	Processing Times: Actual Threshold	CRMD_SRCL_H	ACT_THRESHOLD
THRESHOLD_NOTIF	Processing Times: Active Threshold Notification	CRMD_SRCL_H	THRESHOLD_NOTIF