I_BPSupplierCompanyProcess

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_BPSupplierCompanyProcess.
-- 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_BPSupplierCompanyProcess AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  bukrs AS CompanyCode,
  assignment_id AS BPAssignmentID,
  lifnr AS Supplier,
  pernr AS PersonnelNumber,
  sperr AS SupplierIsBlockedForPosting,
  loevm AS DeletionIndicator,
  zuawa AS LayoutSortingRule,
  akont AS ReconciliationAccount,
  begru AS AuthorizationGroup,
  vzskz AS InterestCalculationCode,
  zwels AS PaymentMethodsList,
  xverr AS ClearCustomerSupplier,
  zahls AS PaymentBlockingReason,
  zterm AS PaymentTerms,
  eikto AS SupplierClerkIDBySupplier,
  zsabe AS SupplierClerk,
  kverm AS SupplierAccountNote,
  fdgrv AS CashPlanningGroup,
  busab AS AccountingClerk,
  lnrze AS SupplierHeadOffice,
  lnrzb AS AlternativePayee,
  zindt AS InterestCalculationDate,
  zinrt AS IntrstCalcFrequencyInMonths,
  datlz AS LastInterestCalcRunDate,
  xdezv AS IsToBeLocallyProcessed,
  _CompanyCode.Currency AS Currency,
  webtr AS BillOfExchLmtAmtInCoCodeCrcy,
  kultg AS CheckPaidDurationInDays,
  reprf AS IsDoubleInvoice,
  togru AS APARToleranceGroup,
  hbkid AS HouseBank,
  xpore AS ItemIsToBePaidSeparately,
  mindk AS MinorityGroup,
  altkn AS PreviousAccountNumber,
  uzawe AS PaymentMethodSupplement,
  qland AS WithholdingTaxCountry,
  xedip AS PaymentIsToBeSentByEDI,
  frgrp AS SupplierReleaseGroup,
  togrr AS SuplrInvcVerificatTolGroup,
  tlfxs AS AccountingClerkFaxNumber,
  intad AS AccountingClerkInternetAddress,
  guzte AS CreditMemoPaymentTerms,
  cerdt AS SupplierCertificationDate,
  nodel AS DeletionIsBlocked,
  tlfns AS AccountingClerkPhoneNumber,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  source_recency AS MDChgProcSrceLastChgdDateTime
FROM lfb1_prc
LEFT OUTER JOIN I_BPSupplierProcess AS _Supplier ON lfb1_prc.process_id = _Supplier.MasterDataChangeProcess AND lfb1_prc.process_step_no = _Supplier.MDChgProcessStep AND lfb1_prc.source_system = _Supplier.MDChgProcessSrceSystem AND lfb1_prc.source_id = _Supplier.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_ToleranceGroupText AS _APARToleranceGroupName ON CompanyCode = _APARToleranceGroupName.CompanyCode AND _APARToleranceGroupName.Language = $session.system_language AND APARToleranceGroup = _APARToleranceGroupName.APARToleranceGroup  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_PaymentBlockingReasonText AS _PaymentBlockingReasonText ON PaymentTerms = _PaymentBlockingReasonText.PaymentBlockingReason  -- association [0..*]
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]
;