I_BPCustomerCompanyProcess

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Company Code Process Data'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerCompanyProcess
  as select from knb1_prc

  association [0..1] to I_BPCustomerProcess        as _Customer                    on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                                   and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                                   and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                                                   and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject
                                                                                   and $projection.BPAssignmentID          = _Customer.BPAssignmentID
  association [0..1] to E_BPCustomerCompanyProcess as _ExtBPCustomerCompanyProcess on  $projection.MasterDataChangeProcess = _ExtBPCustomerCompanyProcess.MasterDataChangeProcess
                                                                                   and $projection.MDChgProcessStep        = _ExtBPCustomerCompanyProcess.MDChgProcessStep
                                                                                   and $projection.MDChgProcessSrceSystem  = _ExtBPCustomerCompanyProcess.MDChgProcessSrceSystem
                                                                                   and $projection.MDChgProcessSrceObject  = _ExtBPCustomerCompanyProcess.MDChgProcessSrceObject
                                                                                   and $projection.BPAssignmentID          = _ExtBPCustomerCompanyProcess.BPAssignmentID
                                                                                   and $projection.CompanyCode             = _ExtBPCustomerCompanyProcess.CompanyCode
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key 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,
      //      qland                    as WithholdingTaxCountry,

      //      @Semantics.booleanIndicator: true

      //      cvp_xblck_b              as IsBusinessPurposeCompleted,

      //      paymentclearinggrpid     as PaymentClearingGroup,

      paytrsn                  as PaymentReason,

      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,

      _Customer
}
where
     assignment_id = '000000000002'
  or assignment_id is initial