I_WorkforceAvailabilityByUser

DDL: I_WORKFORCEAVAILABILITYBYUSER Type: view_entity COMPOSITE Package: VDM_TIMESHEET_CORE

Workforce availability for user

I_WorkforceAvailabilityByUser is a Composite CDS View that provides data about "Workforce availability for user" in SAP S/4HANA. It reads from 1 data source (I_BusinessUserBasic) and exposes 6 fields. Part of development package VDM_TIMESHEET_CORE.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessUserBasic BusinessUser from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Workforce availability for user view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
WorkAssignmentExternalID Workforce WorkAssignmentExternalID
Country2DigitISOCode Workforce Country2DigitISOCode
CalendarDate Availability CalendarDate
PlannedWorkingHours Availability PlannedWorkingHours
AbsenceInHours Availability AbsenceInHours
UserID I_BusinessUserBasic UserID 
@AccessControl:{
       authorizationCheck: #MANDATORY,
       personalData.blocking:#NOT_REQUIRED
}
@VDM.viewType: #COMPOSITE
@ObjectModel: {
   usageType: {
     serviceQuality: #C,
     sizeCategory:   #XL,
     dataClass:      #MASTER
   }
}
@EndUserText.label: 'Workforce availability for user'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_WorkforceAvailabilityByUser
  as select from           I_BusinessUserBasic            as BusinessUser
    left outer to one join I_WorkAssignmentKeyMapping     as Workforce    on Workforce.BusinessPartner = BusinessUser.BusinessPartner
    left outer to one join I_TimeOverviewByWrkAgrmtAndDte as Availability on Workforce.WorkAssignment = Availability.PersonWorkAgreement

{
     Workforce.WorkAssignmentExternalID as WorkAssignmentExternalID,
     Workforce.Country2DigitISOCode     as Country2DigitISOCode,
     Availability.CalendarDate          as CalendarDate,
        Availability.PlannedWorkingHours   as PlannedWorkingHours,
        Availability.AbsenceInHours        as AbsenceInHours,

        case
        when Workforce.IsContingentWorker = 'X'
        then cast( 'S4H_EXT' as catsvarian )
        else cast( 'S4H_INT' as catsvarian )
        end                                as TimeSheetDataEntryProfile,

        BusinessUser.UserID

}

Learn More