I_HCMTimeShtAttndncAbsncType

DDL: I_HCMTIMESHTATTNDNCABSNCTYPE Type: view_entity BASIC
9 Fields 4 Data Sources 2 Associations

HCM Timesheet Attendance Absence Types

I_HCMTimeShtAttndncAbsncType is a Basic CDS View that provides data about "HCM Timesheet Attendance Absence Types" in SAP S/4HANA. It reads from 4 data sources (I_CalendarDate, I_HCMAttendanceAbsenceTypeText, I_HCMOrganizationalAssignment, I_HCMPersonnelSubarea) and exposes 9 fields with key fields HCMAttendanceAbsenceType, PersonnelNumber, HCMWorkDate. It has 2 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_CalendarDate _WorkDate inner
I_HCMAttendanceAbsenceTypeText AttAbsType from
I_HCMOrganizationalAssignment I_HCMOrganizationalAssignment inner
I_HCMPersonnelSubarea I_HCMPersonnelSubarea inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate _CalendarDate.CalendarDate = $projection.HCMWorkDate
[0..1] I_HCMEmployee _HCMEmployee _HCMEmployee.HCMPersonnelNumber = $projection.PersonnelNumber

Annotations (9)

NameValueLevelField
EndUserText.label HCM Timesheet Attendance Absence Types view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey HCMAttendanceAbsenceType view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #BASIC view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY HCMAttendanceAbsenceType I_HCMAttendanceAbsenceTypeText HCMAttendanceAbsenceType Att./abs. type
KEY PersonnelNumber I_HCMOrganizationalAssignment HCMPersonnelNumber Personnel No.
KEY HCMWorkDate I_CalendarDate CalendarDate Calendar Date
HCMPersonnelSubareaGrouping I_HCMAttendanceAbsenceTypeText HCMPersonnelSubareaGrouping PS grouping
EndDate I_HCMOrganizationalAssignment EndDate Term to
StartDate I_HCMOrganizationalAssignment StartDate Valid From
HCMAttendanceAbsenceTypeName I_HCMAttendanceAbsenceTypeText HCMAttendanceAbsenceTypeName Title
_CalendarDate _CalendarDate
_HCMEmployee _HCMEmployee

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_HCMTimeShtAttndncAbsncType.
-- 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_HCMTimeShtAttndncAbsncType AS
SELECT
  AttAbsType.HCMAttendanceAbsenceType AS HCMAttendanceAbsenceType,
  I_HCMOrganizationalAssignment.HCMPersonnelNumber AS PersonnelNumber,
  _WorkDate.CalendarDate AS HCMWorkDate,
  AttAbsType.HCMPersonnelSubareaGrouping AS HCMPersonnelSubareaGrouping,
  I_HCMOrganizationalAssignment.EndDate AS EndDate,
  I_HCMOrganizationalAssignment.StartDate AS StartDate,
  AttAbsType.HCMAttendanceAbsenceTypeName AS HCMAttendanceAbsenceTypeName
FROM I_HCMAttendanceAbsenceTypeText AS AttAbsType
INNER JOIN I_HCMPersonnelSubarea ON /* join condition not captured in parsed metadata */
INNER JOIN I_HCMOrganizationalAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS _WorkDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = HCMWorkDate  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployee AS _HCMEmployee ON _HCMEmployee.HCMPersonnelNumber = PersonnelNumber  -- association [0..1]
;

Learn More