OIJ08_TRIPITM

Transparent Table Application Table
27 Fields 7 CDS Views

Trip Item Details

OIJ08_TRIPITM is an SAP database table in S/4HANA. Trip Item Details. It contains 27 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_TripItemTP view from EXTENSION Extension CDS for Trip Item
I_SchedTripDocItemVH view from BASIC Interface view for Trip Item value help
I_SchedTripDocItemVH view union_all BASIC Interface view for Trip Item value help
I_TripDocItemVH view from BASIC Interface view for Trip Item value help
I_TripItemPayableChrg view from BASIC Trip Item Payable Charges
I_TripItemPayableChrg view union BASIC Trip Item Payable Charges
I_TripItemTP view from TRANSACTIONAL Trip Item information

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY trip_id oij08_tripid Trip ID
KEY trip_item oij08_trip_posnr Trip Item Number
seqnr oij_seqnr Sequence number
trp_itm_status oij08_i_stat Trip Item Status
knote knote Points
bezei bezei30 Description
locid oij_locid Location ID
sityp oit_tripschdtyp Trip Schedule Type
docind oij_docind Ref.Doc.Ind.
vbeln oij_el_cpno Contract no.
posnr oij_el_posnr Item
plandepr_date oij08_p_dep_date Pl.Dep.Date
plandepr_time oit_p_dep_time Planned Dep. Time
planarrival_date oij08_p_arv_date Pl.Arvl.Date
planarrival_time oit_p_arv_time Planned Arv. Time
actdepr_date oij08_a_dep_date Act.Dep.Date
actdepr_time oit_a_dep_time Act Departure Time
actarrival_date oij08_a_arv_date Act.Arv.Date
actarrival_time oit_a_arv_time Act Arrival Time
delind oij_delind Deletion ind.
plnd_laytime oit_pln_layt Planned Laytime
calc_laytime oit_calc_layt Calculated Laytime
disc_laytime oit_disc_layt Discounted Laytime
laytime_unit msehi Internal UoM
wi_id oit_trip_workitem Workflow Workitem
tripitemuuid char32 Character field, length 32

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 Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ08_TRIPITM (
    MANDT,             -- Client [mandt]
    TRIP_ID,           -- Trip ID [oij08_tripid]
    TRIP_ITEM,         -- Trip Item Number [oij08_trip_posnr]
    SEQNR,             -- Sequence number [oij_seqnr]
    TRP_ITM_STATUS,    -- Trip Item Status [oij08_i_stat]
    KNOTE,             -- Points [knote]
    BEZEI,             -- Description [bezei30]
    LOCID,             -- Location ID [oij_locid]
    SITYP,             -- Trip Schedule Type [oit_tripschdtyp]
    DOCIND,            -- Ref.Doc.Ind. [oij_docind]
    VBELN,             -- Contract no. [oij_el_cpno]
    POSNR,             -- Item [oij_el_posnr]
    PLANDEPR_DATE,     -- Pl.Dep.Date [oij08_p_dep_date]
    PLANDEPR_TIME,     -- Planned Dep. Time [oit_p_dep_time]
    PLANARRIVAL_DATE,  -- Pl.Arvl.Date [oij08_p_arv_date]
    PLANARRIVAL_TIME,  -- Planned Arv. Time [oit_p_arv_time]
    ACTDEPR_DATE,      -- Act.Dep.Date [oij08_a_dep_date]
    ACTDEPR_TIME,      -- Act Departure Time [oit_a_dep_time]
    ACTARRIVAL_DATE,   -- Act.Arv.Date [oij08_a_arv_date]
    ACTARRIVAL_TIME,   -- Act Arrival Time [oit_a_arv_time]
    DELIND,            -- Deletion ind. [oij_delind]
    PLND_LAYTIME,      -- Planned Laytime [oit_pln_layt]
    CALC_LAYTIME,      -- Calculated Laytime [oit_calc_layt]
    DISC_LAYTIME,      -- Discounted Laytime [oit_disc_layt]
    LAYTIME_UNIT,      -- Internal UoM [msehi]
    WI_ID,             -- Workflow Workitem [oit_trip_workitem]
    TRIPITEMUUID,      -- Character field, length 32 [char32]
    PRIMARY KEY (MANDT, TRIP_ID, TRIP_ITEM)
);

Learn More