I_DeviationIncidentRoot

DDL: I_DEVIATIONINCIDENTROOT SQL: IDEVINCROOT Type: view BASIC Package: EHHSS_BO_INC_DEVIATION_IMPL

Deviation Incident Root

I_DeviationIncidentRoot is a Basic CDS View that provides data about "Deviation Incident Root" in SAP S/4HANA. It reads from 1 data source (ehhssd_idv_root) and exposes 10 fields with key field DeviationUUID. It has 2 associations to related views. Part of development package EHHSS_BO_INC_DEVIATION_IMPL.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
ehhssd_idv_root ehhssd_idv_root from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Incident _EHSIncident $projection.IncidentRefUUID = _EHSIncident.IncidentUUID
[0..*] I_DeviationIncidentCmplRq _EHSDeviationReq $projection.DeviationUUID = _EHSDeviationReq.DeviationUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDEVINCROOT view
EndUserText.label Deviation Incident Root view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DeviationUUID db_key
CreationDateTime
CreatedByUser user_id_cr
LastChangeDateTime
LastChangedByUser user_id_ch
DeviationReportIsRequired report_req_ts
DeviationMigrationSource migration_src
IncidentRefUUID inc_ref_key
_EHSIncident _EHSIncident
_EHSDeviationReq _EHSDeviationReq 
@AbapCatalog.sqlViewName: 'IDEVINCROOT'
@EndUserText.label: 'Deviation Incident Root'
@VDM.viewType: #BASIC

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL,
                          serviceQuality: #C,
                          sizeCategory: #M }

define view I_DeviationIncidentRoot
  as select from ehhssd_idv_root
  association [1..1] to I_Incident                as _EHSIncident     on $projection.IncidentRefUUID = _EHSIncident.IncidentUUID
  association [0..*] to I_DeviationIncidentCmplRq as _EHSDeviationReq on $projection.DeviationUUID = _EHSDeviationReq.DeviationUUID

{
  key db_key                                                   as DeviationUUID,
      cast( datetime_cr as ehfnd_datetime_cr preserving type ) as CreationDateTime,
      user_id_cr                                               as CreatedByUser,
      cast( datetime_ch as ehfnd_datetime_ch preserving type ) as LastChangeDateTime,
      user_id_ch                                               as LastChangedByUser,
      report_req_ts                                            as DeviationReportIsRequired,
      migration_src                                            as DeviationMigrationSource,
      inc_ref_key                                              as IncidentRefUUID,

      _EHSIncident,
      _EHSDeviationReq
}

Learn More