CRMS4_KNAR_SEARCH

Knowledge Article Search | view: CRMS4_KNARSEARCH | Extraction: Not supported | Component: S4CRM: Reporting

Tables used: CRMD_SRV_REFOBJ, CRMS4D_KNAR_H, CRM_RATING_TABLE, CRMC_ACT_CAT_T, HRP1000, SCPRIOT, CRMS4C_STAT_LC_T, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, BUT000

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates (5)
☰ Categorical (20)
Other (70)
🔗 Relations (16)

Column Name	Description
object_type FK	Business Trans. Cat.
object_id	Transaction ID

Column Name	Description

Column Name	Description

Column Name	Description
valid_from	null
valid_to	null
posting_date	Posting Date for a Business Transaction
created_at_date	null
created_on	null

Column Name	Description
class	Activity Class	Show values
template_type	Template Type of CRM Transaction	Show values
archiving_flag	Indicator Whether the Business Transaction Can Be Archived	Show values
object_id_ok	Indicator That Transaction ID Is Correct	Show values
service_org_ori	Origin Indicator: Service Organization	Show values
service_orgr_ori	Origin Indicator: Service Scenario Organizational Unit	Show values
sales_org_ori	Origin Indicator: Sales Organization	Show values
dis_channel_ori	Origin Indicator: Distribution Channel	Show values
sales_off_ori	Origin Indicator: Sales Office	Show values
sales_group_ori	Origin Indicator: Sales Group	Show values
sales_orgr_ori	Origin Indicator: Sales Scenario Organizational Unit	Show values
division_ori	Origin Flag: Division	Show values
stat_lifecycle	Life Cycle Status	Show values
stat_released	Release Status	Show values
stat_error	Error Status	Show values
stat_cancelled	Cancellation Status	Show values
stat_archivable	Archivable	Show values
stat_archived	Archived	Show values
stat_open	Status "Open"	Show values
average_rate	Rating	Show values

Column Name	Description	Domain name
category_txt	Description (20 Characters)	TEXT20
priority_txt	Description	TEXT40
valid_from_tstmp	Knowledge Article: Valid from Date	BCOS_TSTMP
valid_to_tstmp	Knowledge Article: Valid to Date	BCOS_TSTMP
btadminh_guid	GUID of a CRM Order Object	SYSUUID
guid	GUID of a CRM Order Object	SYSUUID
header_guid	GUID of a CRM Order Object	SYSUUID
process_type_txt	Description (20 Characters)	TEXT20
kadescription	Transaction Description	CRM_PROCESS_DESCRIPTION
description	Transaction Description	CRM_PROCESS_DESCRIPTION
description_uc	null
created_by_h	User that Created the Transaction	UNAME
created_at_h	Created At (Output in User Time Zone)	COM_TSTMP
created_by	User that Created the Transaction	UNAME
created_at	Created At (Output in User Time Zone)	COM_TSTMP
changed_at_h	Changed At (Output in User Time Zone)	COM_TSTMP
changed_by_h	Transaction Last Changed By	UNAME
changed_by	Transaction Last Changed By	UNAME
changed_at	Changed At (Output in User Time Zone)	COM_TSTMP
head_changed_at	Time of Last Change to the Transaction	BCOS_TSTMP
verify_date	Time Period of Last Archiving Attempt	BCOS_TSTMP
sales_org	Sales Organization ID	HROBJEC_14
SALES_ORG_SHORT	Object Abbreviation	TEXT12
sales_org_descr	Object Name	TEXT40
sales_office	Sales Office	HROBJEC_14
sales_group	Sales Group	HROBJEC_14
sales_org_resp	Organizational Unit (Sales)	HROBJEC_14
service_org	Service Organization	HROBJEC_14
SERVICE_ORG_SHORT	Object Abbreviation	TEXT12
service_org_descr	Object Name	TEXT40
service_org_resp	Organizational Unit (Service)	HROBJEC_14
person_resp_list	null
employee_resp_list	null
INBOX_ASSIGNED_TO_list	null
INBOX_GROUP_ASSIGNED_list	null
INBOX_ACCOUNT_list	null
INBOX_CONTACT_PERSON_list	null
stat_lifecycle_desc	Short Text for Fixed Values	DDTEXT
stat_released_desc	Short Text for Fixed Values	DDTEXT
stat_error_desc	Short Text for Fixed Values	DDTEXT
stat_cancelled_desc	Short Text for Fixed Values	DDTEXT
stat_archivable_desc	Short Text for Fixed Values	DDTEXT
stat_archived_desc	Short Text for Fixed Values	DDTEXT
stat_open_desc	Short Text for Fixed Values	DDTEXT
REF_PRODUCT	Material Number	MATNR
catlvlguid01_01	Category GUID 1- schema 1	SYSUUID
catlvlguid02_01	Category GUID 2- schema 1	SYSUUID
catlvlguid03_01	Category GUID 3- schema 1	SYSUUID
catlvlguid04_01	Category GUID 4- schema 1	SYSUUID
catlvlguid05_01	Category GUID 5- schema 1	SYSUUID
catlvlguid06_01	Category GUID 6- schema 1	SYSUUID
catlvlguid07_01	Category GUID 7- schema 1	SYSUUID
catlvlguid08_01	Category GUID 8- schema 1	SYSUUID
catlvlguid09_01	Category GUID 9- schema 1	SYSUUID
catlvlguid10_01	Category GUID 10- schema 1	SYSUUID
asp_id_01	Coherent Cat. - Aspect ID	CRM_ERMS_CAT_AS_ID_DO
cat_id_01	Coherent Cat. - Category ID	CRM_ERMS_CAT_CA_ID_DO
cat_schema	Coherent Cat. - Category ID	CRM_ERMS_CAT_CA_ID_DO
catlvlguid01_02	Category GUID 1- schema 2	SYSUUID
catlvlguid02_02	Category GUID 2- schema 2	SYSUUID
catlvlguid03_02	Category GUID 3- schema 2	SYSUUID
catlvlguid04_02	Category GUID 4- schema 2	SYSUUID
catlvlguid05_02	Category GUID 5- schema 2	SYSUUID
catlvlguid06_02	Category GUID 6- schema 2	SYSUUID
catlvlguid07_02	Category GUID 7- schema 2	SYSUUID
catlvlguid08_02	Category GUID 8- schema 2	SYSUUID
catlvlguid09_02	Category GUID 9- schema 2	SYSUUID
catlvlguid10_02	Category GUID 10- schema 2	SYSUUID
asp_id_02	Coherent Cat. - Aspect ID	CRM_ERMS_CAT_AS_ID_DO
cat_id_02	Coherent Cat. - Category ID	CRM_ERMS_CAT_CA_ID_DO

Master Data Relations	Join Conditions
Authorization Scope Client ? Authorization Scope	`CRMS4_KNAR_SEARCH.MANDT == CRMC_AUTH_SCP.CLIENT` `CRMS4_KNAR_SEARCH.[column in domain "CRM_AUTH_DOM"] == CRMC_AUTH_SCP.AUTH_DOM` `CRMS4_KNAR_SEARCH.AUTH_SCOPE == CRMC_AUTH_SCP.AUTH_SCOPE`
CRM Business Transaction Classification CRM Business Transaction Classification ?	`CRMS4_KNAR_SEARCH.BTX_CLASS == CRMC_TRANS_CLASS.BTX_CLASS` `CRMS4_KNAR_SEARCH.[column in domain "CRMT_SWO_OBJTYP_PROCESS"] == CRMC_TRANS_CLASS.OBJECT_TYPE`
Activity Category (Communication Type) Client Activity Category (Communication Type)	`CRMS4_KNAR_SEARCH.MANDT == CRMC_ACT_CATEGOR.CLIENT` `CRMS4_KNAR_SEARCH.CATEGORY == CRMC_ACT_CATEGOR.CATEGORY`
Language Key of Description	`CRMS4_KNAR_SEARCH.DESCR_LANGUAGE == T002.SPRAS`
Distribution Channel Client Distribution Channel	`CRMS4_KNAR_SEARCH.MANDT == TVTW.MANDT` `CRMS4_KNAR_SEARCH.DIS_CHANNEL == TVTW.VTWEG`
Division Client Division	`CRMS4_KNAR_SEARCH.MANDT == TSPA.MANDT` `CRMS4_KNAR_SEARCH.DIVISION == TSPA.SPART`
Employee Responsible Client Employee Responsible Employee Responsible	`CRMS4_KNAR_SEARCH.MANDT == BUT000.CLIENT` `CRMS4_KNAR_SEARCH.EMPLOYEE_RESP == BUT000.PARTNER` `CRMS4_KNAR_SEARCH.PERSON_RESP == BUT000.PARTNER`
Sales Partners Client Sales Partners	`CRMS4_KNAR_SEARCH.MANDT == BUT000.CLIENT` `CRMS4_KNAR_SEARCH.INBOX_ACCOUNT == BUT000.PARTNER`
Employee Responsible Client Employee Responsible	`CRMS4_KNAR_SEARCH.MANDT == BUT000.CLIENT` `CRMS4_KNAR_SEARCH.INBOX_ASSIGNED_TO == BUT000.PARTNER`
Customer Contact Person Client Customer Contact Person	`CRMS4_KNAR_SEARCH.MANDT == BUT000.CLIENT` `CRMS4_KNAR_SEARCH.INBOX_CONTACT_PERSON == BUT000.PARTNER`
Responsible Group Client Responsible Group	`CRMS4_KNAR_SEARCH.MANDT == BUT000.CLIENT` `CRMS4_KNAR_SEARCH.INBOX_GROUP_ASSIGNED == BUT000.PARTNER`
Status of Agent Inbox Item Client Status of Agent Inbox Item	`CRMS4_KNAR_SEARCH.MANDT == CRMC_AUI_STATUS.CLIENT` `CRMS4_KNAR_SEARCH.INBOX_STATUS == CRMC_AUI_STATUS.INBOX_STATUS`
Business Trans. Cat.	`CRMS4_KNAR_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
Employee Responsible Client Employee Responsible Employee Responsible	`CRMS4_KNAR_SEARCH.MANDT == BUT000.CLIENT` `CRMS4_KNAR_SEARCH.EMPLOYEE_RESP == BUT000.PARTNER` `CRMS4_KNAR_SEARCH.PERSON_RESP == BUT000.PARTNER`
Activity Priority Client Activity Priority	`CRMS4_KNAR_SEARCH.MANDT == SCPRIO.CLIENT` `CRMS4_KNAR_SEARCH.PRIORITY == SCPRIO.PRIORITY`
Business Transaction Type Client Business Transaction Type	`CRMS4_KNAR_SEARCH.MANDT == CRMC_PROC_TYPE.CLIENT` `CRMS4_KNAR_SEARCH.PROCESS_TYPE == CRMC_PROC_TYPE.PROCESS_TYPE`