APL_C_APPL_LOG_OVERVIEW

DDL: APL_C_APPL_LOG_OVERVIEW SQL: APL_C_LOG_OV Type: view

Application log list

APL_C_APPL_LOG_OVERVIEW is a CDS View that provides data about "Application log list" in SAP S/4HANA. It reads from 1 data source (APL_V_APPL_LOG_OVERVIEW) and exposes 24 fields with key field log_handle.

Data Sources (1)

SourceAliasJoin Type
APL_V_APPL_LOG_OVERVIEW Log from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APL_C_LOG_OV view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Application log list view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY log_handle APL_V_APPL_LOG_OVERVIEW log_handle Migration Log Handle
lognumber lognumber UUID
extnumber extnumber External ID
object object TRFM Object
obj_txt obj_txt Object text
subobject subobject Triggering obj.
subobj_txt subobj_txt Subobject Text
msg_cnt_al msg_cnt_al Total Messages
alchdate alchdate Changed on
alchtime alchtime Changed at
alchuser alchuser Changed by
aldate_del aldate_del Expiration Date
msg_cnt_a msg_cnt_a Terminations
msg_cnt_e msg_cnt_e Error Msg
msg_cnt_i msg_cnt_i Informtn Msg
msg_cnt_s msg_cnt_s Successful
msg_cnt_w msg_cnt_w Warning Msg
aldate aldate Date
altime altime Time
aluser aluser User
severity severity Thresh.Val. Severity
alprog alprog Program
del_before del_before Keep til expiry
SeverityText

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 APL_C_APPL_LOG_OVERVIEW.
-- 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: APL_C_LOG_OV

CREATE VIEW APL_C_APPL_LOG_OVERVIEW AS
SELECT
  Log.log_handle AS log_handle,
  lognumber,
  extnumber,
  object,
  obj_txt,
  subobject,
  subobj_txt,
  msg_cnt_al,
  alchdate,
  alchtime,
  alchuser,
  aldate_del,
  msg_cnt_a,
  msg_cnt_e,
  msg_cnt_i,
  msg_cnt_s,
  msg_cnt_w,
  aldate,
  altime,
  aluser,
  severity,
  alprog,
  del_before,
  _Severity._dd07t.SeverityText AS SeverityText
FROM APL_V_APPL_LOG_OVERVIEW AS Log
;