C_EHSInvestigationTP

DDL: C_EHSINVESTIGATIONTP Type: view_entity CONSUMPTION
35 Fields 1 Data Sources

Investigation Consumption

C_EHSInvestigationTP is a Consumption CDS View that provides data about "Investigation Consumption" in SAP S/4HANA. It reads from 1 data source (R_EHSInvestigationTP) and exposes 35 fields with key field EHSInvestigationUUID.

Data Sources (1)

SourceAliasJoin Type
R_EHSInvestigationTP R_EHSInvestigationTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Investigation Consumption view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY EHSInvestigationUUID EHSInvestigationUUID
EHSInvestigationID EHSInvestigationID
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserName _CreatedBy UserDescription Full Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName _LastChangedBy UserDescription Full Name
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
EHSInvestigationTypeCode EHSInvestigationTypeCode
EHSInvestigationTypeCodeTextlocalized
EHSInvestigationStatus EHSInvestigationStatus
EHSInvestigationStatusTextlocalized
EHSInvestigationReasonText EHSInvestigationReasonText
EHSInvstgnActualStartDate EHSInvstgnActualStartDate
EHSInvestigationPlannedEndDate EHSInvestigationPlannedEndDate
EHSInvestigationActualEndDate EHSInvestigationActualEndDate
EHSInvstgnCancelReasonText EHSInvstgnCancelReasonText
EHSInvstgnReopenReasonText EHSInvstgnReopenReasonText
EHSLocationUUID
EHSLocationName
virtualEHSLocationIDAndNametext132
virtualEHSLocationURLchar1024
virtualUICT_hideStartButtonboolean
virtualUICT_hideCloseButtonboolean
virtualUICT_hideCancelButtonboolean
virtualUICT_hideReopenButtonboolean
virtualUICT_hideEditButtonboolean
int1
int1
virtualUICT_hideActualDurationboolean
virtualUICT_hideExpectedDurationboolean
EHSLocationID
IncidentID
_EHSInvestigationStatus _EHSInvestigationStatus

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 C_EHSInvestigationTP.
-- 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.

CREATE VIEW C_EHSInvestigationTP AS
SELECT
  EHSInvestigationUUID,
  EHSInvestigationID,
  CreationDateTime,
  CreatedByUser,
  _CreatedBy.UserDescription AS CreatedByUserName,
  LastChangeDateTime,
  LastChangedByUser,
  _LastChangedBy.UserDescription AS LastChangedByUserName,
  LocalLastChangeDateTime,
  EHSInvestigationTypeCode,
  _EHSInvestigationTypeCodeText.EHSInvestigationTypeCodeText : localized AS EHSInvestigationTypeCodeTextlocalized,
  EHSInvestigationStatus,
  _EHSInvestigationStatus._Text.EHSInvestigationStatusText : localized AS EHSInvestigationStatusTextlocalized,
  EHSInvestigationReasonText,
  EHSInvstgnActualStartDate,
  EHSInvestigationPlannedEndDate,
  EHSInvestigationActualEndDate,
  EHSInvstgnCancelReasonText,
  EHSInvstgnReopenReasonText,
  _EHSInvstgnRelatedObject._Incident._IncidentBasicInfo.EHSLocationUUID AS EHSLocationUUID,
  _EHSInvstgnRelatedObject._Incident._IncidentBasicInfo._LocTextDesc.EHSLocationName AS EHSLocationName,
  virtual EHSLocationIDAndName : text132 AS virtualEHSLocationIDAndNametext132,
  virtual EHSLocationURL : char1024 AS virtualEHSLocationURLchar1024,
  virtual UICT_hideStartButton : boolean AS virtualUICT_hideStartButtonboolean,
  virtual UICT_hideCloseButton : boolean AS virtualUICT_hideCloseButtonboolean,
  virtual UICT_hideCancelButton : boolean AS virtualUICT_hideCancelButtonboolean,
  virtual UICT_hideReopenButton : boolean AS virtualUICT_hideReopenButtonboolean,
  virtual UICT_hideEditButton : boolean AS virtualUICT_hideEditButtonboolean,
  virtual EHSInvstgnStatusCriticality : abap.int1 AS int1,
  virtual UICT_hideActualDuration : boolean AS virtualUICT_hideActualDurationboolean,
  virtual UICT_hideExpectedDuration : boolean AS virtualUICT_hideExpectedDurationboolean,
  _EHSInvstgnRelatedObject._Incident._IncidentBasicInfo._EHSLocationRoot.EHSLocationID AS EHSLocationID,
  _EHSInvstgnRelatedObject._Incident.IncidentID AS IncidentID
FROM R_EHSInvestigationTP
;

Learn More