P_EHSTaskDefinitionHex

DDL: P_EHSTASKDEFINITIONHEX SQL: PEHSTDEFHEX Type: view COMPOSITE

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.

1 data source(s) 10 fields

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
EHSTaskDefinitionHex
EHSTaskOwnerUser EHSTaskOwnerUser
EHSTaskAssignedBP EHSTaskAssignedUser
EHSTaskHostObjectInstance EHSTaskHostObjectInstance
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID
EHSTaskDefinitionStatus EHSTaskDefinitionStatus
EHSLocationUUID EHSLocationUUID
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass
_EHSTaskDefinition _EHSTaskDefinition 
@AbapCatalog.sqlViewName: 'PEHSTDEFHEX'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
//@EndUserText.label: 'Keys of Task Definintions in Hex Format'

define view P_EHSTaskDefinitionHex
  as select from I_EHSTaskDefinition as TaskDefinition
  association [1..1] to I_EHSTaskDefinition as _EHSTaskDefinition on $projection.EHSTaskDefinitionUUID = _EHSTaskDefinition.EHSTaskDefinitionUUID
{
      @ObjectModel.foreignKey.association: '_EHSTaskDefinition'
  key EHSTaskDefinitionUUID,
      bintohex(EHSTaskDefinitionUUID)              as EHSTaskDefinitionHex,
      EHSTaskOwnerUser,      
      EHSTaskAssignedUser                          as EHSTaskAssignedBP,
      EHSTaskHostObjectInstance,
      EHSTaskHostObjectInstanceUUID,
      EHSTaskDefinitionStatus,
      EHSLocationUUID,
      EHSTaskHostObjectAdapterClass,
      _EHSTaskDefinition
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSTASKDEFINITION"
],
"ASSOCIATED":
[
"I_EHSTASKDEFINITION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More