OIJTE

Transparent Table Application Table
24 Fields 1 CDS Views

TSW Ticket Events

OIJTE is an SAP database table in S/4HANA. TSW Ticket Events. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TicketEvent view from BASIC Ticket Event

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY client 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 event_nr OIG_EVNR Event number
type OIG_EVTYPE Event type
doc_type OIG_EVDCTY Document type
ev_seq OIG_EVSEQ Seq. number
doc_number OIG_ASGDOC Document no.
shitem OIG_SHITM Shipment item
status OIG_EVSTAT Event status
actualstartfrom TIMESTAMP Time Stamp
actualstartto TIMESTAMP Time Stamp
actualendfrom TIMESTAMP Time Stamp
actualendto TIMESTAMP Time Stamp
cre_name ERNAM Created By
creation TIMESTAMP Time Stamp
cha_name AENAM Changed By
modification TIMESTAMP Time Stamp
veh_nr OIG_VEHNR Vehicle Seq. No
tsrfo TSRFO Seq.stage
delind OIJ_DELIND Deletion ind.
_dataaging DATA_TEMPERATURE Data Aging

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.

-- TSW Ticket Events
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJTE (
    CLIENT,           -- 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]
    EVENT_NR,         -- Event number [OIG_EVNR]
    TYPE,             -- Event type [OIG_EVTYPE]
    DOC_TYPE,         -- Document type [OIG_EVDCTY]
    EV_SEQ,           -- Seq. number [OIG_EVSEQ]
    DOC_NUMBER,       -- Document no. [OIG_ASGDOC]
    SHITEM,           -- Shipment item [OIG_SHITM]
    STATUS,           -- Event status [OIG_EVSTAT]
    ACTUALSTARTFROM,  -- Time Stamp [TIMESTAMP]
    ACTUALSTARTTO,    -- Time Stamp [TIMESTAMP]
    ACTUALENDFROM,    -- Time Stamp [TIMESTAMP]
    ACTUALENDTO,      -- Time Stamp [TIMESTAMP]
    CRE_NAME,         -- Created By [ERNAM]
    CREATION,         -- Time Stamp [TIMESTAMP]
    CHA_NAME,         -- Changed By [AENAM]
    MODIFICATION,     -- Time Stamp [TIMESTAMP]
    VEH_NR,           -- Vehicle Seq. No [OIG_VEHNR]
    TSRFO,            -- Seq.stage [TSRFO]
    DELIND,           -- Deletion ind. [OIJ_DELIND]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, TICKET_KEY, TICKET_ITEM, TICKET_VERSION, TICKET_PURPOSE, EVENT_NR)
);

Learn More