I_ObjectInsuranceLinkData

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_ObjectInsuranceLinkData.
-- 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_ObjectInsuranceLinkData AS
SELECT
  ins_lnk_guid AS ObjectInsuranceLinkUUID,
  obj_ref_guid AS ObjectReferenceUUID,
  ins_ref_guid AS ObjectInsuranceReferenceUUID,
  ins_objsysid AS InsuranceReferenceSystem,
  _RealEstateObjectData.RealEstateUUID AS RealEstateUUID,
  _CollateralRealEstate.CollateralRealEstateUUID AS CollateralRealEstateUUID,
  _MovableObjectData.MovableObjectUUID AS MovableObjectUUID,
  _ShipObjectData.ShipObjectUUID AS ShipObjectUUID,
  _RightsObjectData.RightsObjectUUID AS RightsObjectUUID
FROM cms_oms_ins_lnk
LEFT OUTER JOIN I_InsuranceObjectData AS _InsuranceObjectData ON ObjectInsuranceReferenceUUID = _InsuranceObjectData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjectData AS _RealEstateObjectData ON ObjectReferenceUUID = _RealEstateObjectData.RealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON ObjectReferenceUUID = _CollateralRealEstate.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_MovableObjectData AS _MovableObjectData ON ObjectReferenceUUID = _MovableObjectData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ShipObjectData AS _ShipObjectData ON ObjectReferenceUUID = _ShipObjectData.ShipObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RightsObjectData AS _RightsObjectData ON ObjectReferenceUUID = _RightsObjectData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectMasterData AS _InsuranceObjectMasterData ON ObjectInsuranceReferenceUUID = _InsuranceObjectMasterData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON ObjectInsuranceReferenceUUID = _CollateralInsurance.CollateralInsuranceUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjectMasterData AS _RealEstateObjectMasterData ON ObjectReferenceUUID = _RealEstateObjectMasterData.RealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstateMaster AS _CollateralRealEstateMaster ON ObjectReferenceUUID = _CollateralRealEstateMaster.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_MovableObjectMasterData AS _MovableObjectMasterData ON ObjectReferenceUUID = _MovableObjectMasterData.MovableObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_RightsObjectMasterData AS _RightsObjectMasterData ON ObjectReferenceUUID = _RightsObjectMasterData.RightsObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectReferenceSystem AS _InsuranceReferenceSystem ON InsuranceReferenceSystem = _InsuranceReferenceSystem.ObjectReferenceSystem  -- association [0..1]
;