I_HCMTimeRequestHeader

DDL: I_HCMTIMEREQUESTHEADER Type: view_entity BASIC

Time Request Header

I_HCMTimeRequestHeader is a Basic CDS View that provides data about "Time Request Header" in SAP S/4HANA. It reads from 1 data source (ptreq_header) and exposes 18 fields with key fields HCMTimeRequestID, HCMTimeRequestVersion.

Data Sources (1)

SourceAliasJoin Type
ptreq_header ptreq_header from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Time Request Header view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY HCMTimeRequestID request_id Request unique ID
KEY HCMTimeRequestVersion version_no Version No
HCMTimeRequestType request_type Travel item
HCMTimeRequestStatus status Workflow Status
HCMTimeReqInitiatorClassUUID initiator_cls GUID
HCMTimeRequestInitiatorUUID initiator_ins GUID
HCMTimeRequestOwnerClassUUID owner_cls GUID
HCMTimeRequestOwnerUUID owner_ins GUID
HCMTimeReqNxtProcsrClassUUID next_processor_c GUID
HCMTimeRequestNxtProcessorUUID next_processor_i GUID
HCMTimeReqResponsibleClassUUID responsible_cls GUID
HCMTimeRequestResponsibleUUID responsible_ins GUID
HCMTimeRequestItemListID item_list_id ID of Item List
LastChangedByUser mod_user User Name
HCMLastChangedDateTime mod_timestamp Timestamp
HCMLastChangedTimeZone mod_timezone Time Zone
HCMWorkItemID workitem_id Work Item ID
HCMTimeRequestRecurrenceID recurr_req_header_id Document ID

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_HCMTimeRequestHeader.
-- 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_HCMTimeRequestHeader AS
SELECT
  request_id AS HCMTimeRequestID,
  version_no AS HCMTimeRequestVersion,
  request_type AS HCMTimeRequestType,
  status AS HCMTimeRequestStatus,
  initiator_cls AS HCMTimeReqInitiatorClassUUID,
  initiator_ins AS HCMTimeRequestInitiatorUUID,
  owner_cls AS HCMTimeRequestOwnerClassUUID,
  owner_ins AS HCMTimeRequestOwnerUUID,
  next_processor_c AS HCMTimeReqNxtProcsrClassUUID,
  next_processor_i AS HCMTimeRequestNxtProcessorUUID,
  responsible_cls AS HCMTimeReqResponsibleClassUUID,
  responsible_ins AS HCMTimeRequestResponsibleUUID,
  item_list_id AS HCMTimeRequestItemListID,
  mod_user AS LastChangedByUser,
  mod_timestamp AS HCMLastChangedDateTime,
  mod_timezone AS HCMLastChangedTimeZone,
  workitem_id AS HCMWorkItemID,
  recurr_req_header_id AS HCMTimeRequestRecurrenceID
FROM ptreq_header
;