I_WorkflowApplComp

DDL: I_WORKFLOWAPPLCOMP SQL: IWRKFLWAPPLCOMP Type: view BASIC

Application Component

I_WorkflowApplComp is a Basic CDS View that provides data about "Application Component" in SAP S/4HANA. It reads from 2 data sources (df14l, t100) and exposes 6 fields with key field SAPApplicationComponent. It has 1 association to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
df14l Component from
t100 t100 union_all

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_WorkflowApplCompText _Text $projection.SAPApplicationComponentId = _Text.SAPApplicationComponentId and $projection.ActivationStatus = _Text.ActivationStatus

Annotations (9)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SAPApplicationComponent
SAPApplicationComponentId df14l fctr_id
ActivationStatus df14l as4local
SAPApplicationComponentId
ActivationStatus
_Text _Text 
@AbapCatalog.sqlViewName: 'IWRKFLWAPPLCOMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Application Component'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #META
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_WorkflowApplComp
  as select from df14l as Component
  association [0..*] to I_WorkflowApplCompText as _Text on  $projection.SAPApplicationComponentId = _Text.SAPApplicationComponentId
                                                            and $projection.ActivationStatus          = _Text.ActivationStatus
{
      @ObjectModel: { text.association: '_Text' }
  key cast( Component.ps_posid as swf_flex_appl_comp preserving type )  as SAPApplicationComponent,
      @Consumption.hidden: true
      Component.fctr_id                                                 as SAPApplicationComponentId,
      @Consumption.hidden: true
      Component.as4local                                                as ActivationStatus,
      _Text
}
union all select from t100
association [0..*] to I_WorkflowApplCompText as _Text on  $projection.SAPApplicationComponentId = _Text.SAPApplicationComponentId
                                                          and $projection.ActivationStatus          = _Text.ActivationStatus
{
  'LOCAL' as SAPApplicationComponent,
  'LOCAL' as SAPApplicationComponentId,
  ''      as ActivationStatus,
  _Text
}
where
      t100.arbgb = 'SWF_FLEX_IFS'
  and t100.msgnr = '024'
  and t100.sprsl = 'E'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DF14L",
"T100"
],
"ASSOCIATED":
[
"I_WORKFLOWAPPLCOMPTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More