I_BPSupplierProcess

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Business Partner Supplier Process Data'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity I_BPSupplierProcess
  as select from lfa1_prc

  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner      on  lfa1_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                          and lfa1_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                          and lfa1_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                          and lfa1_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to E_BPSupplierProcess      as _ExtBPSupplierProcess on  $projection.MasterDataChangeProcess = _ExtBPSupplierProcess.MasterDataChangeProcess
                                                                          and $projection.MDChgProcessStep        = _ExtBPSupplierProcess.MDChgProcessStep
                                                                          and $projection.MDChgProcessSrceSystem  = _ExtBPSupplierProcess.MDChgProcessSrceSystem
                                                                          and $projection.MDChgProcessSrceObject  = _ExtBPSupplierProcess.MDChgProcessSrceObject
                                                                          and $projection.BPAssignmentID          = _ExtBPSupplierProcess.BPAssignmentID
{

  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
      assignment_id            as BPAssignmentID,
      lifnr                    as Supplier,
      bahns                    as TrainStationName,
      begru                    as AuthorizationGroup,
      dtams                    as DataMediumExchangeIndicator,
      dtaws                    as DataExchangeInstructionKey,
      esrnr                    as PaytSlipWthRefSubscriber,
      konzs                    as SupplierCorporateGroup,
      ktokk                    as SupplierAccountGroup,
      kunnr                    as Customer,
      lnrza                    as AlternativePayeeAccountNumber,
      loevm                    as DeletionIndicator,
      sperr                    as AccountIsBlockedForPosting,
      sperm                    as PurchasingIsBlocked,
      stkza                    as BPIsEqualizationTaxSubject,
      stkzu                    as VATLiability,
      xzemp                    as AlternativePayeeIsAllowed,
      vbund                    as TradingPartner,
      fiskn                    as FiscalAddress,
      sperq                    as SupplierProcurementBlock,
      //      kraus                    as CreditorInformationNumber,

      //      revdb                    as CreditDataLastCheckDate,

      qssys                    as SuplrQualityManagementSystem,
      werks                    as SupplierPlant,
      ltsna                    as SupplierIsSubRangeRelevant,
      werkr                    as SupplierIsPlantRelevant,
      plkal                    as FactoryCalendar,
      //      scacd                    as CarrierPartyStandardID,

      //      sfrgr                    as CarrierPartyFreightGroupCode,

      //      dlgrp                    as ServicePerformerPartyGroupCode,

      fityp                    as ResponsibleType,
      //      regss                    as SupplIsSocialInsuranceRegtrd,

      //      actss                    as SocialInsuranceActivityCode,

      ipisp                    as BR_TaxIsSplit,
      taxbs                    as BRSpcfcTaxBasePercentageCode,
      stgdl                    as TranspServiceAgentStstcGrp,
      //      emnfr                    as ManufacturerExternalID,

      j_1kfrepre               as TaxInvoiceRepresentativeName,
      j_1kftbus                as BusinessType,
      j_1kftind                as IndustryType,
      nodel                    as SupplierCentralDeletionIsBlock,
      qssysdat                 as SuplrQltyInProcmtCertfnValidTo,
      podkzb                   as SuplrProofOfDelivRlvtCode,
      fisku                    as SuplrTaxAuthorityAccountNumber,
      weora                    as IsToBeAcceptedAtOrigin,
      ktock                    as ReferenceAccountGroup,
      paytrsn                  as PaymentReason,
      sperz                    as PaymentIsBlockedForSupplier,

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

      xdcset                   as DataControllerSet,
      data_ctrlr1              as DataController1,
      data_ctrlr2              as DataController2,
      data_ctrlr3              as DataController3,
      data_ctrlr4              as DataController4,
      data_ctrlr5              as DataController5,
      data_ctrlr6              as DataController6,
      data_ctrlr7              as DataController7,
      data_ctrlr8              as DataController8,
      data_ctrlr9              as DataController9,
      data_ctrlr10             as DataController10,

      _BusinessPartner

}
where
     assignment_id = '000000000001'
  or assignment_id is initial