C_EHSCmplncScenTskDef

DDL: C_EHSCMPLNCSCENTSKDEF SQL: CEHSSCENDEF Type: view CONSUMPTION Package: EHENV_CNS_EMISSION_INVENTORY
44 Fields 1 Data Sources 3 Associations

Compliance Scenario Task Definitions

C_EHSCmplncScenTskDef is a Consumption CDS View that provides data about "Compliance Scenario Task Definitions" in SAP S/4HANA. It reads from 1 data source (I_EHSTaskDefinitionTP) and exposes 44 fields with key field EHSTaskDefinitionUUID. It has 3 associations to related views. Part of development package EHENV_CNS_EMISSION_INVENTORY.

Data Sources (1)

SourceAliasJoin Type
I_EHSTaskDefinitionTP I_EHSTaskDefinitionTP from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText $projection.EHSTaskWorkflowEvent = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType and _EHSTaskDefinitionTypeText.Language = $session.system_language
[0..1] I_EHSTaskPriorityText _EHSTaskPriorityText $projection.EHSTaskPriority = _EHSTaskPriorityText.EHSTaskPriority and _EHSTaskPriorityText.Language = $session.system_language
[0..1] C_EHSTaskUserValueHelp _EHSTaskAssignedUser $projection.EHSTaskAssignedUser = _EHSTaskAssignedUser.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CEHSSCENDEF view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Compliance Scenario Task Definitions view
Consumption.semanticObject EHSTask view
ObjectModel.semanticKey EHSTaskID view
ObjectModel.representativeKey EHSTaskDefinitionUUID view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID Task Definition
EHSTaskWorkflowEvent EHSTaskWorkflowEvent Task Type
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectInstance EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass Class Name
EHSTaskPriority EHSTaskPriority Priority
EHSTaskAssignedUser EHSTaskAssignedUser Assignee
EHSTaskAssignedUserName _EHSTaskAssignedUser PersonFullName Full Name
EHSTaskOwnerUser EHSTaskOwnerUser Owner
EHSTaskTitle EHSTaskTitle Title
EHSTaskStartDate EHSTaskStartDate Start Date
EHSTaskDueInValue EHSTaskDueInValue Due In
EHSTaskDueInUnit EHSTaskDueInUnit Due In
EHSTaskDueDate EHSTaskDueDate Due Date
EHSTaskRecurrenceType EHSTaskRecurrenceType Recurrence Type
EHSTaskRecurrenceInterval EHSTaskRecurrenceInterval Recurrence
EHSTaskIsRecurringOnMonday EHSTaskIsRecurringOnMonday Monday
EHSTaskIsRecurringOnTuesday EHSTaskIsRecurringOnTuesday Tuesday
EHSTaskIsRecurringOnWednesday EHSTaskIsRecurringOnWednesday Wednesday
EHSTaskIsRecurringOnThursday EHSTaskIsRecurringOnThursday Thursday
EHSTaskIsRecurringOnFriday EHSTaskIsRecurringOnFriday Friday
EHSTaskIsRecurringOnSaturday EHSTaskIsRecurringOnSaturday Saturday
EHSTaskIsRecurringOnSunday EHSTaskIsRecurringOnSunday Sunday
EHSTaskRecurrenceDay EHSTaskRecurrenceDay Day of Month
EHSTaskRecurrenceMonth EHSTaskRecurrenceMonth Month of Year
EHSTaskRecurrenceOffset EHSTaskRecurrenceOffset Recur. Offset
EHSTaskRecurrenceWeekDay EHSTaskRecurrenceWeekDay Weekday
EHSTaskRecurrenceEndType EHSTaskRecurrenceEndType Recur. End Type
EHSTaskRecurrenceEndDate EHSTaskRecurrenceEndDate Recur. End Date
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused Is Paused
EHSTaskID EHSTaskID ID
_EHSTaskPriority _EHSTaskPriority
_EHSTaskDueInUnit _EHSTaskDueInUnit
_EHSTaskRecurrenceType _EHSTaskRecurrenceType
_EHSTaskRecurrenceOffset _EHSTaskRecurrenceOffset
_EHSTaskRecurrenceWeekDay _EHSTaskRecurrenceWeekDay
_EHSTaskRecurrenceMonth _EHSTaskRecurrenceMonth
_EHSTaskRecurrenceEndType _EHSTaskRecurrenceEndType
_EHSTaskAdapterClass _EHSTaskAdapterClass
_EHSTaskAssignedUser _EHSTaskAssignedUser
_EHSTaskOwnerUser _EHSTaskOwnerUser
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText
_EHSTaskPriorityText _EHSTaskPriorityText
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields

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_EHSCmplncScenTskDef.
-- 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: CEHSSCENDEF

CREATE VIEW C_EHSCmplncScenTskDef AS
SELECT
  EHSTaskDefinitionUUID,
  EHSTaskWorkflowEvent,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  EHSTaskPriority,
  EHSTaskAssignedUser,
  _EHSTaskAssignedUser.PersonFullName AS EHSTaskAssignedUserName,
  EHSTaskOwnerUser,
  EHSTaskTitle,
  EHSTaskStartDate,
  EHSTaskDueInValue,
  EHSTaskDueInUnit,
  EHSTaskDueDate,
  EHSTaskRecurrenceType,
  EHSTaskRecurrenceInterval,
  EHSTaskIsRecurringOnMonday,
  EHSTaskIsRecurringOnTuesday,
  EHSTaskIsRecurringOnWednesday,
  EHSTaskIsRecurringOnThursday,
  EHSTaskIsRecurringOnFriday,
  EHSTaskIsRecurringOnSaturday,
  EHSTaskIsRecurringOnSunday,
  EHSTaskRecurrenceDay,
  EHSTaskRecurrenceMonth,
  EHSTaskRecurrenceOffset,
  EHSTaskRecurrenceWeekDay,
  EHSTaskRecurrenceEndType,
  EHSTaskRecurrenceEndDate,
  EHSTaskDefinitionIsPaused,
  EHSTaskID
FROM I_EHSTaskDefinitionTP
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskWorkflowEvent = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType AND _EHSTaskDefinitionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskPriorityText AS _EHSTaskPriorityText ON EHSTaskPriority = _EHSTaskPriorityText.EHSTaskPriority AND _EHSTaskPriorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_EHSTaskUserValueHelp AS _EHSTaskAssignedUser ON EHSTaskAssignedUser = _EHSTaskAssignedUser.BusinessPartner  -- association [0..1]
;

Learn More