I_ISLM_P_ENTITY_HIST

DDL: I_ISLM_P_ENTITY_HIST Type: view_entity
7 Fields 1 Data Sources 2 Associations

Entity history table

I_ISLM_P_ENTITY_HIST is a CDS View that provides data about "Entity history table" in SAP S/4HANA. It reads from 1 data source (islm_entity_hist) and exposes 7 fields with key field guid. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
islm_entity_hist islm_entity_hist from

Associations (2)

CardinalityTargetAliasCondition
[1] I_ISLM_P_MODELVERSION _parent_mv $projection.ref_entity_id = _parent_mv.guid
[1] I_ISLM_P_MVDEPLOY _parent_md $projection.ref_entity_id = _parent_md.guid

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Entity history table view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY guid guid UUID 22 char.
action_type action_type Action Type
created_at created_at Uploaded On
created_by created_by Version Created By
changed_at changed_at Timestamp
_parent_mv _parent_mv
_parent_md _parent_md

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_ISLM_P_ENTITY_HIST.
-- 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_ISLM_P_ENTITY_HIST AS
SELECT
  guid,
  action_type,
  created_at,
  created_by,
  changed_at
FROM islm_entity_hist
LEFT OUTER JOIN I_ISLM_P_MODELVERSION AS _parent_mv ON ref_entity_id = _parent_mv.guid  -- association [1]
LEFT OUTER JOIN I_ISLM_P_MVDEPLOY AS _parent_md ON ref_entity_id = _parent_md.guid  -- association [1]
;

Learn More