C_EHSFindingTask

DDL: C_EHSFINDINGTASK Type: view_entity CONSUMPTION Package: EHAIM_CNS_FINDING

EHS Finding Task

C_EHSFindingTask is a Consumption CDS View that provides data about "EHS Finding Task" in SAP S/4HANA. It reads from 1 data source (C_EHSCombinedTaskDefAndInstce) and exposes 48 fields with key fields EHSTaskDefinitionUUID, WorkflowTaskInternalID, EHSPlannedTaskUUID. It has 2 associations to related views. It is exposed through 1 OData service (UI_EHSFINDING_MANAGE). Part of development package EHAIM_CNS_FINDING.

Data Sources (1)

SourceAliasJoin Type
C_EHSCombinedTaskDefAndInstce C_EHSCombinedTaskDefAndInstce from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_EHSTaskDefinition _Extension $projection.EHSTaskDefinitionUUID = _Extension.EHSTaskDefinitionUUID
[1..1] E_EHSTaskPlannedInstance _ExtensionInstance $projection.EHSPlannedTaskUUID = _ExtensionInstance.EHSPlannedTaskUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label EHS Finding Task view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey EHSTaskDefinitionUUID view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_EHSFINDING_MANAGE UI_EHSFINDING_MANAGE V4 C1 NOT_RELEASED

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID
KEY WorkflowTaskInternalID WorkflowTaskInternalID
KEY EHSPlannedTaskUUID EHSPlannedTaskUUID
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID
EHSTaskHostObjectInstance EHSTaskHostObjectInstance
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass
EHSTaskHostSemanticObject EHSTaskHostSemanticObject
EHSTaskTitle EHSTaskTitle
EHSPlannedTaskID EHSPlannedTaskID
EHSTaskOwnerUser EHSTaskOwnerUser
EHSTaskOwnerUserName EHSTaskOwnerUserName
EHSTaskOwnerBP EHSTaskOwnerBP
EHSTaskAssignedBP EHSTaskAssignedBP
EHSTaskAssignedUserName EHSTaskAssignedUserName
EHSTaskAssignedLocRoleName EHSTaskAssignedLocRoleName
EHSTaskInstanceProcessorName EHSTaskInstanceProcessorName
EHSTaskApproverLocRoleName EHSTaskApproverLocRoleName
EHSTaskApproverLocRole EHSTaskApproverLocRole
EHSTaskApprovingUserName EHSTaskApprovingUserName
EHSTaskDefinitionType EHSTaskDefinitionType
EHSTaskDefinitionStatus EHSTaskDefinitionStatus
EHSTaskStatusName EHSTaskStatusName
EHSTaskStatusCriticality EHSTaskStatusCriticality
WorkflowTaskStatus WorkflowTaskStatus
EHSTaskHasWorkflow EHSTaskHasWorkflow
EHSTaskStatusValueForSorting EHSTaskStatusValueForSorting
EHSLocationUUID EHSLocationUUID
EHSLocationIDAndName EHSLocationIDAndName
EHSTaskStartDate EHSTaskStartDate
EHSTaskTimeZone EHSTaskTimeZone
EHSTaskDueDate EHSTaskDueDate
EHSTaskInstceCompletionDate EHSTaskInstceCompletionDate
EHSTaskDateForSorting EHSTaskDateForSorting
EHSTaskIsRecurrent EHSTaskIsRecurrent
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused
EHSTaskInstanceDisplayAction EHSTaskInstanceDisplayAction
EHSTaskDefinitionManageAction EHSTaskDefinitionManageAction
IsDraftEntity
DraftIsLastChangedByMe DraftIsLastChangedByMe
EHSTaskDraftLastChangeDateTime DraftEntityLastChangeDateTime
InProcessByUser InProcessByUser
InProcessByUserDescription InProcessByUserDescription
LastChangedByUserDescription LastChangedByUserDescription
EHSTaskHasActiveEntity HasActiveEntity
DraftUUID DraftUUID
_EHSTaskDefinition _EHSTaskDefinition
_EHSTaskOwnerUser _EHSTaskOwnerUser
_EHSTaskAssigneeUser _EHSTaskAssigneeUser
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData.blocking: #('TRANSACTIONAL_DATA') }
@EndUserText.label: 'EHS Finding Task'
@Metadata.allowExtensions: true

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MIXED
}

@ObjectModel: { representativeKey: 'EHSTaskDefinitionUUID',
                semanticKey: [ 'EHSPlannedTaskID' ] }

@VDM.viewType: #CONSUMPTION

define view entity C_EHSFindingTask
  as select from C_EHSCombinedTaskDefAndInstce
  association [1..1] to E_EHSTaskDefinition      as _Extension         on $projection.EHSTaskDefinitionUUID = _Extension.EHSTaskDefinitionUUID
  association [1..1] to E_EHSTaskPlannedInstance as _ExtensionInstance on $projection.EHSPlannedTaskUUID = _ExtensionInstance.EHSPlannedTaskUUID

  //  association [1..1] to C_EHSTaskDefinitionType  as _EHSTaskDefinitionType on  $projection.EHSTaskHostObjectAdapterClass = _EHSTaskDefinitionType.EHSTaskAdapterClass

  //                                                                           and $projection.EHSTaskDefinitionType         = _EHSTaskDefinitionType.EHSTaskDefinitionType

{
  key EHSTaskDefinitionUUID,
  key WorkflowTaskInternalID,
  key EHSPlannedTaskUUID,

      EHSTaskHostObjectInstanceUUID,
      EHSTaskHostObjectInstance,
      EHSTaskHostObjectAdapterClass,

      /* start suppress warning shlporigin_not_inherited */
      EHSTaskHostSemanticObject,
      /* end suppress warning shlporigin_not_inherited */

      @Semantics.text: true
      EHSTaskTitle,

      @ObjectModel.filter.enabled: true
      EHSPlannedTaskID,

      @ObjectModel.text.element: [ 'EHSTaskOwnerUserName' ]
      EHSTaskOwnerUser,

      @Semantics.text: true
      EHSTaskOwnerUserName,

      @Consumption.hidden: true
      EHSTaskOwnerBP,

      @Consumption.hidden: true
      EHSTaskAssignedBP,
      EHSTaskAssignedUserName,
      EHSTaskAssignedLocRoleName,

      EHSTaskInstanceProcessorName,

      EHSTaskApproverLocRoleName,
      EHSTaskApproverLocRole,
      EHSTaskApprovingUserName,

      EHSTaskDefinitionType,

      EHSTaskDefinitionStatus,

      @ObjectModel.sort.enabled: true
      @ObjectModel.filter.enabled: false
      @Consumption.filter.hidden: true
      EHSTaskStatusName,
      EHSTaskStatusCriticality,
      WorkflowTaskStatus,
      EHSTaskHasWorkflow,
      EHSTaskStatusValueForSorting,

      EHSLocationUUID,
      EHSLocationIDAndName,

      EHSTaskStartDate,
      EHSTaskTimeZone,
      EHSTaskDueDate,
      EHSTaskInstceCompletionDate,
      EHSTaskDateForSorting,

      EHSTaskIsRecurrent,
      EHSTaskDefinitionIsPaused,

      EHSTaskInstanceDisplayAction,
      EHSTaskDefinitionManageAction,

      // Draft fields necessary for the UI representation of the "Draft" link

      @Semantics.booleanIndicator: true
      cast( IsDraftEntity as ehfnd_task_is_draft_entity preserving type ) as IsDraftEntity,

      @Semantics.booleanIndicator: true
      DraftIsLastChangedByMe,
      DraftEntityLastChangeDateTime                                       as EHSTaskDraftLastChangeDateTime,
      InProcessByUser,

      @Semantics.text: true
      InProcessByUserDescription,
      LastChangedByUserDescription,

      @Semantics.booleanIndicator: true
      HasActiveEntity                                                     as EHSTaskHasActiveEntity,
      DraftUUID,

      /* Associations */
      _EHSTaskDefinition,
      _EHSTaskOwnerUser,
      _EHSTaskAssigneeUser
      //      _EHSTaskDefinitionType

}
where
  EHSTaskHostSemanticObject = 'EHSFinding'