SAP ABAP Table CRMS_QUERY_R_KNOART_BTIL (Knowledge Article: query result structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-KA (Application Component) Knowledge Article
     ⤷ CRM_KNOWLEDGE_ARTICLE_IL (Package) GENIL component for Knowledge Article

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_QUERY_R_KNOART_BTIL	Table Relationship Diagram
Short Description	Knowledge Article: query result 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	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	BTORDER_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	BTADMINH_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	KB_NAME	☐	CRMT_EI_KB_NAME	CRMT_EI_KB_NAME	CHAR	30	0	Name of Knowledge Base	*
6	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
7	OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
8	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
9	ORIG_LANGUAGE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
10	KADESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
11	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
12	STATUS_TXT	☐	CRMT_REPORT_USERSTATUS	TEXT40	CHAR	40	0	User Status
13	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
14	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
15	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
16	SERVICE_ORG_SHORT	☐	CRMT_SERVICE_ORG_SHORT	TEXT12	CHAR	12	0	Service Organization Identifier
17	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
18	PARTNER_FCT	☐	CMST_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
19	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
20	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
21	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
22	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
23	PRIORITY_TXT	☐	CRMT_REPORT_PRIORITY_TXT	DDTEXT	CHAR	60	0	Text Description for Priority
24	CAT_SCHEMA	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
25	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
26	CUSTOMER	☐	CRMT_UIU_CUSTOMER	CRM_PARTNER_NUMBER	CHAR	20	0	Customer
27	REF_PRODUCT	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
28	REF_COMPONENT	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
29	REF_IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
30	REF_IOBJECT	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
31	KEYWORDS	☐	CRMT_KA_KEYWORDS	CRM_KEYWORDS	CHAR	80	0	Keywords
32	CONTACT_PERSON	☐	CRMT_UIU_CONTACT_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Contact
33	CHANGED_AT_DATE	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
34	CREATED_AT_DATE	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
35	AUTH_SCOPE	☐	CRM_AUTH_SCOPE	CRM_AUTH_SCOPE	NUMC	6	0	Authorization Scope	*
36	AUTHORIZED_FOR_TEXT	☐	CRMT_KA_AUTHORIZED_FOR	CRM_TXT_QUERY	CHAR	60	0	Authorized For
37	USER_STAT_PROC	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
38	PROCESS_TYPE_DESCR	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
39	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
40	SERVICE_ORG_DESCR	☐	STEXT	TEXT40	CHAR	40	0	Object Name
41	SALES_ORG_DESCR	☐	STEXT	TEXT40	CHAR	40	0	Object Name
42	LANGUAGE_TXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
43	RANK	☐	CRMT_EI_SEARCH_RANK	CHAR10	CHAR	10	0	EI search service returned hitlist rank value
44	NOTE_TEXT	☐	CRMT_KA_SHORTTEXT	CRM_KA_SHORTTEXT	CHAR	40	0	Text for Knowledge Article
45	.INCLUDE	☐				0	0	EEW Include Knowledge Article Search Result
46	EEW_R_KNOWART_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
47	KADESCRIPTION2	☐	CRMT_NOTE_TEXT	CRM_NOTE_TEXT	CHAR	255	0	Note Text

History

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