I_WORKFORCEASSIGNMENT_1

CDS View

Work Assignment for Worker

I_WORKFORCEASSIGNMENT_1 is a CDS View in S/4HANA. Work Assignment for Worker. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_WorkAssignmentValidity view_entity inner COMPOSITE Work Assignment Validity for the Worker
I_WorkerFactSheetSearch view_entity inner COMPOSITE Workforce Person Details
R_SupplierDetail view_entity inner COMPOSITE Supplier for Contingent Worker
R_WorkAssgmtsBPIdentification view_entity inner COMPOSITE Business Partner for Work Assignment 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Assignment for Worker'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel: {
   compositionRoot:   true,
   representativeKey: 'WorkforceAssignment',
   semanticKey: ['WorkforceAssignment'],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #M
   }
}
@Metadata.allowExtensions:true
//............................................................................................................................

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

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


define view entity I_WorkforceAssignment_1
  as select from wfd_d_assgmt as Assgmt
  association [0..*] to I_WorkAssignmentDetail_1 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,
      block_ind                  as IsBlocked,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Details
}

Learn More