I_WorkflowScenarioApplComp

DDL: I_WORKFLOWSCENARIOAPPLCOMP SQL: IWRKFLWSCENAPPLC Type: view BASIC Package: SWF_FLEX_APP_STAGE

Application Component

I_WorkflowScenarioApplComp is a Basic CDS View that provides data about "Application Component" in SAP S/4HANA. It reads from 3 data sources (df14l, tadir, tdevc) and exposes 1 field with key field WrkflwScen. Part of development package SWF_FLEX_APP_STAGE.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
df14l df14l left_outer
tadir tadir from
tdevc tdevc left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWSCENAPPLC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Application Component view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey WrkflwScen view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY WrkflwScen 
@AbapCatalog.sqlViewName: 'IWRKFLWSCENAPPLC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Application Component'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
  dataClass: #META,
  serviceQuality: #B,
  sizeCategory: #M
}
@ObjectModel.representativeKey: 'WrkflwScen'

define view I_WorkflowScenarioApplComp
  as select from    tadir
    left outer join tdevc on tadir.devclass = tdevc.devclass
    left outer join df14l on tdevc.component = df14l.fctr_id
{
  key cast( concat( 'WS', substring( tadir.obj_name,1,8 ) ) as swf_flex_scenario_id preserving type ) as WrkflwScen,
      cast( case when df14l.ps_posid is null or df14l.ps_posid = '' then 'LOCAL'
            else df14l.ps_posid
            end
            as swf_flex_appl_comp preserving type )                                                   as SAPApplicationComponent
}
where
      tadir.pgmid  = 'R3TR'
  and tadir.object = 'PDWS'

Learn More