I_WORKASSIGNMENTKEYMAPPING

CDS View

Work Assignment Key Mappings

I_WORKASSIGNMENTKEYMAPPING is a CDS View in S/4HANA. Work Assignment Key Mappings. It contains 9 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 9 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_WorkAssignmentBP view_entity from COMPOSITE BP Details of Work Assignment
I_WorkAssignmentBP view_entity union COMPOSITE BP Details of Work Assignment
I_WorkAssignmentValueHelp view_entity from COMPOSITE Work Assignments of a Workforce Person
I_WorkForcePersonMappings view_entity from COMPOSITE Workforce Person Mappings
P_WorkforcePersonInitialAssgmt view_entity from COMPOSITE Initial Assignment of WorkforcePerson

Fields (9)

KeyField CDS FieldsUsed in Views
KEY WorkAssignment WorkAssignment,WorkforceAssignment 3
BusinessPartner BusinessPartner,WorkAssignmentBusinessPartner 3
CentralPerson CentralPerson 1
Country2DigitISOCode Country2DigitISOCode 1
IsBlocked IsBlocked 2
WorkAssignmentExternalID WorkAssignmentExternalID,WorkforceAssignmentExternalID 2
WorkAssignmentStartDate WorkforceAssgmtStartDate 1
WorkforcePersonExternalID WorkforcePersonExternalID 4
WorkforcePersonID WorkforcePersonID 1 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #MASTER
}
@EndUserText.label: 'Work Assignment Key Mappings'
define view entity I_WorkAssignmentKeyMapping 
                as select from wfd_d_keymap  as keymap 
                    inner join wfd_d_assgmt  as assgmt on keymap.workforce_assgmt_id = assgmt.workforce_assgmt_id   
{
  key keymap.workforce_assgmt_id    as WorkAssignment,
      keymap.business_partner_id    as BusinessPartner,
      keymap.person_id_external     as WorkforcePersonExternalID,
      assgmt.start_date             as WorkAssignmentStartDate,
      assgmt.end_date               as WorkAssignmentEndDate,
      assgmt.is_contingent_worker   as IsContingentWorker,
      keymap.central_person         as CentralPerson,
      keymap.worker_id              as WorkforcePersonID,
      keymap.country                as Country2DigitISOCode,
      keymap.work_assignment_ext_id as WorkAssignmentExternalID,
      keymap.bp_model_type          as WorkforceBPModelType,
      keymap.data_source            as WorkAssignmentDataSource,
      keymap.block_ind              as IsBlocked       
}

Learn More