P_EHSTaskDefinitionHex

DDL: P_EHSTASKDEFINITIONHEX SQL: PEHSTDEFHEX Type: view COMPOSITE
10 Fields 1 Data Sources 1 Associations

P_EHSTaskDefinitionHex is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EHSTaskDefinition) and exposes 10 fields with key field EHSTaskDefinitionUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EHSTaskDefinition TaskDefinition from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_EHSTaskDefinition _EHSTaskDefinition $projection.EHSTaskDefinitionUUID = _EHSTaskDefinition.EHSTaskDefinitionUUID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PEHSTDEFHEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID Task Definition
EHSTaskDefinitionHex
EHSTaskOwnerUser EHSTaskOwnerUser Owner
EHSTaskAssignedBP EHSTaskAssignedUser Assignee
EHSTaskHostObjectInstance EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskDefinitionStatus EHSTaskDefinitionStatus Status
EHSLocationUUID EHSLocationUUID NodeID
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass Class Name
_EHSTaskDefinition _EHSTaskDefinition

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 P_EHSTaskDefinitionHex.
-- 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: PEHSTDEFHEX

CREATE VIEW P_EHSTaskDefinitionHex AS
SELECT
  EHSTaskDefinitionUUID,
  bintohex(EHSTaskDefinitionUUID) AS EHSTaskDefinitionHex,
  EHSTaskOwnerUser,
  EHSTaskAssignedUser AS EHSTaskAssignedBP,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskDefinitionStatus,
  EHSLocationUUID,
  EHSTaskHostObjectAdapterClass
FROM I_EHSTaskDefinition AS TaskDefinition
LEFT OUTER JOIN I_EHSTaskDefinition AS _EHSTaskDefinition ON EHSTaskDefinitionUUID = _EHSTaskDefinition.EHSTaskDefinitionUUID  -- association [1..1]
;

Learn More