CRMS4V_PS_SSP_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 CRMS4V_PS_SSP_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: CRMS4VSSPSEARCH

CREATE VIEW CRMS4V_PS_SSP_SEARCH AS
SELECT
  _SSP.client AS client,
  _SSP.object_type AS object_type,
  _SSP.object_id AS object_id,
  _SSP.GUID AS GUID,
  _SSP.process_type AS process_type,
  _SSP.description AS description,
  _SSP.btx_class AS btx_class,
  _SSP.dec_type_txt AS dec_type_txt,
  _SSP.SOLD_TO_PARTY_LIST AS SOLD_TO_PARTY_LIST,
  _SSP.person_resp AS person_resp,
  _SSP.PERSON_RESP_LIST AS PERSON_RESP_LIST,
  _SSP.approved_by AS approved_by,
  _SSP.rejected_by AS rejected_by,
  _SSP.CREATED_BY AS CREATED_BY,
  _SSP.valid_from AS valid_from,
  _SSP.valid_to AS valid_to,
  _SSPI.item_guid AS item_guid,
  _SSPI.item_type AS item_type,
  _SSPI.product_id AS benefit,
  _SSPI.beneficiary AS beneficiary,
  _SSPI.alt_payee AS alt_payee
FROM CRMS4V_PS_SSP AS _SSP
LEFT OUTER JOIN CRMS4V_PS_SSP_I AS _SSPI ON _SSP.GUID = _SSPI.header_guid  -- association [0..*]
;