SAP ABAP Table CRMT_ERMS_ITEMS (Items exctract structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-EMS-MON (Application Component) Monitoring
     ⤷ CRM_ERMS_REPORTING (Package) CRM_ERMS_REPORTING

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ERMS_ITEMS	Table Relationship Diagram
Short Description	Items exctract structure

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	CON_ID	☑	CRMT_ERMS_CONNECTION_ID	CRM_ERMS_CONNECTION_ID	CHAR	34	0	E-Mail ID for E-Mail Response Management System (ERMS)
2	STEP_NO	☑	CRMT_ERMS_STEP_NO	CRM_ERMS_STEP_NO	NUMC	2	0	Step Number
3	FLG_HD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
4	CON_DIRECT	☐	CRMT_ERMS_CONNECTION_DIR	CRM_ERMS_CONNECTION_DIR	CHAR	1	0	Connection Direction
5	EXT_DOMAIN	☐	CRMT_ERMS_DOMAIN	CRM_ERMS_DOMAIN	CHAR	60	0	E-Mail Domain
6	INT_ADDR	☐	CRMT_ERMS_ADDRESS	CRM_ERMS_ADDRESS	CHAR	241	0	Address
7	START_DATE	☐	CRMT_ERMS_STARTDATE	DATE	DATS	8	0	Start Date of E-Mail
8	START_TIME	☐	CRMT_ERMS_STARTTIME	TIME	TIMS	6	0	Start Time of E-Mail
9	CHANGE_ON	☐	CRMT_ERMS_CHANGED_ON	DATS	DATS	8	0	Last Changed On
10	STATUS	☐	CRMT_ERMS_STATUS	CRM_ERMS_STATUS	CHAR	3	0	E-Mail Status	*
11	ORG_UNIT	☐	CRMT_ERMS_ORG	BU_PARTNER	CHAR	10	0	Organizational Unit	*
12	IN_SL	☐	CRMT_ERMS_IN_SL	CRM_ERMS_IN_SL	INT4	10	0	In Service Level
13	STEP_DIRECTION	☐	CRMT_ERMS_STEP_DIRECTION	CRM_ERMS_STEP_DIRECTION	CHAR	1	0	Step Direction
14	EVENT	☐	CRMT_ERMS_EVENT	CRM_ERMS_EVENT	CHAR	3	0	E-Mail Event
15	FIRST_ORG_UNIT	☐	CRMT_ERMS_ORG	BU_PARTNER	CHAR	10	0	Organizational Unit	*
16	SECOND_ORG_UNIT	☐	CRMT_ERMS_ORG	BU_PARTNER	CHAR	10	0	Organizational Unit	*
17	FIRST_AGENT	☐	CRMT_ERMS_ORG	BU_PARTNER	CHAR	10	0	Organizational Unit	*
18	SECOND_AGENT	☐	CRMT_ERMS_ORG	BU_PARTNER	CHAR	10	0	Organizational Unit	*
19	EVENT_DATE	☐	CRMT_ERMS_EVENTDATE	DATE	DATS	8	0	Date of E-Mail Event
20	EVENT_TIME	☐	CRMT_ERMS_EVENTTIME	TIME	TIMS	6	0	Time of E-Mail Event
21	DURATION	☐	CRMT_ERMS_DURATION	CRM_ERMS_DURATION	DEC	13	0	Duration
22	TOTAL_DURATION	☐	CRMT_ERMS_DURATION	CRM_ERMS_DURATION	DEC	13	0	Duration
23	TRANSFER_NO	☐	CRMT_ERMS_TRANSFER_NO	CRM_ERMS_TRANSFER_NO	NUMC	2	0	Connection Step Transfer Number
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	.INCLUDE	☐				0	0	SRV_OSSET Data for BW DataSources
27	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
28	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
29	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
30	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
31	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
32	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
33	EXT_REFOBJ	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
34	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
35	WEBFORM_ID	☐	CRMT_ERMS_WEBFORM_ID	CRM_ERMS_WEBFORM_ID	CHAR	30	0	Web Form ID
36	CASE_ID	☐	CRMT_ERMS_CASE_ID	SCMG_EXT_KEY	CHAR	12	0	Case ID
37	SERVICE_ID	☐	CRMT_ERMS_SERVICE_ID	CRM_OBJECT_ID	CHAR	10	0	Service ID
38	EMAIL_TYPE	☐	CRMT_ERMS_COMMUNICATION_TYPE	CRM_ERMS_COMMUNICATION_TYPE	CHAR	1	0	Communication Type
39	CC_CATEGORY_GUID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
40	CHANGED_AT	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
41	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)

History

Last changed by/on	SAP	20110908
SAP Release Created in	400