C_EHSControlImplementationTask

DDL: C_EHSCONTROLIMPLEMENTATIONTASK Type: view CONSUMPTION

Control Implementation Task

C_EHSControlImplementationTask is a Consumption CDS View that provides data about "Control Implementation Task" in SAP S/4HANA. It reads from 1 data source (C_EHSCombinedTaskDefAndInstce) and exposes 53 fields with key fields EHSTaskDefinitionUUID, WorkflowTaskInternalID, EHSPlannedTaskUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
C_EHSCombinedTaskDefAndInstce CombinedTaskDefAndInstce from

Associations (2)

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

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CEHSCTRLTSK view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.semanticObject EHSTask view
EndUserText.label Control Implementation Task view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID
KEY WorkflowTaskInternalID WorkflowTaskInternalID
KEY EHSPlannedTaskUUID EHSPlannedTaskUUID
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID
EHSTaskHostObjectInstance EHSTaskHostObjectInstance
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass
EHSTaskHostSemanticObject EHSTaskHostSemanticObject
EHSTaskHasWorkflow EHSTaskHasWorkflow
EHSTaskDefinitionType EHSTaskDefinitionType
EHSTaskTitle EHSTaskTitle
EHSPlannedTaskID EHSPlannedTaskID
EHSTaskOwnerUser EHSTaskOwnerUser
EHSTaskInstanceProcessorUser EHSTaskInstanceProcessorUser
EHSTaskInstanceProcessorName EHSTaskInstanceProcessorName
EHSTaskOwnerBP EHSTaskOwnerBP
EHSTaskOwnerUserName EHSTaskOwnerUserName
EHSTaskAssignedBP EHSTaskAssignedBP
EHSTaskAssignedUserName EHSTaskAssignedUserName
EHSTaskApprovingBP EHSTaskApprovingBP
EHSTaskApprovingUserName EHSTaskApprovingUserName
WorkflowTaskStatus WorkflowTaskStatus
EHSTaskDefinitionStatus EHSTaskDefinitionStatus
EHSTaskStatusName EHSTaskStatusName
EHSTaskStatusCriticality EHSTaskStatusCriticality
EHSTaskStatusValueForSorting EHSTaskStatusValueForSorting
EHSTaskStartDate EHSTaskStartDate
EHSTaskDueDate EHSTaskDueDate
EHSTaskInstceCompletionDate EHSTaskInstceCompletionDate
WrkflwTskCompletionUTCDateTime WrkflwTskCompletionUTCDateTime
EHSTaskDateForSorting EHSTaskDateForSorting
EHSTaskTimeZone EHSTaskTimeZone
EHSTaskIsRecurrent EHSTaskIsRecurrent
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused
EHSTaskDefinitionManageAction EHSTaskDefinitionManageAction
EHSTaskInstanceDisplayAction EHSTaskInstanceDisplayAction
IsDraftEntity IsDraftEntity
DraftEntityLastChangeDateTime DraftEntityLastChangeDateTime
DraftIsLastChangedByMe DraftIsLastChangedByMe
LastChangedByUserDescription LastChangedByUserDescription
DraftIsProcessedByMe DraftIsProcessedByMe
InProcessByUserDescription InProcessByUserDescription
InProcessByUser InProcessByUser
HasActiveEntity HasActiveEntity
DraftUUID DraftUUID
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText
_TernaryLogicalStateText _TernaryLogicalStateText
_EHSTaskAdapterClass _EHSTaskAdapterClass
_IncidentAuthorizationFields _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields
IncidentHasAccessRestriction
@AbapCatalog: {
  compiler.compareFilter: true,
  sqlViewName: 'CEHSCTRLTSK',
  preserveKey:true 
}
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.semanticObject: 'EHSTask'
@EndUserText.label: 'Control Implementation Task'
@Metadata.allowExtensions: true
@ObjectModel: {
  representativeKey: ['EHSTaskDefinitionUUID','WorkflowTaskInternalID'],
  semanticKey: ['EHSPlannedTaskID'],
  usageType:{ serviceQuality: #D,        // < 100 msec

              sizeCategory:   #L,         // < 10.000.000

              dataClass:      #MIXED }
}
@VDM.viewType: #CONSUMPTION
define view C_EHSControlImplementationTask
  as select from C_EHSCombinedTaskDefAndInstce   as CombinedTaskDefAndInstce
  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,
      
      @UI.hidden: true
      EHSTaskHostObjectInstanceUUID,
      EHSTaskHostObjectInstance,
      EHSTaskHostObjectAdapterClass,
      EHSTaskHostSemanticObject,
      EHSTaskHasWorkflow,
      
      @Consumption.valueHelpDefinition: [{
        entity: {
          name: 'C_EHSCtrlImplmtnTaskDefTypeVH',
          element: 'EHSTaskDefinitionType'
        }
      }]
      EHSTaskDefinitionType,

      EHSTaskTitle,
      EHSPlannedTaskID,

      EHSTaskOwnerUser,
      @Consumption.hidden: true
      EHSTaskInstanceProcessorUser,
      EHSTaskInstanceProcessorName,

      @ObjectModel.text.element: ['EHSTaskOwnerUserName']
      EHSTaskOwnerBP,
      EHSTaskOwnerUserName,
      
      @ObjectModel.text.element: ['EHSTaskAssignedUserName']
      EHSTaskAssignedBP,
      EHSTaskAssignedUserName,

      @ObjectModel.text.element: ['EHSTaskApprovingUserName']
      EHSTaskApprovingBP,
      EHSTaskApprovingUserName,

      WorkflowTaskStatus,
      EHSTaskDefinitionStatus,
      EHSTaskStatusName,
      EHSTaskStatusCriticality,
      EHSTaskStatusValueForSorting,

      EHSTaskStartDate,
      EHSTaskDueDate,
      EHSTaskInstceCompletionDate,
      WrkflwTskCompletionUTCDateTime,
      EHSTaskDateForSorting,
      EHSTaskTimeZone,
    
      EHSTaskIsRecurrent,
      EHSTaskDefinitionIsPaused,

      EHSTaskDefinitionManageAction,
      EHSTaskInstanceDisplayAction,

      // ************* begin correction  3240821  26.08.2022

      @UI.hidden: true
      @UI.textArrangement: #TEXT_ONLY
      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,
      // ************* end correction  3240821  26.08.2022

      
      _EHSTaskDefinitionTypeText,      
      _TernaryLogicalStateText,

      // Associations for Authorization Check of Host BO

      _EHSTaskAdapterClass,
      _IncidentAuthorizationFields,
      _EHSCtrlImplmtnAuthznFields,
      _EHSRskAssessmentAuthznFields,
      _EHSCmplncScenAuthznFields,
      _CmplncRqmtAuthznFields,   
// begin correction 2898658

      ' ' as IncidentHasAccessRestriction
// end correction 2898658      


} where
  EHSTaskHostSemanticObject = 'EHSControlImplementation'