P_BR_RptgOneTimePartner

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_BR_RptgOneTimePartner.
-- 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: PBRSPED1TMEPART

CREATE VIEW P_BR_RptgOneTimePartner AS
SELECT
  concat(doc.BR_NFPartnerType,doc.BR_NFPartner) AS BusinessPartner,
  concat_with_space(otp.BusinessPartnerName1,otp.BusinessPartnerName2,1) AS BusinessPartnerName,
  bcb.BR_BCBCountryCode AS BR_BCBCountryCode,
  otp.BR_PartnerCNPJ AS BR_PartnerCNPJ,
  otp.BR_PartnerCPF AS BR_PartnerCPF,
  otp.BR_PartnerStateTaxNumberST AS BR_PartnerStateTaxNumberST,
  right(otp.BusinessPartnerTaxJurisdiction,7) AS TaxJurisdiction,
  doc.BR_SUFRAMACode AS BR_SUFRAMACode,
  otp.BusinessPartnerHouseNumber AS HouseNumber,
  otp.BPHsNmbrSuplmntTxt AS HouseNumberSupplementText,
  otp.BusinessPartnerDistrict AS District
FROM I_BR_OneTimePartner AS otp
INNER JOIN I_BR_NFDocument AS doc ON /* join condition not captured in parsed metadata */
INNER JOIN I_BR_BCBCountryCode AS bcb ON /* join condition not captured in parsed metadata */
;