V_OIJBERLOC

12 Fields 1 CDS Views

Generated Table for View

V_OIJBERLOC is an SAP database table in S/4HANA. Generated Table for View. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BerthScheduling view left_outer COMPOSITE Berth Scheduling Information

Fields (12)

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.

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_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]
    PRIMARY KEY (MANDT, PBLNR, BERID)
);

Learn More