C_BPAdditionalSupplier

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_BPAdditionalSupplier.
-- 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: CBPADDSUPP

CREATE VIEW C_BPAdditionalSupplier AS
SELECT
  BPAdditionalSupplier.BusinessPartner AS BusinessPartner,
  BPAdditionalSupplier.Supplier AS Supplier,
  BPAdditionalSupplier.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BPAdditionalSupplier.SupplierForEdit AS SupplierForEdit,
  BPAdditionalSupplier.BPAssignmentReasonID AS BPAssignmentReasonID,
  BPAdditionalSupplier.SupplierAccountGroup AS SupplierAccountGroup,
  BPAdditionalSupplier.InternationalLocationNumber1 AS InternationalLocationNumber1,
  BPAdditionalSupplier.InternationalLocationNumber2 AS InternationalLocationNumber2,
  BPAdditionalSupplier.VATLiability AS VATLiability,
  BPAdditionalSupplier.ReferenceAccountGroup AS ReferenceAccountGroup,
  BPAdditionalSupplier.SupplierAlternativePayee AS SupplierAlternativePayee,
  BPAdditionalSupplier.Customer AS Customer,
  BPAdditionalSupplier.PostingIsBlocked AS PostingIsBlocked,
  BPAdditionalSupplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  BPAdditionalSupplier.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  BPAdditionalSupplier.AuthorizationGroup AS AuthorizationGroup,
  BPAdditionalSupplier.SupplierName AS SupplierName,
  BPAdditionalSupplier.AddressNumber AS AddressNumber,
  BPAdditionalSupplier.DraftKey AS DraftKey,
  BPAdditionalSupplier.StreetName AS StreetName,
  BPAdditionalSupplier.HouseNumber AS HouseNumber,
  BPAdditionalSupplier.PostalCode AS PostalCode,
  BPAdditionalSupplier.CityName AS CityName,
  BPAdditionalSupplier.Country AS Country,
  BPAdditionalSupplier.Region AS Region,
  BPAdditionalSupplier.POBoxPostalCode AS POBoxPostalCode,
  BPAdditionalSupplier.POBox AS POBox,
  BPAdditionalSupplier.CorrespondenceLanguage AS CorrespondenceLanguage,
  BPAdditionalSupplier.PrfrdCommMediumType AS PrfrdCommMediumType,
  BPAdditionalSupplier.BR_TaxIsSplit AS BR_TaxIsSplit,
  BPAdditionalSupplier.DeletionIndicator AS DeletionIndicator
FROM I_BPAdditionalSupplierTP AS BPAdditionalSupplier
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAddlSuplrCompanyCode AS _BPAddlSuplrCompanyCode ON BusinessPartner = _BPAddlSuplrCompanyCode.BusinessPartner AND Supplier = _BPAddlSuplrCompanyCode.Supplier  -- association [1..*]
LEFT OUTER JOIN C_BPAddlSuplrPurgOrg AS _BPAddlSuplrPurgOrg ON BusinessPartner = _BPAddlSuplrPurgOrg.BusinessPartner AND Supplier = _BPAddlSuplrPurgOrg.Supplier  -- association [1..*]
LEFT OUTER JOIN C_BPAddlSuplrTelNmbr AS _BPAddlSuplrTelNmbr ON BusinessPartner = _BPAddlSuplrTelNmbr.BusinessPartner AND Supplier = _BPAddlSuplrTelNmbr.Supplier  -- association [1..*]
LEFT OUTER JOIN C_BPAddlSuplrMblPhNumber AS _BPAddlSuplrMblPhNumber ON BusinessPartner = _BPAddlSuplrMblPhNumber.BusinessPartner AND Supplier = _BPAddlSuplrMblPhNumber.Supplier  -- association [1..*]
LEFT OUTER JOIN C_BPAddlSuplrFaxNumber AS _BPAddlSuplrFaxNumber ON BusinessPartner = _BPAddlSuplrFaxNumber.BusinessPartner AND Supplier = _BPAddlSuplrFaxNumber.Supplier  -- association [1..*]
LEFT OUTER JOIN C_BPAddlSuplrWebsiteURL AS _BPAddlSuplrWebsiteURL ON BusinessPartner = _BPAddlSuplrWebsiteURL.BusinessPartner AND Supplier = _BPAddlSuplrWebsiteURL.Supplier  -- association [1..*]
LEFT OUTER JOIN C_BPAddlSuplrEmailAddress AS _BPAddlSuplrEmailAddress ON BusinessPartner = _BPAddlSuplrEmailAddress.BusinessPartner AND Supplier = _BPAddlSuplrEmailAddress.Supplier  -- association [1..*]
LEFT OUTER JOIN I_BusPartAuthorizationGroupTxt AS _AuthorizationGroupText ON AuthorizationGroup = _AuthorizationGroupText.AuthorizationGroup AND _AuthorizationGroupText.AuthorizationObject = 'SUPPL'  -- association [1..*]
LEFT OUTER JOIN I_SupplierAccountGroupText AS _ReferenceAccountGroupText ON ReferenceAccountGroup = _ReferenceAccountGroupText.SupplierAccountGroup  -- association [0..*]
LEFT OUTER JOIN C_CommMethTextVhTemp AS _CommMethText ON PrfrdCommMediumType = _CommMethText.CommunicationMediumType  -- association [0..*]
LEFT OUTER JOIN C_BPLanguageTextValueHelp AS _LanguageText ON CorrespondenceLanguage = _LanguageText.LanguageCode  -- association [0..*]
;