SAP ABAP Table CRMT_BW_SRV_REQ_SRCL (BW Extract Structure for Processing Times Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_SRV_REQ_SRCL	Table Relationship Diagram
Short Description	BW Extract Structure for Processing Times Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	ORDERADM_H Data for BW DataSources
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
10	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
11	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
12	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
16	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
17	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
18	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
21	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
23	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
24	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
26	.INCLUDE	☐				0	0	Service Request Header Data for BW Data Sources
27	REC_PRIORITY	☐	CRMT_SRQM_REC_PRIORITY	SC_PRIO	NUMC	1	0	Recommended Priority	*
28	URGENCY	☐	CRMT_SRQM_URGENCY	CRM_SRQM_URGENCY	NUMC	2	0	Urgency	*
29	IMPACT	☐	CRMT_SRQM_IMPACT	CRM_SRQM_IMPACT	NUMC	2	0	Impact	*
30	ESCALATION	☐	CRMT_SRQM_ESCALATION	CRM_SRQM_ESCALATION	NUMC	1	0	Escalation
31	CHANGE_CATEGORY	☐	CRMT_SRQM_CHANGE_CAT	CRM_SRQM_CHANGE_CAT	CHAR	3	0	Change Category	*
32	RISK	☐	CRMT_SRQM_RISK	CRM_SRQM_RISK	NUMC	3	0	Risk	*
33	PROBLEM_CATEGORY	☐	CRMT_SRQM_PROBLEM_CATEGORY	CRM_SRQM_PROBLEM_CATEGORY	CHAR	3	0	Problem Category	*
34	LAST_UPDATED_AT	☐	CRMT_SRQM_LAST_UPDATED_AT	COM_TSTMP	DEC	15	0	Last Updated On
35	.INCLUDE	☐				0	0	LOGICAL KEY Data for BW Datasources
36	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
37	USER_STAT_PROC	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
38	.INCLUDE	☐				0	0	Activities Header Data for BW Data Sources
39	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
40	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
41	OBJECTIVE	☐	CRMT_OBJECTIVE	CRM_OBJECTIVE	CHAR	3	0	Goal of an Activity	*
42	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
43	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
44	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
45	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
46	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
47	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
48	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
49	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
50	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
51	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
52	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
53	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
54	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
55	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
56	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
57	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
58	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
59	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
60	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
61	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
62	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
63	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
64	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
65	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
66	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
67	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
68	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
69	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
70	.INCLUDE	☐				0	0	Service Partner for BW Extraction
71	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
72	SERVICE_EMPLOYEE	☐	CRMT_SERVICE_EMPLOYEE	BU_PARTNER	CHAR	10	0	Executing Service Employee	*
73	.INCLUDE	☐				0	0	PARTNER (Call Center) Data for BW Datasoures
74	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
75	RESP_GROUP	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
76	.INCLUDE	☐				0	0	Processing Times Specific Attributes for BW DataSources
77	SRCL_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
78	SRCL_ID	☐	CRMT_SRCL_ID	CRM_SRCL_ID	CHAR	25	0	Processing Time ID	*
79	SRCL_STATUS	☐	CRMT_SRCL_STATUS	CRM_SRCL_STATUS	CHAR	2	0	Status of Processing Time
80	PLAN_START_DATE	☐	CRMT_SRCL_PLAN_START_DATE	RSTSTMP	NUMC	14	0	Processing Times: Planned Start Date
81	PLAN_END_DATE	☐	CRMT_SRCL_PLAN_END_DATE	RSTSTMP	NUMC	14	0	Processing Times: Planned End Date
82	PLAN_RESP_DURA	☐	CRMT_SRCL_PLAN_RESP_DUR	CRMT_SRCL_DURATION	DEC	13	0	Processing Times: Planned Response Duration
83	PLAN_DURATION	☐	CRMT_SRCL_PLAN_DUR	CRMT_SRCL_DURATION	DEC	13	0	Processing Times: Planned Duration
84	ACT_START_DATE	☐	CRMT_SRCL_ACT_START_DATE	RSTSTMP	NUMC	14	0	Processing Times: Actual Start Date
85	ACT_END_DATE	☐	CRMT_SRCL_ACT_END_DATE	RSTSTMP	NUMC	14	0	Processing Times: Actual End Date
86	ACT_DURATION	☐	CRMT_SRCL_ACT_DURATION	CRMT_SRCL_DURATION	DEC	13	0	Processing Times: Actual Duration
87	ACT_DURATION_RT	☐	CRMT_SRCL_ACT_DURA_REAL_TIME	CRMT_SRCL_DURATION	DEC	13	0	Processing Times: Actual Duration Real Time
88	PAUSE_DURATION	☐	CRMT_SRCL_PAUSE_DURATION	CRMT_SRCL_DURATION	DEC	13	0	Processing Times: Pause Duration
89	SRCL_TRH_1LVL	☐	CRMT_SRCL_TRH_1LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 1st Level Threshold
90	SRCL_TRH_2LVL	☐	CRMT_SRCL_TRH_2LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 2nd Level Threshold
91	SRCL_TRH_3LVL	☐	CRMT_SRCL_TRH_3LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 3rd Level Threshold
92	SRCL_TRH_4LVL	☐	CRMT_SRCL_TRH_4LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 4th Level Threshold
93	SRCL_TRH_5LVL	☐	CRMT_SRCL_TRH_5LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 5th Level Threshold
94	SRCL_TRH_6LVL	☐	CRMT_SRCL_TRH_6LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 6th Level Threshold
95	SRCL_TRH_7LVL	☐	CRMT_SRCL_TRH_7LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 7th Level Threshold
96	SRCL_TRH_8LVL	☐	CRMT_SRCL_TRH_8LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 8th Level Threshold
97	SRCL_TRH_9LVL	☐	CRMT_SRCL_TRH_9LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 9th Level Threshold
98	SRCL_TRH_10LVL	☐	CRMT_SRCL_TRH_10LVL_DB	RSTSTMP	NUMC	14	0	Processing Times: 10th Level Threshold
99	ACT_THRESHOLD	☐	CRMT_SRCL_AT	CRM_SRCL_AT	DEC	7	0	Processing Times: Actual Threshold
100	THRESHOLD_NOTIF	☐	CRMT_SRCL_TRH_NOTIF_DB	CHAR30	CHAR	30	0	Processing Times: Active Threshold Notification

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BW_SRV_REQ_SRCL	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

Last changed by/on	SAP	20130604
SAP Release Created in	703