SAP ABAP Table CRMS_CASE_SP_DETAIL (Structure for Account Fact Sheet: CRM Cases Information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CM (Application Component) Case Management
     ⤷ CRM_BSP_MODEL_IL_CMG (Package) Model Implementation: Case Management

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_CASE_SP_DETAIL	Table Relationship Diagram
Short Description	Structure for Account Fact Sheet: CRM Cases Information

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	LINE_KEY	☐	CRMT_FS_LINE_KEY		CHAR	32	0	Line ID in table used for reference between tables
2	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	*
3	CASETYPE_DESCR	☐	SCMGTYPEDESCR	TEXT40	CHAR	40	0	Short Text for Case Type
4	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
5	CASE_TITLE	☐	SCMG_CASE_TITLE	TEXT80	CHAR	80	0	Case Title
6	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status
7	STATPARA_DESCR	☐	SCMGSTATPARA_DESCR	TEXT40	CHAR	40	0	Case: System Status Description
8	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category
9	CATEG_DESCR	☐	SCMG_CATEGORY_DESC	TEXT60	CHAR	60	0	Category
10	REASON_CODE	☐	SCMG_REASON_CODE	CHAR4	CHAR	4	0	Reason for Case
11	REASON_DESCR	☐	CRMT_FS_REASON_CODE_DESC	TEXT60	CHAR	60	0	Description of Reason for Case
12	STAT_ORDERNO	☐	CRMT_FS_CASE_STATUSONR	CHAR2	CHAR	2	0	Case: Status
13	STAT_USER_LINE	☐	SCMGSTATUSERLINE	SCMGSTATLINE	CHAR	40	0	Case: User Status Description (Central Status Management)
14	PRIORITY	☐	CRMT_FS_CASE_PRIORITY	CHAR1	CHAR	1	0	Priority
15	PRIO_DESCR	☐	SCMG_PRIO_DESC	TEXT40	CHAR	40	0	Priority
16	ESCAL_REASON	☐	SCMG_ESCAL_REASON	CHAR2	CHAR	2	0	Reason for Escalation
17	ESCAL_DESCR	☐	SCMG_ESCAL_DESC	TEXT40	CHAR	40	0	Reason for Escalation
18	PROCESSOR	☐	SCMG_PROCESSOR	XUBNAME	CHAR	12	0	Processor	*
19	RESPONSIBLE	☐	SCMG_RESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
20	NUM_OF_BP	☐	CRMD_CMG_NUM_OF_BP	CRMD_CMG_NUM	CHAR	6	0	Counter Field: Number of Business Partners
21	NUM_OF_PRD	☐	CRMD_CMG_NUM_OF_PRD		CHAR	6	0	Counter Field: Number of Products
22	NUM_OF_ACT	☐	CRMD_CMG_NUM_OF_ACT	CRMD_CMG_NUM	CHAR	6	0	Counter Field: Number of Activities
23	NUM_OF_ORD	☐	CRMD_CMG_NUM_OF_ORD		CHAR	6	0	Counter field: Number of Transactions
24	NUM_OF_BO	☐	CRMD_CMG_NUM_OF_BO	CRMD_CMG_NUM	CHAR	6	0	Counter Field: Number of Business Objects
25	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	*
26	CREATED_AT	☐	CRMT_FS_CREATED_AT	CRM_FS_DATE_TEXT	CHAR	19	0	Created On
27	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	*
28	CHANGED_AT	☐	CRMT_FS_CHANGED_AT	CRM_FS_DATE_TEXT	CHAR	19	0	Time of Last Change to the Transaction
29	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	*
30	CLOSED_AT	☐	CRMT_FS_CLOSED_AT	CRM_FS_DATE_TEXT	CHAR	19	0	Closed at Time
31	PLAN_END_DATE	☐	CRMT_FS_PLAN_END_DATE	CRM_FS_DATE_SHORT_TEXT	CHAR	10	0	Planned Close Date
32	CLASS_DESCR_1	☐	CRMD_CMG_SP_CLASS_DESCR_1	CHAR40	CHAR	40	0	Summary Page Detail: Classification 1
33	CLASS_DESCR_2	☐	CRMD_CMG_SP_CLASS_DESCR_2	CHAR40	CHAR	40	0	Summary Page Detail: Classification 2
34	CLASS_DESCR_3	☐	CRMD_CMG_SP_CLASS_DESCR_3	CHAR40	CHAR	40	0	Summary Page Detail: Classification 3

History

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