C_BPAddlSuplrCompanyCode

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_BPAddlSuplrCompanyCode.
-- 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: CBPADDSCC

CREATE VIEW C_BPAddlSuplrCompanyCode AS
SELECT
  BusinessPartnerSupplierCo.CompanyCode AS CompanyCode,
  BusinessPartnerSupplierCo.Supplier AS Supplier,
  BusinessPartnerSupplierCo.BusinessPartner AS BusinessPartner,
  BusinessPartnerSupplierCo.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerSupplierCo.SupplierForEdit AS SupplierForEdit,
  BusinessPartnerSupplierCo.CompanyCodeForEdit AS CompanyCodeForEdit,
  BusinessPartnerSupplierCo.AccountingClerk AS AccountingClerk,
  BusinessPartnerSupplierCo.ReconciliationAccount AS ReconciliationAccount,
  BusinessPartnerSupplierCo.CashPlanningGroup AS CashPlanningGroup,
  BusinessPartnerSupplierCo.SupplierIsBlockedForPosting AS SupplierIsBlockedForPosting,
  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.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.Currency AS Currency,
  BusinessPartnerSupplierCo.BillOfExchLmtAmtInCoCodeCrcy AS BillOfExchLmtAmtInCoCodeCrcy,
  BusinessPartnerSupplierCo.ItemIsToBePaidSeparately AS ItemIsToBePaidSeparately,
  BusinessPartnerSupplierCo.PaymentIsToBeSentByEDI AS PaymentIsToBeSentByEDI,
  BusinessPartnerSupplierCo.WithholdingTaxCountry AS WithholdingTaxCountry,
  BusinessPartnerSupplierCo.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerSupplierCo.Country AS Country,
  BusinessPartnerSupplierCo.CompanyCodeDunningIsByDunArea AS CompanyCodeDunningIsByDunArea,
  BusinessPartnerSupplierCo.InterestCalculationCode AS InterestCalculationCode,
  BusinessPartnerSupplierCo.InterestCalculationDate AS InterestCalculationDate,
  BusinessPartnerSupplierCo.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  BusinessPartnerSupplierCo.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  BusinessPartnerSupplierCo.MinorityGroup AS MinorityGroup,
  BusinessPartnerSupplierCo.CompanyCodeName AS CompanyCodeName
FROM I_BPAddlSuplrCompanyCodeTP AS BusinessPartnerSupplierCo
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAdditionalSupplier AS _BPAdditionalSupplier ON BusinessPartner = _BPAdditionalSupplier.BusinessPartner AND Supplier = _BPAdditionalSupplier.Supplier  -- association [1..1]
LEFT OUTER JOIN C_BPAddlSuplrWhldgTax AS _BPAddlSuplrWhldgTax ON BusinessPartner = _BPAddlSuplrWhldgTax.BusinessPartner AND Supplier = _BPAddlSuplrWhldgTax.Supplier AND CompanyCode = _BPAddlSuplrWhldgTax.CompanyCode  -- association [1..*]
LEFT OUTER JOIN C_BPAddlSuplrDunning AS _BPAddlSuplrDunning ON BusinessPartner = _BPAddlSuplrDunning.BusinessPartner AND Supplier = _BPAddlSuplrDunning.Supplier AND CompanyCode = _BPAddlSuplrDunning.CompanyCode  -- association [1..*]
LEFT OUTER JOIN I_SupplierCompanyCodeVH AS _CompanyCodeValueHelp ON CompanyCodeForEdit = _CompanyCodeValueHelp.CompanyCode AND Country = _CompanyCodeValueHelp.Country  -- association [0..1]
LEFT OUTER JOIN C_PaymentTermsVHTemp AS _PaytTrmsValueHelp ON PaymentTerms = _PaytTrmsValueHelp.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_ToleranceGroupVHTemp AS _ToleranceGroupValueHelp ON APARToleranceGroup = _ToleranceGroupValueHelp.APARToleranceGroup AND CompanyCodeForEdit = _ToleranceGroupValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaytBlkgRsnValueHelp ON PaymentBlockingReason = _PaytBlkgRsnValueHelp.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN C_AccountingClerkVHTemp AS _AcctgClerkValueHelp ON AccountingClerk = _AcctgClerkValueHelp.AccountingClerk AND CompanyCodeForEdit = _AcctgClerkValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_Paymentmethodvhtemp AS _PaymentMethodsValueHelp ON PaymentMethodsList = _PaymentMethodsValueHelp.PaymentMethod AND CompanyCodeForEdit = _PaymentMethodsValueHelp.CompanyCode AND Country = _PaymentMethodsValueHelp.Country  -- association [0..1]
LEFT OUTER JOIN C_Alternativepayeevhtemp AS _AlternatePayeeValueHelp ON AlternativePayee = _AlternatePayeeValueHelp.AlternativePayee AND CompanyCodeForEdit = _AlternatePayeeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroup AS _PlanningGrp ON CashPlanningGroup = _PlanningGrp.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN C_SortKeyVHTemp AS _SortKeyValueHelp ON LayoutSortingRule = _SortKeyValueHelp.AcctgDocItmDisplaySequenceRule  -- association [0..1]
LEFT OUTER JOIN C_ReconAccountVHTemp AS _RecnclnAcctValueHelp ON ReconciliationAccount = _RecnclnAcctValueHelp.ReconciliationAccount AND CompanyCodeForEdit = _RecnclnAcctValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HeadOfficeVH AS _HeadOfficeValueHelp ON SupplierHeadOffice = _HeadOfficeValueHelp.Supplier AND CompanyCodeForEdit = _HeadOfficeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_HouseBankSearchVHTemp AS _HouseBankValueHelp ON HouseBank = _HouseBankValueHelp.HouseBank AND CompanyCodeForEdit = _HouseBankValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_SortKeyTextVHtemp AS _SortKeyText ON LayoutSortingRule = _SortKeyText.AcctgDocItmDisplaySequenceRule  -- association [1..*]
LEFT OUTER JOIN C_PaymentTermsTextVHTemp AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN C_ToleranceGroupTextVHTemp AS _ToleranceGroupText ON _ToleranceGroupText.CompanyCode = CompanyCode AND _ToleranceGroupText.APARToleranceGroup = APARToleranceGroup  -- association [0..*]
LEFT OUTER JOIN I_InterestCalculationCodeText AS _InterestCalculationCodeText ON InterestCalculationCode = _InterestCalculationCodeText.InterestCalculationCode  -- association [0..*]
LEFT OUTER JOIN C_PaymentmethodTextVHTemp AS _PaymentMethodText ON PaymentMethodsList = _PaymentMethodText.PaymentMethod AND Country = _PaymentMethodText.Country  -- association [1..*]
LEFT OUTER JOIN C_WithholdingTaxCountryTextTmp AS _WithholdingTaxCountryText ON WithholdingTaxCountry = _WithholdingTaxCountryText.WithholdingTaxCountry AND Country = _WithholdingTaxCountryText.Country  -- association [0..*]
;