I_INCIDENTWITHTIME

CDS View

Incident With Time

I_INCIDENTWITHTIME is a CDS View in S/4HANA. Incident With Time. It contains 46 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_ManageIncidentValueHelp view_entity from CONSUMPTION Incidents
I_IncidentAssetCaseCube view from COMPOSITE Incident Asset Case Cube
I_IncidentCaseCube view from COMPOSITE Incident Case Cube
I_IncidentCube view from COMPOSITE EHS Incident - Cube
I_IncidentDamageCaseCube view from COMPOSITE Incident Damage Case Cube
I_IncidentGroupCube view from COMPOSITE Incident Group - Cube
I_IncidentInvestigationCube view inner COMPOSITE Incident Investigation - Cube
I_IncidentInvestigationStpCube view inner COMPOSITE Incident Investigation Step - Cube
I_IncidentNtcOfVioltnCaseCube view from COMPOSITE Incident Notice Of Violation - Cube
I_IncidentReleaseCaseCube view from COMPOSITE Incident Release - Cube
P_InjuryIllnessCase view inner COMPOSITE

Fields (46)

KeyField CDS FieldsUsed in Views
KEY IncidentUUID IncidentUUID 9
_CalendarDate _CalendarDate 5
_CalendarMonth _CalendarMonth 5
_CalendarQuarter _CalendarQuarter 2
_CalendarYear _CalendarYear 5
_Country _Country 7
_CurrentEHSParentLocationID _CurrentEHSParentLocationID 5
_EHSLocationRoot _EHSLocationRoot 1
_IncidentBasicInfo _IncidentBasicInfo 5
_IncidentCategory _IncidentCategory 7
_IncidentHasAccessRestriction _IncidentHasAccessRestriction 3
_IncidentHour _IncidentHour 4
_IncidentInjryIllnLogType _IncidentInjryIllnLogType 1
_IncidentInvestigationStatus _IncidentInvestigationStatus 1
_IncidentMajorRootCause _IncidentMajorRootCause 5
_IncidentStatus _IncidentStatus 7
_IncidentTimeIsUnknown _IncidentTimeIsUnknown 3
_OrgUnit _OrgUnit 5
_Plant _Plant 7
_Region _Region 7
_WeekDay _WeekDay 5
_YearMonth _YearMonth 2
Country Country 7
EHSLocationID EHSLocationID 3
EHSLocationUUID EHSLocationUUID 5
IncidentCategory IncidentCategory 7
IncidentDate IncidentDate 5
IncidentHasAccessRestriction IncidentHasAccessRestriction 5
IncidentHour IncidentHour 5
IncidentID IncidentID 7
IncidentInjuryIllnLogType IncidentInjuryIllnLogType 1
IncidentInvestigationStatus IncidentInvestigationStatus 1
IncidentMajorRootCause IncidentMajorRootCause 5
IncidentMonth IncidentMonth 5
IncidentStatus IncidentStatus 7
IncidentTime IncidentTime 5
IncidentTimeIsUnknown IncidentTimeIsUnknown 5
IncidentTitle IncidentTitle 7
IncidentWeekDay IncidentWeekDay 5
IncidentYear IncidentYear 5
IncidentYearMonth IncidentYearMonth 2
IncidentYearQuarter IncidentYearQuarter 2
LastChangeDateTime LastChangeDateTime 1
OrganizationalUnit OrganizationalUnit 7
Plant Plant 7
Region Region 7

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Incident With Time
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INCIDENTWITHTIME (
    INCIDENTUUID,
    _CALENDARDATE,
    _CALENDARMONTH,
    _CALENDARQUARTER,
    _CALENDARYEAR,
    _COUNTRY,
    _CURRENTEHSPARENTLOCATIONID,
    _EHSLOCATIONROOT,
    _INCIDENTBASICINFO,
    _INCIDENTCATEGORY,
    _INCIDENTHASACCESSRESTRICTION,
    _INCIDENTHOUR,
    _INCIDENTINJRYILLNLOGTYPE,
    _INCIDENTINVESTIGATIONSTATUS,
    _INCIDENTMAJORROOTCAUSE,
    _INCIDENTSTATUS,
    _INCIDENTTIMEISUNKNOWN,
    _ORGUNIT,
    _PLANT,
    _REGION,
    _WEEKDAY,
    _YEARMONTH,
    COUNTRY,
    EHSLOCATIONID,
    EHSLOCATIONUUID,
    INCIDENTCATEGORY,
    INCIDENTDATE,
    INCIDENTHASACCESSRESTRICTION,
    INCIDENTHOUR,
    INCIDENTID,
    INCIDENTINJURYILLNLOGTYPE,
    INCIDENTINVESTIGATIONSTATUS,
    INCIDENTMAJORROOTCAUSE,
    INCIDENTMONTH,
    INCIDENTSTATUS,
    INCIDENTTIME,
    INCIDENTTIMEISUNKNOWN,
    INCIDENTTITLE,
    INCIDENTWEEKDAY,
    INCIDENTYEAR,
    INCIDENTYEARMONTH,
    INCIDENTYEARQUARTER,
    LASTCHANGEDATETIME,
    ORGANIZATIONALUNIT,
    PLANT,
    REGION,
    PRIMARY KEY (INCIDENTUUID)
);