OIJBER

Transparent Table Application Table
21 Fields 1 CDS Views

Berth Table

OIJBER is an SAP database table in S/4HANA. Berth Table. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_Berth view_entity from BASIC Location Berth

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY berid OIJ_BERID Berth Identifier
bernam OIJ_BERNAM Description
lighter OIJ_LIGHTERFLG Allow Lightering
equip_nr EQUNR Equipment
cp_grp_id OI0_CP_GRP_ID Compatibility Grp ID
berlen OIJ_BERLEN Length of Berth
bermaxdrft OIJ_BERMAXDRFT Max. draft of berth
berdeplat OIJ_BER_DEPTH_LAT Berth depth at LAT
minshipdwght OIJ_MIN_SHIPDEADWGT Min Ship Deadweight
wgt_uom OIG_WGTUOM Weight UoM
dim_uom OIG_DIMUOM Dimension UoM
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
tktselect OIJ_TKTSELECT Flag to Select Tkt

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.

-- Berth Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJBER (
    MANDT,         -- Client [MANDT]
    BERID,         -- Berth Identifier [OIJ_BERID]
    BERNAM,        -- Description [OIJ_BERNAM]
    LIGHTER,       -- Allow Lightering [OIJ_LIGHTERFLG]
    EQUIP_NR,      -- Equipment [EQUNR]
    CP_GRP_ID,     -- Compatibility Grp ID [OI0_CP_GRP_ID]
    BERLEN,        -- Length of Berth [OIJ_BERLEN]
    BERMAXDRFT,    -- Max. draft of berth [OIJ_BERMAXDRFT]
    BERDEPLAT,     -- Berth depth at LAT [OIJ_BER_DEPTH_LAT]
    MINSHIPDWGHT,  -- Min Ship Deadweight [OIJ_MIN_SHIPDEADWGT]
    WGT_UOM,       -- Weight UoM [OIG_WGTUOM]
    DIM_UOM,       -- Dimension UoM [OIG_DIMUOM]
    ERDAT,         -- Created On [ERDAT]
    ERZEIT,        -- Created [OI0_ERTIM]
    ERNAM,         -- Created By [ERNAM]
    AEDAT,         -- Changed On [AEDAT]
    AEZEIT,        -- Changed [OI0_AETIM]
    AENAM,         -- Changed By [AENAM]
    BLOIND,        -- Blocking ind. [OIJ_BLOIND]
    DELIND,        -- Deletion ind. [OIJ_DELIND]
    TKTSELECT,     -- Flag to Select Tkt [OIJ_TKTSELECT]
    PRIMARY KEY (MANDT, BERID)
);

Learn More