I_ACMUniversalTicketErrorLog

DDL: I_ACMUNIVERSALTICKETERRORLOG SQL: IUNIVTERLOG Type: view BASIC
10 Fields 1 Data Sources

Universal Ticket Error Log

I_ACMUniversalTicketErrorLog is a Basic CDS View that provides data about "Universal Ticket Error Log" in SAP S/4HANA. It reads from 1 data source (oij_el_error_log) and exposes 10 fields with key fields ACMUniversalTicketKey, ACMUniversalTicketItem, ACMUniversalTicketVersion, ACMUniversalTicketPurpose, ACMUniversalTicketSeqNo.

Data Sources (1)

SourceAliasJoin Type
oij_el_error_log oij_el_error_log from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IUNIVTERLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Universal Ticket Error Log view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ACMUniversalTicketKey ticket_key Ticket key
KEY ACMUniversalTicketItem ticket_item Single-Character Flag
KEY ACMUniversalTicketVersion ticket_version Ticket version
KEY ACMUniversalTicketPurpose ticket_purpose Ticket Purpose
KEY ACMUniversalTicketSeqNo seq_nmbr Sequence number
TransactionCodeName tcode Undefined range (can be used for patch levels)
ACMDocumentNumber docnr Well doc.no.
ACMDocumentYear mjahr Mat. Doc. Year
ACMDocumentItemNumber posnr WBS Element
ACMDocumentType vbtyp TSW Det.Doc typ

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_ACMUniversalTicketErrorLog.
-- 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: IUNIVTERLOG

CREATE VIEW I_ACMUniversalTicketErrorLog AS
SELECT
  ticket_key AS ACMUniversalTicketKey,
  ticket_item AS ACMUniversalTicketItem,
  ticket_version AS ACMUniversalTicketVersion,
  ticket_purpose AS ACMUniversalTicketPurpose,
  seq_nmbr AS ACMUniversalTicketSeqNo,
  tcode AS TransactionCodeName,
  docnr AS ACMDocumentNumber,
  mjahr AS ACMDocumentYear,
  posnr AS ACMDocumentItemNumber,
  vbtyp AS ACMDocumentType
FROM oij_el_error_log
;

Learn More