I_WorkforceAvailabilityByUser

DDL: I_WORKFORCEAVAILABILITYBYUSER Type: view_entity COMPOSITE Package: VDM_TIMESHEET_CORE
6 Fields 1 Data Sources

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.

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 WFA Ext. ID
Country2DigitISOCode Workforce Country2DigitISOCode Country/Region
CalendarDate Availability CalendarDate Calendar Date
PlannedWorkingHours Availability PlannedWorkingHours
AbsenceInHours Availability AbsenceInHours
UserID I_BusinessUserBasic UserID User Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkforceAvailabilityByUser.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_WorkforceAvailabilityByUser AS
SELECT
  Workforce.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  Workforce.Country2DigitISOCode AS Country2DigitISOCode,
  Availability.CalendarDate AS CalendarDate,
  Availability.PlannedWorkingHours AS PlannedWorkingHours,
  Availability.AbsenceInHours AS AbsenceInHours,
  BusinessUser.UserID AS UserID
FROM I_BusinessUserBasic AS BusinessUser
;

Learn More