C_EHSCmplncRqmtTskDef

DDL: C_EHSCMPLNCRQMTTSKDEF SQL: CEHSCMPLRQTSKDEF Type: view CONSUMPTION Package: EHFND_CNS_COMPLIANCE_REQ
49 Fields 1 Data Sources 6 Associations

Compliance Requirement Task Definitions

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

Data Sources (1)

SourceAliasJoin Type
I_EHSTaskDefinitionTP I_EHSTaskDefinitionTP from

Associations (6)

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
[0..1] C_EHSTaskUserValueHelp _EHSTaskOwnerUser $projection.EHSTaskOwnerUser = _EHSTaskOwnerUser.BusinessPartner
[0..1] I_BusinessUserBasic _EHSTaskAssignedUserBasic $projection.EHSTaskAssignedUser = _EHSTaskAssignedUserBasic.BusinessPartner
[0..1] I_BusinessUserBasic _EHSTaskOwnerUserBasic $projection.EHSTaskOwnerUser = _EHSTaskOwnerUserBasic.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CEHSCMPLRQTSKDEF view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Compliance Requirement Task Definitions view
Consumption.semanticObject EHSTask view
ObjectModel.semanticKey EHSTaskID view
ObjectModel.representativeKey EHSTaskDefinitionUUID view

Fields (49)

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 _EHSTaskAssignedUserBasic PersonFullName Full Name
EHSTaskOwnerUser EHSTaskOwnerUser Owner
EHSTaskOwnerUserName _EHSTaskOwnerUserBasic PersonFullName Full Name
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
EHSLocationUUID EHSLocationUUID NodeID
EHSTskDefSrceDocPageNumber EHSTskDefSrceDocPageNumber
EHSTskDefSrceDocTxtFragmentId EHSTskDefSrceDocTxtFragmentId
_EHSTaskPriority _EHSTaskPriority
_EHSTaskDueInUnit _EHSTaskDueInUnit
_EHSTaskRecurrenceType _EHSTaskRecurrenceType
_EHSTaskRecurrenceOffset _EHSTaskRecurrenceOffset
_EHSTaskRecurrenceWeekDay _EHSTaskRecurrenceWeekDay
_EHSTaskRecurrenceMonth _EHSTaskRecurrenceMonth
_EHSTaskRecurrenceEndType _EHSTaskRecurrenceEndType
_EHSTaskAdapterClass _EHSTaskAdapterClass
_EHSTaskAssignedUser _EHSTaskAssignedUser
_EHSTaskOwnerUser _EHSTaskOwnerUser
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText
_EHSTaskPriorityText _EHSTaskPriorityText
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields
_EHSTaskOwnerUserBasic _EHSTaskOwnerUserBasic

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_EHSCmplncRqmtTskDef.
-- 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: CEHSCMPLRQTSKDEF

CREATE VIEW C_EHSCmplncRqmtTskDef AS
SELECT
  EHSTaskDefinitionUUID,
  EHSTaskWorkflowEvent,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  EHSTaskPriority,
  EHSTaskAssignedUser,
  _EHSTaskAssignedUserBasic.PersonFullName AS EHSTaskAssignedUserName,
  EHSTaskOwnerUser,
  _EHSTaskOwnerUserBasic.PersonFullName AS EHSTaskOwnerUserName,
  EHSTaskTitle,
  EHSTaskStartDate,
  EHSTaskDueInValue,
  EHSTaskDueInUnit,
  EHSTaskDueDate,
  EHSTaskRecurrenceType,
  EHSTaskRecurrenceInterval,
  EHSTaskIsRecurringOnMonday,
  EHSTaskIsRecurringOnTuesday,
  EHSTaskIsRecurringOnWednesday,
  EHSTaskIsRecurringOnThursday,
  EHSTaskIsRecurringOnFriday,
  EHSTaskIsRecurringOnSaturday,
  EHSTaskIsRecurringOnSunday,
  EHSTaskRecurrenceDay,
  EHSTaskRecurrenceMonth,
  EHSTaskRecurrenceOffset,
  EHSTaskRecurrenceWeekDay,
  EHSTaskRecurrenceEndType,
  EHSTaskRecurrenceEndDate,
  EHSTaskDefinitionIsPaused,
  EHSTaskID,
  EHSLocationUUID,
  EHSTskDefSrceDocPageNumber,
  EHSTskDefSrceDocTxtFragmentId
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]
LEFT OUTER JOIN C_EHSTaskUserValueHelp AS _EHSTaskOwnerUser ON EHSTaskOwnerUser = _EHSTaskOwnerUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskAssignedUserBasic ON EHSTaskAssignedUser = _EHSTaskAssignedUserBasic.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _EHSTaskOwnerUserBasic ON EHSTaskOwnerUser = _EHSTaskOwnerUserBasic.BusinessPartner  -- association [0..1]
;

Learn More