I_EHSLearning

DDL: I_EHSLEARNING Type: view_entity BASIC Package: EHFND_SF_LEARNING
11 Fields 1 Data Sources

Learnings cache table basic layer

I_EHSLearning is a Basic CDS View that provides data about "Learnings cache table basic layer" in SAP S/4HANA. It reads from 1 data source (ehfndd_learning) and exposes 11 fields with key field EHSLearningUUID. Part of development package EHFND_SF_LEARNING.

Data Sources (1)

SourceAliasJoin Type
ehfndd_learning ehfndd_learning from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.resultSet.sizeCategory #XS view
EndUserText.label Learnings cache table basic layer view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EHSLearningUUID ehslearninguuid
EHSLearningDescriptionText ehslearningdescriptiontext
EHSLearningIsActive ehslearningisactive
EHSLearningSourceID ehslearningsourceid
EHSLearningSourceSystem ehslearningsourcesystem
EHSLearningItemTypeID ehslearningitemtypeid
EHSLearningRevisionDateValue ehslearningrevisiondate
CreationUTCDateTime creationutcdatetime Time Stamp
CreatedByUser createdbyuser User Name
LastChangeUTCDateTime lastchangeutcdatetime Time Stamp
LastChangedByUser lastchangedbyuser User Name

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 I_EHSLearning.
-- 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 I_EHSLearning AS
SELECT
  EHSLearningUUID,
  EHSLearningDescriptionText,
  EHSLearningIsActive,
  EHSLearningSourceID,
  EHSLearningSourceSystem,
  EHSLearningItemTypeID,
  ehslearningrevisiondate AS EHSLearningRevisionDateValue,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser
FROM ehfndd_learning
;

Learn More