I_BPRelshpCntctPersnWbsteURLTP

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_BPRelshpCntctPersnWbsteURLTP.
-- 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: IBPRELCPWEBTP

CREATE VIEW I_BPRelshpCntctPersnWbsteURLTP AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2,
  cast( ContactPerson.ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  ContactPerson.RelationshipCategory AS RelationshipCategory,
  ContactPerson.AddressID AS AddressID,
  Website.CommMediumSequenceNumber AS OrdinalNumber,
  ContactPerson.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  Website.CommMediumSequenceNumber AS OrdinalNumberForEdit,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  Website.URLIsCurrentDefault AS IsDefaultURLAddress,
  cast ('' as ad_flnouse ) AS CommNumberIsNotUsed,
  Website._AddressCommunicationRemark.CommunicationRemarkText AS AddressCommunicationRemarkText,
  cast ('' as ad_uriscr) AS UniformResourceIdentifier,
  cast('0' as abap.int4) AS URLFieldLength,
  Website.UniformResourceIdentifier AS WebsiteURL,
  ContactPerson._BusinessPartnerCompany AS _BusinessPartner1,
  ContactPerson._BusinessPartnerPerson AS _BusinessPartner2
FROM P_BPContactToAddress AS ContactPerson
INNER JOIN I_AddressURI AS Website ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusPartRelationshipTP AS _BusPartRelationship ON BusinessPartner1 = _BusPartRelationship.BusinessPartner1 AND BusinessPartner2 = _BusPartRelationship.BusinessPartner2 AND ValidityEndDate = _BusPartRelationship.ValidityEndDate AND RelationshipCategory = _BusPartRelationship.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _BusPartRelationship.BPRelshpCatIsInFwdDirection  -- association [1]
LEFT OUTER JOIN I_BPRelshpContactPersonTP AS _BPRelshpContactPerson ON BusinessPartner1 = _BPRelshpContactPerson.BusinessPartner1 AND BusinessPartner2 = _BPRelshpContactPerson.BusinessPartner2 AND ValidityEndDate = _BPRelshpContactPerson.ValidityEndDate AND RelationshipCategory = _BPRelshpContactPerson.RelationshipCategory  -- association [0..1]
;