CRMS4_OBJECT_LINKAGE_PREDECESR

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_OBJECT_LINKAGE_PREDECESR.
-- 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: CRMS4_OBJLINKPRE

CREATE VIEW CRMS4_OBJECT_LINKAGE_PREDECESR AS
SELECT
  relationid,
  posno,
  breltyp,
  attribut,
  vona_kind,
  invalid,
  secondary,
  seqno,
  voucher_code,
  doc_info,
  _lead.object_id AS lead_id,
  _lead.header_guid AS lead_guid,
  _lead.description_h AS lead_des,
  upper(_lead.description_h) AS lead_des_uc,
  _oppt.object_id AS oppt_id,
  _oppt.header_guid AS oppt_guid,
  _oppt.description_h AS oppt_des,
  upper(_oppt.description_h) AS oppt_des_uc
FROM crmd_brelvonae AS _vonae
LEFT OUTER JOIN crms4d_oppt_h AS _lead ON _lead.objtype_h = _vonae.objtype_a_sel AND _lead.header_guid = _vonae.objguid_a_sel AND _lead.objtype_h = 'BUS2000108'  -- association [0..*]
LEFT OUTER JOIN crms4d_oppt_h AS _oppt ON _oppt.objtype_h = _vonae.objtype_a_sel AND _oppt.header_guid = _vonae.objguid_a_sel AND _oppt.objtype_h = 'BUS2000111'  -- association [0..*]
;