I_TasksHeader

DDL: I_TASKSHEADER SQL: ITASK_HEADER Type: view Package: SCTS_REQ_APP

Tasks

I_TasksHeader is a CDS View that provides data about "Tasks" in SAP S/4HANA. It reads from 1 data source (e070) and exposes 10 fields with key field TransportRequestTaskID. It has 1 association to related views. Part of development package SCTS_REQ_APP.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
e070 e070 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] e07t _Text $projection.TransportRequestTaskID = _Text.trkorr and _Text.as4text is not null

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ITASK_HEADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Tasks view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestTaskID trkorr
TransportRequestTaskType trfunction
TransportRequestTaskStatus trstatus
TransportRequestTaskTarget tarsystem
TransportRequestTaskCategory korrdev
TransportRequestTaskOwner as4user
TransportRequestTaskChangedOn as4date
TransportRequestTaskChangedAt as4time
TransportRequestID strkorr
TransportRequestTaskDesc _Text as4text 
@AbapCatalog.sqlViewName: 'ITASK_HEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Tasks'
define view I_TasksHeader
  as select from e070

  // Table E07T is language-dependent but not translation relevant

  association [0..*] to e07t as _Text on  $projection.TransportRequestTaskID = _Text.trkorr
                                      and _Text.as4text                      is not null
{
      //e070

  key trkorr        as TransportRequestTaskID,
      trfunction    as TransportRequestTaskType,
      trstatus      as TransportRequestTaskStatus,
      tarsystem     as TransportRequestTaskTarget,
      korrdev       as TransportRequestTaskCategory,
      as4user       as TransportRequestTaskOwner,
      as4date       as TransportRequestTaskChangedOn,
      as4time       as TransportRequestTaskChangedAt,
      strkorr       as TransportRequestID,
      _Text.as4text as TransportRequestTaskDesc
}
where
  (
       trfunction = 'Q'
    or trfunction = 'R'
    or trfunction = 'S'
    or trfunction = 'X'
  )

Learn More