R_TaskListLongTextTP

DDL: R_TASKLISTLONGTEXTTP Type: view_entity TRANSACTIONAL
11 Fields 2 Data Sources 2 Associations

Long Text view for Maintenance Tasklist

R_TaskListLongTextTP is a Transactional CDS View that provides data about "Long Text view for Maintenance Tasklist" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceTaskList, I_TaskListLongText) and exposes 11 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListVersionCounter. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceTaskList I_MaintenanceTaskList from
I_TaskListLongText I_TaskListLongText inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_MaintenanceTaskListBasicTP _MaintenanceTaskList $projection.TaskListType = _MaintenanceTaskList.TaskListType and $projection.TaskListGroup = _MaintenanceTaskList.TaskListGroup and $projection.TaskListGroupCounter = _MaintenanceTaskList.TaskListGroupCounter and $projection.TaskListVersionCounter = _MaintenanceTaskList.TaskListVersionCounter
[0..1] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.TextObjectKey and _TextObjectPlainLongText.TextObjectType = 'PLKO' and _TextObjectPlainLongText.TextObjectCategory = 'ROUTING' and _TextObjectPlainLongText.Language = $session.system_language

Annotations (9)

NameValueLevelField
EndUserText.label Long Text view for Maintenance Tasklist view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TaskListType I_MaintenanceTaskList TaskListType Task List Type
KEY TaskListGroup I_MaintenanceTaskList TaskListGroup Group
KEY TaskListGroupCounter I_MaintenanceTaskList TaskListGroupCounter Group Counter
KEY TaskListVersionCounter I_MaintenanceTaskList TaskListVersionCounter Sort pos.
ValidityStartDate I_MaintenanceTaskList ValidityStartDate Validity Start Date
ValidityEndDate I_MaintenanceTaskList ValidityEndDate ValidTo
TextObjectKey I_TaskListLongText TextObjectKey Text Name
PlainLongText I_TaskListLongText PlainLongText Long Text
Language _TextObjectPlainLongText Language Report Text Language
_Header _Header
_MaintenanceTaskList _MaintenanceTaskList

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 R_TaskListLongTextTP.
-- 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.

CREATE VIEW R_TaskListLongTextTP AS
SELECT
  I_MaintenanceTaskList.TaskListType AS TaskListType,
  I_MaintenanceTaskList.TaskListGroup AS TaskListGroup,
  I_MaintenanceTaskList.TaskListGroupCounter AS TaskListGroupCounter,
  I_MaintenanceTaskList.TaskListVersionCounter AS TaskListVersionCounter,
  I_MaintenanceTaskList.ValidityStartDate AS ValidityStartDate,
  I_MaintenanceTaskList.ValidityEndDate AS ValidityEndDate,
  I_TaskListLongText.TextObjectKey AS TextObjectKey,
  I_TaskListLongText.PlainLongText AS PlainLongText,
  _TextObjectPlainLongText.Language AS Language
FROM I_MaintenanceTaskList
INNER JOIN I_TaskListLongText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_MaintenanceTaskListBasicTP AS _MaintenanceTaskList ON TaskListType = _MaintenanceTaskList.TaskListType AND TaskListGroup = _MaintenanceTaskList.TaskListGroup AND TaskListGroupCounter = _MaintenanceTaskList.TaskListGroupCounter AND TaskListVersionCounter = _MaintenanceTaskList.TaskListVersionCounter  -- association [1..1]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON _TextObjectPlainLongText.TextObjectKey = TextObjectKey AND _TextObjectPlainLongText.TextObjectType = 'PLKO' AND _TextObjectPlainLongText.TextObjectCategory = 'ROUTING' AND _TextObjectPlainLongText.Language = $session.system_language  -- association [0..1]
;

Learn More