C_TimeSheetAndAvailyKPI

DDL: C_TIMESHEETANDAVAILYKPI Type: view_entity CONSUMPTION Package: ODATA_TIMESHEET_MAN
18 Fields 1 Data Sources 2 OData Services

Timesheet and availability KPIs

C_TimeSheetAndAvailyKPI is a Consumption CDS View that provides data about "Timesheet and availability KPIs" in SAP S/4HANA. It reads from 1 data source (I_TimeSheetAndAvailyKPI) and exposes 18 fields with key fields WorkAssignmentExternalID, Country2DigitISOCode, CalendarDate. It is exposed through 2 OData services (ASQL_F1823A, UI_TIMESHEET_MANAGE). Part of development package ODATA_TIMESHEET_MAN.

Data Sources (1)

SourceAliasJoin Type
I_TimeSheetAndAvailyKPI I_TimeSheetAndAvailyKPI from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Timesheet and availability KPIs view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F1823A ASQL_F1823A C2 NOT_RELEASED
UI_TIMESHEET_MANAGE UI_TIMESHEET_MANAGE V4 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentExternalID WorkAssignmentExternalID WFA Ext. ID
KEY Country2DigitISOCode Country2DigitISOCode Country/Region
KEY CalendarDate CalendarDate Calendar Date
TimeSheetReadyToSubmitHours TimeSheetReadyToSubmitHours
TimeSheetSubmittedForApprvlHrs TimeSheetSubmittedForApprvlHrs
TimeSheetApprovedHours TimeSheetApprovedHours
TimeSheetRejectedHours TimeSheetRejectedHours
TimeSheetSubmittedHours TimeSheetSubmittedHours
TimeSheetNotSubmittedHours TimeSheetNotSubmittedHours
TimeSheetTotalRecordedHours TimeSheetTotalRecordedHours
TimeSheetDraftHours TimeSheetDraftHours
NormalWorkingTimeInHours NormalWorkingTimeInHours
WorkforceAvailabilityMaintSts WorkforceAvailabilityMaintSts
AbsenceInHours AbsenceInHours
IsNonWorkingDay IsNonWorkingDay
PublicHolidayClass PublicHolidayClass
WorkforceAssignmentIsPrimary WorkforceAssignmentIsPrimary Checkbox
TimeSheetDailyKeyStatus TimeSheetDailyKeyStatus

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 C_TimeSheetAndAvailyKPI.
-- 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 C_TimeSheetAndAvailyKPI AS
SELECT
  WorkAssignmentExternalID,
  Country2DigitISOCode,
  CalendarDate,
  TimeSheetReadyToSubmitHours,
  TimeSheetSubmittedForApprvlHrs,
  TimeSheetApprovedHours,
  TimeSheetRejectedHours,
  TimeSheetSubmittedHours,
  TimeSheetNotSubmittedHours,
  TimeSheetTotalRecordedHours,
  TimeSheetDraftHours,
  NormalWorkingTimeInHours,
  WorkforceAvailabilityMaintSts,
  AbsenceInHours,
  IsNonWorkingDay,
  PublicHolidayClass,
  WorkforceAssignmentIsPrimary,
  TimeSheetDailyKeyStatus
FROM I_TimeSheetAndAvailyKPI
;

Learn More