I_DvtnIncdntTriggeringTask

DDL: I_DVTNINCDNTTRIGGERINGTASK Type: view COMPOSITE

Deviation Triggering Task

I_DvtnIncdntTriggeringTask is a Composite CDS View that provides data about "Deviation Triggering Task" in SAP S/4HANA. It reads from 2 data sources (I_EHSCombinedTaskDefAndInstce, I_EHSTaskFollowUp) and exposes 9 fields with key fields EHSPlannedTaskUUID, TaskFollowRefObjUUID. It has 1 association to related views.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_EHSCombinedTaskDefAndInstce EHSCombinedTaskDefAndInstce from
I_EHSTaskFollowUp EHSTaskFollowUp inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_DeviationIncidentRoot _EHSDeviationRoot $projection.TaskFollowRefObjUUID = _EHSDeviationRoot.IncidentRefUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDVTNINCTRIGGER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Deviation Triggering Task view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EHSPlannedTaskUUID I_EHSCombinedTaskDefAndInstce EHSPlannedTaskUUID
KEY TaskFollowRefObjUUID I_EHSTaskFollowUp TaskFollowRefObjUUID
TaskFollowCategoryCode I_EHSTaskFollowUp TaskFollowCategoryCode
DeviationUUID _EHSDeviationRoot DeviationUUID
IncidentRefUUID _EHSDeviationRoot IncidentRefUUID
CmplRqVersUUID
ComplianceRequirement
CmplRqVersName
IncidentID 
@AbapCatalog: {
  sqlViewName: 'IDVTNINCTRIGGER',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Deviation Triggering Task'

@ObjectModel.usageType:{ serviceQuality: #D,
                         sizeCategory:  #XL,
                         dataClass: #MIXED }

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_DvtnIncdntTriggeringTask

  as select from I_EHSCombinedTaskDefAndInstce as EHSCombinedTaskDefAndInstce
    inner join   I_EHSTaskFollowUp             as EHSTaskFollowUp on EHSCombinedTaskDefAndInstce.EHSPlannedTaskUUID = EHSTaskFollowUp.EHSPlannedTaskUUID
  association [0..*] to I_DeviationIncidentRoot as _EHSDeviationRoot on $projection.TaskFollowRefObjUUID = _EHSDeviationRoot.IncidentRefUUID
{

  key EHSCombinedTaskDefAndInstce.EHSPlannedTaskUUID,
  key EHSTaskFollowUp.TaskFollowRefObjUUID,
      EHSTaskFollowUp.TaskFollowCategoryCode,      
 
      _EHSDeviationRoot.DeviationUUID,
      _EHSDeviationRoot.IncidentRefUUID,
      _EHSDeviationRoot._EHSDeviationReq.CmplRqVersUUID,
      _EHSDeviationRoot._EHSDeviationReq.ComplianceRequirement,
      _EHSDeviationRoot._EHSDeviationReq.CmplRqVersName,
      _EHSDeviationRoot._EHSIncident.IncidentID

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEVIATIONINCIDENTCMPLRQ",
"I_DEVIATIONINCIDENTROOT",
"I_EHSCOMBINEDTASKDEFANDINSTCE",
"I_EHSTASKFOLLOWUP",
"I_INCIDENT"
],
"ASSOCIATED":
[
"I_DEVIATIONINCIDENTROOT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More