CRMS4_KNAR_SEARCH

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CRMS4_KNAR_SEARCH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CRMS4_KNARSEARCH

CREATE VIEW CRMS4_KNAR_SEARCH AS
SELECT
  objtype_h AS object_type,
  object_id,
  category,
  _actc.description AS category_txt,
  priority,
  _prio.txt_long AS priority_txt,
  class,
  tstmp_to_dats( valid_from, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_from AS clientNULLasvalid_from,
  tstmp_to_dats( valid_to, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_to AS clientNULLasvalid_to,
  header_guid AS guid,
  header_guid,
  process_type,
  posting_date,
  description_h AS description,
  tstmp_to_dats( created_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as created_at_date AS clientNULLascreated_at_date,
  tstmp_to_dats( created_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as created_on AS clientNULLascreated_on,
  created_by_h,
  created_at_h,
  created_by_h AS created_by,
  created_at_h AS created_at,
  changed_at_h,
  changed_by_h,
  changed_by_h AS changed_by,
  changed_at_h AS changed_at,
  btx_class,
  auth_scope,
  object_id_ok,
  verify_date,
  dis_channel,
  division,
  division_ori,
  sales_org,
  _slso.short AS SALES_ORG_SHORT,
  sales_office,
  sales_group,
  service_org,
  _srvo.short AS SERVICE_ORG_SHORT,
  person_resp,
  _inbxasgnto.BusinessPartnerFullName AS INBOX_ASSIGNED_TO_list,
  _inbxgrpasgn.BusinessPartnerFullName AS INBOX_GROUP_ASSIGNED_list,
  _inbxacct.BusinessPartnerFullName AS INBOX_ACCOUNT_list,
  _inbxcustcont.BusinessPartnerFullName AS INBOX_CONTACT_PERSON_list,
  stat_error,
  stat_open,
  inbox_status,
  _refo.product_id AS REF_PRODUCT,
  _rate.rating AS average_rate,
  asp_id_01,
  cat_id_01,
  cat_id_01 AS cat_schema,
  asp_id_02,
  cat_id_02
FROM crms4d_knar_h AS _knar
LEFT OUTER JOIN I_BusinessPartner AS _resp ON _knar.person_resp = _resp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxasgnto ON _knar.inbox_assigned_to = _inbxasgnto.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxgrpasgn ON _knar.inbox_group_assigned = _inbxgrpasgn.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxacct ON _knar.inbox_account = _inbxacct.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxcustcont ON _knar.inbox_contact_person = _inbxcustcont.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN crmc_act_cat_t AS _actc ON _knar.category = _actc.category AND _actc.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN scpriot AS _prio ON _knar.priority = _prio.priority AND _prio.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN CRMS4_PROC_TYPE AS _proc ON _knar.process_type = _proc.Process_Type  -- association [0..1]
LEFT OUTER JOIN crmd_srv_subject AS _subj ON _knar.header_guid = _subj.guid_ref  -- association [0..1]
LEFT OUTER JOIN crmd_srv_refobj AS _refo ON _knar.header_guid = _refo.guid_ref  -- association [0..1]
LEFT OUTER JOIN hrp1000 AS _slso ON _knar.sales_org = _slso.otjid  -- association [0..1]
LEFT OUTER JOIN hrp1000 AS _srvo ON _knar.service_org = _srvo.otjid  -- association [0..1]
LEFT OUTER JOIN CRMS4_LFCY_STATUS AS _lfcy ON _knar.stat_lifecycle = _lfcy.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_CANC_STATUS AS _canc ON _knar.stat_cancelled = _canc.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_RELE_STATUS AS _rele ON _knar.stat_released = _rele.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ERRO_STATUS AS _erro ON _knar.stat_error = _erro.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_OPEN_STATUS AS _open ON _knar.stat_open = _open.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ARCB_STATUS AS _arcb ON _knar.stat_archivable = _arcb.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ARCD_STATUS AS _arcd ON _knar.stat_archived = _arcd.domvalue_l  -- association [0..1]
LEFT OUTER JOIN crm_rating_table AS _rate ON _knar.header_guid = _rate.doc_guid  -- association [0..1]
LEFT OUTER JOIN E_KnowledgeArticle AS _KnowledgeArticleExt ON _knar.objtype_h = _KnowledgeArticleExt.KnowledgeProviderObjectCat AND _knar.object_id = _KnowledgeArticleExt.KnowledgeProvider  -- association [0..1]
;