R_MaintTaskListOpLongTextTP

DDL: R_MAINTTASKLISTOPLONGTEXTTP Type: view_entity TRANSACTIONAL

Operation Longtext

R_MaintTaskListOpLongTextTP is a Transactional CDS View that provides data about "Operation Longtext" in SAP S/4HANA. It reads from 2 data sources (R_MaintTaskListOpBasicTP, I_TaskListOperationLongText) and exposes 13 fields with key fields TaskListType, TaskListGroup, TaskListGroupCounter, TaskListSequence, TaskListOperationInternalId. It has 2 associations to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
R_MaintTaskListOpBasicTP I_MaintTaskListOperation from
I_TaskListOperationLongText I_TaskListOperationLongText inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_MaintTaskListOpBasicTP _Operation $projection.TaskListType = _Operation.TaskListType and $projection.TaskListGroup = _Operation.TaskListGroup and $projection.TaskListGroupCounter = _Operation.TaskListGroupCounter and $projection.TaskListOperationInternalId = _Operation.TaskListOperationInternalId and $projection.TaskListSequence = _Operation.TaskListSequence and $projection.TaskListOpBOMItmIntVersCounter = _Operation.TaskListOpBOMItmIntVersCounter
[0..1] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.TextObjectKey and _TextObjectPlainLongText.TextObjectType = 'PLPO' and _TextObjectPlainLongText.TextObjectCategory = 'ROUTING' and _TextObjectPlainLongText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Operation Longtext view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TaskListType R_MaintTaskListOpBasicTP TaskListType
KEY TaskListGroup R_MaintTaskListOpBasicTP TaskListGroup
KEY TaskListGroupCounter R_MaintTaskListOpBasicTP TaskListGroupCounter
KEY TaskListSequence R_MaintTaskListOpBasicTP TaskListSequence
KEY TaskListOperationInternalId R_MaintTaskListOpBasicTP TaskListOperationInternalId
KEY TaskListOpBOMItmIntVersCounter R_MaintTaskListOpBasicTP TaskListOpBOMItmIntVersCounter
MaintenanceTaskListOperation R_MaintTaskListOpBasicTP MaintenanceTaskListOperation
TextObjectKey I_TaskListOperationLongText TextObjectKey
PlainLongText I_TaskListOperationLongText PlainLongText
Language _TextObjectPlainLongText Language
_Operation _Operation
_NonHistOp _NonHistOp
_Header _Header 
@AbapCatalog : {dataMaintenance:#RESTRICTED }
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Operation Longtext'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}

define view entity R_MaintTaskListOpLongTextTP
  as select from R_MaintTaskListOpBasicTP as I_MaintTaskListOperation
    inner join   I_TaskListOperationLongText on  I_MaintTaskListOperation.TaskListType                   = I_TaskListOperationLongText.TaskListType
                                             and I_MaintTaskListOperation.TaskListGroup                  = I_TaskListOperationLongText.TaskListGroup
                                             and I_MaintTaskListOperation.TaskListOpBOMItmIntVersCounter = I_TaskListOperationLongText.BOOInternalVersionCounter
                                             and I_MaintTaskListOperation.TaskListOperationInternalId    = I_TaskListOperationLongText.BOOOperationInternalID
  association        to parent R_MaintTaskListOperationTP as _NonHistOp               on  $projection.TaskListType                = _NonHistOp.TaskListType
                                                                                      and $projection.TaskListGroup               = _NonHistOp.TaskListGroup
                                                                                      and $projection.TaskListGroupCounter        = _NonHistOp.TaskListGroupCounter
                                                                                      and $projection.TaskListSequence            = _NonHistOp.TaskListSequence
                                                                                      and $projection.TaskListOperationInternalId = _NonHistOp.TaskListOperationInternalId
  association [1..1] to R_MaintTaskListOpBasicTP          as _Operation               on  $projection.TaskListType                   = _Operation.TaskListType
                                                                                      and $projection.TaskListGroup                  = _Operation.TaskListGroup
                                                                                      and $projection.TaskListGroupCounter           = _Operation.TaskListGroupCounter
                                                                                      and $projection.TaskListOperationInternalId    = _Operation.TaskListOperationInternalId
                                                                                      and $projection.TaskListSequence               = _Operation.TaskListSequence
                                                                                      and $projection.TaskListOpBOMItmIntVersCounter = _Operation.TaskListOpBOMItmIntVersCounter
  association [0..1] to I_TextObjectPlainLongText         as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.TextObjectKey
                                                                                      and _TextObjectPlainLongText.TextObjectType     = 'PLPO'
                                                                                      and _TextObjectPlainLongText.TextObjectCategory = 'ROUTING'
                                                                                      and _TextObjectPlainLongText.Language           = $session.system_language
  association        to R_MaintenanceTaskListTP           as _Header                  on  $projection.TaskListType         = _Header.TaskListType
                                                                                      and $projection.TaskListGroup        = _Header.TaskListGroup
                                                                                      and $projection.TaskListGroupCounter = _Header.TaskListGroupCounter


{
  key  I_MaintTaskListOperation.TaskListType                   as TaskListType,
  key  I_MaintTaskListOperation.TaskListGroup                  as TaskListGroup,
  key  I_MaintTaskListOperation.TaskListGroupCounter           as TaskListGroupCounter,
  key  I_MaintTaskListOperation.TaskListSequence               as TaskListSequence,
  key  I_MaintTaskListOperation.TaskListOperationInternalId    as TaskListOperationInternalId,
  key  I_MaintTaskListOperation.TaskListOpBOMItmIntVersCounter as TaskListOpBOMItmIntVersCounter,
       I_MaintTaskListOperation.MaintenanceTaskListOperation   as MaintenanceTaskListOperation,
       I_TaskListOperationLongText.TextObjectKey,
       I_TaskListOperationLongText.PlainLongText,
       _TextObjectPlainLongText.Language                       as Language,
       _Operation, // Make association public

       _NonHistOp,
       _Header
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TASKLISTOPERATIONLONGTEXT",
"I_TEXTOBJECTPLAINLONGTEXT",
"R_MAINTTASKLISTOPBASICTP"
],
"ASSOCIATED":
[
"R_MAINTENANCETASKLISTTP",
"R_MAINTTASKLISTOPBASICTP",
"R_MAINTTASKLISTOPERATIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More