Show TOC

 E-Mail Response Management System E-Mails

Technical Name: 0CRM_ERMS_ITEMS

Technical Data

DataSource Type

Transactional Data

Application Components

CRM Interaction Center (0CRM_CIC)

Available as from OLTP Release

SAP Customer Relationship Management (SAP CRM) 4.0 Add-On for Service Industries

RemoteCube-Capable

No

Use

You can use this DataSource to transfer data from SAP CRM E-Mail Response Management System (ERMS)to SAP Business Information Warehouse (SAP BW).

This DataSource contains detailed information about e-mail messages and Web formIDs that are handled by ERMS. This information includes:

  • Technical names and IDs for e-mail messages and Web form IDs

  • Processing steps

  • Statuses

  • Events

  • Responsible agent(s) or organizational unit(s)

Delta Update

The following delta process is supported: NEWD ( Only new data records (inserts) via delta queue (cube-enabled) ).

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

CON_ID

Connection ID

CRMD_ERMS_HEADER

CON_ID

STEP_NO

Step Number

CRMD_ERMS_STEP

STEP_NO

FLG_HD

Checkbox (Header entry for connection: X if header record, space if not)

X or space

CON_DIRECT

Connection Direction

CRMD_ERMS_HEADER

CON_DIRECT

EXT_DOMAIN

E-Mail Domain (of e-mail sender)

CRMD_ERMS_HEADER

EXT_ADDR

INT_ADDR

Address

CRMD_ERMS_HEADER

INT_ADDR

START_DATE

Start Date of E-Mail

CRMD_ERMS_HEADER

START_TMSP

START_TIME

Start Time of E-Mail

CRMD_ERMS_HEADER

START_TMSP

CHANGE_ON

Last Changed on

CRMD_ERMS_HEADER

CHANGE_ON

STATUS

E-Mail Status

CRMD_ERMS_HEADER

STATUS

ORG_UNIT

Organizational Unit

CRMD_ERMS_HEADER

ORG_UNIT

IN_SL

In Service Level

CRMD_ERMS_HEADER

IN_SL

STEP_DIRECTION

Step Direction

CRMD_ERMS_STEP

STEP_DIRECTION

EVENT

E-Mail Event

CRMD_ERMS_STEP

EVENT

FIRST_ORG_UNIT

Organizational Unit

CRMD_ERMS_STEP

FIRST_ORG_UNIT

SECOND_ORG_UNIT

Organizational Unit

CRMD_ERMS_STEP

SECOND_ORG_UNIT

FIRST_AGENT

Organizational Unit

CRMD_ERMS_STEP

FIRST_AGENT

SECOND_AGENT

Organizational Unit

CRMD_ERMS_STEP

SECOND_AGENT

EVENT_DATE

Date of E-Mail Event

CRMD_ERMS_STEP

EVENT_TMSP

EVENT_TIME

Time of E-Mail Event

CRMD_ERMS_STEP

EVENT_TMSP

DURATION

Duration

CRMD_ERMS_STEP

DURATION

TOTAL_DURATION

Duration

CRMD_ERMS_STEP

TOTAL_DURATION

TRANSFER_NO

Connection Step Transfer Number

CRMD_ERMS_STEP

TRANSFER_NO

SOLD_TO_PARTY

Sold-To Party

CONTACT_PERSON

Customer Contact Person

KATALOGART

Catalog

CODEGRUPPE

Code Group

CODE

Code

ACT_REASON_CAT

Catalog

ACT_REASON_GROUP

Code Group

ACT_REASON_CODE

Code

RECORDMODE

BW Delta Process: Record Mode

WEBFORM_ID

Web Form ID

CASE_ID

Case ID

SERVICE_ID

Service ID

EMAIL_TYPE

Communication Type

Particular Features of the Extractor

The extractor, which runs in the SAP CRM system, allows full upload and delta processing. It uses the following program logic:

  1. Reads data from the view CRMV_ERMS_EXTRCT

  2. Transforms data into the extraction structure

  3. Fills the DataSource with additional data from business transaction documents