I_WorkAssignmentKeyMapping

DDL: I_WORKASSIGNMENTKEYMAPPING Type: view_entity BASIC

Work Assignment Key Mappings

I_WorkAssignmentKeyMapping is a Basic CDS View that provides data about "Work Assignment Key Mappings" in SAP S/4HANA. It reads from 2 data sources (wfd_d_assgmt, wfd_d_keymap) and exposes 13 fields with key field WorkAssignment.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
wfd_d_assgmt assgmt inner
wfd_d_keymap keymap from

Annotations (7)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Work Assignment Key Mappings view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment wfd_d_keymap workforce_assgmt_id
BusinessPartner wfd_d_keymap business_partner_id
WorkforcePersonExternalID wfd_d_keymap person_id_external
WorkAssignmentStartDate wfd_d_assgmt start_date
WorkAssignmentEndDate wfd_d_assgmt end_date
IsContingentWorker wfd_d_assgmt is_contingent_worker
CentralPerson wfd_d_keymap central_person
WorkforcePersonID wfd_d_keymap worker_id
Country2DigitISOCode wfd_d_keymap country
WorkAssignmentExternalID wfd_d_keymap work_assignment_ext_id
WorkforceBPModelType wfd_d_keymap bp_model_type
WorkAssignmentDataSource wfd_d_keymap data_source
IsBlocked wfd_d_keymap block_ind 
@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       
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WFD_D_ASSGMT",
"WFD_D_KEYMAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More