OIJ08_TRIPEVENT

Transparent Table Application Table
30 Fields 3 CDS Views

Trip Item Events

OIJ08_TRIPEVENT is an SAP database table in S/4HANA. Trip Item Events. It contains 30 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_TripInfluencingEventsTP view from TRANSACTIONAL Trip Laytime influencing events
I_TripLayTimeEventsTP view from TRANSACTIONAL Trip Item Laytime Events
I_TripOtherEventsTP view from TRANSACTIONAL Trip Other events view

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY trip_id OIJ08_TRIPID Trip ID
KEY trip_item OIJ08_TRIP_POSNR Trip Item Number
KEY event_nr OIG_EVNR Event number
KEY linetype OIT_EL_LINET Type of line
op_point OIJ_EL_OPP Op. time point
event OIJ_EL_LTEV Laytime event
rsncode OIT_RSNCODE Reason code
descr OIT_RSNDESCR Reason Code Desc
evt_qty OIT_EVT_QTY Quantity
evt_uom OIT_EVT_UOM Unit of Measure
add_time OIJ_EL_ADD Add time
add_uom OIJ_EL_ADDUOM Time UoM
ev_rule OIJ_EL_RULE Event rule
rate OIJ_EL_RATE Event rate
pstdtf OIG_PSTDTF PlndStartDateFr
psttmf OIG_PSTTMF PlndStTimeFrom
peddtt OIG_PEDDTT PlEndDateTo
pedtmt OIG_PEDTMT PlEndTimeTo
astdtf OIG_ASTDTF Strt Date-From
asttmf OIG_ASTTMF Strt Time-From
aeddtt OIG_AEDDTT ActEndDateTo
aedtmt OIG_AEDTMT ActEndTimeTo
del_ind OIT_DEL_IND Delete Indicator
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By

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.

-- Trip Item Events
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ08_TRIPEVENT (
    MANDT,      -- Client [MANDT]
    TRIP_ID,    -- Trip ID [OIJ08_TRIPID]
    TRIP_ITEM,  -- Trip Item Number [OIJ08_TRIP_POSNR]
    EVENT_NR,   -- Event number [OIG_EVNR]
    LINETYPE,   -- Type of line [OIT_EL_LINET]
    OP_POINT,   -- Op. time point [OIJ_EL_OPP]
    EVENT,      -- Laytime event [OIJ_EL_LTEV]
    RSNCODE,    -- Reason code [OIT_RSNCODE]
    DESCR,      -- Reason Code Desc [OIT_RSNDESCR]
    EVT_QTY,    -- Quantity [OIT_EVT_QTY]
    EVT_UOM,    -- Unit of Measure [OIT_EVT_UOM]
    ADD_TIME,   -- Add time [OIJ_EL_ADD]
    ADD_UOM,    -- Time UoM [OIJ_EL_ADDUOM]
    EV_RULE,    -- Event rule [OIJ_EL_RULE]
    RATE,       -- Event rate [OIJ_EL_RATE]
    PSTDTF,     -- PlndStartDateFr [OIG_PSTDTF]
    PSTTMF,     -- PlndStTimeFrom [OIG_PSTTMF]
    PEDDTT,     -- PlEndDateTo [OIG_PEDDTT]
    PEDTMT,     -- PlEndTimeTo [OIG_PEDTMT]
    ASTDTF,     -- Strt Date-From [OIG_ASTDTF]
    ASTTMF,     -- Strt Time-From [OIG_ASTTMF]
    AEDDTT,     -- ActEndDateTo [OIG_AEDDTT]
    AEDTMT,     -- ActEndTimeTo [OIG_AEDTMT]
    DEL_IND,    -- Delete Indicator [OIT_DEL_IND]
    ERDAT,      -- Created On [ERDAT]
    ERZEIT,     -- Created [OI0_ERTIM]
    ERNAM,      -- Created By [ERNAM]
    AEDAT,      -- Changed On [AEDAT]
    AEZEIT,     -- Changed [OI0_AETIM]
    AENAM,      -- Changed By [AENAM]
    PRIMARY KEY (MANDT, TRIP_ID, TRIP_ITEM, EVENT_NR, LINETYPE)
);

Learn More