I_HCMTimeEvent

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_HCMTimeEvent.
-- 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_HCMTimeEvent AS
SELECT
  PersonnelNumber,
  HCMTimeEventDate,
  HCMTimeEventOperation,
  HCMTimeRequestVersion,
  HCMTimeEventTime,
  HCMTimeEventType,
  HCMTimeEventAttndncAbsncReason,
  HCMTimeEventStatus,
  HCMTimeEventCreationDate,
  HCMTimeEventCreationTime,
  HCMTimeEventTerminalID,
  HCMTimeEventOrigin,
  HCMTimeEvtDayAssgmt,
  HCMTimeEvtTimeRecordingID,
  HCMTimeRequestItemListID,
  HCMTimeEventApprover,
  HCMTimeEventInstanceID,
  HCMTimeRequestID,
  _Note.HCMTimeRequestNoteText AS HCMTimeEventNoteText,
  abap.string'' AS HCMTimeEventDetailedNoteText,
  HCMObjectType,
  HCMPosition,
  PayScaleGroup,
  PayScaleLevel,
  HCMPremiumNumberCode,
  HCMPremiumIndicatorCode,
  HCMExtraPayIndicatorCode,
  HCMValuationBasisAmount,
  HCMCurrency,
  HCMActivityType,
  HCMCostObject,
  WBSElementExternalID,
  NetworkNumberForAcctAssgmt,
  SalesDocument,
  SalesDocumentItem,
  BusinessProcess,
  HCMFundsCenter,
  HCMCostAssgmtFund,
  HCMCostCenter,
  CompanyCode,
  HCMBusinessArea,
  HCMTimeEventItemText,
  HCMServiceType,
  HCMServiceCategory,
  HCMFunctionalArea,
  GrantID,
  HCMTimeEvtCommitmentItemInt,
  HCMTimeEvtCommitmentItemExt,
  BudgetPeriod,
  HCMTimeReqFreeDefined01Value,
  HCMTimeReqFreeDefined02Value,
  HCMTimeReqFreeDefined03Value,
  HCMTimeReqFreeDefined04Value,
  HCMTimeReqFreeDefined05Value,
  HCMTimeReqFreeDefined06Value,
  HCMTimeReqFreeDefined07Value,
  HCMTimeReqFreeDefined08Value,
  HCMTimeReqFreeDefined09Value,
  HCMTimeReqFreeDefined10Value
FROM I_HCMTimeEventBase
LEFT OUTER JOIN I_WorkflowTask AS _WorkflowTaskInternalID ON HCMTimeEventInstanceID = _WorkflowTaskInternalID.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeEventNoteInfo AS _Note ON _Note.HCMTimeRequestID = HCMTimeRequestID  -- association [0..1]
LEFT OUTER JOIN I_HCMTimeEventType AS _HCMTimeEventType ON _HCMTimeEventType.PersonnelNumber = PersonnelNumber AND _HCMTimeEventType.HCMTimeEventDate = HCMTimeEventDate AND _HCMTimeEventType.HCMTimeEventType = HCMTimeEventType  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployee AS _HCMEmployee ON _HCMEmployee.HCMPersonnelNumber = HCMTimeEventApprover  -- association [0..1]
;