C_EHSTaskLearningTP

DDL: C_EHSTASKLEARNINGTP Type: view_entity CONSUMPTION
24 Fields 1 Data Sources 1 Associations

EHS Learning Task Consumption

C_EHSTaskLearningTP is a Consumption CDS View that provides data about "EHS Learning Task Consumption" in SAP S/4HANA. It reads from 1 data source (I_EHSTaskLearningTP) and exposes 24 fields with key field EHSTaskLearningUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EHSTaskLearningTP I_EHSTaskLearningTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_EHSLearningTaskDefinitionTP _EHSLearningTaskDef $projection.EHSTaskDefinitionUUID = _EHSLearningTaskDef.EHSTaskDefinitionUUID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
EndUserText.label EHS Learning Task Consumption view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey EHSTaskLearningUUID view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskLearningUUID EHSTaskLearningUUID
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
EHSTaskDefinitionUUID EHSTaskDefinitionUUID Task Definition
EHSLearningUUID EHSLearningUUID Learning
EHSLearningDescriptionText _EHSLearning EHSLearningDescriptionText
UICT_EHSLearningUUIDNVI
EHSTaskHostObjectInstance _EHSLearningTaskDef EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectInstanceUUID _EHSLearningTaskDef EHSTaskHostObjectInstanceUUID Host Obj. UUID
_EHSCmplncScenAuthznFields _EHSLearningTaskDef _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields _EHSLearningTaskDef _CmplncRqmtAuthznFields
_EHSCtrlImplmtnAuthznFields _EHSLearningTaskDef _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields _EHSLearningTaskDef _EHSRskAssessmentAuthznFields
_EHSRskAssmt2RskCtrlAuthznFld _EHSLearningTaskDef _EHSRskAssmt2RskCtrlAuthznFld
_IncidentAuthorizationFields _EHSLearningTaskDef _IncidentAuthorizationFields
IncidentHasAccessRestriction _EHSLearningTaskDef IncidentHasAccessRestriction Restricted
EHSTaskHostObjectAdapterClass _EHSLearningTaskDef EHSTaskHostObjectAdapterClass Class Name
_EHSTaskAdapterClass _EHSLearningTaskDef _EHSTaskAdapterClass
EHSTaskOwnerUser _EHSLearningTaskDef EHSTaskOwnerUser Owner
_EHSTaskOwnerUser _EHSLearningTaskDef _EHSTaskOwnerUser
_EHSLearningTaskDef _EHSLearningTaskDef
_EHSLearning _EHSLearning

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_EHSTaskLearningTP.
-- 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.

CREATE VIEW C_EHSTaskLearningTP AS
SELECT
  EHSTaskLearningUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  EHSTaskDefinitionUUID,
  EHSLearningUUID,
  _EHSLearning.EHSLearningDescriptionText AS EHSLearningDescriptionText,
  cast('' as rap_null_value_indicator ) AS UICT_EHSLearningUUIDNVI,
  _EHSLearningTaskDef.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  _EHSLearningTaskDef.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  _EHSLearningTaskDef._EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields,
  _EHSLearningTaskDef._CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields,
  _EHSLearningTaskDef._EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields,
  _EHSLearningTaskDef._EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields,
  _EHSLearningTaskDef._EHSRskAssmt2RskCtrlAuthznFld AS _EHSRskAssmt2RskCtrlAuthznFld,
  _EHSLearningTaskDef._IncidentAuthorizationFields AS _IncidentAuthorizationFields,
  _EHSLearningTaskDef.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  _EHSLearningTaskDef.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  _EHSLearningTaskDef._EHSTaskAdapterClass AS _EHSTaskAdapterClass,
  _EHSLearningTaskDef.EHSTaskOwnerUser AS EHSTaskOwnerUser,
  _EHSLearningTaskDef._EHSTaskOwnerUser AS _EHSTaskOwnerUser
FROM I_EHSTaskLearningTP
LEFT OUTER JOIN C_EHSLearningTaskDefinitionTP AS _EHSLearningTaskDef ON EHSTaskDefinitionUUID = _EHSLearningTaskDef.EHSTaskDefinitionUUID  -- association [1..1]
;

Learn More