CRMS4V_PS_SOA_I_UNION

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_SOA_I_UNION.
-- 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: CRMS4VPSSOAIUN

CREATE VIEW CRMS4V_PS_SOA_I_UNION AS
SELECT
  _SOAI.client AS client,
  _SOAI.object_type AS object_type,
  _SOAI.object_id AS object_id,
  _SOAI.number_int AS number_int,
  _SOAI.item_guid AS item_guid,
  _SOAI.created_at_i AS created_at_i,
  _SOAI.created_by_i AS created_by_i,
  _SOAI.changed_at_i AS changed_at_i,
  _SOAI.changed_by_i AS changed_by_i,
  _SOAI.objtype_i AS objtype_i,
  _SOAI.header_guid AS header_guid,
  _SOAI.parent AS parent,
  _SOAI.alternative AS alternative,
  _SOAI.product AS product,
  _SOAI.product_id AS product_id,
  _SOAI.partner_prod AS partner_prod,
  _SOAI.description AS description,
  _SOAI.itm_language AS itm_language,
  _SOAI.number_ext AS number_ext,
  _SOAI.item_type AS item_type,
  _SOAI.order_date AS order_date,
  _SOAI.itm_usage AS itm_usage,
  _SOAI.product_kind AS product_kind,
  _SOAI.revacc_refid AS revacc_refid,
  _SOAI.process_type AS process_type,
  _SOAI.item_no_appt AS item_no_appt,
  _SOAI.valid_from AS valid_from,
  _SOAI.valid_to AS valid_to,
  cast( '' as abap.char(10) ) AS beneficiary
FROM CRMS4V_PS_SOA_I AS _SOAI
-- UNION with additional select branch(es): CRMS4V_PS_PREQ_I
;