P_Bpcontacts_Address

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 P_Bpcontacts_Address.
-- 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: P_MD_BPC_ADR

CREATE VIEW P_Bpcontacts_Address AS
SELECT
  but052.relnr AS Relationship,
  but052.partner2 AS BusinessPartner,
  but052.addrnumber AS AddressID,
  but000.persnumber AS Person,
  but052.xdfadr AS IsDefaultAddress,
  _AddressDetails.building AS Building,
  _AddressDetails.floor AS Floor,
  _AddressDetails.roomnumber AS RoomNumber,
  _Telephone.InternationalPhoneNumber AS InternationalPhoneNumber,
  _Telephone.PhoneCountry AS PhoneCountry,
  _Telephone.PhoneNumber AS PhoneNumber,
  _Telephone.PhoneNumberExtension AS PhoneNumberExtension,
  _MobilePhone.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  _MobilePhone.MobilePhoneCountry AS MobilePhoneCountry,
  _MobilePhone.MobilePhoneNumber AS MobilePhoneNumber,
  _MobilePhone.MobilePhoneExtension AS MobilePhoneExtension,
  _Fax.faxnr_long AS InternationalFaxNumber,
  _Fax.country AS FaxCountry,
  _Fax.fax_number AS FaxNumber,
  _Fax.fax_extens AS FaxNumberExtension,
  _Email.smtp_addr AS EmailAddress
FROM but052
INNER JOIN but000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adcp AS _AddressDetails ON AddressID = _AddressDetails.addrnumber AND Person = _AddressDetails.persnumber  -- association [1..1]
LEFT OUTER JOIN P_Bpcontacts_Telephone AS _Telephone ON AddressID = _Telephone.AddressID AND Person = _Telephone.Person  -- association [1..1]
LEFT OUTER JOIN P_Bpcontacts_Mobilephone AS _MobilePhone ON AddressID = _MobilePhone.AddressID AND Person = _MobilePhone.Person  -- association [1..1]
LEFT OUTER JOIN adr3 AS _Fax ON AddressID = _Fax.addrnumber AND Person = _Fax.persnumber  -- association [1..1]
LEFT OUTER JOIN adr6 AS _Email ON AddressID = _Email.addrnumber AND Person = _Email.persnumber  -- association [1..1]
;