C_EHSCmplncRqmtStrucTskDef
Compl. Req. Structure Task Definitions
C_EHSCmplncRqmtStrucTskDef is a Consumption CDS View that provides data about "Compl. Req. Structure Task Definitions" in SAP S/4HANA. It reads from 1 data source (C_EHSCmplncRqmtTskDef) and exposes 93 fields with key field EHSTaskDefinitionUUID.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| C_EHSCmplncRqmtTskDef | C_EHSCmplncRqmtTskDef | from |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CEHSREQSTRTSKDEF | 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 | Compl. Req. Structure Task Definitions | view | |
| Consumption.semanticObject | EHSTask | view | |
| ObjectModel.semanticKey | EHSTaskID | view | |
| ObjectModel.representativeKey | EHSTaskDefinitionUUID | view |
Fields (93)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | EHSTaskDefinitionUUID | C_EHSCmplncRqmtTskDef | EHSTaskDefinitionUUID | Task Definition |
| EHSCmplncRqmtStructureUUID | I_EHSTaskDefReference | EHSTaskRelatedObjInstanceUUID | Compl Req. | |
| EHSTaskWorkflowEvent | EHSTaskWorkflowEvent | Task Type | ||
| EHSTaskHostObjectInstanceUUID | EHSTaskHostObjectInstanceUUID | Host Obj. UUID | ||
| EHSTaskHostObjectInstance | EHSTaskHostObjectInstance | Instance ID | ||
| EHSTaskHostObjectAdapterClass | EHSTaskHostObjectAdapterClass | Class Name | ||
| EHSTaskPriority | EHSTaskPriority | Priority | ||
| EHSTaskAssignedUser | EHSTaskAssignedUser | Assignee | ||
| EHSTaskAssignedUserName | EHSTaskAssignedUserName | Full Name | ||
| EHSTaskOwnerUser | EHSTaskOwnerUser | Owner | ||
| EHSTaskOwnerUserName | _EHSTaskOwnerUser | 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 | ||
| _EHSTaskPriority | _EHSTaskPriority | |||
| _EHSTaskDueInUnit | _EHSTaskDueInUnit | |||
| _EHSTaskRecurrenceType | _EHSTaskRecurrenceType | |||
| _EHSTaskRecurrenceOffset | _EHSTaskRecurrenceOffset | |||
| _EHSTaskRecurrenceWeekDay | _EHSTaskRecurrenceWeekDay | |||
| _EHSTaskRecurrenceMonth | _EHSTaskRecurrenceMonth | |||
| _EHSTaskRecurrenceEndType | _EHSTaskRecurrenceEndType | |||
| _EHSTaskAdapterClass | _EHSTaskAdapterClass | |||
| _EHSTaskAssignedUser | _EHSTaskAssignedUser | |||
| _EHSTaskOwnerUser | _EHSTaskOwnerUser | |||
| _EHSTaskDefinitionTypeText | _EHSTaskDefinitionTypeText | |||
| _EHSTaskPriorityText | _EHSTaskPriorityText | |||
| EHSTaskDefinitionUUID | Task Definition | |||
| EHSCmplncRqmtStructureUUID | I_CmplRqVersStructure | CmplRqUUID | Compl Req. | |
| EHSTaskWorkflowEvent | EHSTaskWorkflowEvent | Task Type | ||
| EHSTaskHostObjectInstanceUUID | EHSTaskHostObjectInstanceUUID | Host Obj. UUID | ||
| EHSTaskHostObjectInstance | EHSTaskHostObjectInstance | Instance ID | ||
| EHSTaskHostObjectAdapterClass | EHSTaskHostObjectAdapterClass | Class Name | ||
| EHSTaskPriority | EHSTaskPriority | Priority | ||
| EHSTaskAssignedUser | EHSTaskAssignedUser | Assignee | ||
| EHSTaskAssignedUserName | EHSTaskAssignedUserName | Full Name | ||
| EHSTaskOwnerUser | EHSTaskOwnerUser | Owner | ||
| EHSTaskOwnerUserName | _EHSTaskOwnerUser | 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 | ||
| _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 |
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_EHSCmplncRqmtStrucTskDef.
-- 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: CEHSREQSTRTSKDEF
CREATE VIEW C_EHSCmplncRqmtStrucTskDef AS
SELECT
C_EHSCmplncRqmtTskDef.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
I_EHSTaskDefReference.EHSTaskRelatedObjInstanceUUID AS EHSCmplncRqmtStructureUUID,
EHSTaskWorkflowEvent,
EHSTaskHostObjectInstanceUUID,
EHSTaskHostObjectInstance,
EHSTaskHostObjectAdapterClass,
EHSTaskPriority,
EHSTaskAssignedUser,
EHSTaskAssignedUserName,
EHSTaskOwnerUser,
_EHSTaskOwnerUser.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
FROM C_EHSCmplncRqmtTskDef
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA