OIJ08_TRIPSHPMNT

Transparent Table Application Table
17 Fields 3 CDS Views

Shipment items

OIJ08_TRIPSHPMNT is an SAP database table in S/4HANA. Shipment items. It contains 17 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 (17)

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
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
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]
    ERDAT,             -- Created On [ERDAT]
    ERZEIT,            -- Created [OI0_ERTIM]
    ERNAM,             -- Created By [ERNAM]
    AEDAT,             -- Changed On [AEDAT]
    AEZEIT,            -- Changed [OI0_AETIM]
    AENAM,             -- Changed By [AENAM]
    VBELN,             -- Delivery [VBELN_VL]
    NOMNR,             -- Nomination no. [OIJ_NOMNR]
    PRIMARY KEY (MANDT, TRIP_ID, TRIP_ITEM, SHNUMBER, SHPITEM, POSNR)
);

Learn More