P_RTGVERSUIWFL

DDL: P_RTGVERSUIWFL Type: view_entity BASIC Package: MPE_PLAN_RTG_VERS

Workflow state for routings

P_RTGVERSUIWFL is a Basic CDS View that provides data about "Workflow state for routings" in SAP S/4HANA. It reads from 3 data sources (P_RTGVERSUIWFLHLP, SWF_FLEX_I_PROCESS, tca01_subtype) and exposes 6 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsVersion, subtype. Part of development package MPE_PLAN_RTG_VERS.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
P_RTGVERSUIWFLHLP _wflhlp inner
SWF_FLEX_I_PROCESS SWF_FLEX_I_PROCESS inner
tca01_subtype tca from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Workflow state for routings view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType P_RTGVERSUIWFLHLP BillOfOperationsType
KEY BillOfOperationsGroup P_RTGVERSUIWFLHLP BillOfOperationsGroup
KEY BillOfOperationsVariant P_RTGVERSUIWFLHLP BillOfOperationsVariant
KEY BillOfOperationsVersion P_RTGVERSUIWFLHLP BillOfOperationsVersion
KEY subtype tca01_subtype subtype
Status SWF_FLEX_I_PROCESS Status 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Workflow state for routings'
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MIXED
}

define view entity P_RTGVERSUIWFL as select from tca01_subtype as tca

inner join SWF_FLEX_I_PROCESS on SWF_FLEX_I_PROCESS.ScenarioID      = tca.workflow_scenario_id

/* inner join swwflexproc on swwflexproc.scenario_id = tca.workflow_scenario_id and swwflexproc.is_review_flow = '' */

inner join P_RTGVERSUIWFLHLP as _wflhlp on SWF_FLEX_I_PROCESS.ApplicationObjectID = _wflhlp.ApplicationObjectID

{

  key _wflhlp.BillOfOperationsType,
  key _wflhlp.BillOfOperationsGroup,
  key _wflhlp.BillOfOperationsVariant,
  key _wflhlp.BillOfOperationsVersion,
  key tca.subtype,
  SWF_FLEX_I_PROCESS.Status
}

Learn More