P_InjuryIllnessCase

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 P_InjuryIllnessCase.
-- 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: PINJRYILLNCASE

CREATE VIEW P_InjuryIllnessCase AS
SELECT
  persinfo.InjuredPersonInfoUUID AS InjuredPersonInfoUUID,
  persinfo.InvolvedPersonUUID AS InvolvedPersonUUID,
  incwithtime.IncidentUUID AS IncidentUUID,
  incwithtime.IncidentID AS IncidentID,
  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.IncidentInvestigationStatus AS IncidentInvestigationStatus,
  incwithtime._IncidentInvestigationStatus AS _IncidentInvestigationStatus,
  incwithtime.IncidentTitle AS IncidentTitle,
  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._EHSLocationRoot AS _EHSLocationRoot,
  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.IncidentTimeIsUnknown AS IncidentTimeIsUnknown,
  incwithtime._IncidentTimeIsUnknown AS _IncidentTimeIsUnknown,
  incwithtime.IncidentTime AS IncidentTime,
  incwithtime.IncidentHour AS IncidentHour,
  incwithtime.IncidentWeekDay AS IncidentWeekDay,
  incwithtime._WeekDay AS _WeekDay,
  incwithtime.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  incwithtime._IncidentHasAccessRestriction AS _IncidentHasAccessRestriction,
  incwithtime.IncidentInjuryIllnLogType AS IncidentInjuryIllnLogType,
  incwithtime._IncidentInjryIllnLogType AS _IncidentInjryIllnLogType,
  incwithtime._IncidentBasicInfo AS _IncidentBasicInfo,
  invpers.PersonInfoHasAccRestriction AS PersonInfoHasAccRestriction,
  cast(persinfo.InjuryIllnessCaseIsRecordable as ehhss_injill_case_is_recordabl) AS InjuryIllnessCaseIsRecordable,
  injury.InjuryIllnessClassification AS InjuryIllnessClassification,
  injury._InjuryIllnessClass AS _InjuryIllnessClass,
  injury.MainInjuryIllnessClassfctn AS MainInjuryIllnessClassfctn,
  injury._MainInjuryIllnessClassfctn AS _MainInjuryIllnessClassfctn,
  injury.MainInjuryIllnessType AS MainInjuryIllnessType,
  injury._InjuryIllnessType AS _InjuryIllnessType,
  injury.MainInjuryIllnessBodyPart AS MainInjuryIllnessBodyPart,
  injury._IncidentBodyPart AS _IncidentBodyPart,
  injury.MainInjuryIllnessBodySide AS MainInjuryIllnessBodySide,
  injury._IncidentBodySide AS _IncidentBodySide,
  cast( case when timedata.NmbrOfCalendarDaysAwayFromWork > 0 or timedata.CaseHasPermanentAbsences = 'X' then 1 else 0 end as abap.int4) as NumberOfCasesWithWorkDaysLost AS int4asNumberOfCasesWithWorkDaysLost,
  cast( case when timedata.NmbrOfRstrcdAndTransfCalDays > 0 or timedata.CaseHasPermanentRestrictions = 'X' then 1 else 0 end as abap.int4) as CaseWithRstrcnOrTransf AS int4asCaseWithRstrcnOrTransf,
  case persinfo.InjuryIllnessIsFatal when 'X' then cast(1 as abap.int4) else cast(0 as abap.int4) end as NumberOfDeathCases AS int4endasNumberOfDeathCases,
  case when persinfo.PersnHasTrtmtBeyond1stAid = 'X' or persinfo.PersnIsTreatedInEmgyRoom = 'X' or persinfo.PersonIsInpatientOvernight = 'X' then cast(1 as abap.int4) else cast(0 as abap.int4) end as NumberOfMedicalTreatmentCases AS int4endasNumberOfMedicalTreatmentCases,
  case when persinfo.PersonHasReceivedFirstAid = 'X' then cast(1 as abap.int4) else cast(0 as abap.int4) end as NmbrOfPersonsReceivedFirstAid AS int4endasNmbrOfPersonsReceivedFirstAid
FROM I_IncidentInjuredPersonInfo AS persinfo
INNER JOIN I_IncidentWithTime AS incwithtime ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Indicator AS _InjuryIllnessCaseIsRecordable ON InjuryIllnessCaseIsRecordable = _InjuryIllnessCaseIsRecordable.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_TernaryLogicalState AS _PersonInfoHasAccRestriction ON PersonInfoHasAccRestriction = _PersonInfoHasAccRestriction.TernaryLogicalState  -- association [1..1]
;