I_INCIDENTWITHTIME
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA