SWF_FLEX_I_PROCESS

CDS View

Workflow

SWF_FLEX_I_PROCESS is a CDS View in S/4HANA. Workflow. It contains 1 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RTGVERSUIWFL view_entity inner BASIC Workflow state for routings

Fields (1)

KeyField CDS FieldsUsed in Views
Status Status 1
@AbapCatalog.sqlViewName: 'SWFFLEXIVPROC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Workflow'
define view SWF_FLEX_I_PROCESS
  as select from    swwflexproc as process
    left outer join swwwihead   as running on process.wi_id = running.wi_id
{
  key process.appl_obj_id                         as ApplicationObjectID,
      process.scenario_id                         as ScenarioID,
      process.scenario_version                    as ScenarioVersion,
      coalesce( running.wi_stat, process.status ) as Status,
      process.wi_id                               as WorkitemID,
      #boolean.' '                                as IsDraft
}
where
  process.appl_obj_id <> ''
and process.is_review_flow = ''
union select from swf_flex_pdraft as draft
  left outer join swwflexproc     as active  on  draft.orig_appl_obj_id =  active.appl_obj_id
                                             and active.appl_obj_id     <> ''
                                             and active.is_review_flow = ''
  left outer join swwwihead       as running on active.wi_id = running.wi_id

{
  key draft.appl_obj_id                          as ApplicationObjectID,
      draft.scenario_id                          as ScenarioID,
      draft.scenario_version                     as ScenarioVersion,
      coalesce( running.wi_stat, active.status ) as Status,
      active.wi_id                               as WorkitemID,
      #boolean.'X'                               as IsDraft
}