CRMS4_IU_C_CTH

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_IU_C_CTH.
-- 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: CRMS4IUVCCTH

CREATE VIEW CRMS4_IU_C_CTH AS
SELECT
  objtype_h,
  object_id,
  header_guid,
  process_type,
  posting_date,
  created_at_h,
  created_by_h,
  changed_at_h,
  changed_by_h,
  btx_class,
  auth_scope,
  object_id_ok,
  verify_date,
  stat_error,
  stat_open,
  tstmp_to_dats(contend_max, 'UTC', $session.client, 'NULL') AS contend_max,
  person_resp,
  sales_office,
  sales_group,
  dis_channel,
  division,
  service_org
FROM CRMS4_IU_I_CTH
LEFT OUTER JOIN CRMS4_IU_E_CTH AS _ContractHeaderExtension ON objtype_h = _ContractHeaderExtension.objtype_h AND object_id = _ContractHeaderExtension.object_id  -- association [0..1]
;