I_RealEstatePrtLandRegister

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_RealEstatePrtLandRegister.
-- 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_RealEstatePrtLandRegister AS
SELECT
  prt_lr_guid AS RealEstatePrtLandRegisterUUID,
  obj_prt_guid AS RealEstatePrtUUID,
  part_id AS RealEstatePrtID,
  lr_id AS RealEstatePrtLandRegLinkUUID
FROM cms_re_prt_lr
LEFT OUTER JOIN I_RealEstateObjectPrt AS _RealEstateObjectPrt ON RealEstatePrtUUID = _RealEstateObjectPrt.RealEstatePrtUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstateObjPrtMstrData AS _RealEstateObjPrtMstrData ON RealEstatePrtUUID = _RealEstateObjPrtMstrData.RealEstatePrtUUID  -- association [0..1]
LEFT OUTER JOIN I_RealEstatePrtAccessory AS _RealEstatePrtAccessory ON RealEstatePrtUUID = _RealEstatePrtAccessory.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtAccsryMstrData AS _RealEstatePrtAccsryMstrData ON RealEstatePrtUUID = _RealEstatePrtAccsryMstrData.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtPartner AS _RealEstatePrtPartner ON RealEstatePrtUUID = _RealEstatePrtPartner.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtCost AS _RealEstatePrtCost ON RealEstatePrtUUID = _RealEstatePrtCost.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEstatePrtValue AS _RealEstatePrtValue ON RealEstatePrtUUID = _RealEstatePrtValue.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_RealEsttePrtLandRegPrptyList AS _RealEsttePrtLandRegPrptyList ON RealEstatePrtLandRegLinkUUID = _RealEsttePrtLandRegPrptyList.REPrtLandRegPrptyListUUID  -- association [0..1]
;