OIJBERLOC

Transparent Table Application Table
13 Fields 1 CDS Views

Index table for berths at TSW locations

OIJBERLOC is an SAP database table in S/4HANA. Index table for berths at TSW locations. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_LocationBerthBasic view_entity from BASIC Index table for berths at TSW locations

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pblnr OIF_PBLNR Location ID
KEY berid OIJ_BERID Berth Identifier
bernr OIJ_BERNR Berth Number
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.

-- Index table for berths at TSW locations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJBERLOC (
    MANDT,      -- Client [MANDT]
    PBLNR,      -- Location ID [OIF_PBLNR]
    BERID,      -- Berth Identifier [OIJ_BERID]
    BERNR,      -- Berth Number [OIJ_BERNR]
    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, PBLNR, BERID)
);

Learn More