I_CollateralInsuranceLinkData

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 I_CollateralInsuranceLinkData.
-- 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.

CREATE VIEW I_CollateralInsuranceLinkData AS
SELECT
  ins_lnk_guid AS CollateralInsuranceLinkUUID,
  obj_ref_guid AS CollateralObjectReferenceUUID,
  ins_ref_guid AS ColltrlInsuranceReferenceUUID,
  obj_ref_sysid AS ColltrlInsurObjLinkingSystem,
  ins_id AS CollateralInsuranceLinkID,
  ins_objsysid AS CollateralReferenceSystem,
  lnk_valid_from AS ColltrlInsurLinkValidFromDate,
  lnk_valid_to AS ColltrlInsurLinkValidToDate,
  created_by AS ColltrlInsuranceLinkEnteredBy,
  created_at AS ColltrlInsurLnkEnteredDateTime,
  changed_by AS ColltrlInsurLinkLastChangedBy,
  changed_at AS ColltrlInsurLnkLastChgdDteTime,
  sourceofentry AS ColltrlInsurLinkEnteredSource
FROM cms_oms_ins_lnk
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON ColltrlInsuranceReferenceUUID = _CollateralInsurance.CollateralInsuranceUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON CollateralObjectReferenceUUID = _CollateralRealEstate.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralReferenceSystem AS _CollateralReferenceSystem ON CollateralReferenceSystem = _CollateralReferenceSystem.CollateralReferenceSystem  -- association [0..1]
;