I_BPCustomerCompanyProcess

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_BPCustomerCompanyProcess.
-- 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_BPCustomerCompanyProcess 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,
  kunnr AS Customer,
  pernr AS PersonnelNumber,
  sperr AS PhysicalInventoryBlockInd,
  loevm AS DeletionIndicator,
  zuawa AS LayoutSortingRule,
  busab AS AccountingClerk,
  akont AS ReconciliationAccount,
  begru AS AuthorizationGroup,
  knrze AS CustomerHeadOffice,
  knrzb AS AlternativePayerAccount,
  zwels AS PaymentMethodsList,
  xverr AS CustomerSupplierClearingIsUsed,
  zahls AS PaymentBlockingReason,
  zterm AS PaymentTerms,
  wakon AS BillExchChargePaymentTerms,
  vzskz AS InterestCalculationCode,
  zindt AS InterestCalculationDate,
  zinrt AS IntrstCalcFrequencyInMonths,
  eikto AS AccountByCustomer,
  zsabe AS UserAtCustomer,
  kverm AS CustomerAccountNote,
  fdgrv AS CashPlanningGroup,
  perkz AS CollectiveInvoiceVariant,
  xdezv AS IsToBeLocallyProcessed,
  xausz AS BPPeriodicAccountStatement,
  datlz AS LastInterestCalcRunDate,
  xzver AS RecordPaymentHistoryIndicator,
  togru AS APARToleranceGroup,
  kultg AS CheckPaidDurationInDays,
  hbkid AS HouseBank,
  xpore AS ItemIsToBePaidSeparately,
  altkn AS CustPreviousMasterRecordNumber,
  urlid AS KnownOrNegotiatedLeave,
  mgrup AS DunningNoticeGroup,
  lockb AS LockboxInternalID,
  uzawe AS PaymentMethodSupplement,
  ekvbd AS BuyingGroupAccountNumber,
  xedip AS PaytAdviceIsSentbyEDI,
  frgrp AS SupplierReleaseGroup,
  tlfxs AS AccountingClerkFaxNumber,
  intad AS AccountingClerkInternetAddress,
  guzte AS CreditMemoPaymentTerms,
  wbrsl AS ValueAdjustmentKey,
  nodel AS DeletionIsBlocked,
  tlfns AS AccountingClerkPhoneNumber,
  cession_kz AS AcctsReceivablePledgingCode,
  paytrsn AS PaymentReason,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  source_recency AS MDChgProcSrceLastChgdDateTime
FROM knb1_prc
LEFT OUTER JOIN I_BPCustomerProcess AS _Customer ON MasterDataChangeProcess = _Customer.MasterDataChangeProcess AND MDChgProcessStep = _Customer.MDChgProcessStep AND MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject AND BPAssignmentID = _Customer.BPAssignmentID  -- association [0..1]
;