I_HCMProcessRecordTP

DDL: I_HCMPROCESSRECORDTP Type: view_entity TRANSACTIONAL
64 Fields 1 Data Sources 5 Associations

HCM Process record details - TP

I_HCMProcessRecordTP is a Transactional CDS View that provides data about "HCM Process record details - TP" in SAP S/4HANA. It reads from 1 data source (I_HCMProcessRecord) and exposes 64 fields with key fields HCMProcessNameCode, HCMProcessUUID, HCMProcessWorkItemID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_HCMProcessRecord I_HCMProcessRecord from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_HCMProcessLinkTP _HCMProcessLink
[0..*] I_HCMProcessFieldMetadataTP _HCMProcessFieldMetadata
[0..*] I_HCMProcessAttachmentTP _HCMProcessAttachment
[0..*] I_HCMProcFldValHelpTP _HCMProcFldValHelp
[0..*] I_HCMProcessUserEventTP _HCMProcessUserEvent

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label HCM Process record details - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name HCMProcessRecord view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY HCMProcessNameCode HCMProcessNameCode Process
KEY HCMProcessUUID HCMProcessUUID Case Key
KEY HCMProcessWorkItemID HCMProcessWorkItemID Work Item ID
HCMProcScenarioName HCMProcScenarioName Scenario
HCMProcessStageName HCMProcessStageName Scenario Step
HCMProcScenarioVersion HCMProcScenarioVersion ScenarioVersion
HCMProcessInitiatorRole HCMProcessInitiatorRole Initiator Role
HCMProcessEventName HCMProcessEventName Operation
HCMProcessAffectedObjectType HCMProcessAffectedObjectType Object Type
HCMPersonnelNumber HCMPersonnelNumber Personnel No.
HCMProcessAffectedObject HCMProcessAffectedObject Object Key
HCMProcessReferenceNumber HCMProcessReferenceNumber Reference Number
HCMProcProcessorName HCMProcProcessorName
HCMProcessAffectedName HCMProcessAffectedName Name
HCMProcessIsStartObject HCMProcessIsStartObject Yes/No
HCMProcessIsOnBehalf HCMProcessIsOnBehalf Yes/No
HCMProcessGroupName HCMProcessGroupName Description
HCMProcessDescription HCMProcessDescription Process Name
HCMProcessIsCustomTable HCMProcessIsCustomTable Yes/No
HCMPersonnelActionType HCMPersonnelActionType Action Type
HCMPersonnelActionReason HCMPersonnelActionReason Reason f.Action
HCMProcessEffectiveDate HCMProcessEffectiveDate Date
HCMCentralPerson HCMCentralPerson WorkForce Master ID
HCMProcessHasAttachments HCMProcessHasAttachments
HCMProcMaxNrOfAttachments HCMProcMaxNrOfAttachments INT4
HCMProcessCommentsText HCMProcessCommentsText
HCMProcessPrevCommentsText HCMProcessPrevCommentsText
HCMProcessAttachMaxSize HCMProcessAttachMaxSize
HCMProcessHasComments HCMProcessHasComments
HCMProcessIsLiteModeCompatible HCMProcessIsLiteModeCompatible
HCMProcUIAttribute HCMProcUIAttribute UI Attribute
HCMProcessIsAddRowEnabled HCMProcessIsAddRowEnabled Yes/No
HCMProcessIsInputHelpEnabled HCMProcessIsInputHelpEnabled Yes/No
HCMProcessAuthorName HCMProcessAuthorName
HCMProcessStatus HCMProcessStatus Process Status
HCMProcessStatusCriticality HCMProcessStatusCriticality Integer
HCMProcessStartDate HCMProcessStartDate Start Date
HCMProcessStartTime HCMProcessStartTime Start Time
HCMProcessStepCompletionDate HCMProcessStepCompletionDate Timestamp
HCMProcessStepCompletionTime HCMProcessStepCompletionTime End Time
HCMProcStatusAfterUserAction HCMProcStatusAfterUserAction Work Item ID
HCMProcessFormType HCMProcessFormType P&F Form Type
HCMProcessFormLayout HCMProcessFormLayout Tab layout
HCMProcessIsAllStepsDisplayed HCMProcessIsAllStepsDisplayed
HCMProcessStepUUID HCMProcessStepUUID UUID
HCMFormTemplateName HCMFormTemplateName PO Layout Tmpl.
HCMProcessApplicationType HCMProcessApplicationType Appl. Type
HCMProcessInitiatorUserID HCMProcessInitiatorUserID ProcessInitiator
HCMProcessWebDynproURL HCMProcessWebDynproURL Value
HCMProcessAutoSaveTimeInterval HCMProcessAutoSaveTimeInterval
HCMProcessStatusText HCMProcessStatusText Status Text
HCMObjectTypeName HCMObjectTypeName Object type
PersonFullName PersonFullName Full Name
HCMProcessIsTimeTicker HCMProcessIsTimeTicker
HCMProcStatAfterActionText HCMProcStatAfterActionText Short Description
HCMProcStatAfterActCriticality HCMProcStatAfterActCriticality Completed Processes
HCMProcessAttachMaxSizeUnit HCMProcessAttachMaxSizeUnit Unit of Measure
HCMProcessErrMsgText HCMProcessErrMsgText
HCMProcessAttchMimeTypeTxt HCMProcessAttchMimeTypeTxt Attac.MIME Type
_HCMProcessLink _HCMProcessLink
_HCMProcessFieldMetadata _HCMProcessFieldMetadata
_HCMProcessAttachment _HCMProcessAttachment
_HCMProcFldValHelp _HCMProcFldValHelp
_HCMProcessUserEvent _HCMProcessUserEvent

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_HCMProcessRecordTP.
-- 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_HCMProcessRecordTP AS
SELECT
  HCMProcessNameCode,
  HCMProcessUUID,
  HCMProcessWorkItemID,
  HCMProcScenarioName,
  HCMProcessStageName,
  HCMProcScenarioVersion,
  HCMProcessInitiatorRole,
  HCMProcessEventName,
  HCMProcessAffectedObjectType,
  HCMPersonnelNumber,
  HCMProcessAffectedObject,
  HCMProcessReferenceNumber,
  HCMProcProcessorName,
  HCMProcessAffectedName,
  HCMProcessIsStartObject,
  HCMProcessIsOnBehalf,
  HCMProcessGroupName,
  HCMProcessDescription,
  HCMProcessIsCustomTable,
  HCMPersonnelActionType,
  HCMPersonnelActionReason,
  HCMProcessEffectiveDate,
  HCMCentralPerson,
  HCMProcessHasAttachments,
  HCMProcMaxNrOfAttachments,
  HCMProcessCommentsText,
  HCMProcessPrevCommentsText,
  HCMProcessAttachMaxSize,
  HCMProcessHasComments,
  HCMProcessIsLiteModeCompatible,
  HCMProcUIAttribute,
  HCMProcessIsAddRowEnabled,
  HCMProcessIsInputHelpEnabled,
  HCMProcessAuthorName,
  HCMProcessStatus,
  HCMProcessStatusCriticality,
  HCMProcessStartDate,
  HCMProcessStartTime,
  HCMProcessStepCompletionDate,
  HCMProcessStepCompletionTime,
  HCMProcStatusAfterUserAction,
  HCMProcessFormType,
  HCMProcessFormLayout,
  HCMProcessIsAllStepsDisplayed,
  HCMProcessStepUUID,
  HCMFormTemplateName,
  HCMProcessApplicationType,
  HCMProcessInitiatorUserID,
  HCMProcessWebDynproURL,
  HCMProcessAutoSaveTimeInterval,
  HCMProcessStatusText,
  HCMObjectTypeName,
  PersonFullName,
  HCMProcessIsTimeTicker,
  HCMProcStatAfterActionText,
  HCMProcStatAfterActCriticality,
  HCMProcessAttachMaxSizeUnit,
  HCMProcessErrMsgText,
  HCMProcessAttchMimeTypeTxt
FROM I_HCMProcessRecord
LEFT OUTER JOIN I_HCMProcessLinkTP AS _HCMProcessLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_HCMProcessFieldMetadataTP AS _HCMProcessFieldMetadata ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_HCMProcessAttachmentTP AS _HCMProcessAttachment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_HCMProcFldValHelpTP AS _HCMProcFldValHelp ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_HCMProcessUserEventTP AS _HCMProcessUserEvent ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More