C_EHSTaskMonitoring

@AbapCatalog.sqlViewName: 'CEHSTASKMON'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{ serviceQuality: #D,        // < 100 msec

                         sizeCategory:  #XL,         // < 10.000.000

                         dataClass: #MIXED }
@AccessControl: {
  authorizationCheck: #CHECK
}

// #NOT_REQUIRED as a start

@AccessControl.personalData.blocking: #NOT_REQUIRED

@EndUserText.label: 'Monitor Tasks'

@Consumption.semanticObject: 'EHSTask'
@ObjectModel.semanticKey: 'EHSPlannedTaskID'
@ObjectModel.representativeKey: 'WorkflowTaskInternalID'
@Metadata.allowExtensions: true

define view C_EHSTaskMonitoring
  as select from C_EHSCombinedTaskDefAndInstce as CombinedTaskDefAndInstce
  association [0..*] to I_EHSSemanticObjectText  as _SemanticObjectText on $projection.EHSTaskHostSemanticObject = _SemanticObjectText.EHSSemanticObject
  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
{
  key EHSTaskDefinitionUUID,
  key WorkflowTaskInternalID,
  key EHSPlannedTaskUUID,

      // Task Type:

      @Consumption.valueHelpDefinition: [{ entity: {
        name: 'C_EHSTaskDefinitionTypeVH',
        element: 'EHSTaskDefinitionType'
      } }]
      @ObjectModel.text.association: '_EHSTaskDefinitionTypeText'
      EHSTaskDefinitionType,

      // Task Title:

      EHSTaskTitle,

      cast(EHSPlannedTaskID as ehfnd_task_planned_id) as EHSPlannedTaskID,

      // Task Status:

      EHSTaskStatusValueForSorting,
      EHSTaskStatusName,
      EHSTaskDefinitionIsPaused,
      EHSTaskDefinitionStatus,
      WorkflowTaskStatus,
      WrkflwTskCompletionUTCDateTime,
      @Consumption.valueHelpDefinition: [{ entity: {
        name: 'I_Indicator',
        element: 'IndicatorValue'
      } }]
      EHSTaskHasWorkflow,

      // Task Due Date:

      EHSTaskDueDate,

      // Task Start Date:

      EHSTaskStartDate,

      // Task Completion Date:

      EHSTaskInstceCompletionDate,

      // Task Recurrence:

      EHSTaskIsRecurrent,

      // Task Priority:

      @ObjectModel.text.element: ['EHSTaskPriorityName']
      EHSTaskPriority,

      @Semantics.text:true
      EHSTaskPriorityName,

      EHSTaskStatusCriticality,

      @Consumption.valueHelpDefinition: [{ entity: {
        name: 'C_EHSTaskSemanticObjValueHelp',
        element: 'EHSSemanticObject'
      } }]
      @ObjectModel.text.association: '_SemanticObjectText'
      EHSTaskHostSemanticObject,

      EHSTaskHostObjectInstance,

      @UI.hidden: true
      EHSTaskHostObjectInstanceUUID,

      @ObjectModel.foreignKey.association: '_BusinessPartner'
      @Consumption.valueHelpDefinition: [{
      entity: {
        name: 'C_EHSTaskUserValueHelp',
        element: 'BusinessPartner'
      } }]
      @ObjectModel.text.element: ['EHSTaskUserName']
      EHSTaskUser,

      @Semantics.text:true
      EHSTaskUserName,

      // Task Current Processor:

      @ObjectModel.foreignKey.association: '_EHSTaskInstanceProcessorUser'
      @Consumption.valueHelpDefinition: [{
          entity: {
          name: 'C_EHSTaskProcessorValueHelp',
          element: 'BusinessPartner'
          } }]
      @ObjectModel.text.element: ['EHSTaskInstanceProcessorName']
      EHSTaskInstanceProcessorBP,

      EHSTaskInstanceProcessorUser,

      @Semantics.text:true
      EHSTaskInstanceProcessorName,

      // Task Owner:

      EHSTaskOwnerUser,

      @ObjectModel.foreignKey.association: '_EHSTaskOwnerUser'
      @Consumption.valueHelpDefinition: [{
        entity: {
          name: 'C_EHSTaskOwnerValueHelp',
          element: 'BusinessPartner'
        } }]
      @ObjectModel.text.element: ['EHSTaskOwnerUserName']
      EHSTaskOwnerBP,

      EHSTaskOwnerUserName,

      _EHSTaskAssigneeUser.UserID                   as EHSTaskAssignedUser,

      @ObjectModel.foreignKey.association: '_EHSTaskAssigneeUser'
      @Consumption.valueHelpDefinition: [{
        entity: {
          name: 'C_EHSTaskAssignedUserVH',
          element: 'BusinessPartner'
        } }]
      @ObjectModel.text.element: ['EHSTaskAssignedUserName']
      EHSTaskAssignedBP,

      @Semantics.text:true
      EHSTaskAssignedUserName,

      @Consumption.valueHelpDefinition: [{
        entity: {
          name: 'C_EHSLocationPersnRespRoleVH',
          element: 'EHSLocationPersonRespRole'
        } }]
      @ObjectModel.text.element: ['EHSTaskAssignedLocRoleName']
      EHSTaskAssignedLocRole,

      EHSTaskAssignedLocRoleName,

      @Consumption.valueHelpDefinition: [{
        entity: {
          name: 'C_EHSTaskApprovingUserVH',
          element: 'BusinessPartner'
        } }]
      @ObjectModel.text.element: ['EHSTaskApprovingUserName']
      EHSTaskApprovingBP,

      @Semantics.text:true
      EHSTaskApprovingUserName,

      @Consumption.valueHelpDefinition: [{
        entity: {
          name: 'C_EHSLocationPersnRespRoleVH',
          element: 'EHSLocationPersonRespRole'
        } }]
      @ObjectModel.text.element: ['EHSTaskApproverLocRoleName']
      EHSTaskApproverLocRole,

      EHSTaskApproverLocRoleName,

      EHSTaskDefinitionManageAction,
      EHSTaskInstanceDisplayAction,

      // Task Date - for sorting:

      EHSTaskDateForSorting,

      EHSTaskHostObjectAdapterClass,

      @ObjectModel: {
               readOnly: true,
               virtualElement: true,
               virtualElementCalculatedBy: 'ABAP:CL_EHFND_TASK_MON_EXIT'
      }
      cast('' as text240)                           as EHSTskRelatedObjectDescription,

      @ObjectModel: {
               readOnly: true,
               virtualElement: true,
               virtualElementCalculatedBy: 'ABAP:CL_EHFND_TASK_MON_EXIT'
      }
      cast('' as text1024)                          as EHSTaskRelatedObjectURL,

      @ObjectModel.text.element: ['EHSLocationIDAndName']
      @ObjectModel.sort.enabled: false
      EHSLocationUUID,
      EHSLocationName,
      EHSLocationID,
      @Consumption.filter.hidden: true
      EHSLocationIDAndName,
      EHSTaskTimeZone,

      @UI.textArrangement: #TEXT_ONLY
      @UI.hidden: true
      IsDraftEntity,

      // Draft Administrative Data

      @UI.hidden: true
      DraftEntityLastChangeDateTime,
      @UI.hidden: true
      @UI.textArrangement: #TEXT_ONLY
      DraftIsLastChangedByMe,
      @UI.hidden: true
      LastChangedByUserDescription,
      @UI.hidden: true
      DraftIsProcessedByMe,
      @UI.hidden: true
      InProcessByUserDescription,
      @UI.hidden: true
      InProcessByUser,

      @UI.hidden: true
      @Semantics.booleanIndicator: true
      HasActiveEntity,

      @UI.hidden: true
      DraftUUID,

      // associations exposure:

      @Consumption.hidden: true
      _SemanticObjectText,
      _EHSTaskDefinitionTypeText,
      _TernaryLogicalStateText,
      _EHSTaskOwnerUser,
      _EHSTaskAssigneeUser,
      _EHSTaskApprovingUser,
      _EHSTaskSortingStatus,
      _EHSTaskPriority,
      _EHSTaskInstanceProcessorUser,
      _BusinessPartner,

      // Associations for Authorization Check of Host BO

      _EHSTaskAdapterClass,
      _IncidentAuthorizationFields,
      _EHSCtrlImplmtnAuthznFields,
      _EHSRskAssessmentAuthznFields,
      _EHSCmplncScenAuthznFields,
      _CmplncRqmtAuthznFields,
      IncidentHasAccessRestriction
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_EHSCOMBINEDTASKDEFANDINSTCE",
"I_BUSINESSUSERBASIC"
],
"ASSOCIATED":
[
"E_EHSTASKDEFINITION",
"E_EHSTASKPLANNEDINSTANCE",
"I_BUSINESSUSERBASIC",
"I_CMPLNCRQMTAUTHZNFIELDS",
"I_EHSCMPLNCSCENAUTHZNFIELDS",
"I_EHSCTRLIMPLMTNAUTHZNFIELDS",
"I_EHSRSKASSESSMENTAUTHZNFIELDS",
"I_EHSSEMANTICOBJECTTEXT",
"I_EHSTASKADAPTERCLASS",
"I_EHSTASKDEFINITIONTYPETEXT",
"I_EHSTASKPRIORITY",
"I_EHSTASKSORTINGSTATUS",
"I_INCIDENTCOMBAUTHFIELDS",
"I_TERNARYLOGICALSTATETEXT"
],
"BASE":
[
"C_EHSCOMBINEDTASKDEFANDINSTCE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/