Technical Name: 0CRM_ERMS_ITEMS
DataSource Type |
Transactional Data |
---|---|
Application Components |
|
Available as from OLTP Release |
SAP Customer Relationship Management (SAP CRM) 4.0 Add-On for Service Industries |
RemoteCube-Capable |
No |
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)
The following delta process is supported: NEWD (
Only new data records (inserts) via delta queue (cube-enabled)
).
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 |
The extractor, which runs in the SAP CRM system, allows full upload and delta processing. It uses the following program logic:
Reads data from the view CRMV_ERMS_EXTRCT
Transforms data into the extraction structure
Fills the DataSource with additional data from business transaction documents