I_PPM_TaskText

DDL: I_PPM_TASKTEXT Type: view BASIC

Language dependent Texts for PPM tasks

I_PPM_TaskText is a Basic CDS View that provides data about "Language dependent Texts for PPM tasks" in SAP S/4HANA. It reads from 2 data sources (I_PPM_Task, I_PPM_Text) and exposes 3 fields with key field TaskUUID.

Data Sources (2)

SourceAliasJoin Type
I_PPM_Task Task from
I_PPM_Text TextLogon left_outer

Annotations (14)

NameValueLevelField
EndUserText.label Language dependent Texts for PPM tasks view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IPPMTASKTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TaskUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID I_PPM_Task TaskUUID
ObjectNameUserLanguage I_PPM_Text ObjectName
ObjectNameMasterLanguage I_PPM_Task TaskName
@EndUserText.label: 'Language dependent Texts for PPM tasks'
@VDM.viewType: #BASIC

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE     

@AbapCatalog: { 
    sqlViewName: 'IPPMTASKTEXT',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel:
{
  dataCategory: #TEXT,
  representativeKey: 'TaskUUID',
  usageType:
  {
    serviceQuality: #B,
    dataClass: #MIXED,
    sizeCategory: #XL
  }
}
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_PPM_TaskText as select from I_PPM_Task as Task            
               
            left outer join I_PPM_Text as TextLogon 
                         on ( TextLogon.LanguageCode = $session.system_language )
                        and ( TextLogon.ReferencedObjectUUID = Task.TaskUUID )
{
   key Task.TaskUUID,
    @EndUserText.label: 'Object Description'
    
        cast
        ( case 
           when TextLogon.ObjectName > '' then
                TextLogon.ObjectName   
                            
           else Task.TaskName
           
    end as /s4ppm/tv_project_name preserving type ) as ObjectName,    
    
      TextLogon.ObjectName    as ObjectNameUserLanguage,
      Task.TaskName           as ObjectNameMasterLanguage  
      
}