I_IncidentInvstgnAuthznFields

DDL: I_INCIDENTINVSTGNAUTHZNFIELDS SQL: INCINVAUTHFLDS Type: view BASIC

Incident Authorization Fields

I_IncidentInvstgnAuthznFields is a Basic CDS View that provides data about "Incident Authorization Fields" in SAP S/4HANA. It reads from 1 data source (I_IncidentInvestigationStep) and exposes 18 fields with key field IncidentInvestigationStepUUID. It has 1 association to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_IncidentInvestigationStep I_IncidentInvestigationStep from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_IncidentBasicInfo _IncidentBasicInfo $projection.IncidentUUID = _IncidentBasicInfo.IncidentUUID

Annotations (10)

NameValueLevelField
EndUserText.label Incident Authorization Fields view
AbapCatalog.sqlViewName INCINVAUTHFLDS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY IncidentInvestigationStepUUID IncidentInvestigationStepUUID
IncidentUUID IncidentUUID
EHSTaskHostObjectInstanceUUID IncidentInvestigationStepUUID
InvestigationHasAccRestriction _IncidentInvestigation InvestigationHasAccRestriction
_TernaryLogicalState _IncidentInvestigation _TernaryLogicalState
IncidentCategory
IncidentStatus
Plant _IncidentBasicInfo Plant
EHSLocationUUID _IncidentBasicInfo EHSLocationUUID
_CurrentEHSParentLocationID _IncidentBasicInfo _CurrentEHSParentLocationID
Country _IncidentBasicInfo Country
Region _IncidentBasicInfo Region
_IncidentCategory
_IncidentStatus
_IncidentBasicInfo _IncidentBasicInfo
_Plant _IncidentBasicInfo _Plant
_Country _IncidentBasicInfo _Country
_Region _IncidentBasicInfo _Region 
@EndUserText.label: 'Incident Authorization Fields'

@AbapCatalog.sqlViewName: 'INCINVAUTHFLDS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 

@AccessControl.authorizationCheck: #NOT_ALLOWED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #BASIC

define view I_IncidentInvstgnAuthznFields 
 as select from I_IncidentInvestigationStep
 association [1..1] to I_IncidentBasicInfo      as _IncidentBasicInfo        on  $projection.IncidentUUID = _IncidentBasicInfo.IncidentUUID
 {
   key IncidentInvestigationStepUUID,
  // bintohex(IncidentInvestigationStepUUID)    as  EHSTaskHostObjectInstance, // removed due to performance optimization 

   IncidentUUID,
   IncidentInvestigationStepUUID as EHSTaskHostObjectInstanceUUID,
   _IncidentInvestigation.InvestigationHasAccRestriction,
   _IncidentInvestigation._TernaryLogicalState,
    
  _IncidentBasicInfo._Incident.IncidentCategory,
  _IncidentBasicInfo._Incident.IncidentStatus,
  
  _IncidentBasicInfo.Plant,
  // when incident is assigned to location and user has authorizations for any of the location parents, then the user has the same autorizations for this incident 

   @ObjectModel.foreignKey.association: '_CurrentEHSParentLocationID'
  _IncidentBasicInfo.EHSLocationUUID,
  _IncidentBasicInfo._CurrentEHSParentLocationID,
  _IncidentBasicInfo.Country,
  _IncidentBasicInfo.Region,
  
  _IncidentBasicInfo._Incident._IncidentCategory,
  _IncidentBasicInfo._Incident._IncidentStatus,
  _IncidentBasicInfo,
  _IncidentBasicInfo._Plant,
  _IncidentBasicInfo._Country,
  _IncidentBasicInfo._Region

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INCIDENT",
"I_INCIDENTBASICINFO",
"I_INCIDENTINVESTIGATION",
"I_INCIDENTINVESTIGATIONSTEP"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_CURRENTEHSPARENTLOCATIONID",
"I_INCIDENTBASICINFO",
"I_INCIDENTCATEGORY",
"I_INCIDENTSTATUS",
"I_PLANT",
"I_REGION",
"I_TERNARYLOGICALSTATE"
],
"BASE":
[
"I_INCIDENT",
"I_INCIDENTBASICINFO",
"I_INCIDENTINVESTIGATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More