C_BusinessPartnerCustCo

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_BusinessPartnerCustCo.
-- 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: CBUPACUSTCO

CREATE VIEW C_BusinessPartnerCustCo AS
SELECT
  BusinessPartnerCustomerCo.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustomerCo.CompanyCode AS CompanyCode,
  BusinessPartnerCustomerCo.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerCustomerCo.Customer AS Customer,
  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.CreditMemoPaymentTerms AS CreditMemoPaymentTerms,
  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.SupplierReleaseGroup AS SupplierReleaseGroup,
  BusinessPartnerCustomerCo.PersonnelNumber AS PersonnelNumber,
  BusinessPartnerCustomerCo.BuyingGroupAccountNumber AS BuyingGroupAccountNumber,
  BusinessPartnerCustomerCo.BillExchChargePaymentTerms AS BillExchChargePaymentTerms,
  BusinessPartnerCustomerCo.CheckPaidDurationInDays AS CheckPaidDurationInDays,
  BusinessPartnerCustomerCo.PaymentMethodSupplement AS PaymentMethodSupplement,
  BusinessPartnerCustomerCo.AcctsReceivablePledgingCode AS AcctsReceivablePledgingCode,
  BusinessPartnerCustomerCo.LockboxInternalID AS LockboxInternalID,
  BusinessPartnerCustomerCo.CustPreviousMasterRecordNumber AS CustPreviousMasterRecordNumber,
  BusinessPartnerCustomerCo.PaymentClearingGroup AS PaymentClearingGroup,
  BusinessPartnerCustomerCo.ExtendedWhldgTaxIsActive AS ExtendedWhldgTaxIsActive,
  BusinessPartnerCustomerCo.CompanyCodeName AS CompanyCodeName,
  BusinessPartnerCustomerCo.PaymentReason AS PaymentReason,
  BusinessPartnerCustomerCo.DeletionIsBlocked AS DeletionIsBlocked
FROM I_BusinessPartnerCustCoTP AS BusinessPartnerCustomerCo
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustWhdgTax AS _BusinessPartnerCustWhdgTax ON BusinessPartner = _BusinessPartnerCustWhdgTax.BusinessPartner AND CompanyCode = _BusinessPartnerCustWhdgTax.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_BPCustomerDunning AS _BPCustomerDunning ON BusinessPartner = _BPCustomerDunning.BusinessPartner AND CompanyCode = _BPCustomerDunning.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_BusinessPartnerCustCoText AS _BusinessPartnerCustCoText ON BusinessPartner = _BusinessPartnerCustCoText.BusinessPartner AND CompanyCode = _BusinessPartnerCustCoText.CompanyCode  -- association [0..*]
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_CustPaymentTermsTextVHTemp AS _CreditMemoPaymentTermsText ON CreditMemoPaymentTerms = _CreditMemoPaymentTermsText.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_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 I_Paymentmethodsupplementtext AS _PaymentMethodSupplementText ON PaymentMethodSupplement = _PaymentMethodSupplementText.PaymentMethodSupplement  -- association [0..*]
LEFT OUTER JOIN I_MM_SuplrReleaseGroupText AS _MM_SuplrReleaseGroupText ON SupplierReleaseGroup = _MM_SuplrReleaseGroupText.SupplierReleaseGroup  -- association [0..*]
LEFT OUTER JOIN C_KnownOrNegotiatedLeaveTxtTmp AS _KnownOrNegotiatedLeaveText ON KnownOrNegotiatedLeave = _KnownOrNegotiatedLeaveText.KnownOrNegotiatedLeave  -- association [0..*]
LEFT OUTER JOIN I_ARLockboxVH AS _ARLockboxVH ON LockboxInternalID = _ARLockboxVH.LockboxInternalID  -- association [0..*]
LEFT OUTER JOIN C_CustPaymentTermsTextVHTemp AS _BillExchChargePaymentTermsTxt ON BillExchChargePaymentTerms = _BillExchChargePaymentTermsTxt.CustomerPaymentTerms  -- association [0..*]
;