I_IncidentInvestigationStpCube

DDL: I_INCIDENTINVESTIGATIONSTPCUBE SQL: IEHSINCINVSTPC Type: view COMPOSITE Package: EHHSS_BO_INC_IMPL
53 Fields 2 Data Sources 1 Associations

Incident Investigation Step - Cube

I_IncidentInvestigationStpCube is a Composite CDS View (Cube) that provides data about "Incident Investigation Step - Cube" in SAP S/4HANA. It reads from 2 data sources (I_IncidentWithTime, I_IncidentInvestigationStep) and exposes 53 fields with key field IncidentInvestigationStepUUID. It has 1 association to related views. Part of development package EHHSS_BO_INC_IMPL.

Data Sources (2)

SourceAliasJoin Type
I_IncidentWithTime _Incident inner
I_IncidentInvestigationStep _IncidentInvestigationStep from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EHSLocation _EHSLocation $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IEHSINCINVSTPC view
EndUserText.label Incident Investigation Step - Cube view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY IncidentInvestigationStepUUID I_IncidentInvestigationStep IncidentInvestigationStepUUID UUID
IncidentUUID I_IncidentWithTime IncidentUUID Incident UUID
IncidentID I_IncidentWithTime IncidentID
IncidentTitle I_IncidentWithTime IncidentTitle
IncidentStatus I_IncidentWithTime IncidentStatus
_IncidentStatus I_IncidentWithTime _IncidentStatus
IncidentCategory I_IncidentWithTime IncidentCategory
_IncidentCategory I_IncidentWithTime _IncidentCategory
Country I_IncidentWithTime Country Venue: Ctry/Reg
_Country I_IncidentWithTime _Country
Region I_IncidentWithTime Region Venue Region
_Region I_IncidentWithTime _Region
Plant I_IncidentWithTime Plant Valuation Area
_Plant I_IncidentWithTime _Plant
OrganizationalUnit I_IncidentWithTime OrganizationalUnit Org. Unit ID
_OrgUnit I_IncidentWithTime _OrgUnit
EHSLocationUUID EHSLocationUUID NodeID
EHSLocationID EHSLocationID
_EHSLocation _EHSLocation
_CurrentEHSParentLocationID _CurrentEHSParentLocationID
IncidentDate I_IncidentWithTime IncidentDate
_CalendarDate I_IncidentWithTime _CalendarDate
IncidentYear I_IncidentWithTime IncidentYear
_CalendarYear I_IncidentWithTime _CalendarYear
IncidentWeekDay I_IncidentWithTime IncidentWeekDay
_WeekDay I_IncidentWithTime _WeekDay
IncidentTimeIsUnknown I_IncidentWithTime IncidentTimeIsUnknown
_IncidentTimeIsUnknown I_IncidentWithTime _IncidentTimeIsUnknown
IncidentTime I_IncidentWithTime IncidentTime
IncidentHour I_IncidentWithTime IncidentHour
_IncidentHour I_IncidentWithTime _IncidentHour
IncidentHasAccessRestriction I_IncidentWithTime IncidentHasAccessRestriction Restricted
_IncidentHasAccessRestriction I_IncidentWithTime _IncidentHasAccessRestriction
IncidentInvestigationUUID
IncidentInvstgnIsRequired
IncidentInvestigationLead
IncidentInvestigationStatus
IncidentInvestigationStartDate
IncidentInvestigationEndDate
IncidentInvestigationReopenDte
IncidentMajorRootCause I_IncidentWithTime IncidentMajorRootCause
_IncidentMajorRootCause I_IncidentWithTime _IncidentMajorRootCause
InvestigationHasAccRestriction
InvstgnStepSqncNumber I_IncidentInvestigationStep InvstgnStepSqncNumber Sequence No.
InvestigationStepCodeName
InvestigationStepExecutorName I_IncidentInvestigationStep InvestigationStepExecutorName
InvestigationStepDueDate I_IncidentInvestigationStep InvestigationStepDueDate Due Date
InvestigationStpCompletionDate I_IncidentInvestigationStep InvestigationStpCompletionDate Timestamp
InvestigationStepIsRequired I_IncidentInvestigationStep InvestigationStepIsRequired Mandatory Parameter
InvestigationStepStatus I_IncidentInvestigationStep InvestigationStepStatus
InvestigationStepFormName I_IncidentInvestigationStep InvestigationStepFormName Name
NumberOfInvestigationSteps
_IncidentBasicInfo I_IncidentWithTime _IncidentBasicInfo

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_IncidentInvestigationStpCube.
-- 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: IEHSINCINVSTPC

CREATE VIEW I_IncidentInvestigationStpCube AS
SELECT
  _IncidentInvestigationStep.IncidentInvestigationStepUUID AS IncidentInvestigationStepUUID,
  _Incident.IncidentUUID AS IncidentUUID,
  _Incident.IncidentID AS IncidentID,
  _Incident.IncidentTitle AS IncidentTitle,
  _Incident.IncidentStatus AS IncidentStatus,
  _Incident._IncidentStatus AS _IncidentStatus,
  _Incident.IncidentCategory AS IncidentCategory,
  _Incident._IncidentCategory AS _IncidentCategory,
  _Incident.Country AS Country,
  _Incident._Country AS _Country,
  _Incident.Region AS Region,
  _Incident._Region AS _Region,
  _Incident.Plant AS Plant,
  _Incident._Plant AS _Plant,
  _Incident.OrganizationalUnit AS OrganizationalUnit,
  _Incident._OrgUnit AS _OrgUnit,
  EHSLocationUUID,
  EHSLocationID,
  _Incident.IncidentDate AS IncidentDate,
  _Incident._CalendarDate AS _CalendarDate,
  _Incident.IncidentYear AS IncidentYear,
  _Incident._CalendarYear AS _CalendarYear,
  _Incident.IncidentWeekDay AS IncidentWeekDay,
  _Incident._WeekDay AS _WeekDay,
  _Incident.IncidentTimeIsUnknown AS IncidentTimeIsUnknown,
  _Incident._IncidentTimeIsUnknown AS _IncidentTimeIsUnknown,
  _Incident.IncidentTime AS IncidentTime,
  _Incident.IncidentHour AS IncidentHour,
  _Incident._IncidentHour AS _IncidentHour,
  _Incident.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  _Incident._IncidentHasAccessRestriction AS _IncidentHasAccessRestriction,
  _IncidentInvestigationStep._IncidentInvestigation.IncidentInvestigationUUID AS IncidentInvestigationUUID,
  _IncidentInvestigationStep._IncidentInvestigation.IncidentInvstgnIsRequired AS IncidentInvstgnIsRequired,
  _IncidentInvestigationStep._IncidentInvestigation.IncidentInvestigationLead AS IncidentInvestigationLead,
  _IncidentInvestigationStep._IncidentInvestigation.IncidentInvestigationStatus AS IncidentInvestigationStatus,
  _IncidentInvestigationStep._IncidentInvestigation.IncidentInvestigationStartDate AS IncidentInvestigationStartDate,
  _IncidentInvestigationStep._IncidentInvestigation.IncidentInvestigationEndDate AS IncidentInvestigationEndDate,
  _IncidentInvestigationStep._IncidentInvestigation.IncidentInvestigationReopenDte AS IncidentInvestigationReopenDte,
  _Incident.IncidentMajorRootCause AS IncidentMajorRootCause,
  _Incident._IncidentMajorRootCause AS _IncidentMajorRootCause,
  _IncidentInvestigationStep._IncidentInvestigation.InvestigationHasAccRestriction AS InvestigationHasAccRestriction,
  _IncidentInvestigationStep.InvstgnStepSqncNumber AS InvstgnStepSqncNumber,
  _IncidentInvestigationStep._InvestigationStepCodeText[1: Language = $session.system_language ].InvestigationStepCodeName AS InvestigationStepCodeName,
  _IncidentInvestigationStep.InvestigationStepExecutorName AS InvestigationStepExecutorName,
  _IncidentInvestigationStep.InvestigationStepDueDate AS InvestigationStepDueDate,
  _IncidentInvestigationStep.InvestigationStpCompletionDate AS InvestigationStpCompletionDate,
  _IncidentInvestigationStep.InvestigationStepIsRequired AS InvestigationStepIsRequired,
  _IncidentInvestigationStep.InvestigationStepStatus AS InvestigationStepStatus,
  _IncidentInvestigationStep.InvestigationStepFormName AS InvestigationStepFormName,
  cast( 1 as ehfnd_integer ) AS NumberOfInvestigationSteps,
  _Incident._IncidentBasicInfo AS _IncidentBasicInfo
FROM I_IncidentInvestigationStep AS _IncidentInvestigationStep
INNER JOIN I_IncidentWithTime AS _Incident ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON EHSLocationUUID = _EHSLocation.EHSLocationUUID  -- association [0..*]
;

Learn More