I_BPCustomerProcess

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

  association [0..1] to I_BusinessPartnerProcess as _BusinessPartner      on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                          and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                          and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                          and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to E_BPCustomerProcess      as _ExtBPCustomerProcess on  $projection.MasterDataChangeProcess = _ExtBPCustomerProcess.MasterDataChangeProcess
                                                                          and $projection.MDChgProcessStep        = _ExtBPCustomerProcess.MDChgProcessStep
                                                                          and $projection.MDChgProcessSrceSystem  = _ExtBPCustomerProcess.MDChgProcessSrceSystem
                                                                          and $projection.MDChgProcessSrceObject  = _ExtBPCustomerProcess.MDChgProcessSrceObject
                                                                          and $projection.BPAssignmentID          = _ExtBPCustomerProcess.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,
      kunnr                    as Customer,
      aufsd                    as OrderIsBlockedForCustomer,
      bahne                    as ExpressTrainStationName,
      bahns                    as TrainStationName,
      begru                    as AuthorizationGroup,
      faksd                    as BillingIsBlockedForCustomer,
      fiskn                    as FiscalAddress,
      knrza                    as AlternativePayerAccount,
      konzs                    as CustomerCorporateGroup,
      ktokd                    as CustomerAccountGroup,
      kukla                    as CustomerClassification,
      lifnr                    as Supplier,
      lifsd                    as DeliveryIsBlocked,
      locco                    as CityCoordinates,
      loevm                    as DeletionIndicator,
      niels                    as NielsenRegion,
      counc                    as County,
      cityc                    as CityCode,
      sperr                    as PostingIsBlocked,
      stkza                    as BPSubjectToEqualizationTax,
      stkzu                    as VATLiability,
      xzemp                    as AlternativePayeeIsAllowed,
      bran1                    as IndustryCode1,
      bran2                    as IndustryCode2,
      bran3                    as IndustryCode3,
      bran4                    as IndustryCode4,
      bran5                    as IndustryCode5,
      umjah                    as YearForWhichSalesGiven,
      jmzah                    as CustYearlyNumberOfEmployees,
      jmjah                    as EmployeesNumberGivenForYear,
      katr1                    as FreeDefinedAttribute01,
      katr2                    as FreeDefinedAttribute02,
      katr3                    as FreeDefinedAttribute03,
      katr4                    as FreeDefinedAttribute04,
      katr5                    as FreeDefinedAttribute05,
      katr6                    as FreeDefinedAttribute06,
      katr7                    as FreeDefinedAttribute07,
      katr8                    as FreeDefinedAttribute08,
      katr9                    as FreeDefinedAttribute09,
      katr10                   as FreeDefinedAttribute10,
      periv                    as CustomerFiscalYearVariant,
      dtams                    as DataMediumExchangeIndicator,
      dtaws                    as DataMediumExchangeKey,
      civve                    as CustomerIsForCivilUse,
      milve                    as CustomerIdentityForMilitaryUse,
      kdkg1                    as CustomerConditionGroup1,
      kdkg2                    as CustomerConditionGroup2,
      kdkg3                    as CustomerConditionGroup3,
      kdkg4                    as CustomerConditionGroup4,
      kdkg5                    as CustomerConditionGroup5,
      fityp                    as ResponsibleType,
      xicms                    as CustomerExempt1,
      xxipi                    as CustomerExempt,
      xsubt                    as CustomerGroupForCalculation,
      cfopc                    as CustomerCategory,
      ccc01                    as BioChemicalWarfareLegal,
      ccc02                    as NuclearNonProliferationLegal,
      ccc03                    as NationalSecurityLegalControl,
      ccc04                    as MissileTechnologyLegalControl,
      cassd                    as CustomerCentralSalesBlock,
      j_1kfrepre               as TaxInvoiceRepresentativeName,
      j_1kftbus                as BusinessType,
      j_1kftind                as IndustryType,
      nodel                    as CustomerCentralDeletionIsBlock,

      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 = '000000000002'
  or assignment_id is initial