CRMS4_REPA_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_REPA_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.

CREATE VIEW CRMS4_REPA_H_SEARCH AS
SELECT
  objtype_h AS object_type,
  object_id,
  header_guid,
  header_guid AS guid,
  process_type,
  posting_date,
  description_h AS description,
  created_at_h,
  created_by_h,
  changed_at_h,
  changed_by_h,
  created_at_h AS created_at,
  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 AS created_by,
  changed_at_h AS changed_at,
  tstmp_to_dats( changed_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as changed_at_date AS clientNULLaschanged_at_date,
  tstmp_to_dats( changed_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as changed_on AS clientNULLaschanged_on,
  changed_by_h AS changed_by,
  object_id_ok,
  verify_date,
  _SituationHdr.SitnNumberOfInstances AS sit_num_hdr,
  cast(_SituationTot.SitnNumberOfInstances as sit_de_inst_count) AS sit_num_tot,
  dis_channel,
  division,
  division_ori,
  sales_org,
  sales_office,
  sales_group,
  sales_org_sd,
  person_resp,
  stat_error,
  stat_open,
  _statusreason.Codetext AS Codetext,
  ref_msr_id
FROM crms4d_repa_h AS _repa
LEFT OUTER JOIN I_BusinessPartner AS _sold ON _repa.sold_to_party = _sold.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ship ON _repa.ship_to_party = _ship.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _resp ON _repa.person_resp = _resp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _cont ON _repa.contact_person = _cont.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN CRMS4_PROC_TYPE AS _proc ON _repa.process_type = _proc.Process_Type  -- association [0..1]
LEFT OUTER JOIN CRMS4_LFCY_STATUS AS _lfcy ON _repa.stat_lifecycle = _lfcy.domvalue_l AND _lfcy.domname = 'CRMS4_STAT_LIFECYCLE'  -- association [0..1]
LEFT OUTER JOIN CRMS4_ERRO_STATUS AS _erro ON _repa.stat_error = _erro.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ARCB_STATUS AS _arcb ON _repa.stat_archivable = _arcb.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ARCD_STATUS AS _arcd ON _repa.stat_archived = _arcd.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_OPEN_STATUS AS _open ON _repa.stat_open = _open.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_STATUS_REASON AS _statusreason ON _repa.objtype_h = _statusreason.ObjtypeH AND _repa.object_id = _statusreason.ObjectId  -- association [0..1]
LEFT OUTER JOIN I_SitnInstceIndicator AS _SituationHdr ON _repa.header_guid_char = _SituationHdr.SitnInstceAnchorObjectKey  -- association [0..1]
LEFT OUTER JOIN CRMS4_SERV_SITN_TOT_COUNT AS _SituationTot ON _repa.header_guid_char = _SituationTot.header_key  -- association [0..1]
;