OIJ08_TRIPITM

Transparent Table Application Table
34 Fields 7 CDS Views

Trip Item Details

OIJ08_TRIPITM is an SAP database table in S/4HANA. Trip Item Details. It contains 34 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 (34)

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
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
wi_id OIT_TRIP_WORKITEM Workflow Workitem
dummy_tripitm_incl_eew_ps OIT_EXTN Extension Field
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]
    ERDAT,                      -- Created On [ERDAT]
    ERZEIT,                     -- Created [OI0_ERTIM]
    ERNAM,                      -- Created By [ERNAM]
    AEDAT,                      -- Changed On [AEDAT]
    AEZEIT,                     -- Changed [OI0_AETIM]
    AENAM,                      -- Changed By [AENAM]
    WI_ID,                      -- Workflow Workitem [OIT_TRIP_WORKITEM]
    DUMMY_TRIPITM_INCL_EEW_PS,  -- Extension Field [OIT_EXTN]
    TRIPITEMUUID,               -- Character field, length 32 [CHAR32]
    PRIMARY KEY (MANDT, TRIP_ID, TRIP_ITEM)
);

Learn More