C_IncidentTaskDefAndInstance

DDL: C_INCIDENTTASKDEFANDINSTANCE SQL: CINCDEFINST Type: view CONSUMPTION
58 Fields 1 Data Sources 2 Associations

Incident Task Inst. and Future Defs.

C_IncidentTaskDefAndInstance is a Consumption CDS View that provides data about "Incident Task Inst. and Future Defs." in SAP S/4HANA. It reads from 1 data source (C_EHSCombinedTaskDefAndInstce) and exposes 58 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 (15)

NameValueLevelField
AbapCatalog.sqlViewName CINCDEFINST view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Incident Task Inst. and Future Defs. view
Consumption.semanticObject EHSTask view
ObjectModel.semanticKey EHSTaskDefinitionUUID view
ObjectModel.representativeKey EHSTaskDefinitionUUID view
Metadata.allowExtensions true view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID Task Definition
KEY WorkflowTaskInternalID WorkflowTaskInternalID Work Item ID
KEY EHSPlannedTaskUUID EHSPlannedTaskUUID Planned Task
EHSTaskHostObjectInstance EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass Class Name
EHSTaskHostSemanticObject EHSTaskHostSemanticObject
EHSTaskHasWorkflow EHSTaskHasWorkflow
EHSTaskTitle EHSTaskTitle Title
EHSPlannedTaskID EHSPlannedTaskID ID
EHSTaskDefinitionType EHSTaskDefinitionType Task Type
EHSTaskStatusName EHSTaskStatusName
EHSTaskStatusCriticality EHSTaskStatusCriticality
EHSTaskDueDate EHSTaskDueDate Due Date
EHSTaskIsRecurrent EHSTaskIsRecurrent
EHSTaskInstanceProcessorName
EHSTskRelatedObjectDescription
EHSTaskStartDate EHSTaskStartDate Start Date
EHSTaskInstceCompletionDate EHSTaskInstceCompletionDate Completion Date
EHSTaskStatusValueForSorting EHSTaskStatusValueForSorting
EHSTaskDateForSorting EHSTaskDateForSorting
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused Is Paused
WorkflowTaskStatus WorkflowTaskStatus
WrkflwTskCompletionUTCDateTime WrkflwTskCompletionUTCDateTime
EHSTaskDefinitionStatus EHSTaskDefinitionStatus Status
EHSTaskTimeZone EHSTaskTimeZone Time Zone
EHSTaskDefinitionManageAction EHSTaskDefinitionManageAction Action TaskDef
EHSTaskInstanceDisplayAction EHSTaskInstanceDisplayAction Action TaskInst
EHSTaskOwnerUser EHSTaskOwnerUser Owner
EHSTaskOwnerBP EHSTaskOwnerBP Owner
EHSTaskOwnerUserName EHSTaskOwnerUserName Owner
EHSTaskAssignedBP EHSTaskAssignedBP Assignee
EHSTaskAssignedUserName EHSTaskAssignedUserName Assignee
EHSTaskAssignedLocRoleName EHSTaskAssignedLocRoleName
EHSTaskApprovingBP EHSTaskApprovingBP Approver
EHSTaskApprovingUserName EHSTaskApprovingUserName Approver
EHSTaskApproverLocRoleName EHSTaskApproverLocRoleName
EHSTaskInstanceProcessorUser EHSTaskInstanceProcessorUser User Name
IsDraftEntity IsDraftEntity
DraftEntityLastChangeDateTime DraftEntityLastChangeDateTime Draft Last Changed On
DraftIsLastChangedByMe DraftIsLastChangedByMe
LastChangedByUserDescription LastChangedByUserDescription Description
DraftIsProcessedByMe DraftIsProcessedByMe
InProcessByUserDescription InProcessByUserDescription
InProcessByUser InProcessByUser
HasActiveEntity HasActiveEntity TRUE
DraftUUID DraftUUID UUID
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText
_TernaryLogicalStateText _TernaryLogicalStateText
_EHSTaskAdapterClass _EHSTaskAdapterClass
IncidentUUID _IncidentAuthorizationFields IncidentUUID Incident UUID
_IncidentAuthorizationFields _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields
_EHSTaskDefinition _EHSTaskDefinition
IncidentHasAccessRestriction IncidentHasAccessRestriction Restricted

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_IncidentTaskDefAndInstance.
-- 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.
-- SQL view name: CINCDEFINST

CREATE VIEW C_IncidentTaskDefAndInstance AS
SELECT
  EHSTaskDefinitionUUID,
  WorkflowTaskInternalID,
  EHSPlannedTaskUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectAdapterClass,
  EHSTaskHostSemanticObject,
  EHSTaskHasWorkflow,
  EHSTaskTitle,
  EHSPlannedTaskID,
  EHSTaskDefinitionType,
  EHSTaskStatusName,
  EHSTaskStatusCriticality,
  EHSTaskDueDate,
  EHSTaskIsRecurrent,
  cast(EHSTaskInstanceProcessorName as ehfnd_current_processor_name) AS EHSTaskInstanceProcessorName,
  cast ( '' as ehfnd_task_reference_descr ) AS EHSTskRelatedObjectDescription,
  EHSTaskStartDate,
  EHSTaskInstceCompletionDate,
  EHSTaskStatusValueForSorting,
  EHSTaskDateForSorting,
  EHSTaskDefinitionIsPaused,
  WorkflowTaskStatus,
  WrkflwTskCompletionUTCDateTime,
  EHSTaskDefinitionStatus,
  EHSTaskTimeZone,
  EHSTaskDefinitionManageAction,
  EHSTaskInstanceDisplayAction,
  EHSTaskOwnerUser,
  EHSTaskOwnerBP,
  EHSTaskOwnerUserName,
  EHSTaskAssignedBP,
  EHSTaskAssignedUserName,
  EHSTaskAssignedLocRoleName,
  EHSTaskApprovingBP,
  EHSTaskApprovingUserName,
  EHSTaskApproverLocRoleName,
  EHSTaskInstanceProcessorUser,
  IsDraftEntity,
  DraftEntityLastChangeDateTime,
  DraftIsLastChangedByMe,
  LastChangedByUserDescription,
  DraftIsProcessedByMe,
  InProcessByUserDescription,
  InProcessByUser,
  HasActiveEntity,
  DraftUUID,
  _IncidentAuthorizationFields.IncidentUUID AS IncidentUUID,
  IncidentHasAccessRestriction
FROM C_EHSCombinedTaskDefAndInstce AS CombinedTaskDefAndInstce
LEFT OUTER JOIN E_EHSTaskDefinition AS _Extension ON EHSTaskDefinitionUUID = _Extension.EHSTaskDefinitionUUID  -- association [1..1]
LEFT OUTER JOIN E_EHSTaskPlannedInstance AS _ExtensionInstance ON EHSPlannedTaskUUID = _ExtensionInstance.EHSPlannedTaskUUID  -- association [1..1]
;

Learn More