XAJ_JOB_LOG_HEADER

DDL: XAJ_JOB_LOG_HEADER SQL: XAJ_APL_HEAD_OV Type: view

Applog Header CDS view for XAJ (no auth check)

XAJ_JOB_LOG_HEADER is a CDS View that provides data about "Applog Header CDS view for XAJ (no auth check)" in SAP S/4HANA. It reads from 1 data source (APL_V_APPL_LOG_OVERVIEW) and exposes 22 fields with key field log_handle.

Data Sources (1)

SourceAliasJoin Type
APL_V_APPL_LOG_OVERVIEW LOGHEADER from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName XAJ_APL_HEAD_OV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Applog Header CDS view for XAJ (no auth check) view

Fields (22)

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
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 XAJ_JOB_LOG_HEADER.
-- 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: XAJ_APL_HEAD_OV

CREATE VIEW XAJ_JOB_LOG_HEADER AS
SELECT
  LOGHEADER.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,
  _Severity._dd07t.SeverityText AS SeverityText
FROM APL_V_APPL_LOG_OVERVIEW AS LOGHEADER
;