OIJ_EL_CP_LAYT

Transparent Table Application Table
41 Fields 6 CDS Views

Charter party and laytime and demurrage agreement

OIJ_EL_CP_LAYT is an SAP database table in S/4HANA. Charter party and laytime and demurrage agreement. It contains 41 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_FreightContractVH view left_outer BASIC Value Help for Freight Contract
I_TripOutbDeliveryItemTP view left_outer TRANSACTIONAL Outbound Delivery Items
I_TripOutboundDelivery view left_outer BASIC Outbound Delivery details
I_TripOutboundDeliveryVH view left_outer BASIC Value Help for Outbound Delivery
I_TripPurchaseContractVH view left_outer BASIC Value Help for Purchase Contract
I_TripSalesContractVH view left_outer BASIC Value Help for Sales Contract

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vbeln oij_el_cpno Contract no.
KEY vbtyp oij_el_vbtyp TSW Det.Doc typ
KEY posnr oij_el_posnr Item
val_from oij_el_valf Valid from
val_to oij_el_valt Valid to
single_voy oij_el_sv Single voyage
vehicle oig_vhlnmr Vehicle Number
veh_type oig_vhltyp Vehicle type
ld_start oij_el_lds Laydays start
ld_end oij_el_lde Laydays end
rd_start oij_el_rds Redeliv. start
rd_end oij_el_rde Redeliv. end
grades_no oij_el_gno Number grades
route oij_el_route Route
speed oij_el_speed Base speed
min_speed oij_el_minsp Minimum speed
max_speed oij_el_maxsp Maximum speed
sp_uom oij_el_spuom UoM speed
min_quan oij_el_minqu Min. quantity
quan_uom oij_el_quuom Quantity UoM
capacity oij_el_cap Cargo size
cap_uom oij_el_capuom Capacity UoM
tol_min oij_el_tmin Min. tolerance
tol_max oij_el_tmax Max. tolerance
pressure oij_el_press Man. pressure
pres_uom oij_el_pruom Pressure UoM
bunker_l oij_el_bul Cons. laden
cl_uom oij_el_csuom Quan. UoM
clt_uom oij_el_cltuom Time UoM
bunker_b oij_el_bub Cons. ballasted
st_f_cons oij_el_stfc Standby fuel
st_d_cons oij_el_stdc Standby diesel
fuel_mg oij_el_bfuel Fuel mat. group
dies_mg oij_el_bdies Dies. mat group
decl oij_el_decl Declare ship by
decl_qu oij_el_dequ Decl. Quantity
lpa oij_el_lpa Load port agent
dpa oij_el_dpa Dis. port agent
cons_perc oij_cons_perc Bunker Cons.Perc.
_dataaging data_temperature Data Aging

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.

-- Charter party and laytime and demurrage agreement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_EL_CP_LAYT (
    MANDT,       -- Client [mandt]
    VBELN,       -- Contract no. [oij_el_cpno]
    VBTYP,       -- TSW Det.Doc typ [oij_el_vbtyp]
    POSNR,       -- Item [oij_el_posnr]
    VAL_FROM,    -- Valid from [oij_el_valf]
    VAL_TO,      -- Valid to [oij_el_valt]
    SINGLE_VOY,  -- Single voyage [oij_el_sv]
    VEHICLE,     -- Vehicle Number [oig_vhlnmr]
    VEH_TYPE,    -- Vehicle type [oig_vhltyp]
    LD_START,    -- Laydays start [oij_el_lds]
    LD_END,      -- Laydays end [oij_el_lde]
    RD_START,    -- Redeliv. start [oij_el_rds]
    RD_END,      -- Redeliv. end [oij_el_rde]
    GRADES_NO,   -- Number grades [oij_el_gno]
    ROUTE,       -- Route [oij_el_route]
    SPEED,       -- Base speed [oij_el_speed]
    MIN_SPEED,   -- Minimum speed [oij_el_minsp]
    MAX_SPEED,   -- Maximum speed [oij_el_maxsp]
    SP_UOM,      -- UoM speed [oij_el_spuom]
    MIN_QUAN,    -- Min. quantity [oij_el_minqu]
    QUAN_UOM,    -- Quantity UoM [oij_el_quuom]
    CAPACITY,    -- Cargo size [oij_el_cap]
    CAP_UOM,     -- Capacity UoM [oij_el_capuom]
    TOL_MIN,     -- Min. tolerance [oij_el_tmin]
    TOL_MAX,     -- Max. tolerance [oij_el_tmax]
    PRESSURE,    -- Man. pressure [oij_el_press]
    PRES_UOM,    -- Pressure UoM [oij_el_pruom]
    BUNKER_L,    -- Cons. laden [oij_el_bul]
    CL_UOM,      -- Quan. UoM [oij_el_csuom]
    CLT_UOM,     -- Time UoM [oij_el_cltuom]
    BUNKER_B,    -- Cons. ballasted [oij_el_bub]
    ST_F_CONS,   -- Standby fuel [oij_el_stfc]
    ST_D_CONS,   -- Standby diesel [oij_el_stdc]
    FUEL_MG,     -- Fuel mat. group [oij_el_bfuel]
    DIES_MG,     -- Dies. mat group [oij_el_bdies]
    DECL,        -- Declare ship by [oij_el_decl]
    DECL_QU,     -- Decl. Quantity [oij_el_dequ]
    LPA,         -- Load port agent [oij_el_lpa]
    DPA,         -- Dis. port agent [oij_el_dpa]
    CONS_PERC,   -- Bunker Cons.Perc. [oij_cons_perc]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, VBELN, VBTYP, POSNR)
);

Learn More