I_ColltrlRELandRegister

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_ColltrlRELandRegister.
-- 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_ColltrlRELandRegister AS
SELECT
  prt_lr_guid AS ColltrlREPrtLandRegisterUUID,
  obj_prt_guid AS CollateralRealEstatePartUUID,
  part_id AS CollateralRealEstatePartID,
  lr_id AS ColltrlRELandRegisterLinkUUID,
  created_by AS CollateralRealEstateEnteredBy,
  created_date AS ColltrlRealEstateEnteredDate,
  created_time AS ColltrlRealEstateEnteredTime,
  entry_src AS ColltrlRealEstateEnteredSource,
  last_chg_by AS ColltrlRealEstateLastChangedBy,
  last_chg_date AS ColltrlRELastChangedDate,
  last_chg_time AS ColltrlRELastChangedTime,
  processing_src AS ColltrlRELastChangedSource
FROM cms_re_prt_lr
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON CollateralRealEstatePartUUID = _CollateralRealEstatePart.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartMaster AS _ColltrlREPartMaster ON CollateralRealEstatePartUUID = _ColltrlREPartMaster.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartAccessory AS _ColltrlREPartAccessory ON CollateralRealEstatePartUUID = _ColltrlREPartAccessory.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartAccessoryMaster AS _ColltrlREPartAccessoryMaster ON CollateralRealEstatePartUUID = _ColltrlREPartAccessoryMaster.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartPartner AS _ColltrlREPartPartner ON CollateralRealEstatePartUUID = _ColltrlREPartPartner.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstatePartCost AS _CollateralRealEstatePartCost ON CollateralRealEstatePartUUID = _CollateralRealEstatePartCost.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartValue AS _ColltrlREPartValue ON CollateralRealEstatePartUUID = _ColltrlREPartValue.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlRELandRegPropertyList AS _ColltrlRELandRegPropertyList ON ColltrlRELandRegisterLinkUUID = _ColltrlRELandRegPropertyList.ColltrlLandRegPropertyListUUID  -- association [0..1]
;