OIJ08_TRIPH

Transparent Table Application Table
12 Fields 6 CDS Views

Trip Header

OIJ08_TRIPH is an SAP database table in S/4HANA. Trip Header. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_TripHeadTP view from EXTENSION
I_SchedTripDocItemVH view inner BASIC Interface view for Trip Item value help
I_SchedTripDocVH view from BASIC Trip ID value help
I_SchedTripDocVH view union_all BASIC Trip ID value help
I_TripDocVH view from BASIC Trip key value help
I_TripHeadTP view from TRANSACTIONAL Trip Header information

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY trip_id oij08_tripid Trip ID
trip_number oij08_trpnr Trip Number
trip_type oij08_trip_type Trip Type
trip_stat oij08_h_stat Trip Header Status
vehicle oig_vhlnmr Vehicle Number
veh_type oig_vhltyp Vehicle type
doc_ref_type oij08_doc_ref Ref. Document Type
trip_dem oij_dm_potential Pot. demurrage
dem_curr oij_dm_curr DemurrCurr
delind oij_delind Deletion ind.
trselect oit_trpselect Flag to Select Trp

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ08_TRIPH (
    MANDT,         -- Client [mandt]
    TRIP_ID,       -- Trip ID [oij08_tripid]
    TRIP_NUMBER,   -- Trip Number [oij08_trpnr]
    TRIP_TYPE,     -- Trip Type [oij08_trip_type]
    TRIP_STAT,     -- Trip Header Status [oij08_h_stat]
    VEHICLE,       -- Vehicle Number [oig_vhlnmr]
    VEH_TYPE,      -- Vehicle type [oig_vhltyp]
    DOC_REF_TYPE,  -- Ref. Document Type [oij08_doc_ref]
    TRIP_DEM,      -- Pot. demurrage [oij_dm_potential]
    DEM_CURR,      -- DemurrCurr [oij_dm_curr]
    DELIND,        -- Deletion ind. [oij_delind]
    TRSELECT,      -- Flag to Select Trp [oit_trpselect]
    PRIMARY KEY (MANDT, TRIP_ID)
);

Learn More