I_TimeSheetMissingHoursPerDay

DDL: I_TIMESHEETMISSINGHOURSPERDAY Type: view_entity COMPOSITE Package: VDM_TIMESHEET_CORE
7 Fields 1 Data Sources

Missing hours for each day

I_TimeSheetMissingHoursPerDay is a Composite CDS View that provides data about "Missing hours for each day" in SAP S/4HANA. It reads from 1 data source (I_TimeSheetAndAvailyKPI) and exposes 7 fields with key fields WorkAssignmentExternalID, Country2DigitISOCode, CalendarDate. Part of development package VDM_TIMESHEET_CORE.

Data Sources (1)

SourceAliasJoin Type
I_TimeSheetAndAvailyKPI TimeSheetMisgHrs from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Missing hours for each day view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentExternalID I_TimeSheetAndAvailyKPI WorkAssignmentExternalID WFA Ext. ID
KEY Country2DigitISOCode I_TimeSheetAndAvailyKPI Country2DigitISOCode Country/Region
KEY CalendarDate I_TimeSheetAndAvailyKPI CalendarDate Calendar Date
NormalWorkingTimeInHours I_TimeSheetAndAvailyKPI NormalWorkingTimeInHours
WorkforceAssignmentIsPrimary I_TimeSheetAndAvailyKPI WorkforceAssignmentIsPrimary Checkbox
UserID I_TimeSheetAndAvailyKPI UserID User Name
NumberOfDaysForTimeSheetMisgHr DataEntryProfile NumberOfDaysForTimeSheetMisgHr

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_TimeSheetMissingHoursPerDay.
-- 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_TimeSheetMissingHoursPerDay AS
SELECT
  TimeSheetMisgHrs.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  TimeSheetMisgHrs.Country2DigitISOCode AS Country2DigitISOCode,
  TimeSheetMisgHrs.CalendarDate AS CalendarDate,
  TimeSheetMisgHrs.NormalWorkingTimeInHours AS NormalWorkingTimeInHours,
  TimeSheetMisgHrs.WorkforceAssignmentIsPrimary AS WorkforceAssignmentIsPrimary,
  TimeSheetMisgHrs.UserID AS UserID,
  DataEntryProfile.NumberOfDaysForTimeSheetMisgHr AS NumberOfDaysForTimeSheetMisgHr
FROM I_TimeSheetAndAvailyKPI AS TimeSheetMisgHrs
;

Learn More