I_BPCustomerCompanyProcessTP

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_BPCustomerCompanyProcessTP.
-- 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.

CREATE VIEW I_BPCustomerCompanyProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPAssignmentID,
  CompanyCode,
  Customer,
  PersonnelNumber,
  PhysicalInventoryBlockInd,
  DeletionIndicator,
  LayoutSortingRule,
  AccountingClerk,
  ReconciliationAccount,
  AuthorizationGroup,
  CustomerHeadOffice,
  AlternativePayerAccount,
  PaymentMethodsList,
  CustomerSupplierClearingIsUsed,
  PaymentBlockingReason,
  PaymentTerms,
  BillExchChargePaymentTerms,
  InterestCalculationCode,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  AccountByCustomer,
  UserAtCustomer,
  CustomerAccountNote,
  CashPlanningGroup,
  CollectiveInvoiceVariant,
  IsToBeLocallyProcessed,
  BPPeriodicAccountStatement,
  LastInterestCalcRunDate,
  RecordPaymentHistoryIndicator,
  APARToleranceGroup,
  CheckPaidDurationInDays,
  HouseBank,
  ItemIsToBePaidSeparately,
  CustPreviousMasterRecordNumber,
  KnownOrNegotiatedLeave,
  DunningNoticeGroup,
  LockboxInternalID,
  PaymentMethodSupplement,
  BuyingGroupAccountNumber,
  PaytAdviceIsSentbyEDI,
  SupplierReleaseGroup,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  CreditMemoPaymentTerms,
  ValueAdjustmentKey,
  DeletionIsBlocked,
  AccountingClerkPhoneNumber,
  AcctsReceivablePledgingCode,
  PaymentReason,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcSrceLastChgdDateTime
FROM I_BPCustomerCompanyProcess
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BPProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerk ON CompanyCode = _AccountingClerk.CompanyCode AND AccountingClerk = _AccountingClerk.AccountingClerk  -- association [0..1]
LEFT OUTER JOIN I_ToleranceGroup AS _ToleranceGroup ON CompanyCode = _ToleranceGroup.CompanyCode AND APARToleranceGroup = _ToleranceGroup.APARToleranceGroup  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroup AS _CashPlanningGroup ON CashPlanningGroup = _CashPlanningGroup.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _ReconciliationAccount ON CompanyCode = _ReconciliationAccount.CompanyCode AND ReconciliationAccount = _ReconciliationAccount.GLAccount AND _ReconciliationAccount.ReconciliationAccountType = 'D'  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _HeadOffice ON CustomerHeadOffice = _HeadOffice.Customer  -- association [0..1]
LEFT OUTER JOIN I_AcctgDocItmDspSqncRule AS _LayoutSortingRule ON LayoutSortingRule = _LayoutSortingRule.AcctgDocItmDisplaySequenceRule  -- association [0..1]
LEFT OUTER JOIN I_Paymentmethodsupplement AS _PaymentMethodSupplement ON PaymentMethodSupplement = _PaymentMethodSupplement.PaymentMethodSupplement  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _AlternativePayer ON AlternativePayerAccount = _AlternativePayer.Customer AND CompanyCode = _AlternativePayer.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_InterestCalculationCode AS _InterestCalculationCode ON InterestCalculationCode = _InterestCalculationCode.InterestCalculationCode  -- association [0..1]
LEFT OUTER JOIN I_MM_SuplrReleaseGroupVH AS _SupplierReleaseGroup ON SupplierReleaseGroup = _SupplierReleaseGroup.SupplierReleaseGroup  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _CreditMemoPaymentTerms ON CreditMemoPaymentTerms = _CreditMemoPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _BillExchChargePaymentTerms ON BillExchChargePaymentTerms = _BillExchChargePaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_NegotiatedLeave AS _NegotiatedLeave ON KnownOrNegotiatedLeave = _NegotiatedLeave.KnownOrNegotiatedLeave  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BuyingGroupAccount ON BuyingGroupAccountNumber = _BuyingGroupAccount.Customer  -- association [0..1]
LEFT OUTER JOIN I_BPPeriodicAccountStatement AS _PeriodicAccountStatement ON BPPeriodicAccountStatement = _PeriodicAccountStatement.BPPeriodicAccountStatement  -- association [0..1]
LEFT OUTER JOIN I_AcctsReceivablePledging AS _AcctsReceivablePledging ON AcctsReceivablePledgingCode = _AcctsReceivablePledging.AcctsReceivablePledgingCode AND CompanyCode = _AcctsReceivablePledging.CompanyCode  -- association [0..1]
LEFT OUTER JOIN E_BPCustomerCompanyProcess AS _ExtBPCustomerCompanyProcess ON MasterDataChangeProcess = _ExtBPCustomerCompanyProcess.MasterDataChangeProcess AND MDChgProcessStep = _ExtBPCustomerCompanyProcess.MDChgProcessStep AND MDChgProcessSrceSystem = _ExtBPCustomerCompanyProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtBPCustomerCompanyProcess.MDChgProcessSrceObject AND BPAssignmentID = _ExtBPCustomerCompanyProcess.BPAssignmentID AND CompanyCode = _ExtBPCustomerCompanyProcess.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BPCustomerDunningProcessTP AS _CustomerDunning ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCustomerWhgdTaxProcessTP AS _CustomerWithholdingTax ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCustCoTextGeneralProcessTP AS _CustomerCompanyTextGeneral ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCustCoPmtdAltvPayerProcTP AS _CustomerCompanyPermittedPayer ON /* condition not available in parsed metadata */  -- association [0..*]
;