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