SAP ABAP Table CRMT_CMG_ADVANCED_SEARCH (CRM Case: Selection Parameters)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CM (Application Component) Case Management
     ⤷ CRM_CMG_GENERAL (Package) Case Management: General Components

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_CMG_ADVANCED_SEARCH	Table Relationship Diagram
Short Description	CRM Case: Selection Parameters

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	.INCLUDE	☐				0	0	Case Attributes
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)	SCMG_T_CASE
4	.INCLUDE	☐				0	0	Case Attributes
5	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	SCMGCASETYPE
6	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
7	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
8	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	USR02
9	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
10	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	USR02
11	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
12	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	USR02
13	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
14	PLAN_END_DATE	☐	SCMG_PLAN_END_DATE	DATUM	DATS	8	0	Planned Close Date
15	PROCESSOR	☐	SCMG_PROCESSOR	XUBNAME	CHAR	12	0	Processor	USR02
16	RESPONSIBLE	☐	SCMG_RESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
17	CASE_TITLE	☐	SCMG_CASE_TITLE	TEXT80	CHAR	80	0	Case Title
18	ESCAL_REASON	☐	SCMG_ESCAL_REASON	CHAR2	CHAR	2	0	Reason for Escalation	SCMGATTR_SESCAL
19	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category	SCMGATTR_CATEGO
20	PRIORITY	☐	SCMG_PRIORITY	NUM01	NUMC	1	0	Priority	SCMGATTR_PRIO
21	SECURE_LEVEL	☐	SCMG_SECURE_LEVEL	CHAR1	CHAR	1	0	Authorization level	SCMGAUT_SECLEVL
22	PROFILE_ID	☐	SCMGSTATUSPROFID	SCMGPROFID	CHAR	8	0	Case: Status Profile	SCMGSTATPROF
23	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
24	STAT_PARA	☐	SCMGSTATPARA	CHAR03	CHAR	3	0	Case: System Status	SCMGSTAT
25	STAT_OBJNR	☐	SCMGSTATOBJNR	SYSUUID_C	CHAR	32	0	Case: Status Object Number (GUID), (Central Status Managmnt)
26	STAT_LINE	☐	SCMGSTATLINE	SCMGSTATLINE	CHAR	40	0	Case: System Status Description (Central Status Management)
27	STAT_USER_LINE	☐	SCMGSTATUSERLINE	SCMGSTATLINE	CHAR	40	0	Case: User Status Description (Central Status Management)
28	REASON_CODE	☐	SCMG_REASON_CODE	CHAR4	CHAR	4	0	Reason for Case	SCMGATTR_REASON
29	CREATE_DATE_FROM	☐	SCMG_CREATE_DATE	DATUM	DATS	8	0	Created On
30	CHANGE_DATE_FROM	☐	SCMG_CHANGE_DATE	DATUM	DATS	8	0	Date of Last Change
31	CLOSING_DATE_FROM	☐	SCMG_CLOSING_DATA	DATUM	DATS	8	0	Closed On
32	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
33	IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
34	INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
35	CLASSIFICATION_ID1	☐	CRMT_CMG_CLASS_ITEM	IB_INSTANCE	NUMC	18	0	Classification
36	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
37	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
38	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
39	DOC_NO	☐	OPBEL_CA	OPBEL_CA	CHAR	12	0	Contract Accounts Receivable and Payable Document Number
40	PYCLS	☐	PYCLS_CA		CHAR	2	0	Category of Payment Information Assigned
41	PYKEY	☐	PYKEY_CA		CHAR	24	0	Key for Payment Information Assigned
42	PROCESS	☐	SCMGPROCESS	SCMGPROCESS	CHAR	4	0	Permitted Process for Case Type	*
43	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
44	OBJECT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
45	IBASE_GUID	☐	IB_RECNO	SYSUUID_22	CHAR	22	0	IB: Unique record number
46	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
47	BUAG_GUID	☐	CRMT_BUAG_GUID_C	SYSUUID_C	CHAR	32	0	GUID of Business Agreement in Character Format
48	CREATE_DATE_TO	☐	CRMD_CMG_CREATE_DATE_TO	DATUM	DATS	8	0	CRM Case Management: Creation Date To
49	CHANGE_DATE_TO	☐	CRMD_CMG_CHANGE_DATE_TO	DATUM	DATS	8	0	CRM Case Management: Change Date To
50	.INCLUDE	☐				0	0	Include for CRM-Specific Case Attributes(SAP, IBU and Cust.)
51	CRM_CASE_TITLE	☐	CRMT_CMG_CASE_TITLE_UPPER	CHAR80	CHAR	80	0	Text Without Upper/Lower Case
52	CRM_SCH_REF_TIME	☐	CRMT_CMG_SCH_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Schema Reference Timestamp - Categories
53	CRM_BUS_REF_TIME	☐	CRMT_CMG_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Business Reference Timestamp - Categories
54	CRM_SCHEMA_ID	☐	CRMT_CMG_SCH_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	CRM Case Management - Schema ID
55	CRM_CATEGORY_ID	☐	CRMT_CMG_CAT_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	CRM Case Management - Reference Category ID
56	.INCLUDE	☐				0	0
57	.INCLUDE	☐				0	0
58	.INCLUDE	☐				0	0
59	.INCLUDE	☐				0	0
60	.INCLUDE	☐				0	0
61	.INCLUDE	☐				0	0
62	.INCLUDE	☐				0	0	FS-Specific Case Attributes
63	PROD_CAT_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
64	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
65	.INCLUDE	☐				0	0	Include for Customer Includes used by Standard Case
66	CMG_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
67	.INCLUDE	☐				0	0
68	.INCLUDE	☐				0	0
69	ISMNR	☐	ISMNR	ISMNR	CHAR	12	0	Number of Problem Record	*
70	ISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
71	CRM_INCL_SUBCATEGORIES	☐	CRMT_CMG_INCL_SUBCATEGORIES	CRM_BOOLEAN	CHAR	1	0	Case Search Including Subcategories
72	OBJECT_TYPE	☐	OJ_NAME	OJ_NAME	CHAR	10	0	Object type	*
73	CLOSING_DATE_TO	☐	SCMG_CLOSING_DATA	DATUM	DATS	8	0	Closed On
74	PARTNER_FCT	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
75	PARTNER_FCT_MAIN	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
76	DATE_RANGE	☐	CRMT_DAT_RANGE	CRMT_DATE_RANGE	CHAR	5	0	Time Frame
77	QUERY_IC	☐	CRM_BOOLEAN	CRMD_BOOLEAN	CHAR	1	0	Data element to simulate bool: 'X' is true and ' ' is false

Foreign Keys

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

History

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