OIJ_EL_ERROR_LOG

Transparent Table Application Table
25 Fields 4 CDS Views

OIL-TSW: Error log for ticketing process

OIJ_EL_ERROR_LOG is an SAP database table in S/4HANA. OIL-TSW: Error log for ticketing process. It contains 25 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ACMUniversalTicketErrorLog view from BASIC Universal Ticket Error Log
I_TicketErrorLog view from BASIC Nomination Ticket Error Log
I_TicketErrorLogCheck view from BASIC Ticket Error Log Check
OIJ07_TICKET_ERRORLOG view from CDS for error_log from ticket error log table

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ticket_key oij_el_tkt_key Ticket key
KEY ticket_item oij_el_tkt_posnr Item number
KEY ticket_version oij_el_tkt_version Ticket version
KEY ticket_purpose oij_el_tkt_purpose Ticket Purpose
KEY seq_nmbr oij_seqnr Sequence number
nomtk oij_nomtk Nomination key
nomit oij_item Nom. key item
mvscenario oij_mvscen Mvmt.scenario
tcode tcode Transaction Code
returncode sret_rcode Return code
docnr oij_docnr Ref. doc.
mjahr mjahr Mat. Doc. Year
posnr oij_docitm Ref.Doc.Item
vbtyp vbtypl Document Cat.
trdate oij_date Date
trtime oij_time Time
msgid msgid Message ID
msgty msgty Message Type
msgno msgno Message Number
msgv1 msgv1 Message var.
msgv2 msgv2 Message var.
msgv3 msgv3 Message var.
msgv4 msgv4 Message var.
revdoc oij_revdoc RevDoc

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- OIL-TSW: Error log for ticketing process
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_EL_ERROR_LOG (
    MANDT,           -- Client [mandt]
    TICKET_KEY,      -- Ticket key [oij_el_tkt_key]
    TICKET_ITEM,     -- Item number [oij_el_tkt_posnr]
    TICKET_VERSION,  -- Ticket version [oij_el_tkt_version]
    TICKET_PURPOSE,  -- Ticket Purpose [oij_el_tkt_purpose]
    SEQ_NMBR,        -- Sequence number [oij_seqnr]
    NOMTK,           -- Nomination key [oij_nomtk]
    NOMIT,           -- Nom. key item [oij_item]
    MVSCENARIO,      -- Mvmt.scenario [oij_mvscen]
    TCODE,           -- Transaction Code [tcode]
    RETURNCODE,      -- Return code [sret_rcode]
    DOCNR,           -- Ref. doc. [oij_docnr]
    MJAHR,           -- Mat. Doc. Year [mjahr]
    POSNR,           -- Ref.Doc.Item [oij_docitm]
    VBTYP,           -- Document Cat. [vbtypl]
    TRDATE,          -- Date [oij_date]
    TRTIME,          -- Time [oij_time]
    MSGID,           -- Message ID [msgid]
    MSGTY,           -- Message Type [msgty]
    MSGNO,           -- Message Number [msgno]
    MSGV1,           -- Message var. [msgv1]
    MSGV2,           -- Message var. [msgv2]
    MSGV3,           -- Message var. [msgv3]
    MSGV4,           -- Message var. [msgv4]
    REVDOC,          -- RevDoc [oij_revdoc]
    PRIMARY KEY (MANDT, TICKET_KEY, TICKET_ITEM, TICKET_VERSION, TICKET_PURPOSE, SEQ_NMBR)
);

Learn More