CRMS4_IU_C_CTHIP

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_CTHIP.
-- 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: CRMS4IUVCCTHIP

CREATE VIEW CRMS4_IU_C_CTHIP AS
SELECT
  objtype_h,
  object_id,
  posting_date,
  header_guid,
  contend_max,
  process_type,
  _ContractItem.installation AS installation,
  _ContractItem.pod_int_ui AS pod_int_ui,
  _ContractItem.premise AS premise,
  _ContractItem.isu_contract AS isu_contract,
  _ContractItem.Division AS Division,
  _ContractItem.contend AS contend,
  _ContractItem.product_id AS product_id,
  _ContractItem.product AS product,
  _ContractItem.ordered_prod AS ordered_prod,
  _ContractItem.partner_prod AS partner_prod,
  _ContractItem.product_kind AS product_kind,
  _ContractItem.order_date AS order_date,
  _ContractItem.stat_error AS stat_error,
  _ContractItem.stat_open AS stat_open,
  _ContractItem._PointOfDelivery.UtilsExternalPointOfDelivery AS UtilsExternalPointOfDelivery,
  _ContractPeriod.root_config AS root_config,
  _ContractPeriod.exist_vckey AS exist_vckey
FROM CRMS4_IU_C_CTH
;