C_BPAddlCustCompanyCode

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_BPAddlCustCompanyCode.
-- 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: CBPADDCCC

CREATE VIEW C_BPAddlCustCompanyCode AS
SELECT
  BusinessPartnerCustomerCo.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustomerCo.Customer AS Customer,
  BusinessPartnerCustomerCo.CompanyCode AS CompanyCode,
  BusinessPartnerCustomerCo.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerCustomerCo.CustomerForEdit AS CustomerForEdit,
  BusinessPartnerCustomerCo.CompanyCodeForEdit AS CompanyCodeForEdit,
  BusinessPartnerCustomerCo.AccountingClerk AS AccountingClerk,
  BusinessPartnerCustomerCo.ReconciliationAccount AS ReconciliationAccount,
  BusinessPartnerCustomerCo.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  BusinessPartnerCustomerCo.PaymentBlockingReason AS PaymentBlockingReason,
  BusinessPartnerCustomerCo.UserAtCustomer AS UserAtCustomer,
  BusinessPartnerCustomerCo.AccountingClerkPhoneNumber AS AccountingClerkPhoneNumber,
  BusinessPartnerCustomerCo.AccountingClerkFaxNumber AS AccountingClerkFaxNumber,
  BusinessPartnerCustomerCo.AccountingClerkInternetAddress AS AccountingClerkInternetAddress,
  BusinessPartnerCustomerCo.AccountByCustomer AS AccountByCustomer,
  BusinessPartnerCustomerCo.IsToBeLocallyProcessed AS IsToBeLocallyProcessed,
  BusinessPartnerCustomerCo.CustomerAccountNote AS CustomerAccountNote,
  BusinessPartnerCustomerCo.CollectiveInvoiceVariant AS CollectiveInvoiceVariant,
  BusinessPartnerCustomerCo.PaymentTerms AS PaymentTerms,
  BusinessPartnerCustomerCo.APARToleranceGroup AS APARToleranceGroup,
  BusinessPartnerCustomerCo.CustomerSupplierClearingIsUsed AS CustomerSupplierClearingIsUsed,
  BusinessPartnerCustomerCo.RecordPaymentHistoryIndicator AS RecordPaymentHistoryIndicator,
  BusinessPartnerCustomerCo.ItemIsToBePaidSeparately AS ItemIsToBePaidSeparately,
  BusinessPartnerCustomerCo.PaytAdviceIsSentbyEDI AS PaytAdviceIsSentbyEDI,
  BusinessPartnerCustomerCo.PaymentMethodsList AS PaymentMethodsList,
  BusinessPartnerCustomerCo.AlternativePayerAccount AS AlternativePayerAccount,
  BusinessPartnerCustomerCo.CustomerHeadOffice AS CustomerHeadOffice,
  BusinessPartnerCustomerCo.LayoutSortingRule AS LayoutSortingRule,
  BusinessPartnerCustomerCo.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerCustomerCo.InterestCalculationCode AS InterestCalculationCode,
  BusinessPartnerCustomerCo.InterestCalculationDate AS InterestCalculationDate,
  BusinessPartnerCustomerCo.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  BusinessPartnerCustomerCo.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  BusinessPartnerCustomerCo.HouseBank AS HouseBank,
  BusinessPartnerCustomerCo.Country AS Country,
  BusinessPartnerCustomerCo.CashPlanningGroup AS CashPlanningGroup,
  BusinessPartnerCustomerCo.ValueAdjustmentKey AS ValueAdjustmentKey,
  BusinessPartnerCustomerCo.KnownOrNegotiatedLeave AS KnownOrNegotiatedLeave,
  BusinessPartnerCustomerCo.CompanyCodeDunningIsByDunArea AS CompanyCodeDunningIsByDunArea,
  BusinessPartnerCustomerCo.CompanyCodeName AS CompanyCodeName
FROM I_BPAddlCustCompanyCodeTP AS BusinessPartnerCustomerCo
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAdditionalCustomer AS _BPAdditionalCustomer ON BusinessPartner = _BPAdditionalCustomer.BusinessPartner AND Customer = _BPAdditionalCustomer.Customer  -- association [1..1]
LEFT OUTER JOIN C_BPAddlCustWhldgTax AS _BusinessPartnerCustWhdgTax ON BusinessPartner = _BusinessPartnerCustWhdgTax.BusinessPartner AND Customer = _BusinessPartnerCustWhdgTax.Customer AND CompanyCode = _BusinessPartnerCustWhdgTax.CompanyCode  -- association [1..*]
LEFT OUTER JOIN C_BPAddlCustDunning AS _BPAddlCustDunning ON BusinessPartner = _BPAddlCustDunning.BusinessPartner AND Customer = _BPAddlCustDunning.Customer AND CompanyCode = _BPAddlCustDunning.CompanyCode  -- association [1..*]
LEFT OUTER JOIN I_CustomerCompanyCodeVH AS _CompanyCodeValueHelp ON CompanyCodeForEdit = _CompanyCodeValueHelp.CompanyCode AND Country = _CompanyCodeValueHelp.Country  -- association [0..1]
LEFT OUTER JOIN C_Custrecnclnacctvhtemp AS _ReconciliationAccountVH ON ReconciliationAccount = _ReconciliationAccountVH.ReconciliationAccount AND CompanyCodeForEdit = _ReconciliationAccountVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_AccountingClerkVHTemp AS _AccountingClerkValueHelp ON AccountingClerk = _AccountingClerkValueHelp.AccountingClerk AND CompanyCodeForEdit = _AccountingClerkValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AlternativePayerVH AS _AlternativePayerValueHelp ON AlternativePayerAccount = _AlternativePayerValueHelp.AlternativePayer AND CompanyCodeForEdit = _AlternativePayerValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustheadoffcVH AS _HeadOfficeValueHelp ON CustomerHeadOffice = _HeadOfficeValueHelp.Customer AND CompanyCodeForEdit = _HeadOfficeValueHelp.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_ValAdjmtKeyValueHelpTmp AS _ValueAdjmtKeyValueHelp ON ValueAdjustmentKey = _ValueAdjmtKeyValueHelp.ValueAdjustmentKey  -- association [0..*]
LEFT OUTER JOIN C_SortKeyTextVHtemp AS _SortKeyText ON LayoutSortingRule = _SortKeyText.AcctgDocItmDisplaySequenceRule  -- association [1..*]
LEFT OUTER JOIN C_CustPaymentTermsTextVHTemp AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.CustomerPaymentTerms  -- association [0..*]
LEFT OUTER JOIN C_ToleranceGroupTextVHTemp AS _ToleranceGroupText ON _ToleranceGroupText.CompanyCode = CompanyCode AND _ToleranceGroupText.APARToleranceGroup = APARToleranceGroup  -- association [0..*]
LEFT OUTER JOIN C_PaymentmethodTextVHTemp AS _PaymentMethodText ON PaymentMethodsList = _PaymentMethodText.PaymentMethod AND Country = _PaymentMethodText.Country  -- association [1..*]
LEFT OUTER JOIN I_PaymentBlockingReasonText AS _PaymentBlockingReasonText ON PaymentBlockingReason = _PaymentBlockingReasonText.PaymentBlockingReason  -- association [0..*]
LEFT OUTER JOIN I_InterestCalculationCodeText AS _InterestCalculationCodeText ON InterestCalculationCode = _InterestCalculationCodeText.InterestCalculationCode  -- association [0..*]
LEFT OUTER JOIN I_CashPlanningGroupText AS _PlanningGroupText ON CashPlanningGroup = _PlanningGroupText.CashPlanningGroup  -- association [0..*]
LEFT OUTER JOIN C_KnownOrNegotiatedLeaveTxtTmp AS _KnownOrNegotiatedLeaveText ON KnownOrNegotiatedLeave = _KnownOrNegotiatedLeaveText.KnownOrNegotiatedLeave  -- association [0..*]
;