P_PPM_ComboTaskSevCat

DDL: P_PPM_COMBOTASKSEVCAT SQL: PPPMCMBTSKSEVCAT Type: view COMPOSITE

P_PPM_ComboTaskSevCat is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PPM_Task) and exposes 3 fields.

Data Sources (1)

SourceAliasJoin Type
I_PPM_Task task inner

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PPPMCMBTSKSEVCAT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (3)

KeyFieldSource TableSource FieldDescription
ViolationReasonCode severity ViolationReasonCode
ProjectSummaryTaskUUID I_PPM_Task TaskUUID
ProjectUUID I_PPM_Task ProjectUUID
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PPPMCMBTSKSEVCAT'
@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'ComboTaskSevCat'

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
//@ObjectModel.usageType.serviceQuality: #B

//@ObjectModel.usageType.sizeCategory:  #M

//@ObjectModel.usageType.dataClass:  #TRANSACTIONAL

//@ObjectModel.representativeKey: 'ProjectUUID'

define view P_PPM_ComboTaskSevCat
  as select distinct from I_PPM_Severity as severity
    inner join            I_PPM_Task     as task on task.ObjectType = 'DPO'
{
  severity.ViolationReasonCode,
  task.TaskUUID as ProjectSummaryTaskUUID,
  task.ProjectUUID as ProjectUUID
}
where
  severity.ViolationReasonCode <> '' 
                                                 
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_SEVERITY",
"I_PPM_TASK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/