P_EIT_Action_Log

DDL: P_EIT_ACTION_LOG SQL: PEITACTIONLOG Type: view Package: S_APS_ODATA_EXT_EIT_IMPORT
13 Fields 1 Data Sources 3 Associations

Extensibility Template: Action Log

P_EIT_Action_Log is a CDS View that provides data about "Extensibility Template: Action Log" in SAP S/4HANA. It reads from 1 data source (eit_imp_tmpl_job) and exposes 13 fields with key fields TemplateId, TemplateVersion, Timestamp. It has 3 associations to related views. Part of development package S_APS_ODATA_EXT_EIT_IMPORT.

Data Sources (1)

SourceAliasJoin Type
eit_imp_tmpl_job eit_imp_tmpl_job from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_EIT_User_Name _UserName _UserName.UserName = $projection.UserName
[0..1] I_Eit_Template_Action _Action _Action.Code = $projection.Action
[0..1] I_Eit_Import_Job_Status _JobStatus _JobStatus.Code = $projection.Status

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PEITACTIONLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Extensibility Template: Action Log view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TemplateId template_id Template LinkID
KEY TemplateVersion template_version Template Version
KEY Timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
UserName user_name User Name
Action action User action
Duration action_duration Act. Duration
ActionStatus action_status Upload Status
Status status Workflow Status
JobCount job_count Job No.
BallogHandle ballog_handle Handle
_JobStatus _JobStatus
_UserName _UserName
_Action _Action

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_EIT_Action_Log.
-- 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: PEITACTIONLOG

CREATE VIEW P_EIT_Action_Log AS
SELECT
  template_id AS TemplateId,
  template_version AS TemplateVersion,
  Timestamp,
  user_name AS UserName,
  Action,
  action_duration AS Duration,
  action_status AS ActionStatus,
  Status,
  job_count AS JobCount,
  ballog_handle AS BallogHandle
FROM eit_imp_tmpl_job
LEFT OUTER JOIN P_EIT_User_Name AS _UserName ON _UserName.UserName = UserName  -- association [0..1]
LEFT OUTER JOIN I_Eit_Template_Action AS _Action ON _Action.Code = Action  -- association [0..1]
LEFT OUTER JOIN I_Eit_Import_Job_Status AS _JobStatus ON _JobStatus.Code = Status  -- association [0..1]
;

Learn More