I_DvtnIncdntTriggeringTask

DDL: I_DVTNINCDNTTRIGGERINGTASK Type: view COMPOSITE Package: EHHSS_CNS_INC_DEVIATION

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. Part of development package EHHSS_CNS_INC_DEVIATION.

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 (11)

NameValueLevelField
AbapCatalog.sqlViewName IDVTNINCTRIGGER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #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: #MANDATORY
@AccessControl.personalData.blocking: #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

}

Learn More