CRMS4_IU_C_LOG

DDL: CRMS4_IU_C_LOG SQL: CRMS4IUVCLOG Type: view

Utilities Message Log Header

CRMS4_IU_C_LOG is a CDS View that provides data about "Utilities Message Log Header" in SAP S/4HANA. It reads from 1 data source (CRMS4_IU_I_LOG) and exposes 39 fields with key field lognumber.

Data Sources (1)

SourceAliasJoin Type
CRMS4_IU_I_LOG CRMS4_IU_I_LOG from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4IUVCLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utilities Message Log Header view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY lognumber lognumber UUID
object object TRFM Object
subobject subobject Triggering obj.
extnumber extnumber External ID
aldate aldate Date
altime altime Time
aluser aluser User
altcode altcode Transaction
alprog alprog Program
almode almode Operating mode
altext altext Standard text
userexitp userexitp Callback: Progr
userexitf userexitf Callback: Name
probclass probclass Max. prob. cl.
aldate_del aldate_del Expiration Date
del_before del_before Keep til expiry
alstate alstate Status
userexitt userexitt Callback: Type
alchdate alchdate Changed on
alchtime alchtime Changed at
alchuser alchuser Changed by
log_handle log_handle Migration Log Handle
tabname tabname Table/Constant Value
msg_cnt_al msg_cnt_al Total Messages
msg_cnt_a msg_cnt_a Terminations
msg_cnt_e msg_cnt_e Error Msg
msg_cnt_w msg_cnt_w Warning Msg
msg_cnt_i msg_cnt_i Informtn Msg
msg_cnt_s msg_cnt_s Successful
last_msgnr last_msgnr Message no.
tim_stmp tim_stmp Time Stamp
db_version db_version DB format
msg_cnt_p1 msg_cnt_p1 very high
msg_cnt_p2 msg_cnt_p2 High
msg_cnt_p3 msg_cnt_p3 Medium
msg_cnt_p4 msg_cnt_p4 low
client_cre client_cre Client
char_size char_size Bytes
_dataaging _dataaging Data Aging

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 CRMS4_IU_C_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: CRMS4IUVCLOG

CREATE VIEW CRMS4_IU_C_LOG AS
SELECT
  lognumber,
  object,
  subobject,
  extnumber,
  aldate,
  altime,
  aluser,
  altcode,
  alprog,
  almode,
  altext,
  userexitp,
  userexitf,
  probclass,
  aldate_del,
  del_before,
  alstate,
  userexitt,
  alchdate,
  alchtime,
  alchuser,
  log_handle,
  tabname,
  msg_cnt_al,
  msg_cnt_a,
  msg_cnt_e,
  msg_cnt_w,
  msg_cnt_i,
  msg_cnt_s,
  last_msgnr,
  tim_stmp,
  db_version,
  msg_cnt_p1,
  msg_cnt_p2,
  msg_cnt_p3,
  msg_cnt_p4,
  client_cre,
  char_size
FROM CRMS4_IU_I_LOG
;