SAP ABAP Table CRMT_BSP_CMG_SEARCH (Transfer Structure for Case Management: Search Structure)

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	CRMT_BSP_CMG_SEARCH	Table Relationship Diagram
Short Description	Transfer Structure for Case Management: Search 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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	.INCLUDE	☐				0	0	CRM Case: Selection Parameters
3	.INCLUDE	☐				0	0	CRM Case: Include for Partner Function Search
4	PARTNER_FCT	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
5	CRM_MAIN_PARTNER	☐	CRMT_PARTNER_MAIN	CRM_BOOLEAN	CHAR	1	0	Main Partner (For Ambiguous Partner Functions)
6	.INCLUDE	☐				0	0	Case Attributes
7	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
8	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)	*
9	.INCLUDE	☐				0	0	Case Attributes
10	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	*
11	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
12	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
13	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	*
14	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
15	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	*
16	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
17	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	USR02
18	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
19	PLAN_END_DATE	☐	SCMG_PLAN_END_DATE	DATUM	DATS	8	0	Planned Close Date
20	PROCESSOR	☐	SCMG_PROCESSOR	XUBNAME	CHAR	12	0	Processor	*
21	RESPONSIBLE	☐	SCMG_RESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
22	CASE_TITLE	☐	SCMG_CASE_TITLE	TEXT80	CHAR	80	0	Case Title
23	ESCAL_REASON	☐	SCMG_ESCAL_REASON	CHAR2	CHAR	2	0	Reason for Escalation	*
24	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category	*
25	PRIORITY	☐	SCMG_PRIORITY	NUM01	NUMC	1	0	Priority	*
26	SECURE_LEVEL	☐	SCMG_SECURE_LEVEL	CHAR1	CHAR	1	0	Authorization level	SCMGAUT_SECLEVL
27	PROFILE_ID	☐	SCMGSTATUSPROFID	SCMGPROFID	CHAR	8	0	Case: Status Profile	SCMGSTATPROF
28	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
29	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status	*
30	STAT_OBJNR	☐	SCMGSTATOBJNR	SYSUUID_C	CHAR	32	0	Case: Status Object Number (GUID), (Central Status Managmnt)
31	STAT_LINE	☐	SCMGSTATLINE	SCMGSTATLINE	CHAR	40	0	Case: System Status Description (Central Status Management)
32	STAT_USER_LINE	☐	SCMGSTATUSERLINE	SCMGSTATLINE	CHAR	40	0	Case: User Status Description (Central Status Management)
33	REASON_CODE	☐	SCMG_REASON_CODE	CHAR4	CHAR	4	0	Reason for Case	*
34	CREATE_DATE	☐	SCMG_CREATE_DATE	DATUM	DATS	8	0	Created On
35	CHANGE_DATE	☐	SCMG_CHANGE_DATE	DATUM	DATS	8	0	Date of Last Change
36	CLOSING_DATE	☐	SCMG_CLOSING_DATA	DATUM	DATS	8	0	Closed On
37	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
38	IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
39	IN_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
40	INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
41	CLASSIFICATION_ID1	☐	CRMT_CMG_CLASS_ITEM	IB_INSTANCE	NUMC	18	0	Classification
42	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
43	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
44	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
45	DOC_NO	☐	OPBEL_CA	OPBEL_CA	CHAR	12	0	Contract Accounts Receivable and Payable Document Number
46	PYCLS	☐	PYCLS_CA		CHAR	2	0	Category of Payment Information Assigned
47	PYKEY	☐	PYKEY_CA		CHAR	24	0	Key for Payment Information Assigned
48	PROCESS	☐	SCMGPROCESS	SCMGPROCESS	CHAR	4	0	Permitted Process for Case Type	*
49	MY_ACTIVITIES	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
50	MY_CASES	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
51	MAX_HITS	☐	NUM03	NUM03	NUMC	3	0	Counter
52	NUM_OF_BP	☐	CRMD_CMG_NUM_OF_BP	CRMD_CMG_NUM	CHAR	6	0	Counter Field: Number of Business Partners
53	NUM_OF_PRD	☐	CRMD_CMG_NUM_OF_PRD		CHAR	6	0	Counter Field: Number of Products
54	NUM_OF_ACT	☐	CRMD_CMG_NUM_OF_ACT	CRMD_CMG_NUM	CHAR	6	0	Counter Field: Number of Activities
55	NUM_OF_ORD	☐	CRMD_CMG_NUM_OF_ORD		CHAR	6	0	Counter field: Number of Transactions
56	NUM_OF_DOC	☐	CRMD_CMG_NUM_OF_DOC	CRMD_CMG_NUM	CHAR	6	0	Counter Field: Number of Documents
57	NUM_OF_BO	☐	CRMD_CMG_NUM_OF_BO	CRMD_CMG_NUM	CHAR	6	0	Counter Field: Number of Business Objects
58	CLOSED_CASES	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
59	MY	☐	CRMD_CMG_MY	CRMD_CMG_MY	CHAR	1	0	CRM Case: My (Cases, Favorites, Activities)
60	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
61	OBJECT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
62	IBASE_GUID	☐	IB_RECNO	SYSUUID_22	CHAR	22	0	IB: Unique record number
63	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
64	BUAG_GUID	☐	CRMT_BUAG_GUID_C	SYSUUID_C	CHAR	32	0	GUID of Business Agreement in Character Format
65	CREATE_DATE_TO	☐	CRMD_CMG_CREATE_DATE_TO	DATUM	DATS	8	0	CRM Case Management: Creation Date To
66	CHANGE_DATE_TO	☐	CRMD_CMG_CHANGE_DATE_TO	DATUM	DATS	8	0	CRM Case Management: Change Date To
67	.INCLUDE	☐				0	0	Include for CRM-Specific Case Attributes(SAP, IBU and Cust.)
68	CRM_CASE_TITLE	☐	CRMT_CMG_CASE_TITLE_UPPER	CHAR80	CHAR	80	0	Text Without Upper/Lower Case
69	CRM_SCH_REF_TIME	☐	CRMT_CMG_SCH_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Schema Reference Timestamp - Categories
70	CRM_BUS_REF_TIME	☐	CRMT_CMG_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Business Reference Timestamp - Categories
71	CRM_SCHEMA_ID	☐	CRMT_CMG_SCH_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	CRM Case Management - Schema ID
72	CRM_CATEGORY_ID	☐	CRMT_CMG_CAT_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	CRM Case Management - Reference Category ID
73	.INCLUDE	☐				0	0
74	.INCLUDE	☐				0	0
75	.INCLUDE	☐				0	0
76	.INCLUDE	☐				0	0
77	.INCLUDE	☐				0	0
78	.INCLUDE	☐				0	0
79	.INCLUDE	☐				0	0	FS-Specific Case Attributes
80	PROD_CAT_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
81	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
82	.INCLUDE	☐				0	0	Include for Customer Includes used by Standard Case
83	CMG_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
84	.INCLUDE	☐				0	0
85	.INCLUDE	☐				0	0
86	STATPARA_DESCR	☐	SCMGSTATPARA_DESCR	TEXT40	CHAR	40	0	Case: System Status Description
87	STAT_ORDNO_DESCR	☐	SCMGSTAT_DESCR	SCMGSTAT_DESCR	CHAR	40	0	Case: Status Description
88	PRIO_DESCR	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
89	ESCAL_DESCR	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
90	CATEG_DESCR	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
91	REASON_DESCR	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
92	CASETYPE_DESCR	☐	SCMGTYPEDESCR	TEXT40	CHAR	40	0	Short Text for Case Type
93	ISMNR	☐	ISMNR	ISMNR	CHAR	12	0	Number of Problem Record	*
94	ISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
95	CRM_BUS_REF_DATE	☐	CRMT_CMG_REF_DATE	DATUM	DATS	8	0	CRM Case Management - Business Reference Date
96	CRM_SCH_REF_DATE	☐	CRMT_CMG_SCH_REF_DATE	DATUM	DATS	8	0	CRM Case Management - Schema Reference Date
97	CRM_SCH_REF_TIM	☐	CRMT_CMG_SCH_REF_TIME	CMG_TIME	TIMS	6	0	CRM Case Management - Schema Reference Time
98	CRM_INCL_SUBCATEGORIES	☐	CRMT_CMG_INCL_SUBCATEGORIES	CRM_BOOLEAN	CHAR	1	0	Case Search Including Subcategories
99	CRM_CAT_LABEL	☐	CRMT_CMG_CAT_LABEL	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	CRM Case Management - Reference Category Label
100	PROFILID_STATUS	☐	CRMT_CMGPROFILSTATUS	CHAR11	CHAR	11	0	User Status
101	PROFILID_STATUS_DESCR	☐	CRMT_CMGPROFSTATDESCR	CHAR41	CHAR	41	0	Description of User Status
102	OBJECT_TYPE	☐	OJ_NAME	OJ_NAME	CHAR	10	0	Object type	*
103	PARTNER_FCT_MAIN	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
104	ORG_UNIT	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
105	PROCESSOR_DESCR	☐	CRMD_CMG_PROCESSOR_BUPA	BU_TEXT50	CHAR	50	0	Case Management: Short Description of Processing Bus.Partner
106	RESPONSIBLE_DESCR	☐	CRMD_CMG_RESPONSIBLE_BUPA	BU_TEXT50	CHAR	50	0	Case Management: Short Description of Owner Business Partner
107	ORG_UNIT_DESCRP	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
108	PARENT_CASE	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
109	PARENT_CASE_TITLE	☐	SCMG_CASE_TITLE	TEXT80	CHAR	80	0	Case Title
110	QUERY_IC	☐	CRM_BOOLEAN	CRMD_BOOLEAN	CHAR	1	0	Data element to simulate bool: 'X' is true and ' ' is false
111	IC_EMPL_ASSIGNED	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
112	IC_EMPL_ASSIGNED_DESCRP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
113	IC_GROUP_ASSIGNED	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
114	IC_GROUP_ASSIGNED_DESCRP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
115	IC_CUSTOMER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
116	IC_CUSTOMER_DESCRP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
117	IC_CONTACT_PERSON	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
118	IC_CONTACT_PERSON_DESCRP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
119	.INCLUDE	☐				0	0	Case Management: Internal Bus. Partner (Processor, Owner)
120	PROCESSOR_BUPA	☐	CRMD_CMG_PROCESSOR_PARTNER	BU_PARTNER	CHAR	10	0	Case Man.: Partner Number of Processed Business Partner	*
121	RESPONSIBLE_BUPA	☐	CRMD_CMG_RESPONSIBLE_PARTNER	BU_PARTNER	CHAR	10	0	Case Man.: Partner Number of Responsible Business Partner	*
122	PROCESSOR_TEXT	☐	CRMD_CMG_PROCESSOR_BUPA	BU_TEXT50	CHAR	50	0	Case Management: Short Description of Processing Bus.Partner
123	RESPONSIBLE_TEXT	☐	CRMD_CMG_RESPONSIBLE_BUPA	BU_TEXT50	CHAR	50	0	Case Management: Short Description of Owner Business Partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_CMG_SEARCH	CLOSED_BY	USR02	BNAME
2	CRMT_BSP_CMG_SEARCH	PROFILE_ID	SCMGSTATPROF	PROFILE_ID	KEY	1	N
3	CRMT_BSP_CMG_SEARCH	SECURE_LEVEL	SCMGAUT_SECLEVL	SECURE_LEVEL	KEY
4	CRMT_BSP_CMG_SEARCH	STAT_ORDERNO	SCMGSTATPROFS	STAT_ORDERNO	KEY	1	N

History

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