R_TaskListLongTextTP

DDL: R_TASKLISTLONGTEXTTP Type: view_entity TRANSACTIONAL Package: VDM_EAM_TASKLIST

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. Part of development package VDM_EAM_TASKLIST.

2 data source(s) 11 fields

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
KEY TaskListGroup I_MaintenanceTaskList TaskListGroup
KEY TaskListGroupCounter I_MaintenanceTaskList TaskListGroupCounter
KEY TaskListVersionCounter I_MaintenanceTaskList TaskListVersionCounter
ValidityStartDate I_MaintenanceTaskList ValidityStartDate
ValidityEndDate I_MaintenanceTaskList ValidityEndDate
TextObjectKey I_TaskListLongText TextObjectKey
PlainLongText I_TaskListLongText PlainLongText
Language _TextObjectPlainLongText Language
_Header _Header
_MaintenanceTaskList _MaintenanceTaskList 
@EndUserText.label: 'Long Text view for Maintenance Tasklist'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity R_TaskListLongTextTP

  as select from I_MaintenanceTaskList
    inner join   I_TaskListLongText on  I_MaintenanceTaskList.TaskListType           = I_TaskListLongText.TaskListType
                                    and I_MaintenanceTaskList.TaskListGroup          = I_TaskListLongText.TaskListGroup
                                    and I_MaintenanceTaskList.TaskListGroupCounter   = I_TaskListLongText.TaskListGroupCounter
                                    and I_MaintenanceTaskList.TaskListVersionCounter = I_TaskListLongText.TaskListVersionCounter
  association        to parent R_MaintenanceTaskListTP as _Header                  on  $projection.TaskListType         = _Header.TaskListType
                                                                                   and $projection.TaskListGroup        = _Header.TaskListGroup
                                                                                   and $projection.TaskListGroupCounter = _Header.TaskListGroupCounter

  association [1..1] to R_MaintenanceTaskListBasicTP   as _MaintenanceTaskList     on  $projection.TaskListType           = _MaintenanceTaskList.TaskListType
                                                                                   and $projection.TaskListGroup          = _MaintenanceTaskList.TaskListGroup
                                                                                   and $projection.TaskListGroupCounter   = _MaintenanceTaskList.TaskListGroupCounter
                                                                                   and $projection.TaskListVersionCounter = _MaintenanceTaskList.TaskListVersionCounter

  association [0..1] to I_TextObjectPlainLongText      as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.TextObjectKey
                                                                                   and _TextObjectPlainLongText.TextObjectType     = 'PLKO'
                                                                                   and _TextObjectPlainLongText.TextObjectCategory = 'ROUTING'
                                                                                   and _TextObjectPlainLongText.Language           = $session.system_language
{
  key    I_MaintenanceTaskList.TaskListType,
  key    I_MaintenanceTaskList.TaskListGroup,
  key    I_MaintenanceTaskList.TaskListGroupCounter,
  key    I_MaintenanceTaskList.TaskListVersionCounter,
         I_MaintenanceTaskList.ValidityStartDate,
         I_MaintenanceTaskList.ValidityEndDate,
         I_TaskListLongText.TextObjectKey,
         I_TaskListLongText.PlainLongText,

         _TextObjectPlainLongText.Language,
         _Header,
         _MaintenanceTaskList

}

Learn More