I_HCMTimeEventCore

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_HCMTimeEventCore.
-- 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_HCMTimeEventCore AS
SELECT
  tptcor_core.pernr AS PersonnelNumber,
  tptcor_core.ldate AS HCMTimeEventDate,
  cast(_Header.request_id as char32) AS HCMTimeEventID,
  Item.item_list_no AS HCMTimeReqItemListSqncNumber,
  tptcor_core.operation AS HCMTimeEventOperation,
  _Header.version_no AS HCMTimeRequestVersion,
  tptcor_core.ltime AS HCMTimeEventTime,
  tptcor_core.satza AS HCMTimeEventType,
  tptcor_core.abwgr AS HCMTimeEventAttndncAbsncReason,
  _Header.status AS HCMTimeEventStatus,
  tptcor_core.erdat AS HCMTimeEventCreationDate,
  tptcor_core.ertim AS HCMTimeEventCreationTime,
  dats_tims_to_tstmp( tptcor_core.erdat, tptcor_core.ertim, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as HCMTimeEventCreationDateTime AS clientNULLasHCMTimeEventCreationDateTime,
  tptcor_core.terid AS HCMTimeEventTerminalID,
  tptcor_core.origf AS HCMTimeEventOrigin,
  cast(tptcor_core.dallf as char1) AS HCMTimeEvtDayAssgmt,
  tptcor_core.zausw AS HCMTimeEvtTimeRecordingID,
  tptcor_core.item_id AS HCMTimeRequestItemListID,
  cast(_approver.objid as pernr_d) AS HCMTimeEventApprover,
  _Header.mod_timestamp AS HCMTimeEventModifDateTime,
  _Header.workitem_id AS HCMTimeEventInstanceID,
  _apl.otype AS HCMObjectType,
  _apl.plans AS HCMPosition,
  _apl.trfgr AS PayScaleGroup,
  _apl.trfst AS PayScaleLevel,
  _apl.prakn AS HCMPremiumNumberCode,
  _apl.prakz AS HCMPremiumIndicatorCode,
  _apl.aufkz AS HCMExtraPayIndicatorCode,
  _apl.bwgrl AS HCMValuationBasisAmount,
  _apl.waers AS HCMCurrency,
  _kostl.ltlst AS HCMActivityType,
  _kostl.kstrg AS HCMCostObject,
  cast(_kostl.posid as ps_posid_edit ) AS WBSElementExternalID,
  _kostl.nplnr AS NetworkNumberForAcctAssgmt,
  _kostl.kdauf AS SalesDocument,
  _kostl.kdpos AS SalesDocumentItem,
  _kostl.prznr AS BusinessProcess,
  _kostl.fistl AS HCMFundsCenter,
  _kostl.geber AS HCMCostAssgmtFund,
  _kostl.skost AS HCMCostCenter,
  _kostl.sbukr AS CompanyCode,
  _kostl.sgsbr AS HCMBusinessArea,
  _kostl.sgtxt AS HCMTimeEventItemText,
  _kostl.dart AS HCMServiceType,
  _kostl.udart AS HCMServiceCategory,
  _kostl.fkber AS HCMFunctionalArea,
  _kostl.grant_nbr AS GrantID,
  cast(_kostl.fipos as char14) AS HCMTimeEvtCommitmentItemInt,
  _kostl.fipex AS HCMTimeEvtCommitmentItemExt,
  _kostl.budget_pd AS BudgetPeriod,
  _cust.customer01 AS HCMTimeReqFreeDefined01Value,
  _cust.customer02 AS HCMTimeReqFreeDefined02Value,
  _cust.customer03 AS HCMTimeReqFreeDefined03Value,
  _cust.customer04 AS HCMTimeReqFreeDefined04Value,
  _cust.customer05 AS HCMTimeReqFreeDefined05Value,
  _cust.customer06 AS HCMTimeReqFreeDefined06Value,
  _cust.customer07 AS HCMTimeReqFreeDefined07Value,
  _cust.customer08 AS HCMTimeReqFreeDefined08Value,
  _cust.customer09 AS HCMTimeReqFreeDefined09Value,
  _cust.customer10 AS HCMTimeReqFreeDefined10Value
FROM tptcor_core
LEFT OUTER JOIN ptreq_actor AS _approver ON _approver.actor_id = _Header.next_processor_i  -- association [0..1]
LEFT OUTER JOIN tptcor_apl AS _apl ON HCMTimeRequestItemListID = _apl.item_id  -- association [0..1]
LEFT OUTER JOIN tptcor_kostl AS _kostl ON HCMTimeRequestItemListID = _kostl.item_id  -- association [0..1]
LEFT OUTER JOIN tptcor_customer AS _cust ON HCMTimeRequestItemListID = _cust.item_id  -- association [0..1]
;