CRMS4V_PS_PREQ_I

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_PREQ_I.
-- 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: CRMS4VPSPREQI

CREATE VIEW CRMS4V_PS_PREQ_I AS
SELECT
  _PREQI.client AS client,
  _PREQI.objtype_h AS object_type,
  _PREQI.object_id AS object_id,
  _PREQI.number_int AS number_int,
  _PREQI.item_guid AS item_guid,
  _PREQI.created_at_i AS created_at_i,
  _PREQI.created_by_i AS created_by_i,
  _PREQI.changed_at_i AS changed_at_i,
  _PREQI.changed_by_i AS changed_by_i,
  _PREQI.objtype_i AS objtype_i,
  _PREQI.header_guid AS header_guid,
  _PREQI.parent AS parent,
  _PREQI.alternative AS alternative,
  _PREQI.product AS product,
  _PREQI.ordered_prod AS product_id,
  _PREQI.partner_prod AS partner_prod,
  _PREQI.description_i AS description,
  _PREQI.itm_language AS itm_language,
  _PREQI.number_ext AS number_ext,
  _PREQI.itm_type AS item_type,
  _PREQI.order_date AS order_date,
  _PREQI.itm_usage AS itm_usage,
  _PREQI.product_kind AS product_kind,
  _PREQI.revacc_refid AS revacc_refid,
  _PREQI.process_type AS process_type,
  tstmp_to_dats(_PREQI.contstart_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as header_valid_from AS clientNULLasheader_valid_from,
  tstmp_to_dats( _PREQI.contend_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as header_valid_to AS clientNULLasheader_valid_to,
  _PREQI.item_no_appt AS item_no_appt,
  tstmp_to_dats(_PREQI.contstart_i, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_from AS clientNULLasvalid_from,
  tstmp_to_dats( _PREQI.contend_i, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_to AS clientNULLasvalid_to,
  _PREQI.beneficiary AS beneficiary,
  CONCAT_WITH_SPACE( _bene.mc_name2, _bene.mc_name1, 1 ) AS BENEFICIARY_LIST,
  CONCAT_WITH_SPACE( _payr.mc_name2, _payr.mc_name1, 1 ) AS PAYM_RECIPIENT_LIST
FROM crms4d_preq_i AS _PREQI
LEFT OUTER JOIN but000 AS _bene ON _PREQI.beneficiary = _bene.partner  -- association [0..1]
LEFT OUTER JOIN but000 AS _payr ON _PREQI.payment_recipient = _payr.partner  -- association [0..1]
LEFT OUTER JOIN CRMS4V_PS_SOAL_STATUS AS _actv ON _PREQI.stat_activation_h = _actv.domvalue_l  -- association [0..1]
;