I_BPAddlSuplrCompanyCodeTP

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_BPAddlSuplrCompanyCodeTP.
-- 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: IBPADDSCCTP

CREATE VIEW I_BPAddlSuplrCompanyCodeTP AS
SELECT
  BPMultipleAssignment.BusinessPartner AS BusinessPartner,
  BusinessPartnerSupplierCo.Supplier AS Supplier,
  BusinessPartnerSupplierCo.CompanyCode AS CompanyCode,
  BusinessPartnerSupplierCo.CompanyCode AS CompanyCodeForEdit,
  BusinessPartnerSupplierCo.Supplier AS SupplierForEdit,
  BPMultipleAssignment.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerSupplierCo.SupplierIsBlockedForPosting AS SupplierIsBlockedForPosting,
  BusinessPartnerSupplierCo.AccountingClerk AS AccountingClerk,
  BusinessPartnerSupplierCo.SupplierClerk AS SupplierClerk,
  BusinessPartnerSupplierCo.AccountingClerkPhoneNumber AS AccountingClerkPhoneNumber,
  BusinessPartnerSupplierCo.AccountingClerkFaxNumber AS AccountingClerkFaxNumber,
  BusinessPartnerSupplierCo.AccountingClerkInternetAddress AS AccountingClerkInternetAddress,
  BusinessPartnerSupplierCo.SupplierClerkIDBySupplier AS SupplierClerkIDBySupplier,
  BusinessPartnerSupplierCo.IsToBeLocallyProcessed AS IsToBeLocallyProcessed,
  BusinessPartnerSupplierCo.SupplierAccountNote AS SupplierAccountNote,
  BusinessPartnerSupplierCo.PaymentTerms AS PaymentTerms,
  BusinessPartnerSupplierCo.APARToleranceGroup AS APARToleranceGroup,
  BusinessPartnerSupplierCo.CheckPaidDurationInDays AS CheckPaidDurationInDays,
  BusinessPartnerSupplierCo.IsDoubleInvoice AS IsDoubleInvoice,
  BusinessPartnerSupplierCo.CustomerSupplierClearingIsUsed AS CustomerSupplierClearingIsUsed,
  BusinessPartnerSupplierCo.ReconciliationAccount AS ReconciliationAccount,
  BusinessPartnerSupplierCo.SupplierHeadOffice AS SupplierHeadOffice,
  BusinessPartnerSupplierCo.LayoutSortingRule AS LayoutSortingRule,
  BusinessPartnerSupplierCo.SupplierCertificationDate AS SupplierCertificationDate,
  BusinessPartnerSupplierCo.PaymentMethodsList AS PaymentMethodsList,
  BusinessPartnerSupplierCo.PaymentBlockingReason AS PaymentBlockingReason,
  BusinessPartnerSupplierCo.AlternativePayee AS AlternativePayee,
  BusinessPartnerSupplierCo.HouseBank AS HouseBank,
  BusinessPartnerSupplierCo.BillOfExchLmtAmtInCoCodeCrcy AS BillOfExchLmtAmtInCoCodeCrcy,
  BusinessPartnerSupplierCo.ItemIsToBePaidSeparately AS ItemIsToBePaidSeparately,
  BusinessPartnerSupplierCo.PaymentIsToBeSentByEDI AS PaymentIsToBeSentByEDI,
  BusinessPartnerSupplierCo.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerSupplierCo.CashPlanningGroup AS CashPlanningGroup,
  BusinessPartnerSupplierCo.WithholdingTaxCountry AS WithholdingTaxCountry,
  BusinessPartnerSupplierCo.InterestCalculationCode AS InterestCalculationCode,
  BusinessPartnerSupplierCo.InterestCalculationDate AS InterestCalculationDate,
  BusinessPartnerSupplierCo.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  BusinessPartnerSupplierCo.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  BusinessPartnerSupplierCo.MinorityGroup AS MinorityGroup,
  _Country.Country AS Country,
  _Country.CompanyCodeName AS CompanyCodeName,
  _CompanyCode.Currency AS Currency,
  CompanyCodeDunningControl.xmabe AS CompanyCodeDunningIsByDunArea
FROM I_SupplierCompany AS BusinessPartnerSupplierCo
INNER JOIN I_BPMultipleAssignment AS BPMultipleAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t047 AS CompanyCodeDunningControl 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_BPAdditionalSupplierTP AS _BPAdditionalSupplier ON BusinessPartner = _BPAdditionalSupplier.BusinessPartner AND Supplier = _BPAdditionalSupplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_BPAddlSuplrWhldgTaxTP AS _BPAddlSuplrWhldgTax ON BusinessPartner = _BPAddlSuplrWhldgTax.BusinessPartner AND Supplier = _BPAddlSuplrWhldgTax.Supplier AND CompanyCode = _BPAddlSuplrWhldgTax.CompanyCode  -- association [1..*]
LEFT OUTER JOIN I_BPAddlSuplrDunningTP AS _BPAddlSuplrDunning ON BusinessPartner = _BPAddlSuplrDunning.BusinessPartner AND Supplier = _BPAddlSuplrDunning.Supplier AND CompanyCode = _BPAddlSuplrDunning.CompanyCode  -- association [1..*]
LEFT OUTER JOIN I_CompanyCode AS _Country ON CompanyCode = _Country.CompanyCode  -- association [1..1]
;