I_HCMProcessBasic

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_HCMProcessBasic.
-- 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_HCMProcessBasic AS
SELECT
  case_guid AS HCMProcessUUID,
  reference_number AS HCMProcessReferenceNumber,
  process AS HCMProcessNameCode,
  initiator AS HCMProcessInitiatorUserID,
  initiator_role AS HCMProcessInitiatorRole,
  xi_scenario AS HCMProcessRecruitingScenario,
  application AS HCMProcessApplicationType,
  object_key AS HCMProcessAffectedObject,
  init_date AS HCMProcessStartDate,
  init_time AS HCMProcessStartTime,
  init_tst AS HCMProcessStartDateTime,
  init_delta AS HCMProcessStartTimeDiff,
  completion_date AS HCMProcessCompletionDate,
  completion_time AS HCMProcessCompletionTime,
  completion_tst AS HCMProcessCompltnDateTime,
  completion_delta AS HCMProcessCompltnTimeDiff,
  no_of_attachment AS HCMProcessNumberOfAttachments,
  error_occured AS HCMProcessHasError,
  version AS HCMProcessObjectVersionValue,
  initiator_busi AS HCMProcessBusinessUserID,
  object_title AS HCMProcAffcdObjDesc,
  object_type AS HCMProcessAffectedObjectType,
  group_ref_number AS HCMProcessGroupReferenceNumber,
  process_group AS HCMProcessGroup,
  effective_date AS HCMProcessEffectiveDate
FROM t5asrprocesses
LEFT OUTER JOIN I_HCMProcessName AS _HCMProcessName ON HCMProcessNameCode = _HCMProcessName.HCMProcessNameCode  -- association [0..1]
LEFT OUTER JOIN I_HCMProcInitiatorRole AS _HCMProcessInitiatorRole ON HCMProcessInitiatorRole = _HCMProcessInitiatorRole.HCMProcessInitiatorRole  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessStatus AS _HCMProcessStatus ON HCMProcessStatus = _HCMProcessStatus.HCMProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessApplicationType AS _HCMProcessApplicationType ON HCMProcessApplicationType = _HCMProcessApplicationType.HCMProcessApplicationType  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessAffectedObject AS _HCMProcessAffectedObject ON HCMProcessAffectedObjectType = _HCMProcessAffectedObject.HCMObjectType AND HCMProcessAffectedObject = _HCMProcessAffectedObject.HCMProcessAffectedObject  -- association [0..*]
LEFT OUTER JOIN I_HCMProcessAffectedObjectType AS _HCMProcessAffectedObjectType ON HCMProcessAffectedObjectType = _HCMProcessAffectedObjectType.HCMObjectType  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessGroup AS _HCMProcessGroup ON HCMProcessGroup = _HCMProcessGroup.HCMProcessGroup  -- association [0..1]
;