I_HCMTimeEvtReqCore

DDL: I_HCMTIMEEVTREQCORE Type: view_entity BASIC
15 Fields 1 Data Sources 1 Associations

HCM Time Events Request Core Info

I_HCMTimeEvtReqCore is a Basic CDS View that provides data about "HCM Time Events Request Core Info" in SAP S/4HANA. It reads from 1 data source (tptcor_core) and exposes 15 fields with key field HCMTimeRequestItemListID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tptcor_core tptcor_core from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_HCMPersonWorkAgreement _HCMPersonWorkAgreement _HCMPersonWorkAgreement.PersonWorkAgreement = $projection.PersonnelNumber

Annotations (7)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label HCM Time Events Request Core Info view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY HCMTimeRequestItemListID item_id Simulation Item ID
HCMTimeEventOperation operation Transaction
HCMTimeEventID Number
PersonnelNumber pernr Personnel no.
HCMTimeEventDate ldate Entry Date
HCMTimeEventTime ltime Time received
HCMTimeEventCreationDate erdat Entered On
HCMTimeEventCreationTime ertim Time
HCMTimeEventType satza Time event type
HCMTimeEventTerminalID terid Terminal ID
HCMTimeEventAttndncAbsncReason abwgr Undefined range (can be used for patch levels)
HCMTimeEventOrigin origf Origin
HCMTimeEvtDayAssgmt Single-Character Flag
HCMTimeEvtTimeRecordingID zausw Time rec.ID no.
_HCMPersonWorkAgreement _HCMPersonWorkAgreement

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_HCMTimeEvtReqCore.
-- 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_HCMTimeEvtReqCore AS
SELECT
  item_id AS HCMTimeRequestItemListID,
  operation AS HCMTimeEventOperation,
  cast(pdsnr as char32) AS HCMTimeEventID,
  pernr AS PersonnelNumber,
  ldate AS HCMTimeEventDate,
  ltime AS HCMTimeEventTime,
  erdat AS HCMTimeEventCreationDate,
  ertim AS HCMTimeEventCreationTime,
  satza AS HCMTimeEventType,
  terid AS HCMTimeEventTerminalID,
  abwgr AS HCMTimeEventAttndncAbsncReason,
  origf AS HCMTimeEventOrigin,
  cast(dallf as char1) AS HCMTimeEvtDayAssgmt,
  zausw AS HCMTimeEvtTimeRecordingID
FROM tptcor_core
LEFT OUTER JOIN I_HCMPersonWorkAgreement AS _HCMPersonWorkAgreement ON _HCMPersonWorkAgreement.PersonWorkAgreement = PersonnelNumber  -- association [0..1]
;

Learn More