C_IncidentTaskDefinition

DDL: C_INCIDENTTASKDEFINITION SQL: CINCDEFINITION Type: view CONSUMPTION Package: EHHSS_CNS_INC_RECORDING
58 Fields 1 Data Sources 1 OData Services

Incident Task Definition

C_IncidentTaskDefinition is a Consumption CDS View that provides data about "Incident Task Definition" in SAP S/4HANA. It reads from 1 data source (C_EHSTaskDefinitionWithDraft) and exposes 58 fields with key field EHSTaskDefinitionUUID. It is exposed through 1 OData service (ASQL_F3091). Part of development package EHHSS_CNS_INC_RECORDING.

Data Sources (1)

SourceAliasJoin Type
C_EHSTaskDefinitionWithDraft C_EHSTaskDefinitionWithDraft from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CINCDEFINITION 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 Definition view
Consumption.semanticObject EHSTask view
ObjectModel.semanticKey EHSTaskID view
ObjectModel.representativeKey EHSTaskDefinitionUUID view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3091 ASQL_F3091 C2 NOT_RELEASED

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID Task Definition
IsDraftEntity IsDraftEntity
EHSTaskHasWorkflow EHSTaskHasWorkflow
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectInstance EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass Class Name
EHSTaskHostSemanticObject EHSTaskHostSemanticObject
EHSTaskTitle EHSTaskTitle Title
EHSTaskPriorityName EHSTaskPriorityName
EHSTaskAssignedUserName EHSTaskAssignedUserName Full Name
EHSTaskOwnerUserName EHSTaskOwnerUserName Full Name
EHSTaskApprovingUserName EHSTaskApprovingUserName Full Name
EHSTaskApproverLocRoleName EHSTaskApproverLocRoleName Approver Location Role
EHSTaskAssignedLocRoleName EHSTaskAssignedLocRoleName
EHSTaskRecurrenceDescription EHSTaskRecurrenceDescription
EHSTaskOwnerBP EHSTaskOwnerBP Owner
EHSTaskID EHSTaskID ID
EHSTaskDefinitionStatus EHSTaskDefinitionStatus Status
EHSTaskDefinitionType EHSTaskDefinitionType Task Type
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText
EHSTaskInstanceDisplayAction EHSTaskInstanceDisplayAction Action TaskInst
EHSTaskDefinitionManageAction EHSTaskDefinitionManageAction Action TaskDef
EHSTaskStartDate EHSTaskStartDate Start Date
EHSTaskDueInValue EHSTaskDueInValue Due In
EHSTaskDueInUnit EHSTaskDueInUnit Due In
EHSTaskDueDate EHSTaskDueDate Due Date
EHSTaskRecurrenceType EHSTaskRecurrenceType Recurrence Type
EHSTaskIsDueOnSameDay EHSTaskIsDueOnSameDay Due Same Day
EHSTaskStartBeforeValue EHSTaskStartBeforeValue Start Before
EHSTaskStartBeforeUnit EHSTaskStartBeforeUnit Start Before
EHSTaskRecurrenceIsByDueDate EHSTaskRecurrenceIsByDueDate Due Date Based
EHSTaskRecurrenceOffset EHSTaskRecurrenceOffset Recur. Offset
EHSTaskIsRecurringOnMonday EHSTaskIsRecurringOnMonday Monday
EHSTaskIsRecurringOnTuesday EHSTaskIsRecurringOnTuesday Tuesday
EHSTaskIsRecurringOnWednesday EHSTaskIsRecurringOnWednesday Wednesday
EHSTaskIsRecurringOnThursday EHSTaskIsRecurringOnThursday Thursday
EHSTaskIsRecurringOnFriday EHSTaskIsRecurringOnFriday Friday
EHSTaskIsRecurringOnSaturday EHSTaskIsRecurringOnSaturday Saturday
EHSTaskIsRecurringOnSunday EHSTaskIsRecurringOnSunday Sunday
EHSTaskRecurrenceWeekDay EHSTaskRecurrenceWeekDay Weekday
EHSTaskRecurrenceInterval EHSTaskRecurrenceInterval Recurrence
EHSTaskRecurrenceEndDate EHSTaskRecurrenceEndDate Recur. End Date
EHSTaskRecurrenceFirstDueDate EHSTaskRecurrenceFirstDueDate First Due Date
EHSTaskRecurrenceDay EHSTaskRecurrenceDay Day of Month
DraftEntityLastChangeDateTime DraftEntityLastChangeDateTime Draft Last Changed On
DraftIsLastChangedByMe DraftIsLastChangedByMe
LastChangedByUserDescription LastChangedByUserDescription Description
DraftIsProcessedByMe DraftIsProcessedByMe
InProcessByUserDescription InProcessByUserDescription
InProcessByUser InProcessByUser
HasActiveEntity HasActiveEntity TRUE
EHSTaskDefinitionActiveUUID EHSTaskDefinitionActiveUUID
IncidentUUID _IncidentAuthorizationFields IncidentUUID Incident UUID
_IncidentAuthorizationFields _IncidentAuthorizationFields
_EHSTaskAdapterClass _EHSTaskAdapterClass
_EHSTaskOwnerUser _EHSTaskOwnerUser
_IncidentTaskRefAccRestricted _IncidentTaskRefAccRestricted
_EHSTaskDefinitionStatusText _EHSTaskDefinitionStatusText

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_IncidentTaskDefinition.
-- 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: CINCDEFINITION

CREATE VIEW C_IncidentTaskDefinition AS
SELECT
  EHSTaskDefinitionUUID,
  IsDraftEntity,
  EHSTaskHasWorkflow,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  EHSTaskHostSemanticObject,
  EHSTaskTitle,
  EHSTaskPriorityName,
  EHSTaskAssignedUserName,
  EHSTaskOwnerUserName,
  EHSTaskApprovingUserName,
  EHSTaskApproverLocRoleName,
  EHSTaskAssignedLocRoleName,
  EHSTaskRecurrenceDescription,
  EHSTaskOwnerBP,
  EHSTaskID,
  EHSTaskDefinitionStatus,
  EHSTaskDefinitionType,
  EHSTaskInstanceDisplayAction,
  EHSTaskDefinitionManageAction,
  EHSTaskStartDate,
  EHSTaskDueInValue,
  EHSTaskDueInUnit,
  EHSTaskDueDate,
  EHSTaskRecurrenceType,
  EHSTaskIsDueOnSameDay,
  EHSTaskStartBeforeValue,
  EHSTaskStartBeforeUnit,
  EHSTaskRecurrenceIsByDueDate,
  EHSTaskRecurrenceOffset,
  EHSTaskIsRecurringOnMonday,
  EHSTaskIsRecurringOnTuesday,
  EHSTaskIsRecurringOnWednesday,
  EHSTaskIsRecurringOnThursday,
  EHSTaskIsRecurringOnFriday,
  EHSTaskIsRecurringOnSaturday,
  EHSTaskIsRecurringOnSunday,
  EHSTaskRecurrenceWeekDay,
  EHSTaskRecurrenceInterval,
  EHSTaskRecurrenceEndDate,
  EHSTaskRecurrenceFirstDueDate,
  EHSTaskRecurrenceDay,
  DraftEntityLastChangeDateTime,
  DraftIsLastChangedByMe,
  LastChangedByUserDescription,
  DraftIsProcessedByMe,
  InProcessByUserDescription,
  InProcessByUser,
  HasActiveEntity,
  EHSTaskDefinitionActiveUUID,
  _IncidentAuthorizationFields.IncidentUUID AS IncidentUUID
FROM C_EHSTaskDefinitionWithDraft
;

Learn More