I_BPRelshpCntctPersnAddressTP

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_BPRelshpCntctPersnAddressTP.
-- 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_BPRelshpCntctPersnAddressTP AS
SELECT
  P_BPContactToAddress.BusinessPartnerCompany AS BusinessPartner1,
  P_BPContactToAddress.BusinessPartnerPerson AS BusinessPartner2,
  cast( P_BPContactToAddress.ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  P_BPContactToAddress.RelationshipCategory AS RelationshipCategory,
  P_BPContactToAddress.AddressID AS AddressID,
  P_BPContactToAddress.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  P_BPContactToAddress.AddressID AS AddressIDForEdit,
  P_BPContactToAddress.RelationshipNumber AS RelationshipNumber,
  P_BPContactToAddress.IsDefaultAddress AS IsDefaultAddress,
  P_BPContactToAddress.ContactRelationshipFunction AS ContactRelationshipFunction,
  P_BPContactToAddress.ContactRelationshipDepartment AS ContactRelationshipDepartment,
  P_BPContactToAddress.Floor AS Floor,
  P_BPContactToAddress.Building AS Building,
  P_BPContactToAddress.RoomNumber AS RoomNumber,
  P_BPContactToAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  P_BPContactToAddress.CorrespondenceShortName AS CorrespondenceShortName,
  P_BPContactToAddress.InhouseMail AS InhouseMail,
  concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.HouseNumber, concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.StreetName, concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.CityName, concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.PostalCode,P_BPContactToAddress._BPCompanyPostalAddress.Country,1),1),1),1) as FormattedAddress AS Country1111asFormattedAddress,
  P_BPContactToAddress._BPCompanyPostalAddress.FormOfAddress AS FormOfAddress,
  P_BPContactToAddress._BPCompanyPostalAddress.FullName AS FullName,
  P_BPContactToAddress._BPCompanyPostalAddress.HouseNumber AS HouseNumber,
  P_BPContactToAddress._BPCompanyPostalAddress.StreetName AS StreetName,
  P_BPContactToAddress._BPCompanyPostalAddress.CityName AS CityName,
  P_BPContactToAddress._BPCompanyPostalAddress.PostalCode AS PostalCode,
  P_BPContactToAddress._BPCompanyPostalAddress.Region AS Region,
  P_BPContactToAddress._BPCompanyPostalAddress.Country AS Country,
  P_BPContactToAddress._BPCompanyPostalAddress.AddressTimeZone AS AddressTimeZone,
  P_BPContactToAddress.RelValidityEndDate AS RelValidityEndDate,
  P_BPContactToAddress._BusinessPartnerCompany AS _BusinessPartner1,
  P_BPContactToAddress._BusinessPartnerPerson AS _BusinessPartner2
FROM P_BPContactToAddress
LEFT OUTER JOIN I_BPRelshpContactPersonTP AS _BPRelshpContactPerson ON BusinessPartner1 = _BPRelshpContactPerson.BusinessPartner1 AND BusinessPartner2 = _BPRelshpContactPerson.BusinessPartner2 AND ValidityEndDate = _BPRelshpContactPerson.ValidityEndDate AND RelationshipCategory = _BPRelshpContactPerson.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _BPRelshpContactPerson.BPRelshpCatIsInFwdDirection  -- association [1]
LEFT OUTER JOIN I_BPRelshpCntctPersnTelNmbrTP AS _BPRelStandardTelNumber ON BusinessPartner1 = _BPRelStandardTelNumber.BusinessPartner1 AND BusinessPartner2 = _BPRelStandardTelNumber.BusinessPartner2 AND ValidityEndDate = _BPRelStandardTelNumber.ValidityEndDate AND RelationshipCategory = _BPRelStandardTelNumber.RelationshipCategory AND AddressID = _BPRelStandardTelNumber.AddressID AND BPRelshpCatIsInFwdDirection = _BPRelStandardTelNumber.BPRelshpCatIsInFwdDirection AND _BPRelStandardTelNumber.PhoneNumberType = '1' AND _BPRelStandardTelNumber.IsDefaultPhoneNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpCntctPersnMblNmbrTP AS _BPRelStandardMblNumber ON BusinessPartner1 = _BPRelStandardMblNumber.BusinessPartner1 AND BusinessPartner2 = _BPRelStandardMblNumber.BusinessPartner2 AND ValidityEndDate = _BPRelStandardMblNumber.ValidityEndDate AND RelationshipCategory = _BPRelStandardMblNumber.RelationshipCategory AND AddressID = _BPRelStandardMblNumber.AddressID AND BPRelshpCatIsInFwdDirection = _BPRelStandardMblNumber.BPRelshpCatIsInFwdDirection AND _BPRelStandardMblNumber.PhoneNumberType = '3' AND _BPRelStandardMblNumber.IsDefaultPhoneNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpCntctPersnFaxNmbrTP AS _BPRelStandardFaxNmbr ON BusinessPartner1 = _BPRelStandardFaxNmbr.BusinessPartner1 AND BusinessPartner2 = _BPRelStandardFaxNmbr.BusinessPartner2 AND ValidityEndDate = _BPRelStandardFaxNmbr.ValidityEndDate AND RelationshipCategory = _BPRelStandardFaxNmbr.RelationshipCategory AND AddressID = _BPRelStandardFaxNmbr.AddressID AND BPRelshpCatIsInFwdDirection = _BPRelStandardFaxNmbr.BPRelshpCatIsInFwdDirection AND _BPRelStandardFaxNmbr.IsDefaultFaxNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpCntctPersnEmlAddrTP AS _BPRelStandardEmlAddr ON BusinessPartner1 = _BPRelStandardEmlAddr.BusinessPartner1 AND BusinessPartner2 = _BPRelStandardEmlAddr.BusinessPartner2 AND ValidityEndDate = _BPRelStandardEmlAddr.ValidityEndDate AND RelationshipCategory = _BPRelStandardEmlAddr.RelationshipCategory AND AddressID = _BPRelStandardEmlAddr.AddressID AND BPRelshpCatIsInFwdDirection = _BPRelStandardEmlAddr.BPRelshpCatIsInFwdDirection AND _BPRelStandardEmlAddr.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpCntctPersnAddrVersTP AS _BPRelshpCntctPersnAddrVers ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPRelshpCntctPersnEmlAddrTP AS _BPRelshpCntctPersnEmlAddr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPRelshpCntctPersnTelNmbrTP AS _BPRelshpCntctPersnTelNmbr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPRelshpCntctPersnMblNmbrTP AS _BPRelshpCntctPersnMblNmbr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPRelshpCntctPersnFaxNmbrTP AS _BPRelshpCntctPersnFaxNmbr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPRelshpCntctPersnWbsteURLTP AS _BPRelshpCntctPersnWbsteURL ON /* condition not available in parsed metadata */  -- association [0..*]
;