I_BusinessPartnerCustCoTP

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_BusinessPartnerCustCoTP.
-- 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: IBUPACUSTCOTP

CREATE VIEW I_BusinessPartnerCustCoTP AS
SELECT
  BusinessPartnerCustomerCo.BusinessPartner AS BusinessPartner,
  BusinessPartnerCustomerCo.CompanyCode AS CompanyCode,
  BusinessPartnerCustomerCo.CompanyCode AS CompanyCodeForEdit,
  BusinessPartnerCustomerCo.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerCustomerCo.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerCustomerCo.Customer AS Customer,
  BusinessPartnerCustomerCo.AccountingClerk AS AccountingClerk,
  BusinessPartnerCustomerCo.ReconciliationAccount AS ReconciliationAccount,
  BusinessPartnerCustomerCo.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerCustomerCo.CustomerHeadOffice AS CustomerHeadOffice,
  BusinessPartnerCustomerCo.AlternativePayerAccount AS AlternativePayerAccount,
  BusinessPartnerCustomerCo.PaymentBlockingReason AS PaymentBlockingReason,
  BusinessPartnerCustomerCo.InterestCalculationCode AS InterestCalculationCode,
  BusinessPartnerCustomerCo.InterestCalculationDate AS InterestCalculationDate,
  BusinessPartnerCustomerCo.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  BusinessPartnerCustomerCo.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  BusinessPartnerCustomerCo.CustomerAccountNote AS CustomerAccountNote,
  BusinessPartnerCustomerCo.APARToleranceGroup AS APARToleranceGroup,
  BusinessPartnerCustomerCo.HouseBank AS HouseBank,
  BusinessPartnerCustomerCo.ItemIsToBePaidSeparately AS ItemIsToBePaidSeparately,
  BusinessPartnerCustomerCo.PaytAdviceIsSentbyEDI AS PaytAdviceIsSentbyEDI,
  BusinessPartnerCustomerCo.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  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.CollectiveInvoiceVariant AS CollectiveInvoiceVariant,
  BusinessPartnerCustomerCo.LayoutSortingRule AS LayoutSortingRule,
  BusinessPartnerCustomerCo.PaymentTerms AS PaymentTerms,
  BusinessPartnerCustomerCo.CreditMemoPaymentTerms AS CreditMemoPaymentTerms,
  BusinessPartnerCustomerCo.CustomerSupplierClearingIsUsed AS CustomerSupplierClearingIsUsed,
  BusinessPartnerCustomerCo.RecordPaymentHistoryIndicator AS RecordPaymentHistoryIndicator,
  BusinessPartnerCustomerCo.PaymentMethodsList AS PaymentMethodsList,
  BusinessPartnerCustomerCo.CashPlanningGroup AS CashPlanningGroup,
  BusinessPartnerCustomerCo.ValueAdjustmentKey AS ValueAdjustmentKey,
  BusinessPartnerCustomerCo.KnownOrNegotiatedLeave AS KnownOrNegotiatedLeave,
  BusinessPartnerCustomerCo.Country AS Country,
  CompanyCodeDunningControl.xmabe AS CompanyCodeDunningIsByDunArea,
  BusinessPartnerCustomerCo.SupplierReleaseGroup AS SupplierReleaseGroup,
  BusinessPartnerCustomerCo.PersonnelNumber AS PersonnelNumber,
  BusinessPartnerCustomerCo.BuyingGroupAccountNumber AS BuyingGroupAccountNumber,
  BusinessPartnerCustomerCo.BillExchChargePaymentTerms AS BillExchChargePaymentTerms,
  BusinessPartnerCustomerCo.CheckPaidDurationInDays AS CheckPaidDurationInDays,
  BusinessPartnerCustomerCo.CustomerPaymentBlockingReason AS CustomerPaymentBlockingReason,
  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_BusinessPartnerCustCo AS BusinessPartnerCustomerCo
LEFT OUTER JOIN t047 AS CompanyCodeDunningControl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_CUSCO_D AS _DraftExtension ON CompanyCode = _DraftExtension.CompanyCode AND Customer = _DraftExtension.Customer  -- association [0..1]
LEFT OUTER JOIN E_CUSCO_D AS _ActiveExtension ON CompanyCode = _ActiveExtension.CompanyCode AND Customer = _ActiveExtension.Customer  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerCustWhdgTaxTP AS _BusinessPartnerCustWhdgTax ON BusinessPartner = _BusinessPartnerCustWhdgTax.BusinessPartner AND CompanyCode = _BusinessPartnerCustWhdgTax.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPCustomerDunningTP AS _BPCustomerDunning ON BusinessPartner = _BPCustomerDunning.BusinessPartner AND CompanyCode = _BPCustomerDunning.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerCustCoTextTP AS _BusinessPartnerCustCoText ON BusinessPartner = _BusinessPartnerCustCoText.BusinessPartner AND CompanyCode = _BusinessPartnerCustCoText.CompanyCode  -- association [0..*]
;