I_WORKFORCEPERSONKEYMAP

CDS View

Keymapping for Worker

I_WORKFORCEPERSONKEYMAP is a CDS View in S/4HANA. Keymapping for Worker. It contains 2 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 2 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_InactiveWorkAssignment view_entity from COMPOSITE Work Assignment Status of a Worker
P_InactiveWorkAssignment view_entity from COMPOSITE Work Assignment Status of a Worker
P_WFD_EMPLOYMENT view_entity from COMPOSITE Get minimum Active employment
P_WFD_GET_MINEPERNR_MAIN_EMP view_entity from COMPOSITE Get min. Active pernr with Main Emp
P_WFD_GET_MINEPERNR_NMAIN_EMP view_entity from COMPOSITE Get minimum Active pernr with Main Employment flag

Fields (2)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 3
CentralPerson PersonnelNumber 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Keymapping for Worker'
@Metadata.ignorePropagatedAnnotations: true
@VDM:{
viewType:#BASIC,
lifecycle.contract.type:#SAP_INTERNAL_API
}
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
//............................................................................................................................

// This CDS view is meant for private consumption in Worker Overview ONLY ---- Do not use it for for other applications

//............................................................................................................................


define view entity I_WorkforcePersonKeyMap
  as select from wfd_d_keymap 

{
  key workforce_assgmt_id    as WorkAssignment,
      worker_id              as WorkforcePersonID,
      business_partner_id    as BusinessPartner,
      person_id_external     as WorkforcePersonExternalID,
      user_id                as WorkforcePersonUserID,
      central_person         as CentralPerson,
      cast(user_id as wfd_assgmt_ext_id preserving type ) as WorkAssignmentExternalID,   
      bp_model_type          as WorkforceBPModelType,
      data_source            as WorkAssignmentDataSource,
      block_ind              as IsBlocked


}

Learn More