I_INCIDENTINVESTIGATIONSTEP

CDS View

Incident Investigation Step

I_INCIDENTINVESTIGATIONSTEP is a CDS View in S/4HANA. Incident Investigation Step. It contains 1 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 1 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_IncidentInvstgnRelatedTask view from CONSUMPTION Incident Investigation Related Task List
I_IncidentInvestigationStpCube view from COMPOSITE Incident Investigation Step - Cube
I_IncidentInvstgnAuthznFields view from BASIC Incident Authorization Fields
I_IncidentTaskHostObject view union_all COMPOSITE Task Host Object Union

Fields (1)

KeyField CDS FieldsUsed in Views
KEY IncidentInvestigationStepUUID IncidentInvestigationStepUUID 1 
@EndUserText.label: 'Incident Investigation Step'
@VDM.viewType: #BASIC

@ObjectModel.representativeKey: 'IncidentInvestigationStepUUID'
@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog.sqlViewName: 'IINCINSTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}

define view I_IncidentInvestigationStep
  as select from ehhssd_inc_instp

  association [1..*] to I_InvestigationStepCodeText as _InvestigationStepCodeText on $projection.InvestigationStepCode = _InvestigationStepCodeText.InvestigationStepCode
  association [1..1] to I_IncidentInvestigation     as _IncidentInvestigation     on $projection.IncidentInvestigationUUID = _IncidentInvestigation.IncidentInvestigationUUID
// Begin correction 3255934 - 14.10.2022  **************************  

  association [1..1] to I_IncidentInvestStepStatus  as _InvestigationStepStatus  on $projection.InvestigationStepStatus = _InvestigationStepStatus.InvestigationStepStatus
// End correction 3255934 - 14.10.2022  ****************************  

{

  key db_key                                                 as IncidentInvestigationStepUUID,
      bintohex(db_key)                                       as IncidentInvstgnStepUUIDHex,
      @ObjectModel.foreignKey.association: '_IncidentInvestigation'
      parent_key                                             as IncidentInvestigationUUID,
      root_key                                               as IncidentUUID,

      // Admin data

      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,

      @ObjectModel.foreignKey.association: '_InvestigationStepCodeText'
      step_code                                              as InvestigationStepCode,

// Begin correction 3255934 - 14.10.2022  **************************

      step_seq_num                                           as InvstgnStepSqncNumber,

      cast(executor_id as ehhss_inv_step_exec_id_nc preserving type)  as InvestigationStepExecutorName,
      
      @ObjectModel.foreignKey.association: '_InvestigationStepStatus'
      cast(step_status as ehhss_inv_step_status_code_nc preserving type) as InvestigationStepStatus,
      _InvestigationStepStatus,
     
      form_name                                              as InvestigationStepFormName,    
  
      completion_date                                        as InvestigationStpCompletionDate,
      
      mandatory_ind                                          as InvestigationStepIsRequired,

//      step_category                                          as InvestigationStepCategory,

//      offline_ind                                            as InvestigationStepOfflineInd,


// End correction 3255934 - 14.10.2022  ****************************


      deadline_date                                          as InvestigationStepDueDate,

      _InvestigationStepCodeText,
      _IncidentInvestigation

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHHSSD_INC_INSTP"
],
"ASSOCIATED":
[
"I_INCIDENTINVESTIGATION",
"I_INCIDENTINVESTSTEPSTATUS",
"I_INVESTIGATIONSTEPCODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More