SAP ABAP Table CRMS_KNOW_SEARCH (Knowledge Search Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-SOL (Application Component) Solution Search
     ⤷ CRM_KNOWLEDGE_BASE_IL (Package) CRM Knowledge Base GENIL Package

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_KNOW_SEARCH	Table Relationship Diagram
Short Description	Knowledge 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	SAF_APPLICATION	☐	CRMT_EI_APP_NAME	CHAR20	CHAR	20	0	Application Name
2	KB_NAME	☐	CRMT_EI_KB_NAME	CRMT_EI_KB_NAME	CHAR	30	0	Name of Knowledge Base	*
3	LANGUAGE	☐	CRMT_EI_LANGUAGE_ISO	LAISO	CHAR	2	0	Language Key
4	SEARCH_TERMS	☐	CRMT_KA_SEARCH_TXTQUERY	CRM_TXT_QUERY	CHAR	60	0	Search Text
5	EXCLUDE_TEXT	☐	CRMT_KA_SEARCH_TXTQUERY	CRM_TXT_QUERY	CHAR	60	0	Search Text
6	EXACT_PHRASE	☐	CRMT_KA_EXACT_TXTQUERY	CRM_TXT_QUERY	CHAR	60	0	Exact Phrase
7	.INCLUDE	☐				0	0	Knowledge Base Search: KA query parameters
8	KA_OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
9	KA_PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
10	KA_DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
11	KA_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
12	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
13	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
14	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
15	PARTNER_FCT	☐	CMST_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
16	KA_POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
17	KA_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
18	KA_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
19	KA_PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
20	CAT_SCHEMA	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
21	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
22	CUSTOMER	☐	CRMT_UIU_CUSTOMER	CRM_PARTNER_NUMBER	CHAR	20	0	Customer
23	REF_PRODUCT	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
24	REF_IOBJECT	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
25	KA_KEYWORDS	☐	CRMT_KA_KEYWORDS	CRM_KEYWORDS	CHAR	80	0	Keywords
26	KA_CHANGED_AT_DATE	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
27	KA_CREATED_AT_DATE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
28	AUTH_SCOPE	☐	CRM_AUTH_SCOPE	CRM_AUTH_SCOPE	NUMC	6	0	Authorization Scope	*
29	REF_COMPONENT	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
30	REF_IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
31	.INCLUDE	☐				0	0	Knowledge Base Search: IS query parameters
32	SCRIPT_ID	☐	CRM_IC_SCRIPTID_DECO		CHAR	32	0	Scripting ID
33	SCRIPT_DESC	☐	CRM_IC_SCRDSC	CRM_IC_SCRDSC	CHAR	64	0	Interactive Scripting Object Description
34	TEMPLATE_ID	☐	CRM_IC_SCRIPTID_DECO		CHAR	32	0	Scripting ID
35	.INCLUDE	☐				0	0	Knowledge Base Search: MF query parameters
36	MAIL_ID	☐	CRMT_PML_ID	CRMD_PML_ID	CHAR	30	0	Personalized Mails: Mail Form ID
37	MAIL_USAGE	☐	CRMT_PML_USAGE	CRMD_PML_USAGE	CHAR	1	0	Personalized Mails: 'Channel - Text type' combination
38	MF_CREATED_BY	☐	CRMT_PML_CREATED_BY	TDUSER	CHAR	12	0	Personalized Mails: Created by
39	MF_CHANGED_BY	☐	CRMT_PML_CHANGED_BY	TDUSER	CHAR	12	0	Personalized Mails: Changed by
40	MF_CREATED_AT	☐	SYDATS	SYDATS	DATS	8	0	(8-character) Date for SYST
41	MF_CHANGED_AT	☐	SYDATS	SYDATS	DATS	8	0	(8-character) Date for SYST
42	MAIL_DESCRIPTION	☐	CRMT_PML_DESCRIPTION	CRMD_PML_DESCR60	CHAR	60	0	Personalized Mails: Description of Mail Form
43	MF_DESCRIPTIONUC	☐	CRMT_PML_DESCRIPTION	CRMD_PML_DESCR60	CHAR	60	0	Personalized Mails: Description of Mail Form
44	.INCLUDE	☐				0	0	Knowledge Base Search: PS query parameters
45	PROBLEM_TYPE	☐	ISMTP	ISMPT	CHAR	2	0	Problem Type	*
46	PROBLEM_SUBTYPE	☐	PROB_SUBTYPE	PROBLEM_SUBTYPE	CHAR	4	0	SDB: Problem Subtype
47	APPLICATION_AREA	☐	APPLAR	CHAR20	CHAR	20	0	Application Area
48	PRIORITY_TYPE	☐	TYPPR	TYPPR	CHAR	2	0	Priority Type
49	PRIORITY_LEVEL	☐	SDB_PRIOR	SDB_PRIOR	CHAR	1	0	Priority Level
50	SOLUTION_TYPE	☐	ISLTP	ISLTP	CHAR	2	0	Solution Type	*
51	SOLUTION_SUBTYPE	☐	ISLART_EX		CHAR	4	0	SDB: Solution Subtype
52	LOCATION_CODE_GRP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
53	LOCATION_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
54	DAMAGE_CODE_GRP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
55	DAMAGE_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
56	CAUSE_CODE_GRP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
57	CAUSE_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
58	BUSINESS_OBJECT_TYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
59	VALIDATION_CATEGORY	☐	VALCAT	VALCAT	CHAR	40	0	Validation Category	*
60	PROBLEM_ID	☐	ISMNR	ISMNR	CHAR	12	0	Number of Problem Record	*
61	SOLUTION_ID	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
62	PROB_DESCRIPTION	☐	ISMTEXT	TEXT40	CHAR	40	0	Problem Description
63	SUBJECT_PROFILE	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	*
64	SOL_DESCRIPTION	☐	ISLTEXT	TEXT40	CHAR	40	0	Solution Description
65	.INCLUDE	☐				0	0	Knowledge Base Search: CT query parameters
66	CHAT_CONTENT	☐	CRMC_IC_STRING	CRMC_IC_STRING	STRG	0	0	String
67	CHAT_PARTICIPANTS	☐	CHAR200	CHAR200	CHAR	200	0	Text field length 200
68	CHAT_STARTED_ON	☐	SYDATS	SYDATS	DATS	8	0	(8-character) Date for SYST
69	CHAT_SUBJECT	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
70	.INCLUDE	☐				0	0	Extension Include - Knowledge Search Query
71	KNOWS_QUERY_KB	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20130604
SAP Release Created in	700