I_IncidentWithTime

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_IncidentWithTime.
-- 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: IINCWITHTIME

CREATE VIEW I_IncidentWithTime AS
SELECT
  incident.IncidentUUID AS IncidentUUID,
  incident.IncidentID AS IncidentID,
  incident.IncidentStatus AS IncidentStatus,
  incident._IncidentStatus AS _IncidentStatus,
  incident.IncidentCategory AS IncidentCategory,
  incident._IncidentCategory AS _IncidentCategory,
  incident._IncidentInvolvedPerson AS _IncidentInvolvedPerson,
  incident._IncidentInvestigation AS _IncidentInvestigation,
  incident._IncidentInvolvedAsset AS _IncidentInvolvedAsset,
  incident.LastChangeDateTime AS LastChangeDateTime,
  incident._IncidentBasicInfo AS _BasicInfo,
  _IncidentInvestigation[IncidentInvestigationStatus <> '00'].IncidentMajorRootCause AS IncidentMajorRootCause,
  _IncidentInvestigation[IncidentInvestigationStatus <> '00']._IncidentMajorRootCause AS _IncidentMajorRootCause,
  _IncidentInvestigation.IncidentInvestigationStatus AS IncidentInvestigationStatus,
  _IncidentInvestigation._IncidentInvestigationStatus AS _IncidentInvestigationStatus,
  _IncidentBasicInfo.IncidentTitle AS IncidentTitle,
  _IncidentBasicInfo.Country AS Country,
  _IncidentBasicInfo._Country AS _Country,
  _IncidentBasicInfo.Region AS Region,
  _IncidentBasicInfo._Region AS _Region,
  _IncidentBasicInfo.Plant AS Plant,
  _IncidentBasicInfo._Plant AS _Plant,
  _IncidentBasicInfo.OrganizationalUnit AS OrganizationalUnit,
  _IncidentBasicInfo._OrgUnit AS _OrgUnit,
  _IncidentBasicInfo.EHSLocationUUID AS EHSLocationUUID,
  _IncidentBasicInfo._EHSLocationRoot AS _EHSLocationRoot,
  _IncidentBasicInfo.EHSLocationID AS EHSLocationID,
  _IncidentBasicInfo._CurrentEHSParentLocationID AS _CurrentEHSParentLocationID,
  _IncidentBasicInfo.IncidentDate AS IncidentDate,
  _IncidentBasicInfo._CalendarDate AS _CalendarDate,
  _IncidentBasicInfo._CalendarDate.CalendarMonth AS IncidentMonth,
  _IncidentBasicInfo._CalendarDate._CalendarMonth AS _CalendarMonth,
  _IncidentBasicInfo._CalendarDate.CalendarYear AS IncidentYear,
  _IncidentBasicInfo._CalendarDate._CalendarYear AS _CalendarYear,
  _IncidentBasicInfo.IncidentTimeIsUnknown AS IncidentTimeIsUnknown,
  _IncidentBasicInfo._IncidentTimeIsUnknown AS _IncidentTimeIsUnknown,
  _IncidentBasicInfo.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  _IncidentBasicInfo._IncidentHasAccessRestriction AS _IncidentHasAccessRestriction,
  _IncidentBasicInfo.IncidentInjuryIllnLogType AS IncidentInjuryIllnLogType,
  _IncidentBasicInfo._IncidentInjryIllnLogType AS _IncidentInjryIllnLogType,
  cast( case _IncidentBasicInfo.IncidentTimeIsUnknown when 'X' then '' else tstmp_to_tims(_IncidentBasicInfo.IncidentUTCDateTime, _IncidentBasicInfo.IncidentTimeZone, $session.client, 'INITIAL') end as tims ) as IncidentTime AS clientINITIALendastimsasIncidentTime,
  _IncidentBasicInfo._CalendarDate.WeekDay AS IncidentWeekDay,
  _IncidentBasicInfo._CalendarDate._WeekDay AS _WeekDay,
  _IncidentBasicInfo._CalendarDate.CalendarQuarter AS IncidentYearQuarter,
  _IncidentBasicInfo._CalendarDate._CalendarQuarter AS _CalendarQuarter,
  _IncidentBasicInfo._CalendarDate.YearMonth AS IncidentYearMonth,
  _IncidentBasicInfo._CalendarDate._YearMonth AS _YearMonth,
  incident.EHSDeviationHasJoinCondition AS EHSDeviationHasJoinCondition,
  incident.IncidentReportingSourceCode AS IncidentReportingSourceCode,
  incident._IncidentReportingSource AS _IncidentReportingSource
FROM I_Incident AS incident
LEFT OUTER JOIN I_IncidentGroup AS grp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSDeviationGroupIsEnabled AS is_dev_grp_enabled ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IncidentHour AS _IncidentHour ON IncidentHour = _IncidentHour.IncidentHour  -- association [0..1]
;