I_REContrPartnerAssgmt

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_REContrPartnerAssgmt.
-- 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.
-- SQL view name: IREPARTNERASS

CREATE VIEW I_REContrPartnerAssgmt AS
SELECT
  objrelguid AS REPartnerRelationUUID,
  intreno AS InternalRealEstateNumber,
  partner AS BusinessPartner,
  role AS BusinessPartnerRole,
  subrole AS REPartnerRoleType,
  addrtype AS AddressType,
  cast ( validfrom as rebdvdmvalidfrom preserving type ) AS ValidityStartDate,
  cast ( validto as rebdvdmvalidto preserving type ) AS ValidityEndDate,
  appl AS REPartnerApplicationCategory,
  bruteil AS REFractionalPrptyShrRatio,
  bmiteig AS REOwnershipShrRatio,
  panteil AS RECoOwnershipShrRatio,
  rfakt AS REFractionalShrCnvrsnRatio,
  vkont AS ContractAccount
FROM vibpobjrel AS _REPartnerAssgmt
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerRole AS _BusinessPartnerRole ON BusinessPartnerRole = _BusinessPartnerRole.BusinessPartnerRole  -- association [0..1]
LEFT OUTER JOIN I_REPartnerRoleType AS _REPartnerRoleType ON BusinessPartnerRole = _REPartnerRoleType.BusinessPartnerRole AND REPartnerRoleType = _REPartnerRoleType.REPartnerRoleType  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerAddressType AS _BusinessPartnerAddressType ON AddressType = _BusinessPartnerAddressType.AddressType  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _CAHeader ON ContractAccount = _CAHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [0..1]
;