I_BusPartRelationshipTP

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_BusPartRelationshipTP.
-- 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_BusPartRelationshipTP AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  cast( ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  RelationshipCategory,
  BPRelshpCatIsInFwdDirection,
  BusinessPartner1 AS BusinessPartner1ForEdit,
  BusinessPartner2 AS BusinessPartner2ForEdit,
  RelationshipCategory AS RelationshipCategoryForEdit,
  RelationshipNumber,
  ValidityStartDate,
  ValidityEndDate AS ValidityEndDateForEdit,
  BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirForEdit,
  IsStandardRelationship,
  BPRelationshipType,
  BusPartRelshpIsRoleDefinition,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerUUID,
  _BusinessPartner1.BusinessPartnerUUID AS BusinessPartnerUUID1,
  _BusinessPartner2.BusinessPartnerUUID AS BusinessPartnerUUID2
FROM I_BPRelationshipUnion
LEFT OUTER JOIN I_BPRelshpCntctPersnAddressTP AS _BusPartRelStdAddress ON BusinessPartner1 = _BusPartRelStdAddress.BusinessPartner1 AND BusinessPartner2 = _BusPartRelStdAddress.BusinessPartner2 AND ValidityEndDate = _BusPartRelStdAddress.ValidityEndDate AND RelationshipCategory = _BusPartRelStdAddress.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _BusPartRelStdAddress.BPRelshpCatIsInFwdDirection AND _BusPartRelStdAddress.IsDefaultAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BusPartRelshpCategoryDesc AS _RelationshipCategoryText ON RelationshipCategory = _RelationshipCategoryText.RelationshipCategory AND BusPartRelshpIsRoleDefinition = _RelationshipCategoryText.BusPartRelshpIsRoleDefinition AND BPRelshpCatIsInFwdDirection = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpCompanyInterestTP AS _BPRelshpCompanyInterest ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpContactPersonTP AS _BPRelshpContactPerson ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpCntctPersnAddressTP AS _BPRelshpCntctPersnAddress ON /* condition not available in parsed metadata */  -- association [0..*]
;