I_WORKFORCEASSIGNMENT

CDS View

Workforce Assignment

I_WORKFORCEASSIGNMENT is a CDS View in S/4HANA. Workforce Assignment. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkerSearch view from COMPOSITE Workforce CDS view for OP
I_WorkForcePersonSearch view inner COMPOSITE Workforce Person basic details

Fields (1)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssignment EmploymentInternalID 1 
@AbapCatalog.sqlViewName: 'IWORKFORCEASSGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC
}
@ObjectModel: {
   compositionRoot:   true,
   representativeKey: 'WorkforceAssignment',
   semanticKey: ['WorkforceAssignment'],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #M
   }
}
@EndUserText.label: 'Workforce Assignment'
@Metadata.allowExtensions:true
define view I_WorkforceAssignment
  as select from wfd_d_assgmt as Assgmt
  association [0..*] to I_WorkforceAssignmentDetails as _Details   on $projection.WorkforceAssignment = _Details.WorkforceAssignment
  association [1]    to E_WorkforceAssignment        as _Extension on $projection.WorkforceAssignment = _Extension.WorkforceAssignment

{

  key Assgmt.workforce_assgmt_id as WorkforceAssignment,
      start_date                 as WorkforceAssgmtStartDate,
      end_date                   as WorkforceAssgmtEndDate,
      business_partner_id        as BusinessPartner,
      ext_workforce_assgmt_uuid  as WorkforceAssignmentExternalID,
      is_contingent_worker       as IsContingentWorker,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Details
}
where
  block_ind = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WFD_D_ASSGMT"
],
"ASSOCIATED":
[
"E_WORKFORCEASSIGNMENT",
"I_WORKFORCEASSIGNMENTDETAILS"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More