I_IncidentTaskRefAccRestricted

DDL: I_INCIDENTTASKREFACCRESTRICTED SQL: IINCTSKREFACCRST Type: view COMPOSITE

Incident Task Def. Ref. Access Restr.

I_IncidentTaskRefAccRestricted is a Composite CDS View that provides data about "Incident Task Def. Ref. Access Restr." in SAP S/4HANA. It reads from 1 data source (I_IncidentTaskDefReference) and exposes 4 fields with key fields EHSTaskDefinitionUUID, IncidentUUID.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_IncidentTaskDefReference I_IncidentTaskDefReference from

Annotations (12)

NameValueLevelField
EndUserText.label Incident Task Def. Ref. Access Restr. view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey EHSTaskDefinitionUUID view
AccessControl.authorizationCheck #NOT_ALLOWED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName IINCTSKREFACCRST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID
KEY IncidentUUID _IncidentRestrictionAvailable IncidentUUID
IncidentUUIDHex
IncidentHasAccessRestriction 
@EndUserText.label: 'Incident Task Def. Ref. Access Restr.'
@VDM.viewType: #COMPOSITE

@ObjectModel.representativeKey: 'EHSTaskDefinitionUUID'

@AccessControl.authorizationCheck: #NOT_ALLOWED
// #NOT_REQUIRED because of existing end of purpose check

@AccessControl.personalData.blocking: #NOT_REQUIRED


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

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

define view I_IncidentTaskRefAccRestricted
  as select from I_IncidentTaskDefReference
 {
      key EHSTaskDefinitionUUID,
      key _IncidentRestrictionAvailable.IncidentUUID,
      bintohex(_IncidentRestrictionAvailable.IncidentUUID)            as IncidentUUIDHex,
      
      cast( max(_IncidentRestrictionAvailable.IncidentHasAccessRestriction) as ehhss_per_inv_confid_ts preserving type ) as IncidentHasAccessRestriction
      
} 
where _IncidentRestrictionAvailable.IncidentUUID is not null
group by _IncidentRestrictionAvailable.IncidentUUID,  EHSTaskDefinitionUUID
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INCIDENTRESTRICTIONAVAILABLE",
"I_INCIDENTTASKDEFREFERENCE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More