What is I_IncidentReleaseCaseCube in SAP S/4HANA?

I_IncidentReleaseCaseCube is a composite CDS view in SAP S/4HANA. Incident Release - Cube It contains 45 fields.

Which tables does I_IncidentReleaseCaseCube read from?

I_IncidentReleaseCaseCube reads data from: I_IncidentWithTime, I_IncidentRelease.

What VDM layer is I_IncidentReleaseCaseCube?

I_IncidentReleaseCaseCube is classified as a Composite view that combines data from multiple basic views.

I_IncidentReleaseCaseCube

DDL: I_INCIDENTRELEASECASECUBE SQL: IINCRELEASECUBE Type: view COMPOSITE Package: EHHSS_BO_INC_IMPL

45 Fields 2 Data Sources 2 Associations

Incident Release - Cube

I_IncidentReleaseCaseCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_IncidentReleaseCaseCube is a Composite CDS View (Cube) that provides data about "Incident Release - Cube" in SAP S/4HANA. It reads from 2 data sources (I_IncidentWithTime, I_IncidentRelease) and exposes 45 fields with key field IncidentReleaseUUID. It has 2 associations to related views. Part of development package EHHSS_BO_INC_IMPL.

SAP Help Documentation

Category	Incident Release Case Query
Data Category	Cube
Status	Status

Purpose
This CDS view provides access to data on incidents of group Release , such as their total number, the type and size of release, and the date, time, and location of the incident. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role that includes authorization based on the following business catalog: SAP_EHS_BC_IM_SAC_PC ( Incident Management - SAP Analytics Cloud ) This business catalog includes read access to the following restriction types: EHHSS_INC6 EHFND_LOC These restriction types are edited in the Maintain Business Roles app.

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute NumberOfReleaseCases Release-Related Cases Measure IncidentReleaseType Release Type Attribute IncidentReleaseSize Release Size Attribute IncidentReleaseUUID NodeID Attribute IncidentID Incident ID Attribute IncidentUUID Incident UUID Attribute IncidentTitle Title Attribute IncidentStatus Status Attribute IncidentCategory Category Attribute IncidentDate Start Date Attribute IncidentYear Calendar Year Attribute IncidentMonth Calendar Month Attribute IncidentYearMonth Year Month Attribute IncidentYearQuarter Calendar Quarter Attribute IncidentWeekDay Week Day Attribute IncidentTimeIsUnknown Time Unknown Attribute IncidentTime Field of type TIMS Attribute IncidentHour Hour Attribute IncidentHasAccessRestriction Restricted Attribute EHSLocationID Location ID Attribute EHSLocationUUID Location Attribute OrganizationalUnit Organizational Unit Attribute Plant Plant ID Attribute Country Country/Region Attribute Region Region Attribute IncidentMajorRootCause Major Root Cause Attribute

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Cross Applications
Application Component	EHS-SUS-IM
Capabilities	Data Provider for Analytical Queries
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Cross Applications for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view provides access to data on incidents of group Release, such as their total number, the type and size of release, and the date, time, and location of the incident.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (2)

Source	Alias	Join Type
I_IncidentWithTime	incwithtime	from
I_IncidentRelease	rel	inner

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_EHSLocation	_EHSLocation	`$projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID`
[1..*]	I_EHSLocationGeoPoint	_EHSLocationGeoPoint	`$projection.EHSLocationID = _EHSLocationGeoPoint.EHSLocationID`

Annotations (13)

Name	Value	Level
EndUserText.label	Incident Release - Cube	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	IINCRELEASECUBE	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view

Fields (45)

Key	Field	Source Table	Source Field	Description
KEY	IncidentReleaseUUID		IncidentReleaseUUID	NodeID
	IncidentUUID	I_IncidentWithTime	IncidentUUID	Incident UUID
	IncidentID	I_IncidentWithTime	IncidentID	Incident ID
	IncidentTitle	I_IncidentWithTime	IncidentTitle	Incident Title
	IncidentStatus	I_IncidentWithTime	IncidentStatus	Incident Status
	_IncidentStatus	I_IncidentWithTime	_IncidentStatus
	IncidentCategory	I_IncidentWithTime	IncidentCategory	Incident Category
	_IncidentCategory	I_IncidentWithTime	_IncidentCategory
	IncidentMajorRootCause	I_IncidentWithTime	IncidentMajorRootCause	Major Root Cause
	_IncidentMajorRootCause	I_IncidentWithTime	_IncidentMajorRootCause
	Country	I_IncidentWithTime	Country	Country/Region of Incident
	_Country	I_IncidentWithTime	_Country
	Region	I_IncidentWithTime	Region	Region of Incident
	_Region	I_IncidentWithTime	_Region
	Plant	I_IncidentWithTime	Plant	Valuation Area
	_Plant	I_IncidentWithTime	_Plant
	OrganizationalUnit	I_IncidentWithTime	OrganizationalUnit	Organizational Unit ID
	EHSLocationUUID	I_IncidentWithTime	EHSLocationUUID	Location
	_EHSLocation		_EHSLocation
	EHSLocationID			Location ID
	_EHSLocationGeoPoint		_EHSLocationGeoPoint
	_CurrentEHSParentLocationID	I_IncidentWithTime	_CurrentEHSParentLocationID
	_IncidentBasicInfo	I_IncidentWithTime	_IncidentBasicInfo
	IncidentDate	I_IncidentWithTime	IncidentDate	Incident Start Date
	_CalendarDate	I_IncidentWithTime	_CalendarDate
	IncidentMonth	I_IncidentWithTime	IncidentMonth	Calendar Month
	_CalendarMonth	I_IncidentWithTime	_CalendarMonth
	IncidentYear	I_IncidentWithTime	IncidentYear	Calendar Year
	_CalendarYear	I_IncidentWithTime	_CalendarYear
	IncidentYearQuarter	I_IncidentWithTime	IncidentYearQuarter	Calendar Quarter
	_CalendarQuarter	I_IncidentWithTime	_CalendarQuarter
	IncidentYearMonth	I_IncidentWithTime	IncidentYearMonth	Year Month
	_YearMonth	I_IncidentWithTime	_YearMonth
	IncidentWeekDay	I_IncidentWithTime	IncidentWeekDay	Week Day
	_WeekDay	I_IncidentWithTime	_WeekDay
	IncidentTimeIsUnknown	I_IncidentWithTime	IncidentTimeIsUnknown	Time Unknown for Incident Start
	IncidentTime	I_IncidentWithTime	IncidentTime	Field of type TIMS
	IncidentHour	I_IncidentWithTime	IncidentHour	Hour
	_IncidentHour	I_IncidentWithTime	_IncidentHour
	IncidentHasAccessRestriction	I_IncidentWithTime	IncidentHasAccessRestriction	Restricted Access to Incident Record
	IncidentReleaseType	I_IncidentRelease	IncidentReleaseType	Release Type
	_IncidentReleaseType	I_IncidentRelease	_IncidentReleaseType
	IncidentReleaseSize	I_IncidentRelease	IncidentReleaseSize	Release Size
	_IncidentReleaseSize	I_IncidentRelease	_IncidentReleaseSize
	NumberOfReleaseCases			Number of Release-Related Cases

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_IncidentReleaseCaseCube.
-- 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: IINCRELEASECUBE

CREATE VIEW I_IncidentReleaseCaseCube AS
SELECT
  IncidentReleaseUUID,
  incwithtime.IncidentUUID AS IncidentUUID,
  incwithtime.IncidentID AS IncidentID,
  incwithtime.IncidentTitle AS IncidentTitle,
  incwithtime.IncidentStatus AS IncidentStatus,
  incwithtime._IncidentStatus AS _IncidentStatus,
  incwithtime.IncidentCategory AS IncidentCategory,
  incwithtime._IncidentCategory AS _IncidentCategory,
  incwithtime.IncidentMajorRootCause AS IncidentMajorRootCause,
  incwithtime._IncidentMajorRootCause AS _IncidentMajorRootCause,
  incwithtime.Country AS Country,
  incwithtime._Country AS _Country,
  incwithtime.Region AS Region,
  incwithtime._Region AS _Region,
  incwithtime.Plant AS Plant,
  incwithtime._Plant AS _Plant,
  incwithtime.OrganizationalUnit AS OrganizationalUnit,
  incwithtime.EHSLocationUUID AS EHSLocationUUID,
  cast(EHSLocationID as ehfnd_loc_id) AS EHSLocationID,
  incwithtime._CurrentEHSParentLocationID AS _CurrentEHSParentLocationID,
  incwithtime._IncidentBasicInfo AS _IncidentBasicInfo,
  incwithtime.IncidentDate AS IncidentDate,
  incwithtime._CalendarDate AS _CalendarDate,
  incwithtime.IncidentMonth AS IncidentMonth,
  incwithtime._CalendarMonth AS _CalendarMonth,
  incwithtime.IncidentYear AS IncidentYear,
  incwithtime._CalendarYear AS _CalendarYear,
  incwithtime.IncidentYearQuarter AS IncidentYearQuarter,
  incwithtime._CalendarQuarter AS _CalendarQuarter,
  incwithtime.IncidentYearMonth AS IncidentYearMonth,
  incwithtime._YearMonth AS _YearMonth,
  incwithtime.IncidentWeekDay AS IncidentWeekDay,
  incwithtime._WeekDay AS _WeekDay,
  incwithtime.IncidentTimeIsUnknown AS IncidentTimeIsUnknown,
  incwithtime.IncidentTime AS IncidentTime,
  incwithtime.IncidentHour AS IncidentHour,
  incwithtime._IncidentHour AS _IncidentHour,
  incwithtime.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  rel.IncidentReleaseType AS IncidentReleaseType,
  rel._IncidentReleaseType AS _IncidentReleaseType,
  rel.IncidentReleaseSize AS IncidentReleaseSize,
  rel._IncidentReleaseSize AS _IncidentReleaseSize,
  cast(1 as ehhss_number_release_cases) AS NumberOfReleaseCases
FROM I_IncidentWithTime AS incwithtime
INNER JOIN I_IncidentRelease AS rel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
LEFT OUTER JOIN I_EHSLocationGeoPoint AS _EHSLocationGeoPoint ON EHSLocationID = _EHSLocationGeoPoint.EHSLocationID  -- association [1..*]
;

Depth:

I_IncidentReleaseCaseCube view

I_IncidentWithTime view
I_IncidentRelease view

C_IncidentReleaseCaseQuery view