I_BPSupplierCompanyProcessTP

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_BPSupplierCompanyProcessTP.
-- 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_BPSupplierCompanyProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPAssignmentID,
  CompanyCode,
  Supplier,
  PersonnelNumber,
  SupplierIsBlockedForPosting,
  DeletionIndicator,
  LayoutSortingRule,
  ReconciliationAccount,
  AuthorizationGroup,
  InterestCalculationCode,
  PaymentMethodsList,
  ClearCustomerSupplier,
  PaymentBlockingReason,
  PaymentTerms,
  SupplierClerkIDBySupplier,
  SupplierClerk,
  SupplierAccountNote,
  CashPlanningGroup,
  AccountingClerk,
  SupplierHeadOffice,
  AlternativePayee,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  LastInterestCalcRunDate,
  IsToBeLocallyProcessed,
  Currency,
  BillOfExchLmtAmtInCoCodeCrcy,
  CheckPaidDurationInDays,
  IsDoubleInvoice,
  APARToleranceGroup,
  HouseBank,
  ItemIsToBePaidSeparately,
  MinorityGroup,
  PreviousAccountNumber,
  PaymentMethodSupplement,
  WithholdingTaxCountry,
  PaymentIsToBeSentByEDI,
  SupplierReleaseGroup,
  SuplrInvcVerificatTolGroup,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  CreditMemoPaymentTerms,
  SupplierCertificationDate,
  DeletionIsBlocked,
  AccountingClerkPhoneNumber,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcSrceLastChgdDateTime
FROM I_BPSupplierCompanyProcess
LEFT OUTER JOIN I_BusinessPartnerProcessTP AS _BusinessPartner ON MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartner.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject  -- association [1..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_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_SupplierMinorityGroup AS _SupplierMinorityGroup ON MinorityGroup = _SupplierMinorityGroup.MinorityGroup  -- 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_SuplrInvcSuplrTolSettings AS _SuplrInvcSuplrTolSettings ON CompanyCode = _SuplrInvcSuplrTolSettings.CompanyCode AND SuplrInvcVerificatTolGroup = _SuplrInvcSuplrTolSettings.SuplrInvcVerificatTolGroup  -- 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 = 'K'  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _HeadOffice ON SupplierHeadOffice = _HeadOffice.Supplier  -- 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_SupplierCompany AS _AlternativePayee ON AlternativePayee = _AlternativePayee.Supplier AND CompanyCode = _AlternativePayee.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_CompanyCode AS _CompanyCode2 ON CompanyCode = _CompanyCode2.CompanyCode  -- association [0..1]
LEFT OUTER JOIN E_BPSupplierCompanyProcess AS _ExtBPSupplierCompanyProcess ON MasterDataChangeProcess = _ExtBPSupplierCompanyProcess.MasterDataChangeProcess AND MDChgProcessStep = _ExtBPSupplierCompanyProcess.MDChgProcessStep AND MDChgProcessSrceSystem = _ExtBPSupplierCompanyProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtBPSupplierCompanyProcess.MDChgProcessSrceObject AND BPAssignmentID = _ExtBPSupplierCompanyProcess.BPAssignmentID AND CompanyCode = _ExtBPSupplierCompanyProcess.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BPSupplierDunningProcessTP AS _SupplierDunning ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPSuplrWithholdingTaxProcTP AS _SupplierWithHoldingTax ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPSuplrCoTxtGeneralProcessTP AS _SupplierCompanyTextGeneral ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPSuplrCoPmtdAltvPayeeProcTP AS _SupplierCompanyPermittedPayee ON /* condition not available in parsed metadata */  -- association [0..*]
;