OIJ08_TRIPH

Transparent Table Application Table
19 Fields 6 CDS Views

Trip Header

OIJ08_TRIPH is an SAP database table in S/4HANA. Trip Header. It contains 19 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 (19)

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.
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
trselect OIT_TRPSELECT Flag to Select Trp
dummy_triphdr_incl_eew_ps OIT_EXTN Extension Field

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]
    ERDAT,                      -- Created On [ERDAT]
    ERZEIT,                     -- Created [OI0_ERTIM]
    ERNAM,                      -- Created By [ERNAM]
    AEDAT,                      -- Changed On [AEDAT]
    AEZEIT,                     -- Changed [OI0_AETIM]
    AENAM,                      -- Changed By [AENAM]
    TRSELECT,                   -- Flag to Select Trp [OIT_TRPSELECT]
    DUMMY_TRIPHDR_INCL_EEW_PS,  -- Extension Field [OIT_EXTN]
    PRIMARY KEY (MANDT, TRIP_ID)
);

Learn More