R_WORKASSIGNMENT_1

CDS View

Work Assignments

R_WORKASSIGNMENT_1 is a CDS View in S/4HANA. Work Assignments. It contains 9 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 9 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_WorkAssignmentPayment_1 view_entity from TRANSACTIONAL Work assignment Payment details
R_WorkAssignmentTP_1 view_entity from TRANSACTIONAL Work Assignments
R_WorkAssignmentTP_3 view_entity from TRANSACTIONAL Work Assignments
R_WorkforcePersonTag_1 view_entity inner BASIC WorkforcePerson Tags Basic View
R_WrkAssgmtSrvcCostLvl_1 view_entity from BASIC Service Cost level of a Work Assignment
R_WrkAssgmtWrkOrdDet view_entity from TRANSACTIONAL Workorder details for Work Assignment

Fields (9)

KeyField CDS FieldsUsed in Views
KEY Country2DigitISOCode Country2DigitISOCode 6
KEY WorkAssignmentExternalID WorkAssignmentExternalID 6
KEY WorkAssignmentStartDate WorkAssignmentStartDate 3
KEY WorkforcePersonExternalID WorkforcePersonExternalID 4
BusinessPartner BusinessPartner 2
IsBlocked IsBlocked 4
IsContingentWorker IsContingentWorker 2
WorkAssignment WorkAssignment 3
WorkAssignmentEndDate WorkAssignmentEndDate 3 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Work Assignments'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #TRANSACTIONAL
}
define view entity R_WorkAssignment_1
  as select from P_WORKASSIGNMENT       as Workassignment
    inner join   P_WORKASSIGNMENTKEYMAP as WorkAssignmentKeymap on Workassignment.WorkAssignment = WorkAssignmentKeymap.WorkAssignment
{

  key Workassignment.WorkAssignment,
      Workassignment.WorkAssignmentStartDate,
      Workassignment.WorkAssignmentEndDate,
      WorkAssignmentKeymap.BusinessPartner,
      Workassignment.WorkAssignmentExternalID,
      Workassignment.IsBlocked,
      Workassignment.IsContingentWorker,

      // Keymapping

      WorkAssignmentKeymap.Country2DigitISOCode,
      WorkAssignmentKeymap.WorkforcePersonID,
      cast(upper(WorkAssignmentKeymap.WorkforcePersonExternalID) as wfd_person_id_external preserving type ) as WorkforcePersonExternalID,
      //      upper(WorkAssignmentKeymap.WorkforcePersonExternalID) as WorkforcePersonExternalID,

      WorkAssignmentKeymap.WorkforcePersonDataSource

}
where
  WorkAssignmentKeymap.BusinessPartner is not initial;

Learn More