I_TasksHeader

DDL: I_TASKSHEADER SQL: ITASK_HEADER Type: view
10 Fields 1 Data Sources 1 Associations

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.

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 Virtual Transport
TransportRequestTaskType trfunction Type
TransportRequestTaskStatus trstatus Status
TransportRequestTaskTarget tarsystem Transport Target
TransportRequestTaskCategory korrdev Category
TransportRequestTaskOwner as4user Person Respons.
TransportRequestTaskChangedOn as4date Date
TransportRequestTaskChangedAt as4time Time
TransportRequestID strkorr Parent Request
TransportRequestTaskDesc _Text as4text Short Description

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TasksHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ITASK_HEADER

CREATE VIEW I_TasksHeader AS
SELECT
  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
FROM e070
LEFT OUTER JOIN e07t AS _Text ON TransportRequestTaskID = _Text.trkorr AND _Text.as4text is not null  -- association [0..*]
;

Learn More