R_WORKASSIGNMENTDETAIL_1

CDS View

Work Assignment Details

R_WORKASSIGNMENTDETAIL_1 is a CDS View in S/4HANA. Work Assignment Details. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_WorkAssignmentDetailTP_1 view_entity from TRANSACTIONAL Work Assignment Details
R_WorkAssignmentDetailTP_3 view_entity from TRANSACTIONAL Work Assignment Details 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Work Assignment Details'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
define view entity R_WorkAssignmentDetail_1
  as select from P_WORKASSIGNMENTDETAILS as WorkAssignmentDetails

  //    inner join   R_Workassignment_1      as WorkAssignment on WorkAssignmentDetails.WorkAssignment = WorkAssignment.WorkAssignment

    inner join   P_WORKASSIGNMENTKEYMAP  as WorkAssignmentKeymap on WorkAssignmentDetails.WorkAssignment = WorkAssignmentKeymap.WorkAssignment
    inner join   P_WORKASSIGNMENT        as Workassignment       on Workassignment.WorkAssignment = WorkAssignmentKeymap.WorkAssignment

{

  key WorkAssignmentDetails.WorkAssignment,
  key WorkAssignmentDetails.WorkAssignmentStartDate,
      WorkAssignmentDetails.WorkAssignmentEndDate,
      WorkAssignmentKeymap.BusinessPartner,
      WorkAssignmentKeymap.WorkAssignmentExternalID,
      //      upper(WorkAssignmentKeymap.WorkforcePersonExternalID) as WorkforcePersonExternalID,

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

      @Semantics.booleanIndicator: true
      WorkAssignmentDetails.WorkAssignmentStatus,
      WorkAssignmentDetails.EmploymentPercent,
      WorkAssignmentDetails.CompanyCode,
      WorkAssignmentDetails.CostCenter,
      WorkAssignmentDetails.ControllingArea,
      WorkAssignmentDetails.WeeklyWorkingHours,
      WorkAssignmentDetails.WeeklyWorkingDays,
      WorkAssignmentDetails.WorkAssignmentJobTitle,
      WorkAssignmentDetails.WorkAssignmentJobCode,
      WorkAssignmentDetails.SupervisorWorkAssignmentID,
      WorkAssignmentDetails.Country2DigitISOCode,
      WorkAssignmentDetails.SupervisorWorkAssignmentExtID,
      @Semantics.booleanIndicator: true
      WorkAssignmentDetails.WorkforceAssignmentIsPrimary,
      @Semantics.booleanIndicator: true
      Workassignment.IsBlocked
}
where
      WorkAssignmentDetails.CompanyCode    is not initial
  and WorkAssignmentKeymap.BusinessPartner is not initial;

Learn More