P_Bpcontacts_Data

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_Data.
-- 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_DATA

CREATE VIEW P_Bpcontacts_Data AS
SELECT
  but000.partner AS BusinessPartner,
  but000.title AS FormOfAddress,
  but000.name_first AS FirstName,
  but000.name_last AS LastName,
  but000.persnumber AS PersonNumber,
  but000.augrp AS AuthorizationGroup,
  but000.xpcpt AS IsBusinessPurposeCompleted,
  but000.birthdt AS BirthDate
FROM but000
LEFT OUTER JOIN I_PersonFormOfAddrT AS _PersonFormOfAddressText ON FormOfAddress = _PersonFormOfAddressText.FormOfAddress  -- association [1..*]
LEFT OUTER JOIN but100 AS _Role ON BusinessPartner = _Role.partner  -- association [1..1]
LEFT OUTER JOIN tb037t AS _AuthorizationGroupText ON AuthorizationGroup = _AuthorizationGroupText.augrp  -- association [1..1]
;