I_HCMPROCESSSTEP

CDS View

HCM Process Step

I_HCMPROCESSSTEP is a CDS View in S/4HANA. HCM Process Step. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_HCMProcessStep view from CONSUMPTION HCM Process Step 
@AbapCatalog: { sqlViewName: 'IHCMPROCESSSTEP',
                compiler.compareFilter: true,
                preserveKey: true,
                buffering.status: #NOT_ALLOWED,
                buffering.type: #NONE }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { representativeKey: 'HCMProcessStepUUID',
                usageType.sizeCategory: #XL,
                usageType.dataClass:  #TRANSACTIONAL,
                usageType.serviceQuality: #C,
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ] }
@VDM.viewType: #COMPOSITE

@EndUserText.label: 'HCM Process Step'
define view I_HCMProcessStep
  as select from I_HCMProcessStepBasic
{
  key HCMProcessStepUUID,
      HCMProcessScenarioUUID,
      HCMProcessStepName,
      Language,
      HCMProcessStepProcessor,
      HCMProcessStepProcessorRole,
      HCMProcessStageName,
      HCMProcessStepStatus,
      case HCMProcessStepStatus when 'COMPLETED' then 3 when 'STARTED' then 2 when 'ERROR' then 1 else 0 end as HCMProcStepStatusCriticality,
      HCMProcessStepStartDate,
      HCMProcessStepStartTime,
      HCMProcessStepStartDateTime,
      HCMProcessStepStartTimeDiff,
      HCMProcessStepCompletionDate,
      HCMProcessStepCompletionTime,
      HCMProcStpCompltnDateTme,
      HCMProcessStepCompltnTimeDiff,
      HCMProcessStepLatestStartDate,
      HCMProcessStepLatestStartTime,
      HCMProcessStepLtstStrtDateTime,
      HCMProcessStepLtstStrtTmeDiff,
      HCMProcessStepLatestEndDate,
      HCMProcessStepLatestEndTime,
      HCMProcessStepLtstEndDateTime,
      HCMProcessStepLtstEndTmeDiff,
      HCMProcessStepFwdByUserName,
      HCMProcStepNmbrOfAttachments,
      cast(case HCMProcStatusAfterUserAction when '' then 'OPEN' else HCMProcStatusAfterUserAction end as asr_processing_status) as HCMProcStatusAfterUserAction,
      HCMProcessBusinessStatus,
      _HCMProcessScenario.HCMProcessUUID,
      _HCMProcessScenario._HCMProcessBasic.HCMProcessNameCode,
      //_HCMProcessStepDetails.HCMProcessGUID,

      //_HCMProcessStepDetails.HCMProcessName,

      _HCMProcessStepDetails.HCMProcessStepChgDateTime,
      _HCMProcessStepDetails.HCMProcessStepDraftDateTime,
      @Semantics.quantity.unitOfMeasure: 'HCMProcessProcgTimeUnit'
      cast(_HCMProcessStepDetails.HCMProcessProcessingDuration as abap.dec(10,1))                            as HCMProcessProcessingDuration,
      //cast(_HCMProcessStepDetails.HCMProcessRetentionTime as abap.dec(10,1)) as HCMProcessRetentionTime,

      //_HCMProcessStepDetails.HCMProcessProcessingTime + _HCMProcessStepDetails.HCMProcessRetentionTime as testProcTime,

      @Semantics.unitOfMeasure: true
      _HCMProcessStepDetails.HCMProcessProcgTimeUnit,
      @Semantics.quantity.unitOfMeasure: 'HCMProcessRetentionTimeUnit'
      _HCMProcessStepDetails.HCMProcessRetentionDuration,
      @Semantics.unitOfMeasure: true
      _HCMProcessStepDetails.HCMProcessRetentionTimeUnit,
      //_HCMProcessStepDetails._HCMProcess,

      _HCMProcessStepDetails._HCMProcessProcgTimeUnit,
      _HCMProcessStepDetails._HCMProcessRetentionTimeUnit,
      /* Associations */
      _HCMProcessScenario,
      _HCMProcessStepDetails,
      _HCMProcProcessorRole,
      _HCMProcessStepStatus      
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HCMPROCESSBASIC",
"I_HCMPROCESSSCENARIO",
"I_HCMPROCESSSTEPBASIC",
"I_HCMPROCESSSTEPDETAILS"
],
"ASSOCIATED":
[
"I_HCMPROCESSSCENARIO",
"I_HCMPROCESSSTEPDETAILS",
"I_HCMPROCESSSTEPSTATUS",
"I_HCMPROCPROCESSORROLE",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_HCMPROCESSSTEPBASIC",
"I_HCMPROCESSSTEPDETAILS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More