C_Sadl_Voc_Businesspartner

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 C_Sadl_Voc_Businesspartner.
-- 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: CSADL_VOC_BP

CREATE VIEW C_Sadl_Voc_Businesspartner AS
SELECT
  bp.BusinessPartnerKey AS BusinessPartnerKey,
  bp.BusinessPartnerRole AS BusinessPartnerRole,
  bp.EmailAddress AS EmailAddress,
  bp.PhoneNumber AS PhoneNumber,
  bp.FaxNumber AS FaxNumber,
  bp.WebAddress AS WebAddress,
  bp.AddressGuid AS AddressGuid,
  bp.BusinessPartnerId AS BusinessPartnerId,
  bp.CompanyName AS CompanyName,
  bp.LegalForm AS LegalForm,
  bp.CreatedBy AS CreatedBy,
  bp.CreatedAt AS CreatedAt,
  bp.ChangedBy AS ChangedBy,
  bp.ChangedAt AS ChangedAt,
  bp.CurrencyCode AS CurrencyCode,
  'CurrText' AS CurrencyText,
  1 AS BPScoreA,
  1 AS BPScoreB,
  1 AS BPAccumalativeScore,
  1 AS duration_sec,
  1 AS duration_min,
  1 AS duration_day,
  _BusinessPartnerAddress.Country AS Country,
  _BusinessPartnerAddress.City AS City,
  _BusinessPartnerAddress.PostalCode AS PostalCode,
  _BusinessPartnerAddress.Street AS Street
FROM I_Sadl_Voc_Businesspartner AS bp
;