R_SuplrListBusPartnerDetails

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 R_SuplrListBusPartnerDetails.
-- 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: RSUPLRLBPDET

CREATE VIEW R_SuplrListBusPartnerDetails AS
SELECT
  Supplier,
  _SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _SupplierToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  SupplierName,
  _SupplierToBusinessPartner._BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  AddressID,
  _Supplier.Country AS Country,
  _Supplier.Region AS Region,
  _SupplierToBusinessPartner._BusinessPartner.FirstName AS FirstName,
  _SupplierToBusinessPartner._BusinessPartner.LastName AS LastName,
  OrganizationBPName1,
  OrganizationBPName2,
  _SupplierToBusinessPartner._BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  _SupplierToBusinessPartner._BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  _SuplrListSuplrCountryGroup.SupplierCountryGroup AS SupplierCountryGroup,
  AuthorizationGroup,
  SupplierAccountGroup
FROM I_Supplier AS _Supplier
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SupplierToBusinessPartner AS _SupplierToBusinessPartner ON Supplier = _SupplierToBusinessPartner.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _Address ON AddressID = _Address.AddressID AND _Address.AddressPersonID = '' AND _Address.AddressRepresentationCode = ''  -- association [1..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON Region = _RegionText.Region AND Country = _RegionText.Country AND _RegionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SuplrListSuplrCountryGroup AS _SuplrListSuplrCountryGroup ON Country = _SuplrListSuplrCountryGroup.Country  -- association [0..1]
LEFT OUTER JOIN I_SupplierAccountGroupText AS _AccountGroupText ON SupplierAccountGroup = _AccountGroupText.SupplierAccountGroup AND _AccountGroupText.Language = $session.system_language  -- association [0..1]
;