I_BPEMPLOYMENTPROCESS

CDS View

BP employments

I_BPEMPLOYMENTPROCESS is a CDS View in S/4HANA. BP employments. It contains 7 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 7 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPEmploymentProcessChanges view from BP employments changes
I_BPEmploymentProcessChanges view union_all BP employments changes
I_BPEmploymentProcessTP view_entity from TRANSACTIONAL BP employments

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BPEmploymentStartDate BPEmploymentStartDate 1
KEY BusinessPartner BusinessPartner 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP employments'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPEmploymentProcess
  as select from bp011_prc
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner on  bp011_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                     and bp011_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                     and bp011_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                     and bp011_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject

{
  key bp011_prc.process_id      as MasterDataChangeProcess,
  key bp011_prc.process_step_no as MDChgProcessStep,
  key bp011_prc.source_system   as MDChgProcessSrceSystem,
  key bp011_prc.source_id       as MDChgProcessSrceObject,
  key bp011_prc.partnr          as BusinessPartner,
      @Semantics.businessDate.from: true
  key bp011_prc.empl_since      as BPEmploymentStartDate,
      @Semantics.businessDate.to: true
      bp011_prc.empl_until      as BPEmploymentEndDate,
      bp011_prc.employment      as BPEmploymentStatus,
      //      bp011_prc.emp_sector      as EmpSector,

      bp011_prc.emp_sector_zgp  as BusPartEmplrIndstryCode,
      bp011_prc.employer        as BusinessPartnerEmployerName,
      //      bp011_prc.profession      as Profession,

      bp011_prc.jobgr_zgp       as BusinessPartnerOccupationGroup,
      source_recency            as MDChgProcSrceLastChgdDateTime,
      source_modified           as MDChgProcessSourceModified,
      source_modification_blip  as MDChgProcessSourceModifBinary,

      _BusinessPartner
}

Learn More