I_QltyTaskFollowUpAction

DDL: I_QLTYTASKFOLLOWUPACTION Type: view BASIC

Quality Task Follow-Up Action

I_QltyTaskFollowUpAction is a Basic CDS View (Dimension) that provides data about "Quality Task Follow-Up Action" in SAP S/4HANA. It reads from 2 data sources (tq07, tqs07) and exposes 8 fields with key field QltyTaskFollowUpAction. It has 1 association to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
tq07 tq07 from
tqs07 tqs07 union

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_QltyTaskFollowUpActionText _QltyTaskFollowUpActionText $projection.QltyTaskFollowUpAction = _QltyTaskFollowUpActionText.QltyTaskFollowUpAction

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IQTSKFOA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey QltyTaskFollowUpAction view
EndUserText.label Quality Task Follow-Up Action view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY QltyTaskFollowUpAction folgeakti
QltyFllwUpActnUsge qfoart
QltyTskFllwUpActnIsEWMRelated folgeakti_ewm
QltyTskBaseFUPActnForValueHelp base_foa_for_vh
QltyFllwUpActnUsge qfoart
QltyTskFllwUpActnIsEWMRelated folgeakti_ewm
QltyTskBaseFUPActnForValueHelp
_QltyTaskFollowUpActionText _QltyTaskFollowUpActionText 
@AbapCatalog: {
    sqlViewName: 'IQTSKFOA',
    compiler.compareFilter: true,
    preserveKey: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@ObjectModel: {
    usageType: {
        dataClass: #CUSTOMIZING,
        sizeCategory: #S,
        serviceQuality: #A
    },
    representativeKey: 'QltyTaskFollowUpAction'
}

@EndUserText.label: 'Quality Task Follow-Up Action'
define view I_QltyTaskFollowUpAction as select from tq07 

    association [0..*] to I_QltyTaskFollowUpActionText as _QltyTaskFollowUpActionText on $projection.QltyTaskFollowUpAction = _QltyTaskFollowUpActionText.QltyTaskFollowUpAction

{
    @ObjectModel.text.association: '_QltyTaskFollowUpActionText'
    key folgeakti as QltyTaskFollowUpAction,
    
    qfoart as QltyFllwUpActnUsge,
    @Semantics.booleanIndicator: true
    folgeakti_ewm   as QltyTskFllwUpActnIsEWMRelated,
    base_foa_for_vh as QltyTskBaseFUPActnForValueHelp,
    
    /* Association */
    _QltyTaskFollowUpActionText
    
} where qfoart = '2' or qfoart = '1' //'Quality Task' OR 'Task for the Notification'


union

select from tqs07

  association [0..*] to I_QltyTaskFollowUpActionText as _QltyTaskFollowUpActionText on $projection.QltyTaskFollowUpAction = _QltyTaskFollowUpActionText.QltyTaskFollowUpAction

{
  key folgeakti as QltyTaskFollowUpAction,
  
  qfoart as QltyFllwUpActnUsge,
  @Semantics.booleanIndicator: true
  folgeakti_ewm    as QltyTskFllwUpActnIsEWMRelated,
  cast( '        ' as qfoabaseforvh preserving type ) as QltyTskBaseFUPActnForValueHelp,
  
  /* Association */
    _QltyTaskFollowUpActionText

} where qfoart = '2' or qfoart = '1' //'Quality Task' OR 'Task for the Notification'

Learn More