SAP ABAP Table ROXSE30028 (Case Attribute)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ PI_SCMG_BW (Package) Case Management: BW Extractors

Basic Data

Table Category	INTTAB	Structure
Structure	ROXSE30028	Table Relationship Diagram
Short Description	Case Attribute

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	CASE_GUID	☑	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)	SCMG_T_CASE
3	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	SCMGCASETYPE
4	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
5	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
6	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	USR02
7	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
8	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	USR02
9	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
10	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	USR02
11	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
12	PLAN_END_DATE	☐	SCMG_PLAN_END_DATE	DATUM	DATS	8	0	Planned Close Date
13	PROCESSOR	☐	SCMG_PROCESSOR	XUBNAME	CHAR	12	0	Processor	USR02
14	RESPONSIBLE	☐	SCMG_RESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
15	CASE_TITLE	☐	SCMG_CASE_TITLE	TEXT80	CHAR	80	0	Case Title
16	ESCAL_REASON	☐	SCMG_ESCAL_REASON	CHAR2	CHAR	2	0	Reason for Escalation	SCMGATTR_SESCAL
17	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category	SCMGATTR_CATEGO
18	PRIORITY	☐	SCMG_PRIORITY	NUM01	NUMC	1	0	Priority	SCMGATTR_PRIO
19	SECURE_LEVEL	☐	SCMG_SECURE_LEVEL	CHAR1	CHAR	1	0	Authorization level	SCMGAUT_SECLEVL
20	PROFILE_ID	☐	SCMGSTATUSPROFID	SCMGPROFID	CHAR	8	0	Case: Status Profile	SCMGSTATPROF
21	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
22	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status	SCMGSTAT
23	STAT_OBJNR	☐	SCMGSTATOBJNR	SYSUUID_C	CHAR	32	0	Case: Status Object Number (GUID), (Central Status Managmnt)
24	STAT_LINE	☐	SCMGSTATLINE	SCMGSTATLINE	CHAR	40	0	Case: System Status Description (Central Status Management)
25	STAT_USER_LINE	☐	SCMGSTATUSERLINE	SCMGSTATLINE	CHAR	40	0	Case: User Status Description (Central Status Management)
26	REASON_CODE	☐	SCMG_REASON_CODE	CHAR4	CHAR	4	0	Reason for Case	SCMGATTR_REASON

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXSE30028	CASE_GUID	SCMG_T_CASE	CASE_GUID	KEY	1	1
2	ROXSE30028	CASE_TYPE	SCMGCASETYPE	CASE_TYPE	KEY
3	ROXSE30028	CATEGORY	SCMGATTR_CATEGO	CATEGORY	KEY
4	ROXSE30028	CHANGED_BY	USR02	BNAME
5	ROXSE30028	CLOSED_BY	USR02	BNAME
6	ROXSE30028	CREATED_BY	USR02	BNAME
7	ROXSE30028	ESCAL_REASON	SCMGATTR_SESCAL	ESCAL_REASON
8	ROXSE30028	PRIORITY	SCMGATTR_PRIO	PRIORITY	KEY
9	ROXSE30028	PROCESSOR	USR02	BNAME
10	ROXSE30028	PROFILE_ID	SCMGSTATPROF	PROFILE_ID	KEY	1	N
11	ROXSE30028	REASON_CODE	SCMGATTR_REASON	REASON_CODE	KEY
12	ROXSE30028	RESPONSIBLE	USR02	BNAME
13	ROXSE30028	SECURE_LEVEL	SCMGAUT_SECLEVL	SECURE_LEVEL	KEY
14	ROXSE30028	STAT_ORDERNO	SCMGSTATPROFS	STAT_ORDERNO	KEY	1	N
15	ROXSE30028	STAT_PARA	SCMGSTAT	STAT_PARA	KEY	1	N

History

Last changed by/on	SAP	20141013
SAP Release Created in	150