I_IncidentInvestigationCube

DDL: I_INCIDENTINVESTIGATIONCUBE SQL: IEHSINCINVC Type: view COMPOSITE Package: EHHSS_BO_INC_IMPL
44 Fields 2 Data Sources 1 Associations

Incident Investigation - Cube

I_IncidentInvestigationCube is a Composite CDS View (Cube) that provides data about "Incident Investigation - Cube" in SAP S/4HANA. It reads from 2 data sources (I_IncidentWithTime, I_IncidentInvestigation) and exposes 44 fields with key field IncidentInvestigationUUID. It has 1 association to related views. Part of development package EHHSS_BO_INC_IMPL.

Data Sources (2)

SourceAliasJoin Type
I_IncidentWithTime _Incident inner
I_IncidentInvestigation _IncidentInvestigation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EHSLocation _EHSLocation $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IEHSINCINVC view
EndUserText.label Incident Investigation - Cube view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY IncidentInvestigationUUID I_IncidentInvestigation IncidentInvestigationUUID UUID
IncidentUUID I_IncidentWithTime IncidentUUID Incident UUID
IncidentID I_IncidentWithTime IncidentID
IncidentTitle I_IncidentWithTime IncidentTitle
IncidentStatus I_IncidentWithTime IncidentStatus
_IncidentStatus I_IncidentWithTime _IncidentStatus
IncidentCategory I_IncidentWithTime IncidentCategory
_IncidentCategory I_IncidentWithTime _IncidentCategory
Country I_IncidentWithTime Country Venue: Ctry/Reg
_Country I_IncidentWithTime _Country
Region I_IncidentWithTime Region Venue Region
_Region I_IncidentWithTime _Region
Plant I_IncidentWithTime Plant Valuation Area
_Plant I_IncidentWithTime _Plant
OrganizationalUnit I_IncidentWithTime OrganizationalUnit Org. Unit ID
_OrgUnit I_IncidentWithTime _OrgUnit
EHSLocationUUID EHSLocationUUID NodeID
EHSLocationID EHSLocationID
_EHSLocation _EHSLocation
_CurrentEHSParentLocationID _CurrentEHSParentLocationID
IncidentDate I_IncidentWithTime IncidentDate
_CalendarDate I_IncidentWithTime _CalendarDate
IncidentYear I_IncidentWithTime IncidentYear
_CalendarYear I_IncidentWithTime _CalendarYear
IncidentWeekDay I_IncidentWithTime IncidentWeekDay
_WeekDay I_IncidentWithTime _WeekDay
IncidentTimeIsUnknown I_IncidentWithTime IncidentTimeIsUnknown
_IncidentTimeIsUnknown I_IncidentWithTime _IncidentTimeIsUnknown
IncidentTime I_IncidentWithTime IncidentTime
IncidentHour I_IncidentWithTime IncidentHour
_IncidentHour I_IncidentWithTime _IncidentHour
IncidentHasAccessRestriction I_IncidentWithTime IncidentHasAccessRestriction Restricted
_IncidentHasAccessRestriction I_IncidentWithTime _IncidentHasAccessRestriction
IncidentInvstgnIsRequired I_IncidentInvestigation IncidentInvstgnIsRequired Rpt Required
IncidentInvestigationLead I_IncidentInvestigation IncidentInvestigationLead
IncidentInvestigationStatus I_IncidentInvestigation IncidentInvestigationStatus
IncidentInvestigationStartDate I_IncidentInvestigation IncidentInvestigationStartDate Valn start date
IncidentInvestigationEndDate I_IncidentInvestigation IncidentInvestigationEndDate Valn End date
IncidentInvestigationReopenDte I_IncidentInvestigation IncidentInvestigationReopenDte Reopen Date
IncidentMajorRootCause I_IncidentWithTime IncidentMajorRootCause Major Root Cause
_IncidentMajorRootCause I_IncidentWithTime _IncidentMajorRootCause
InvestigationHasAccRestriction I_IncidentInvestigation InvestigationHasAccRestriction Restricted
NumberOfInvestigations
_IncidentBasicInfo I_IncidentWithTime _IncidentBasicInfo

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_IncidentInvestigationCube.
-- 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: IEHSINCINVC

CREATE VIEW I_IncidentInvestigationCube AS
SELECT
  _IncidentInvestigation.IncidentInvestigationUUID AS IncidentInvestigationUUID,
  _Incident.IncidentUUID AS IncidentUUID,
  _Incident.IncidentID AS IncidentID,
  _Incident.IncidentTitle AS IncidentTitle,
  _Incident.IncidentStatus AS IncidentStatus,
  _Incident._IncidentStatus AS _IncidentStatus,
  _Incident.IncidentCategory AS IncidentCategory,
  _Incident._IncidentCategory AS _IncidentCategory,
  _Incident.Country AS Country,
  _Incident._Country AS _Country,
  _Incident.Region AS Region,
  _Incident._Region AS _Region,
  _Incident.Plant AS Plant,
  _Incident._Plant AS _Plant,
  _Incident.OrganizationalUnit AS OrganizationalUnit,
  _Incident._OrgUnit AS _OrgUnit,
  EHSLocationUUID,
  EHSLocationID,
  _Incident.IncidentDate AS IncidentDate,
  _Incident._CalendarDate AS _CalendarDate,
  _Incident.IncidentYear AS IncidentYear,
  _Incident._CalendarYear AS _CalendarYear,
  _Incident.IncidentWeekDay AS IncidentWeekDay,
  _Incident._WeekDay AS _WeekDay,
  _Incident.IncidentTimeIsUnknown AS IncidentTimeIsUnknown,
  _Incident._IncidentTimeIsUnknown AS _IncidentTimeIsUnknown,
  _Incident.IncidentTime AS IncidentTime,
  _Incident.IncidentHour AS IncidentHour,
  _Incident._IncidentHour AS _IncidentHour,
  _Incident.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  _Incident._IncidentHasAccessRestriction AS _IncidentHasAccessRestriction,
  _IncidentInvestigation.IncidentInvstgnIsRequired AS IncidentInvstgnIsRequired,
  _IncidentInvestigation.IncidentInvestigationLead AS IncidentInvestigationLead,
  _IncidentInvestigation.IncidentInvestigationStatus AS IncidentInvestigationStatus,
  _IncidentInvestigation.IncidentInvestigationStartDate AS IncidentInvestigationStartDate,
  _IncidentInvestigation.IncidentInvestigationEndDate AS IncidentInvestigationEndDate,
  _IncidentInvestigation.IncidentInvestigationReopenDte AS IncidentInvestigationReopenDte,
  _Incident.IncidentMajorRootCause AS IncidentMajorRootCause,
  _Incident._IncidentMajorRootCause AS _IncidentMajorRootCause,
  _IncidentInvestigation.InvestigationHasAccRestriction AS InvestigationHasAccRestriction,
  cast( 1 as ehfnd_integer ) AS NumberOfInvestigations,
  _Incident._IncidentBasicInfo AS _IncidentBasicInfo
FROM I_IncidentInvestigation AS _IncidentInvestigation
INNER JOIN I_IncidentWithTime AS _Incident ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
;

Learn More