I_CustomizingTasks

DDL: I_CUSTOMIZINGTASKS SQL: ICUST_TASKS Type: view
19 Fields 1 Data Sources 4 Associations

Customizing Request: Tasks

I_CustomizingTasks is a CDS View that provides data about "Customizing Request: Tasks" in SAP S/4HANA. It reads from 1 data source (I_TasksHeader) and exposes 19 fields with key fields TransportRequestID, TransportRequestTaskID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TasksHeader I_TasksHeader from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_TaskType _TaskTypeText $projection.TransportRequestTaskType = _TaskTypeText.domvalue_l
[0..1] I_RequestStatus _RequestStatusText $projection.TransportRequestTaskStatus = _RequestStatusText.domvalue_l
[0..1] I_User _User $projection.TransportRequestTaskOwner = _User.UserID
[0..*] I_CustomizingTaskObjects _TaskObjects

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ICUST_TASKS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customizing Request: Tasks view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID TransportRequestID Parent Request
KEY TransportRequestTaskID TransportRequestTaskID Virtual Transport
TransportRequestTaskType TransportRequestTaskType Type
TransportRequestTaskStatus TransportRequestTaskStatus Status
TransportRequestTaskTarget TransportRequestTaskTarget Transport Target
TransportRequestTaskCategory TransportRequestTaskCategory Category
TransportRequestTaskOwner TransportRequestTaskOwner Person Respons.
UserDescriptionendasUserDescription
TransportRequestTaskChangedOn TransportRequestTaskChangedOn Date
TransportRequestTaskChangedAt TransportRequestTaskChangedAt Time
TransportRequestTaskDesc TransportRequestTaskDesc Short Description
TransportRequestTypeText _TaskTypeText TransportRequestTypeText
TransportRequestStatusText _RequestStatusText TransportRequestStatusText
IsFieldHidden _Requests IsFieldHidden
TransportRequestType _Requests TransportRequestType
TransportRequestTarget _Requests TransportRequestTarget
RepositoryId _Requests RepositoryId
_Requests _Requests
_TaskObjects _TaskObjects

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_CustomizingTasks.
-- 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: ICUST_TASKS

CREATE VIEW I_CustomizingTasks AS
SELECT
  TransportRequestID,
  TransportRequestTaskID,
  TransportRequestTaskType,
  TransportRequestTaskStatus,
  TransportRequestTaskTarget,
  TransportRequestTaskCategory,
  TransportRequestTaskOwner,
  case when _User.UserDescription is null then TransportRequestTaskOwner when _User.UserDescription = '' then TransportRequestTaskOwner else _User.UserDescription end as UserDescription AS UserDescriptionendasUserDescription,
  TransportRequestTaskChangedOn,
  TransportRequestTaskChangedAt,
  TransportRequestTaskDesc,
  _TaskTypeText.TransportRequestTypeText AS TransportRequestTypeText,
  _RequestStatusText.TransportRequestStatusText AS TransportRequestStatusText,
  _Requests.IsFieldHidden AS IsFieldHidden,
  _Requests.TransportRequestType AS TransportRequestType,
  _Requests.TransportRequestTarget AS TransportRequestTarget,
  _Requests.RepositoryId AS RepositoryId
FROM I_TasksHeader
LEFT OUTER JOIN I_TaskType AS _TaskTypeText ON TransportRequestTaskType = _TaskTypeText.domvalue_l  -- association [0..1]
LEFT OUTER JOIN I_RequestStatus AS _RequestStatusText ON TransportRequestTaskStatus = _RequestStatusText.domvalue_l  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON TransportRequestTaskOwner = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_CustomizingTaskObjects AS _TaskObjects ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More