SAP ABAP Table HREIC_S_ACTIVITY_SEARCH (EIC Activity Query: Attributes)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ PA-EIC (Application Component) Employee Interaction Center
     ⤷ PAOC_EIC_APPL_ACTIVITY (Package) Employee Interaction Center: Activity

Basic Data

Table Category	INTTAB	Structure
Structure	HREIC_S_ACTIVITY_SEARCH	Table Relationship Diagram
Short Description	EIC Activity Query: Attributes

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	ACT_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
2	.INCLUDE	☐				0	0	EIC Activity: All Attributes (Case Attributes + Additional)
3	.INCLUDE	☐				0	0	Case Attributes
4	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	SCMGCASETYPE
5	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
6	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
7	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	USR02
8	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
9	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	USR02
10	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
11	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	USR02
12	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
13	PLAN_END_DATE	☐	SCMG_PLAN_END_DATE	DATUM	DATS	8	0	Planned Close Date
14	PROCESSOR	☐	SCMG_PROCESSOR	XUBNAME	CHAR	12	0	Processor	USR02
15	RESPONSIBLE	☐	SCMG_RESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
16	CASE_TITLE	☐	SCMG_CASE_TITLE	TEXT80	CHAR	80	0	Case Title
17	ESCAL_REASON	☐	SCMG_ESCAL_REASON	CHAR2	CHAR	2	0	Reason for Escalation	SCMGATTR_SESCAL
18	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category	SCMGATTR_CATEGO
19	PRIORITY	☐	SCMG_PRIORITY	NUM01	NUMC	1	0	Priority	SCMGATTR_PRIO
20	SECURE_LEVEL	☐	SCMG_SECURE_LEVEL	CHAR1	CHAR	1	0	Authorization level	SCMGAUT_SECLEVL
21	PROFILE_ID	☐	SCMGSTATUSPROFID	SCMGPROFID	CHAR	8	0	Case: Status Profile	SCMGSTATPROF
22	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
23	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status	SCMGSTAT
24	STAT_OBJNR	☐	SCMGSTATOBJNR	SYSUUID_C	CHAR	32	0	Case: Status Object Number (GUID), (Central Status Managmnt)
25	STAT_LINE	☐	SCMGSTATLINE	SCMGSTATLINE	CHAR	40	0	Case: System Status Description (Central Status Management)
26	STAT_USER_LINE	☐	SCMGSTATUSERLINE	SCMGSTATLINE	CHAR	40	0	Case: User Status Description (Central Status Management)
27	REASON_CODE	☐	SCMG_REASON_CODE	CHAR4	CHAR	4	0	Reason for Case	SCMGATTR_REASON
28	.INCLUDE	☐				0	0	EIC Activity: Additional Attributes
29	EIC_CATEGORY	☐	HREIC_CATEGORY	CHAR10	CHAR	10	0	EIC Category	THREIC_CATEGORY
30	EIC_SUBCATEGORY	☐	HREIC_SUBCATEGORY	CHAR10	CHAR	10	0	EIC Subcategory	THREIC_CATEGORY
31	EIC_SUBCATEGORY2	☐	HREIC_SUBCATEGORY	CHAR10	CHAR	10	0	EIC Subcategory	THREIC_CATEGORY
32	EIC_SUBCATEGORY3	☐	HREIC_SUBCATEGORY	CHAR10	CHAR	10	0	EIC Subcategory	THREIC_CATEGORY
33	EIC_SUBCATEGORY4	☐	HREIC_SUBCATEGORY	CHAR10	CHAR	10	0	EIC Subcategory	THREIC_CATEGORY
34	EIC_PRIORITY	☐	HREIC_PRIORITY	NUMC2	NUMC	2	0	EIC Activity Priority	THREIC_ACTPRIO
35	EIC_PERNR	☐	HREIC_PERNR	PERNR	NUMC	8	0	EIC: Personnel Number of Affected Employee
36	EIC_PERSONID	☐	HREIC_PERSID	PERSONID_EXT	CHAR	20	0	EIC: External Person ID
37	EIC_CREATOR	☐	HREIC_CREATOR	HROBJID_12	CHAR	12	0	EIC: Activity Creator
38	EIC_CREAORGUNIT	☐	HREIC_CREAORG	HROBJID	NUMC	8	0	EIC: Organizational Unit of Activity Creator	*
39	EIC_OWNAGENT	☐	HREIC_OWNER	HROBJID_12	CHAR	12	0	EIC: Activity Owner
40	EIC_OWNORGUNIT	☐	HREIC_OWNORG	HROBJID	NUMC	8	0	EIC: Organizational Unit of Activity Owner	*
41	EIC_PROCAGENT	☐	HREIC_PROCID	HROBJID_12	CHAR	12	0	EIC: Activity Processor
42	EIC_PROCORGUNIT	☐	HREIC_PROCORG	HROBJID	NUMC	8	0	EIC: Organizational Unit of Activity Processor	*
43	CONTRACT	☐	HREIC_SLA_CONTRACT	HREIC_SLA_CONTRACT	CHAR	8	0	Service Level Agreement: Contract	*
44	EIC_DUEDATE	☐	HREIC_SLA_DUEDATE	TZNTSTMPS	DEC	15	0	Due Date
45	EIC_REMINDDATE	☐	HREIC_SLA_REMDATE	TZNTSTMPS	DEC	15	0	Reminder Date
46	EIC_COMPLETETIME	☐	HREIC_TIMESTAMP	TZNTSTMPS	DEC	15	0	EIC: Time Stamp
47	EIC_EXECUTETIME	☐	HREIC_SLA_EXECTIME		INT4	10	0	EIC: Activity Execution Time
48	STATCHNGTIME	☐	HREIC_TIMESTAMP	TZNTSTMPS	DEC	15	0	EIC: Time Stamp
49	TOTWTNGTIME	☐	INT4	INT4	INT4	10	0	Natural number
50	SERVICE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
51	INITIATOR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
52	INITIATOR_USER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
53	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
54	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
55	OBJECTID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
56	.INCLUDE	☐				0	0	EIC Query: Additional Attributes
57	DATE_FROM	☐	DATS	DATS	DATS	8	0	Field of type DATS
58	DATE_TO	☐	DATS	DATS	DATS	8	0	Field of type DATS
59	STATUS_FROM	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
60	STATUS_TO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
61	PRIO_FROM	☐	HREIC_PRIORITY	NUMC2	NUMC	2	0	EIC Activity Priority	THREIC_ACTPRIO
62	PRIO_TO	☐	HREIC_PRIORITY	NUMC2	NUMC	2	0	EIC Activity Priority	THREIC_ACTPRIO
63	FOLLUP_ENDDA	☐	DATS	DATS	DATS	8	0	Field of type DATS
64	FOLLUP_MODE	☐	HREIC_FOLLUP_MODE	HREIC_FOLLUP_MODE	CHAR	2	0	EIC: Follow-Up Mode
65	EIC_DUE_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
66	EIC_DUE_FROM	☐	DATS	DATS	DATS	8	0	Field of type DATS
67	EIC_DUE_TO	☐	DATS	DATS	DATS	8	0	Field of type DATS
68	COMPLETEFROM	☐	DATS	DATS	DATS	8	0	Field of type DATS
69	COMPLETEDTO	☐	DATS	DATS	DATS	8	0	Field of type DATS
70	QUERY_VARIANT	☐	HREIC_QUERY_VARIANT	NUMC3	NUMC	3	0	EIC: Variant for Activity Search
71	QUERY_COUNT	☐	HREIC_QUERY_COUNT	INT4	INT4	10	0	EIC Request: Maximum Number for Selection

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HREIC_S_ACTIVITY_SEARCH	CASE_TYPE	SCMGCASETYPE	CASE_TYPE	KEY
2	HREIC_S_ACTIVITY_SEARCH	CATEGORY	SCMGATTR_CATEGO	CATEGORY	KEY
3	HREIC_S_ACTIVITY_SEARCH	CHANGED_BY	USR02	BNAME
4	HREIC_S_ACTIVITY_SEARCH	CLOSED_BY	USR02	BNAME
5	HREIC_S_ACTIVITY_SEARCH	CREATED_BY	USR02	BNAME
6	HREIC_S_ACTIVITY_SEARCH	EIC_CATEGORY	THREIC_CATEGORY	CATEGORY
7	HREIC_S_ACTIVITY_SEARCH	EIC_PRIORITY	THREIC_ACTPRIO	PRIORITY
8	HREIC_S_ACTIVITY_SEARCH	EIC_SUBCATEGORY	THREIC_CATEGORY	CATEGORY
9	HREIC_S_ACTIVITY_SEARCH	EIC_SUBCATEGORY2	THREIC_CATEGORY	CATEGORY	REF	1	CN
10	HREIC_S_ACTIVITY_SEARCH	EIC_SUBCATEGORY3	THREIC_CATEGORY	CATEGORY	REF	1	CN
11	HREIC_S_ACTIVITY_SEARCH	EIC_SUBCATEGORY4	THREIC_CATEGORY	CATEGORY	REF	1	CN
12	HREIC_S_ACTIVITY_SEARCH	ESCAL_REASON	SCMGATTR_SESCAL	ESCAL_REASON	KEY
13	HREIC_S_ACTIVITY_SEARCH	PRIORITY	SCMGATTR_PRIO	PRIORITY	KEY
14	HREIC_S_ACTIVITY_SEARCH	PRIO_FROM	THREIC_ACTPRIO	PRIORITY
15	HREIC_S_ACTIVITY_SEARCH	PRIO_TO	THREIC_ACTPRIO	PRIORITY
16	HREIC_S_ACTIVITY_SEARCH	PROCESSOR	USR02	BNAME
17	HREIC_S_ACTIVITY_SEARCH	PROFILE_ID	SCMGSTATPROF	PROFILE_ID	KEY	1	N
18	HREIC_S_ACTIVITY_SEARCH	REASON_CODE	SCMGATTR_REASON	REASON_CODE	KEY
19	HREIC_S_ACTIVITY_SEARCH	RESPONSIBLE	USR02	BNAME
20	HREIC_S_ACTIVITY_SEARCH	SECURE_LEVEL	SCMGAUT_SECLEVL	SECURE_LEVEL	KEY
21	HREIC_S_ACTIVITY_SEARCH	STATUS_FROM	SCMGSTATPROFS	STAT_ORDERNO
22	HREIC_S_ACTIVITY_SEARCH	STATUS_TO	SCMGSTATPROFS	STAT_ORDERNO
23	HREIC_S_ACTIVITY_SEARCH	STAT_ORDERNO	SCMGSTATPROFS	STAT_ORDERNO	KEY	1	N
24	HREIC_S_ACTIVITY_SEARCH	STAT_PARA	SCMGSTAT	STAT_PARA	KEY	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in	600