I_BUSINESSPARTNERPROCESS

@AbapCatalog.sqlViewName: 'IBPPROCESS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #REQUIRED
//@Analytics.dataCategory: #DIMENSION

@ClientHandling.algorithm : #SESSION_VARIABLE
@EndUserText.label: 'Business Partner Process'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BusinessPartnerProcess
  as select from but000_prc

  association [0..1] to E_BusinessPartnerProcess   as _Extension       on  $projection.MasterDataChangeProcess = _Extension.MasterDataChangeProcess
                                                                       and $projection.MDChgProcessStep        = _Extension.MDChgProcessStep
                                                                       and $projection.MDChgProcessSrceSystem  = _Extension.MDChgProcessSrceSystem
                                                                       and $projection.MDChgProcessSrceObject  = _Extension.MDChgProcessSrceObject

  association [0..1] to I_BPCountryAddressVariants as _AddressVariants on  _AddressVariants.BPCountryDepdntAddressVariant = _AddressVariants.BPCountryDepdntAddressVariant
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,

      partner                  as BusinessPartner,
      type                     as BusinessPartnerCategory,
      augrp                    as AuthorizationGroup,
      partner_guid             as BusinessPartnerUUID,
      persnumber               as PersonNumber,

      case
        when chusr <> '' then concat(chusr, concat( chdat, chtim ) )
        else concat(crusr, concat( crdat, crtim ) )
      end                      as ETag,

      case type
        when '1' then concat_with_space( name_first, name_last, 1)
        when '2' then concat_with_space( name_org1, name_org2, 1)
        else concat_with_space( name_grp1, name_grp2, 1)
      end                      as BusinessPartnerName,

      case type
        when '1' then
                    case   _AddressVariants.BPCountryDepdntAddressVariant
                      when  '013' then concat_with_space( name_last,name_first, 1)
                    else case name1_text
                      when '' then concat_with_space( name_first, name_last, 1)
                    else name1_text
                     end
                    end
       when '2' then concat_with_space( name_org1, name_org2, 1)
        else concat_with_space( name_grp1, name_grp2, 1)
      end                      as BusinessPartnerFullName,

      crusr                    as CreatedByUser,
      crdat                    as CreationDate,
      crtim                    as CreationTime,
      chusr                    as LastChangedByUser,
      chdat                    as LastChangeDate,
      chtim                    as LastChangeTime,
      xblck                    as BusinessPartnerIsBlocked,

      xpcpt                    as IsBusinessPurposeCompleted,
      name_first               as FirstName,
      name_last                as LastName,

      name1_text               as PersonFullName,

      name_org1                as OrganizationBPName1,
      name_org2                as OrganizationBPName2,
      name_org3                as OrganizationBPName3,
      name_org4                as OrganizationBPName4,
      location_1               as InternationalLocationNumber1,
      location_2               as InternationalLocationNumber2,
      location_3               as InternationalLocationNumber3,

      legal_enty               as LegalForm,
      found_dat                as OrganizationFoundationDate,
      liquid_dat               as OrganizationLiquidationDate,
      ind_sector               as Industry,
      natpers                  as IsNaturalPerson,

      xsexf                    as IsFemale,
      xsexm                    as IsMale,
      xsexu                    as IsSexUnknown,
      gender                   as GenderCodeName,
      title                    as FormOfAddress,
      title_aca1               as AcademicTitle,
      title_aca2               as AcademicTitle2,
      nameformat               as NameFormat,
      namcountry               as NameCountry,

      bu_group                 as BusinessPartnerGrouping,
      partgrptyp               as BusinessPartnerGroupType,

      bpkind                   as BusinessPartnerType,
      namemiddle               as MiddleName,
      name_lst2                as AdditionalLastName,
      name_last2               as BusinessPartnerBirthName,
      title_royl               as BusinessPartnerSupplementName,
      //      title_let                                       as  Salutation,  "No Approved Global Field Name

      name_grp1                as GroupBusinessPartnerName1,
      name_grp2                as GroupBusinessPartnerName2,
      langu_corr               as CorrespondenceLanguage,
      bu_langu                 as Language,
      bu_sort1                 as SearchTerm1,
      bu_sort2                 as SearchTerm2,
      //      bp_sort                                         as  PhoneticSortField,  "No Approved Global Field Name

      mc_name1                 as BPLastNameSearchHelp,
      mc_name2                 as BPFirstNameSearchHelp,
      nickname                 as BusinessPartnerNicknameLabel,
      prefix1                  as LastNamePrefix,
      prefix2                  as LastNameSecondPrefix,
      initials                 as Initials,
      //      rate                                            as  RevenueRate,

      marst                    as BusPartMaritalStatus,
      natio                    as BusPartNationality,
      cndsc                    as NonResidentCompanyOriginCntry,
      jobgr                    as BusinessPartnerOccupation,

      addrcomm                 as IndependentAddressID,

      birthdt                  as BirthDate,
      birthdt_status           as BusinessPartnerBirthDateStatus,
      birthpl                  as BusinessPartnerBirthplaceName,
      emplo                    as NaturalPersonEmployerName,
      deathdt                  as BusinessPartnerDeathDate,

      xdele                    as IsMarkedForArchiving,
      contact                  as ContactPermission,
      bpext                    as BusinessPartnerIDByExtSystem,
      legal_org                as LegalEntityOfOrganization,

      print_mode               as BusinessPartnerPrintFormat,
      source                   as BusinessPartnerDataOriginType,
      not_released             as BusinessPartnerIsNotReleased,

      not_lg_competent         as IsNotContractuallyCapable,

      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      validation_status        as MDChgProcessValidationStatus,
      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,

      dc_not_req               as BPDataControllerIsNotRequired,

      kbanks                   as BankCountry,
      kbankl                   as BankKey,

      /* Associations */
      _AddressVariants
}