CRMS4V_PS_SDP_I2

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_SDP_I2.
-- 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: CRMS4VPSSDPI

CREATE VIEW CRMS4V_PS_SDP_I2 AS
SELECT
  _SDPI.client AS client,
  _SDPI.objtype_h AS object_type,
  _SDPI.object_id AS object_id,
  _SDPI.number_int AS number_int,
  _SDPI.item_guid AS item_guid,
  _SDPI.created_at_i AS created_at_i,
  _SDPI.created_by_i AS created_by_i,
  _SDPI.changed_at_i AS changed_at_i,
  _SDPI.changed_by_i AS changed_by_i,
  _SDPI.objtype_i AS objtype_i,
  _SDPI.header_guid AS header_guid,
  _SDPI.parent AS parent,
  _SDPI.alternative AS alternative,
  _SDPI.product AS product,
  _SDPI.ordered_prod AS product_id,
  _SDPI.partner_prod AS partner_prod,
  _SDPI.description_i AS description,
  _SDPI.itm_language AS itm_language,
  _SDPI.number_ext AS number_ext,
  _SDPI.itm_type AS item_type,
  _SDPI.order_date AS order_date,
  _SDPI.itm_usage AS itm_usage,
  _SDPI.product_kind AS product_kind,
  _SDPI.revacc_refid AS revacc_refid,
  _SDPI.process_type AS process_type,
  tstmp_to_dats( _SDPI.contstart_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as header_valid_from AS clientNULLasheader_valid_from,
  tstmp_to_dats( _SDPI.contend_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as header_valid_to AS clientNULLasheader_valid_to,
  _SDPI.item_no_appt AS item_no_appt,
  tstmp_to_dats( _SDPI.contstart_i, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_from AS clientNULLasvalid_from,
  tstmp_to_dats( _SDPI.contend_i, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_to AS clientNULLasvalid_to,
  _SDPI.deduct_from_party AS deduct_from,
  CONCAT_WITH_SPACE( _dedf.mc_name2, _dedf.mc_name1, 1 ) AS DEDUCT_FROM_LIST,
  _SDPI.deduct_to_party AS deduct_to,
  CONCAT_WITH_SPACE( _dedt.mc_name2, _dedt.mc_name1, 1 ) AS DEDUCT_TO_LIST,
  _SDPI.deduct_ddr AS deduct_ddr
FROM crms4d_psdp_i AS _SDPI
LEFT OUTER JOIN but000 AS _dedf ON _SDPI.deduct_from_party = _dedf.partner  -- association [0..1]
LEFT OUTER JOIN but000 AS _dedt ON _SDPI.deduct_to_party = _dedt.partner  -- association [0..1]
LEFT OUTER JOIN CRMS4V_PS_ACTV_STATUS AS _actv ON _SDPI.stat_activation_h = _actv.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4V_PS_RELA_STATUS AS _rela ON _SDPI.stat_released_i = _rela.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4V_PS_CREA_STATUS AS _crea ON _SDPI.stat_activation_h = _crea.domvalue_l  -- association [0..1]
;