OIJ_EL_CP_LOC

Transparent Table Application Table
18 Fields 1 CDS Views

Charter party contract: load and discharge locations

OIJ_EL_CP_LOC is an SAP database table in S/4HANA. Charter party contract: load and discharge locations. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/DMBE/I_OIJ_EL_CP_LOC view from Charter cntrct:load and disch locations

Fields (18)

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
KEY seqnr OIJ_SEQNR Sequence number
location OIJ_EL_LOCID Location ID
attribute OIJ_EL_LOATT Loc. attribute
exclude OIJ_EL_EX Exclude loc.
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
_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 contract: load and discharge locations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_EL_CP_LOC (
    MANDT,       -- Client [MANDT]
    VBELN,       -- Contract no. [OIJ_EL_CPNO]
    VBTYP,       -- TSW Det.Doc typ [OIJ_EL_VBTYP]
    POSNR,       -- Item [OIJ_EL_POSNR]
    SEQNR,       -- Sequence number [OIJ_SEQNR]
    LOCATION,    -- Location ID [OIJ_EL_LOCID]
    ATTRIBUTE,   -- Loc. attribute [OIJ_EL_LOATT]
    EXCLUDE,     -- Exclude loc. [OIJ_EL_EX]
    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]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, VBELN, VBTYP, POSNR, SEQNR)
);

Learn More