I_BUSINESSPARTNERALIASPROCESS

CDS View

BP Alias Name (Process)

I_BUSINESSPARTNERALIASPROCESS is a CDS View in S/4HANA. BP Alias Name (Process). It contains 9 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 9 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BusinessPartnerAliasProcTP view_entity from TRANSACTIONAL BP Alias Name (Process)
I_BusinessPartnerAlsProcChgs view_entity from Changes View for BP Alias
I_BusinessPartnerAlsProcChgs view_entity union_all Changes View for BP Alias

Fields (9)

KeyField CDS FieldsUsed in Views
KEY BPAliasPositionNumber BPAliasPositionNumber 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
BusinessPartnerAliasName BusinessPartnerAliasName 1
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime 1 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Alias Name (Process)'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusinessPartnerAliasProcess
  as select from bkk21_prc
  association [1..1] to I_BusinessPartnerProcess  as _BusinessPartner     on  bkk21_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                          and bkk21_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                          and bkk21_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                          and bkk21_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BPFinServicesDetailProc as _BPFinServicesDetail on  bkk21_prc.process_id      = _BPFinServicesDetail.MasterDataChangeProcess
                                                                          and bkk21_prc.process_step_no = _BPFinServicesDetail.MDChgProcessStep
                                                                          and bkk21_prc.source_system   = _BPFinServicesDetail.MDChgProcessSrceSystem
                                                                          and bkk21_prc.source_id       = _BPFinServicesDetail.MDChgProcessSrceObject
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key alposnr                  as BPAliasPositionNumber,
      alname                   as BusinessPartnerAliasName,

      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      
      _BusinessPartner,
      _BPFinServicesDetail
}

Learn More