OIJ08_TRIPSHPMNT

Transparent Table Application Table
11 Fields 3 CDS Views

Shipment items

OIJ08_TRIPSHPMNT is an SAP database table in S/4HANA. Shipment items. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_SchedTripDocItemVH view inner BASIC Interface view for Trip Item value help
I_SchedTripDocVH view inner BASIC Trip ID value help
I_TripShptItmTP view from TRANSACTIONAL Shipment Items

Fields (11)

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 shnumber oig_shnum Bulk shipment
KEY shpitem oig_shitm Shipment item
KEY posnr oig_item Item number
allocated_charge oij_dm_potential Pot. demurrage
dem_curr oij_dm_curr DemurrCurr
del_ind oit_del_ind Delete Indicator
vbeln vbeln_vl Delivery
nomnr oij_nomnr Nomination no.

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.

-- Shipment items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ08_TRIPSHPMNT (
    MANDT,             -- Client [mandt]
    TRIP_ID,           -- Trip ID [oij08_tripid]
    TRIP_ITEM,         -- Trip Item Number [oij08_trip_posnr]
    SHNUMBER,          -- Bulk shipment [oig_shnum]
    SHPITEM,           -- Shipment item [oig_shitm]
    POSNR,             -- Item number [oig_item]
    ALLOCATED_CHARGE,  -- Pot. demurrage [oij_dm_potential]
    DEM_CURR,          -- DemurrCurr [oij_dm_curr]
    DEL_IND,           -- Delete Indicator [oit_del_ind]
    VBELN,             -- Delivery [vbeln_vl]
    NOMNR,             -- Nomination no. [oij_nomnr]
    PRIMARY KEY (MANDT, TRIP_ID, TRIP_ITEM, SHNUMBER, SHPITEM, POSNR)
);

Learn More