I_RealEstatePrtPartner

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_RealEstatePrtPartner.
-- 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_RealEstatePrtPartner AS
SELECT
  prt_bp_guid AS RealEstatePrtPartnerUUID,
  obj_prt_guid AS RealEstatePrtUUID,
  part_id AS RealEstatePrtID,
  cast( bupa_id as cms_dte_bpid_vdm preserving type ) AS RealEstatePrtPartnerID,
  bpf AS RealEstatePrtPartnerFunction,
  bupa_share_nr AS RealEstatePrtBPShareNumerator,
  bupa_share_dr AS RealEstatePrtBPShareDnmntr,
  bp_valid_from AS RealEstatePrtBPValidFromDate,
  bp_valid_to AS RealEstatePrtBPValidToDate,
  created_date AS RealEstatePrtEnteredDate
FROM cms_re_prt_bp
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_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_RealEstatePrtLandRegister AS _RealEstatePrtLandRegister ON RealEstatePrtUUID = _RealEstatePrtLandRegister.RealEstatePrtUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralPartnerFunction AS _RealEstatePrtPartnerFunction ON RealEstatePrtPartnerFunction = _RealEstatePrtPartnerFunction.CollateralPartnerFunction  -- association [0..1]
;