I_PPM_ChecklistItemText

DDL: I_PPM_CHECKLISTITEMTEXT SQL: IPPMCHKLSTITMTXT Type: view COMPOSITE

Check item text

I_PPM_ChecklistItemText is a Composite CDS View that provides data about "Check item text" in SAP S/4HANA. It reads from 5 data sources (I_PPM_ChecklistItem, I_PPM_ProjectRoot, I_PPM_Task, I_PPM_Text, I_PPM_Text) and exposes 5 fields with key field ChecklistItemUUID.

5 data source(s) 5 fields

Data Sources (5)

SourceAliasJoin Type
I_PPM_ChecklistItem entity from
I_PPM_ProjectRoot ProjectRoot left_outer
I_PPM_Task task left_outer
I_PPM_Text TextLogon left_outer
I_PPM_Text TextMaster left_outer

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IPPMCHKLSTITMTXT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Check item text view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChecklistItemUUID I_PPM_ChecklistItem ChecklistItemUUID
_AuthUser I_PPM_ChecklistItem _AuthUser
_AuthSubst I_PPM_ChecklistItem _AuthSubst
_AuthRole I_PPM_ChecklistItem _AuthRole
_AuthGroup I_PPM_ChecklistItem _AuthGroup 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory:  #M
@ObjectModel.usageType.dataClass:  #MIXED
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IPPMCHKLSTITMTXT'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Check item text'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_PPM_ChecklistItemText
  as select from    I_PPM_ChecklistItem as entity
    left outer join I_PPM_Task          as task        on entity.ChecklistParentObjectUUID = task.TaskUUID
    left outer join I_PPM_ProjectRoot   as ProjectRoot on task.ProjectUUID = ProjectRoot.ProjectUUID
    left outer join I_PPM_Text          as TextLogon   on  TextLogon.LanguageCode         = $session.system_language
                                                       and TextLogon.ReferencedObjectUUID = entity.ChecklistItemUUID
    left outer join I_PPM_Text          as TextMaster  on  TextMaster.LanguageCode         = ProjectRoot.MasterLanguage
                                                       and TextMaster.ReferencedObjectUUID = entity.ChecklistItemUUID
{
  key entity.ChecklistItemUUID as ChecklistItemUUID,
      @EndUserText.label: 'Object Description'
      cast ( case
         when TextLogon.ObjectName > '' then
              TextLogon.ObjectName
         else (
         case
              when TextMaster.ObjectName > '' then
              TextMaster.ObjectName
              else entity.ChecklistItem
         end
         )
      end as dpr_tv_text )                     as ChecklistItemName,
      entity._AuthUser,
      entity._AuthSubst,
      entity._AuthRole,
      entity._AuthGroup
      
}

Learn More