I_HCMProcessRecord

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_HCMProcessRecord.
-- 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_HCMProcessRecord AS
SELECT
  process_id AS HCMProcessNameCode,
  process_guid AS HCMProcessUUID,
  workitem_id AS HCMProcessWorkItemID,
  form_scenario AS HCMProcScenarioName,
  form_scenario_stage AS HCMProcessStageName,
  form_scenario_version AS HCMProcScenarioVersion,
  initiator_role AS HCMProcessInitiatorRole,
  process_event AS HCMProcessEventName,
  object_type AS HCMProcessAffectedObjectType,
  personnel_number AS HCMPersonnelNumber,
  object_key AS HCMProcessAffectedObject,
  process_reference_number AS HCMProcessReferenceNumber,
  processor_name AS HCMProcProcessorName,
  affected_name AS HCMProcessAffectedName,
  with_start_object AS HCMProcessIsStartObject,
  is_on_behalf AS HCMProcessIsOnBehalf,
  process_group_name AS HCMProcessGroupName,
  process_text AS HCMProcessDescription,
  custom_table AS HCMProcessIsCustomTable,
  action_type AS HCMPersonnelActionType,
  action_reason AS HCMPersonnelActionReason,
  effective_date AS HCMProcessEffectiveDate,
  central_person AS HCMCentralPerson,
  has_attachments AS HCMProcessHasAttachments,
  max_attachments AS HCMProcMaxNrOfAttachments,
  current_note AS HCMProcessCommentsText,
  previous_notes AS HCMProcessPrevCommentsText,
  attachment_max_size AS HCMProcessAttachMaxSize,
  has_comments AS HCMProcessHasComments,
  is_lite_mode AS HCMProcessIsLiteModeCompatible,
  ui_attribute AS HCMProcUIAttribute,
  add_row AS HCMProcessIsAddRowEnabled,
  isvaluehelp AS HCMProcessIsInputHelpEnabled,
  author_name AS HCMProcessAuthorName,
  process_status_id AS HCMProcessStatus,
  init_date AS HCMProcessStartDate,
  init_time AS HCMProcessStartTime,
  completion_date AS HCMProcessStepCompletionDate,
  completion_time AS HCMProcessStepCompletionTime,
  proc_status AS HCMProcStatusAfterUserAction,
  status_criticality AS HCMProcessStatusCriticality,
  form_type AS HCMProcessFormType,
  layout AS HCMProcessFormLayout,
  show_all_step AS HCMProcessIsAllStepsDisplayed,
  step_guid AS HCMProcessStepUUID,
  form_template AS HCMFormTemplateName,
  application AS HCMProcessApplicationType,
  initiator AS HCMProcessInitiatorUserID,
  wda_url AS HCMProcessWebDynproURL,
  auto_save_interval AS HCMProcessAutoSaveTimeInterval,
  status_text AS HCMProcessStatusText,
  otext AS HCMObjectTypeName,
  name_text AS PersonFullName,
  istimetickerhhmm AS HCMProcessIsTimeTicker,
  status_after_action_text AS HCMProcStatAfterActionText,
  status_after_act_criticality AS HCMProcStatAfterActCriticality,
  attachment_max_size_unit AS HCMProcessAttachMaxSizeUnit,
  errmsgforexpert AS HCMProcessErrMsgText,
  attachment_mimetype AS HCMProcessAttchMimeTypeTxt
FROM hrfio_d_asr_pr
;