CRMS4_PSOA_H_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_PSOA_H_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_PSOAHSRCH

CREATE VIEW CRMS4_PSOA_H_SEARCH AS
SELECT
  objtype_h AS object_type,
  object_id,
  header_guid AS GUID,
  header_guid,
  process_type,
  posting_date,
  description_h AS description,
  UPPER(_psoa.description_h) AS DESCRIPTION_UC,
  created_at_h,
  created_at_h AS CREATED_AT,
  tstmp_to_dats( _psoa.created_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CREATED_ON AS clientNULLasCREATED_ON,
  created_by_h AS CREATED_BY,
  changed_at_h AS CHANGED_AT,
  tstmp_to_dats( _psoa.changed_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CHANGED_ON AS clientNULLasCHANGED_ON,
  cast( '' as crmt_privat) AS private_flag,
  changed_by_h AS changed_by,
  btx_class,
  _dect.ddtext AS dec_type_txt,
  auth_scope,
  object_id_ok,
  verify_date,
  _reqt.RequestCategory AS req_type,
  _reqt.RequestCategoryGroup AS req_group,
  contstart_h,
  contend_h,
  tstmp_to_dats( _psoa.contstart_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_from AS clientNULLasvalid_from,
  tstmp_to_dats( _psoa.contend_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_to AS clientNULLasvalid_to,
  _appl.BusinessPartnerFullName AS SOLD_TO_PARTY_LIST,
  person_resp,
  _resp.BusinessPartnerFullName AS PERSON_RESP_LIST,
  approved_by,
  _appr.BusinessPartnerFullName AS APPROVED_BY_LIST,
  rejected_by,
  _rejct.BusinessPartnerFullName AS REJECTED_BY_LIST,
  inbox_status
FROM crms4d_psoa_h AS _psoa
LEFT OUTER JOIN crms4_proctype AS _proc ON _psoa.process_type = _proc.process_type  -- association [1..1]
LEFT OUTER JOIN CRMS4_PS_REQ_TYPE AS _reqt ON _psoa.process_type = _reqt.ProcessType  -- association [0..1]
LEFT OUTER JOIN CRMS4_PS_DEC_TYPE AS _dect ON _psoa.btx_class = _dect.domvalue_l  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _appl ON _psoa.applicant = _appl.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _resp ON _psoa.person_resp = _resp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _appr ON _psoa.approved_by = _appr.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _rejct ON _psoa.rejected_by = _rejct.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN CRMS4_PS_LFCY_STATUS AS _lfcy ON _psoa.stat_lifecycle = _lfcy.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_PS_APPR_STATUS AS _appv ON _psoa.stat_approval_h = _appv.domvalue_l  -- association [0..1]
LEFT OUTER JOIN E_SocialApplication AS _SOAExt ON _psoa.objtype_h = _SOAExt.BusinessObjectType AND _psoa.object_id = _SOAExt.SocialApplication  -- association [0..1]
;