I_IncidentDamageCaseCube

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_IncidentDamageCaseCube.
-- 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: IINCDMGCUBE

CREATE VIEW I_IncidentDamageCaseCube AS
SELECT
  asset.InvolvedAssetUUID AS InvolvedAssetUUID,
  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._OrgUnit AS _OrgUnit,
  incwithtime.EHSLocationUUID AS EHSLocationUUID,
  incwithtime.EHSLocationID AS EHSLocationID,
  incwithtime._CurrentEHSParentLocationID AS _CurrentEHSParentLocationID,
  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.IncidentWeekDay AS IncidentWeekDay,
  incwithtime._WeekDay AS _WeekDay,
  incwithtime.IncidentTimeIsUnknown AS IncidentTimeIsUnknown,
  incwithtime._IncidentTimeIsUnknown AS _IncidentTimeIsUnknown,
  incwithtime.IncidentTime AS IncidentTime,
  incwithtime.IncidentHour AS IncidentHour,
  incwithtime._IncidentHour AS _IncidentHour,
  incwithtime.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  incwithtime._IncidentHasAccessRestriction AS _IncidentHasAccessRestriction,
  asset.InvolvedAssetType AS InvolvedAssetType,
  asset._InvolvedAssetType AS _InvolvedAssetType,
  detail.InvolvedAssetName AS InvolvedAssetName,
  detail.Equipment AS Equipment,
  detail.FunctionalLocation AS FunctionalLocation,
  detail.InvolvedEquipmentType AS InvolvedEquipmentType,
  detail.InvolvedVehicleType AS InvolvedVehicleType,
  detail.InvolvedPropertyType AS InvolvedPropertyType,
  asset._IncidentInvolvedAssetDamage.InvolvedAssetDamageType AS InvolvedAssetDamageType,
  asset._IncidentInvolvedAssetDamage._InvolvedAssetDamageType AS _InvolvedAssetDamageType,
  asset._IncidentInvolvedEquipment.InvolvedEquipmentUUID AS InvolvedEquipmentUUID,
  asset._IncidentInvolvedProperty.InvolvedPropertyUUID AS InvolvedPropertyUUID,
  asset._IncidentInvolvedVehicle.InvolvedVehicleUUID AS InvolvedVehicleUUID,
  cast(1 as ehhss_number_asset_cases) AS NumberOfAssetCases,
  asset._IncidentInvolvedAssetDamage AS _IncidentInvolvedAssetDamage,
  incwithtime._IncidentBasicInfo AS _IncidentBasicInfo
FROM I_IncidentWithTime AS incwithtime
INNER JOIN I_IncidentInvolvedAsset AS asset 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_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_InvolvedEquipmentType AS _InvolvedEquipmentType ON InvolvedEquipmentType = _InvolvedEquipmentType.InvolvedEquipmentType  -- association [0..1]
LEFT OUTER JOIN I_InvolvedVehicleType AS _InvolvedVehicleType ON InvolvedVehicleType = _InvolvedVehicleType.InvolvedVehicleType  -- association [0..1]
LEFT OUTER JOIN I_InvolvedPropertyType AS _InvolvedPropertyType ON InvolvedPropertyType = _InvolvedPropertyType.InvolvedPropertyType  -- association [0..1]
;