CRMS4_SERV_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_SERV_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_SERVSEARCH

CREATE VIEW CRMS4_SERV_SEARCH AS
SELECT
  _SRVH.object_type AS object_type,
  _SRVH.object_id AS object_id,
  _SRVH.GUID AS GUID,
  _SRVH.header_guid AS header_guid,
  _SRVH.process_type AS process_type,
  _SRVH.SOLD_TO_PARTY_LIST AS SOLD_TO_PARTY_LIST,
  _SRVH.NET_VALUE AS NET_VALUE,
  _SRVH.currency AS currency,
  _SRVH.priority AS priority,
  _SRVH.priority_txt AS priority_txt,
  _SRVH.service_team AS service_team,
  _SRVH.description AS description,
  _SRVH.DESCRIPTION_UC AS DESCRIPTION_UC,
  _SRVH.urgency AS urgency,
  _SRVH.impact AS impact,
  _SRVH.stat_error AS stat_error,
  _SRVH.stat_billing AS stat_billing,
  _SRVH.inbox_status AS inbox_status,
  _SRVH.po_date_sold AS po_date_sold,
  _SRVH.category AS category,
  _SRVH.category_txt AS category_txt,
  _SRVH.service_org AS service_org,
  _SRVH.person_resp AS person_resp,
  _SRVH.CREATED_BY AS CREATED_BY,
  _SRVH.CREATED_AT AS CREATED_AT,
  _SRVH.valid_from AS valid_from,
  _SRVH.valid_to AS valid_to,
  _SRVH.posting_date AS posting_date,
  _SRVH.payer AS payer,
  _SRVH.resp_group AS resp_group,
  _SRVI.item_guid AS item_guid,
  _SRVI.itm_type AS itm_type,
  _SRVI.number_int AS number_int,
  _SRVI.description AS REFOBJ_PRODUCT_NAME,
  _SRVI.payer AS payer_i,
  _SRVI.payer_list AS payer_list_i,
  _SRVI.resp_group AS resp_group_i,
  _SRVI.stat_error AS stat_error_i
FROM CRMS4_SERV_H_SEARCH AS _SRVH
LEFT OUTER JOIN CRMS4_SERV_I_SEARCH AS _SRVI ON _SRVH.header_guid = _SRVI.header_guid  -- association [0..*]
;