I_EHSMyInvstgnActySource

DDL: I_EHSMYINVSTGNACTYSOURCE Type: view_entity COMPOSITE Package: EHHSS_BO_INVESTIGATION_IMPL
27 Fields 2 Data Sources 1 Associations

Total number invstgn activities source

I_EHSMyInvstgnActySource is a Composite CDS View that provides data about "Total number invstgn activities source" in SAP S/4HANA. It reads from 2 data sources (I_BusinessUserBasic, I_EHSInvestigationActivity) and exposes 27 fields with key field EHSInvestigationActivityUUID. It has 1 association to related views. Part of development package EHHSS_BO_INVESTIGATION_IMPL.

Data Sources (2)

SourceAliasJoin Type
I_BusinessUserBasic bususer inner
I_EHSInvestigationActivity invac from

Associations (1)

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

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Total number invstgn activities source view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY EHSInvestigationActivityUUID I_EHSInvestigationActivity EHSInvestigationActivityUUID
EHSInvestigationID
EHSInvestigationUUID I_EHSInvestigationActivity EHSInvestigationUUID
CreationDateTime I_EHSInvestigationActivity CreationDateTime Timestamp
CreatedByUser I_EHSInvestigationActivity CreatedByUser User Name
LastChangeDateTime I_EHSInvestigationActivity LastChangeDateTime Timestamp
LastChangedByUser I_EHSInvestigationActivity LastChangedByUser User Name
EHSInvestigationActivityType I_EHSInvestigationActivity EHSInvestigationActivityType
EHSInvstgnActivityTypeText
EHSInvestigationActivityStatus I_EHSInvestigationActivity EHSInvestigationActivityStatus
EHSInvestigationActivityTitle I_EHSInvestigationActivity EHSInvestigationActivityTitle
EHSInvstgnActivityDescription I_EHSInvestigationActivity EHSInvstgnActivityDescription
StartDate I_EHSInvestigationActivity EHSInvstgnActyActualStartDate
EHSInvestigationCompletionDate I_EHSInvestigationActivity EHSInvestigationCompletionDate
EHSInvstgnActivityDueDate I_EHSInvestigationActivity EHSInvstgnActivityDueDate
EHSInvestigationActivityOwner I_EHSInvestigationActivity EHSInvestigationActivityOwner
EHSInvstgnActivityResponsible I_EHSInvestigationActivity EHSInvstgnActivityResponsible
EHSLocationUUID
_EHSLocation _EHSLocation
EHSLocationID
_EHSInvestigation I_EHSInvestigationActivity _EHSInvestigation
_EHSInvstgnActivityStatus I_EHSInvestigationActivity _EHSInvstgnActivityStatus
_EHSInvstgnActivityType I_EHSInvestigationActivity _EHSInvstgnActivityType
_EHSInvstgnActyOwner I_EHSInvestigationActivity _EHSInvstgnActyOwner
_EHSInvstgnActyResponsible I_EHSInvestigationActivity _EHSInvstgnActyResponsible
EHSInvestigationTypeCode
EHSNumberOfActivity Activities

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_EHSMyInvstgnActySource.
-- 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 I_EHSMyInvstgnActySource AS
SELECT
  invac.EHSInvestigationActivityUUID AS EHSInvestigationActivityUUID,
  invac._EHSInvestigation.EHSInvestigationID AS EHSInvestigationID,
  invac.EHSInvestigationUUID AS EHSInvestigationUUID,
  invac.CreationDateTime AS CreationDateTime,
  invac.CreatedByUser AS CreatedByUser,
  invac.LastChangeDateTime AS LastChangeDateTime,
  invac.LastChangedByUser AS LastChangedByUser,
  invac.EHSInvestigationActivityType AS EHSInvestigationActivityType,
  invac._EHSInvstgnActivityType._Text[1:Language = $session.system_language].EHSInvstgnActivityTypeText AS EHSInvstgnActivityTypeText,
  invac.EHSInvestigationActivityStatus AS EHSInvestigationActivityStatus,
  invac.EHSInvestigationActivityTitle AS EHSInvestigationActivityTitle,
  invac.EHSInvstgnActivityDescription AS EHSInvstgnActivityDescription,
  invac.EHSInvstgnActyActualStartDate AS StartDate,
  invac.EHSInvestigationCompletionDate AS EHSInvestigationCompletionDate,
  invac.EHSInvstgnActivityDueDate AS EHSInvstgnActivityDueDate,
  invac.EHSInvestigationActivityOwner AS EHSInvestigationActivityOwner,
  invac.EHSInvstgnActivityResponsible AS EHSInvstgnActivityResponsible,
  invac._EHSInvestigation._EHSInvstgnRelatedObject._Incident._IncidentBasicInfo.EHSLocationUUID AS EHSLocationUUID,
  invac._EHSInvestigation._EHSInvstgnRelatedObject._Incident._IncidentBasicInfo._EHSLocationRoot.EHSLocationID AS EHSLocationID,
  invac._EHSInvestigation AS _EHSInvestigation,
  invac._EHSInvstgnActivityStatus AS _EHSInvstgnActivityStatus,
  invac._EHSInvstgnActivityType AS _EHSInvstgnActivityType,
  invac._EHSInvstgnActyOwner AS _EHSInvstgnActyOwner,
  invac._EHSInvstgnActyResponsible AS _EHSInvstgnActyResponsible,
  invac._EHSInvestigation.EHSInvestigationTypeCode AS EHSInvestigationTypeCode,
  cast(1 as int4) AS EHSNumberOfActivity
FROM I_EHSInvestigationActivity AS invac
INNER JOIN I_BusinessUserBasic AS bususer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSLocation AS _EHSLocation ON ehslocationuuid = _EHSLocation.EHSLocationUUID  -- association [0..*]
;

Learn More