I_PPM_TaskTypeText

DDL: I_PPM_TASKTYPETEXT Type: view BASIC

Task Type - Text

I_PPM_TaskTypeText is a Basic CDS View that provides data about "Task Type - Text" in SAP S/4HANA. It reads from 1 data source (dpr_tsk_type_t) and exposes 5 fields with key fields Language, EntProjectElementType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
dpr_tsk_type_t text from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPM_Tasktype _TaskType $projection.EntProjectElementType = _TaskType.TaskType
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPPMTASKTYPET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey EntProjectElementType view
ObjectModel.dataCategory #TEXT view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
EndUserText.label Task Type - Text view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language language
KEY EntProjectElementType tsk_type
ProjectElementTypeText type_text
_Language _Language
_TaskType _TaskType
@AbapCatalog: { 
      sqlViewName: 'IPPMTASKTYPET',
      compiler.compareFilter: true,
      preserveKey: true
}

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

//@Analytics.dataExtraction.enabled: true


@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
     representativeKey: 'EntProjectElementType',
     dataCategory: #TEXT,
     resultSet.sizeCategory: #XS,
     supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT ],    
     usageType: {
        serviceQuality:  #A,
        dataClass:       #CUSTOMIZING,
        sizeCategory:    #S
    }
}
@Search.searchable: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC

@EndUserText.label: 'Task Type - Text'
define view I_PPM_TaskTypeText as select from dpr_tsk_type_t as text
  association [1..1] to I_PPM_Tasktype as _TaskType
    on $projection.EntProjectElementType = _TaskType.TaskType
  association [1..1] to I_Language as _Language   
    on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key language as Language,
      @ObjectModel.foreignKey.association: '_TaskType'
      @ObjectModel.text.element: ['ProjectElementTypeText'] 
  key tsk_type as EntProjectElementType,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @Semantics.text: true  
  type_text    as ProjectElementTypeText,
  
  _Language,
  _TaskType
}