I_BPAdditionalSupplierTP

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 I_BPAdditionalSupplierTP.
-- 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: IBPADDSUPPTP

CREATE VIEW I_BPAdditionalSupplierTP AS
SELECT
  BPAdditionalSupplier.BusinessPartner AS BusinessPartner,
  Supplier.Supplier AS Supplier,
  BPAdditionalSupplier.BusinessPartner AS BusinessPartnerForEdit,
  Supplier.Supplier AS SupplierForEdit,
  BPAdditionalSupplier.BPAssignmentID AS BPAssignmentID,
  BPAdditionalSupplier.BPAssignmentCategory AS BPAssignmentCategory,
  BPAdditionalSupplier.BPAssignmentReasonID AS BPAssignmentReasonID,
  BPAdditionalSupplier.IsStandardAssignment AS IsStandardAssignment,
  BPAdditionalSupplier.AddressNumber AS AddressNumber,
  Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  Supplier.SupplierCorporateGroup AS SupplierCorporateGroup,
  Supplier.FormOfAddress AS FormOfAddress,
  Supplier.InternationalLocationNumber1 AS InternationalLocationNumber1,
  Supplier.InternationalLocationNumber2 AS InternationalLocationNumber2,
  Supplier.ReferenceAccountGroup AS ReferenceAccountGroup,
  Supplier.AlternativePayeeAccountNumber AS SupplierAlternativePayee,
  Supplier.Customer AS Customer,
  Supplier.PostingIsBlocked AS PostingIsBlocked,
  Supplier.PurchasingIsBlocked AS PurchasingIsBlocked,
  Supplier.PaymentIsBlockedForSupplier AS PaymentIsBlockedForSupplier,
  Supplier.VATLiability AS VATLiability,
  Supplier.BR_TaxIsSplit AS BR_TaxIsSplit,
  Supplier.AuthorizationGroup AS AuthorizationGroup,
  Supplier.SupplierName AS SupplierName,
  Supplier.BPSupplierName AS BPSupplierName,
  Supplier.DeletionIndicator AS DeletionIndicator,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS DraftKey,
  Supplier._AddressDefaultRepresentation.PostalCode AS PostalCode,
  Supplier._AddressDefaultRepresentation.StreetName AS StreetName,
  Supplier._AddressDefaultRepresentation.HouseNumber AS HouseNumber,
  Supplier._AddressDefaultRepresentation.CityName AS CityName,
  Supplier._AddressDefaultRepresentation.Country AS Country,
  Supplier._AddressDefaultRepresentation.Region AS Region,
  Supplier._AddressDefaultRepresentation.POBoxPostalCode AS POBoxPostalCode,
  Supplier._AddressDefaultRepresentation.POBox AS POBox,
  Supplier._AddressDefaultRepresentation.CorrespondenceLanguage AS CorrespondenceLanguage,
  Supplier._AddressDefaultRepresentation.PrfrdCommMediumType AS PrfrdCommMediumType,
  Supplier.DataControllerSet AS DataControllerSet,
  Supplier.DataController1 AS DataController1,
  Supplier.DataController2 AS DataController2,
  Supplier.DataController3 AS DataController3,
  Supplier.DataController4 AS DataController4,
  Supplier.DataController5 AS DataController5,
  Supplier.DataController6 AS DataController6,
  Supplier.DataController7 AS DataController7,
  Supplier.DataController8 AS DataController8,
  Supplier.DataController9 AS DataController9,
  Supplier.DataController10 AS DataController10
FROM I_Supplier AS Supplier
INNER JOIN I_BPMultipleAssignment AS BPAdditionalSupplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPAddlSuplrCompanyCodeTP AS _BPAddlSuplrCompanyCode ON BusinessPartner = _BPAddlSuplrCompanyCode.BusinessPartner AND Supplier = _BPAddlSuplrCompanyCode.Supplier  -- association [1..*]
LEFT OUTER JOIN I_BPAddlSuplrPurgOrgTP AS _BPAddlSuplrPurgOrg ON BusinessPartner = _BPAddlSuplrPurgOrg.BusinessPartner AND Supplier = _BPAddlSuplrPurgOrg.Supplier  -- association [1..*]
LEFT OUTER JOIN I_BPAddlSuplrTelNmbrTP AS _BPAddlSuplrTelNmbr ON BusinessPartner = _BPAddlSuplrTelNmbr.BusinessPartner AND Supplier = _BPAddlSuplrTelNmbr.Supplier  -- association [1..*]
LEFT OUTER JOIN I_BPAddlSuplrEmailAddressTP AS _BPAddlSuplrEmailAddress ON BusinessPartner = _BPAddlSuplrEmailAddress.BusinessPartner AND Supplier = _BPAddlSuplrEmailAddress.Supplier  -- association [1..*]
LEFT OUTER JOIN I_BPAddlSuplrMblPhNumberTP AS _BPAddlSuplrMblPhNumber ON BusinessPartner = _BPAddlSuplrMblPhNumber.BusinessPartner AND Supplier = _BPAddlSuplrMblPhNumber.Supplier  -- association [1..*]
LEFT OUTER JOIN I_BPAddlSuplrWebsiteURLTP AS _BPAddlSuplrWebsiteURL ON BusinessPartner = _BPAddlSuplrWebsiteURL.BusinessPartner AND Supplier = _BPAddlSuplrWebsiteURL.Supplier  -- association [1..*]
LEFT OUTER JOIN I_BPAddlSuplrFaxNumberTP AS _BPAddlSuplrFaxNumber ON BusinessPartner = _BPAddlSuplrFaxNumber.BusinessPartner AND Supplier = _BPAddlSuplrFaxNumber.Supplier  -- association [1..*]
;