P_Cpbupafaxall

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_Cpbupafaxall.
-- 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: PCPBUPAFAXA

CREATE VIEW P_Cpbupafaxall AS
SELECT
  _BPRelationship.BusinessPartnerCompany AS BusinessPartner,
  _BPRelationship.BusinessPartnerPerson AS ContactPerson,
  _BPAddress.AddressNumber AS AddressNumber,
  cast( '0' as abap.char(1) ) AS BusinessPartnerCategory,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _AddressFax.FaxNumber AS FaxNumber,
  _AddressFax.FaxCountry AS FaxCountry,
  _AddressFax.FaxNumberExtension AS FaxNumberExtension,
  _AddressFax.InternationalFaxNumber AS InternationalFaxNumber,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _BPRelationship.RelationshipCategory as RelationshipCategory AS BusinessPartnerasBusinessPartner,
  cast( ' ' as bu_reltyp preserving type ) AS RelationshipCategory
FROM I_BPContactToFuncAndDept AS _BPRelationship
INNER JOIN I_BusinessPartner AS _BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartnerAddress AS _BPAddress ON /* join condition not captured in parsed metadata */
INNER JOIN I_Address AS _Addr ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_BusinessPartner
;