C_IncidentRelatedProcesses

DDL: C_INCIDENTRELATEDPROCESSES SQL: CEHSINCOTHTASK Type: view CONSUMPTION

Other incident related tasks

C_IncidentRelatedProcesses is a Consumption CDS View that provides data about "Other incident related tasks" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 8 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask I_WorkflowTask from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkflowTaskStatusText _WorkflowTaskStatusText $projection.WorkflowTaskStatus = _WorkflowTaskStatusText.WorkflowTaskStatus and _WorkflowTaskStatusText.Language = $session.system_language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CEHSINCOTHTASK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Other incident related tasks view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.semanticObject EHSTask view
ObjectModel.representativeKey WorkflowTaskInternalID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID
WorkflowTaskStatus WorkflowTaskStatus
WorkflowTaskStatusDesc _WorkflowTaskStatusText WorkflowTaskStatusDesc
clientNULLasEHSTaskStartDate
clientNULLasEHSTaskInstceCompletionDate
WorkflowTaskName
TechnicalWrkflwObject _TaskApplicationLeadingObject TechnicalWrkflwObject
_WorkflowTaskStatusText _WorkflowTaskStatusText 
@AbapCatalog.sqlViewName: 'CEHSINCOTHTASK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Other incident related tasks'

@VDM.viewType: #CONSUMPTION

// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// #NOT_REQUIRED as a start

@AccessControl.personalData.blocking: #NOT_REQUIRED

@Consumption.semanticObject: 'EHSTask'
@ObjectModel.representativeKey: 'WorkflowTaskInternalID'

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #D,        // < 15 msec   

                         sizeCategory:  #XL,         // < 10.000.000

                         dataClass: #MIXED } 


define view C_IncidentRelatedProcesses as 
 select from I_WorkflowTask
 association [1..1] to I_WorkflowTaskStatusText as _WorkflowTaskStatusText on $projection.WorkflowTaskStatus = _WorkflowTaskStatusText.WorkflowTaskStatus and
                                                                              _WorkflowTaskStatusText.Language = $session.system_language
                                                                                  
 
 {
key WorkflowTaskInternalID,

@ObjectModel.text.association: '_WorkflowTaskStatusText'
WorkflowTaskStatus, 
_WorkflowTaskStatusText.WorkflowTaskStatusDesc,

tstmp_to_dats( WrkflwTskCreationUTCDateTime,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )   as EHSTaskStartDate,

tstmp_to_dats( WrkflwTskCompletionUTCDateTime,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )   as EHSTaskInstceCompletionDate,

_TaskTitle[1: Language = $session.system_language].WorkflowTaskName,
_TaskApplicationLeadingObject.TechnicalWrkflwObject,

_WorkflowTaskStatusText
    
} where WorkflowTaskType = 'F' // sub workflow

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKFLOWTASK",
"I_WORKFLOWTASKLEADINGAPPLOBJ",
"I_WORKFLOWTASKSTATUSTEXT",
"I_WORKFLOWTASKTITLE"
],
"ASSOCIATED":
[
"I_WORKFLOWTASKSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More