I_BPRelshpCntctPersnAddrVersTP

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_BPRelshpCntctPersnAddrVersTP.
-- 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: IBPRELCPADVERTP

CREATE VIEW I_BPRelshpCntctPersnAddrVersTP 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,
  AddressDetails.nation AS AddressRepresentationCode,
  P_BPContactToAddress.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  AddressDetails.nation AS AddrRepCodeForEdit,
  P_BPContactToAddress.RelationshipNumber AS RelationshipNumber,
  PersonDetails.title AS FormOfAddress,
  PersonDetails.name_first AS FirstName,
  PersonDetails.name_last AS LastName,
  PersonDetails.name2 AS BirthName,
  PersonDetails.namemiddle AS MiddleName,
  PersonDetails.name_last2 AS AdditionalFamilyName,
  PersonDetails.name_text AS FullName,
  PersonDetails.converted AS PersonFullNameMaintStatus,
  PersonDetails.title_aca1 AS AcademicTitle,
  PersonDetails.title_aca2 AS AcademicTitle2,
  PersonDetails.prefix1 AS LastNamePrefix,
  PersonDetails.prefix2 AS LastNameSecondPrefix,
  PersonDetails.title_sppl AS NameSupplement,
  PersonDetails.nickname AS BusinessPartnerNicknameLabel,
  PersonDetails.initials AS Initials,
  PersonDetails.nameformat AS NameFormat,
  PersonDetails.namcountry AS NameCountry,
  PersonDetails.profession AS PersonProfessionName,
  PersonDetails.sex AS GenderCode,
  PersonDetails.sort1 AS AddressSearchText1,
  PersonDetails.sort2 AS AddressSearchText2,
  AddressDetails.function AS ContactRelationshipFunction,
  AddressDetails.department AS ContactRelationshipDepartment,
  AddressDetails.floor AS Floor,
  AddressDetails.building AS Building,
  AddressDetails.roomnumber AS RoomNumber,
  AddressDetails.id_code AS CorrespondenceShortName,
  AddressDetails.ih_mail AS InhouseMail,
  P_BPContactToAddress._BusinessPartnerCompany AS _BusinessPartner1,
  P_BPContactToAddress._BusinessPartnerPerson AS _BusinessPartner2
FROM P_BPContactToAddress
INNER JOIN adcp AS AddressDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS PersonDetails 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]
LEFT OUTER JOIN I_AddressRepresentationText AS _AddressRepresentationText ON AddressRepresentationCode = _AddressRepresentationText.AddressRepresentationCode  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerFormOfAddrTxt AS _BusinessPartnerFormOfAddrTxt ON FormOfAddress = _BusinessPartnerFormOfAddrTxt.FormOfAddress  -- association [0..*]
;