SAP ABAP Table CRMT_CIC_CTI_CON (Connection structure between oneorder GUID and connection ID)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC-REP (Application Component) Reporting
     ⤷ CRM_CIC_BW (Package) BW extraction for IC

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_CIC_CTI_CON	Table Relationship Diagram
Short Description	Connection structure between oneorder GUID and connection ID

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	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	.INCLUDE	☐				0	0	BW datasource for CIC CTI statistic data
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	CON_ID	☐	SP_CONID	SYSUUID_C	CHAR	32	0	SAPphone: Statistics - Connection ID
5	STEP_NO	☐	SP_STEPNO	NUM2	NUMC	2	0	SAPphone: Statistical Data - Connection Step Number
6	FLG_HD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
7	COM_TYPE	☐	CRMT_CIC_CTI_COM_TYPE	CRMT_CIC_CTI_COM_TYPE	NUMC	2	0	CRM CIC: Communication Type
8	DIRECTION_CONN	☐	SP_CONDRC	SP_CONDRC	CHAR	1	0	SAPphone: Connection Direction (Inbound, Outbound, Autom c.)
9	DIRECTION_STEP	☐	SP_STEPDRC	SP_STEPDRC	CHAR	1	0	SAPphone: Statistical Data - Connection Step Direction
10	CTI_QUEUE	☐	SP_QUEUE	CHAR30	CHAR	30	0	SAPphone: ACD Group/Campaign
11	AGENT_STEP1	☐	SP_USER	SYCHAR12	CHAR	12	0	SAPphone: Work Center User
12	AGENT_STEP2	☐	SP_USER	SYCHAR12	CHAR	12	0	SAPphone: Work Center User
13	.INCLUDE	☐				0	0	BW extraction of CIC statistics: CRM data
14	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
15	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
16	.INCLUDE	☐				0	0	SRV_OSSET Data for BW DataSources
17	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
18	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
19	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
20	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
21	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
22	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
23	EXT_REFOBJ	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
24	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
25	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
26	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
27	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
28	MKT_ELEMENT	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
29	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
30	CC_CATEGORY_GUID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
31	START_DATE_CON	☐	CRMT_CIC_CTI_START_DATE	DATUM	DATS	8	0	CRM CIC: start date of connection
32	START_TIME_CON	☐	CRMT_CIC_CTI_START_TIME	TIME	TIMS	6	0	CRM CIC: start time of connection
33	START_DATE_STEP	☐	CRMT_CIC_CTI_START_DATE	DATUM	DATS	8	0	CRM CIC: start date of connection
34	START_TIME_STEP	☐	CRMT_CIC_CTI_START_TIME	TIME	TIMS	6	0	CRM CIC: start time of connection
35	STEP_TYP	☐	SP_STEPTYP	SP_STEPTYP	CHAR	2	0	SAPphone: Statistical Data - Connection Step Type
36	DURATION	☐	CRMT_CIC_CTI_DURATION	TIMEDURA	DEC	13	0	CRM CIC: Duration of Communication Step (in Seconds)
37	FLG_ABAND	☐	SP_F_ABD	SP_BOOLEAN	CHAR	1	0	SAPphone: Statistical Data - Flag Abandoned ('X'/' ')
38	TRANSF_NO	☐	SP_TRANSNO	NUM2	NUMC	2	0	SAPphone: Statistical Data - Connection Step Transfer Number
39	IN_SL_LIMIT	☐	CRMT_CIC_CTI_IN_SL_LIMIT	XFELD	CHAR	1	0	CRM CIC: connectionrouted within Service Level
40	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
41	CHANGED_AT	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
42	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)
43	ACT_SUBJECT_PROFILE	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	*

History

Last changed by/on	SAP	20110908
SAP Release Created in	30A