I_IncidentTaskRefAccRestricted

DDL: I_INCIDENTTASKREFACCRESTRICTED SQL: IINCTSKREFACCRST Type: view COMPOSITE
4 Fields 1 Data Sources

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.

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 #MANDATORY 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 Task Definition
KEY IncidentUUID _IncidentRestrictionAvailable IncidentUUID Incident UUID
IncidentUUIDHex
IncidentHasAccessRestriction

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_IncidentTaskRefAccRestricted.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IINCTSKREFACCRST

CREATE VIEW I_IncidentTaskRefAccRestricted AS
SELECT
  EHSTaskDefinitionUUID,
  _IncidentRestrictionAvailable.IncidentUUID AS IncidentUUID,
  bintohex(_IncidentRestrictionAvailable.IncidentUUID) AS IncidentUUIDHex,
  cast( max(_IncidentRestrictionAvailable.IncidentHasAccessRestriction) as ehhss_per_inv_confid_ts preserving type ) AS IncidentHasAccessRestriction
FROM I_IncidentTaskDefReference
;

Learn More