OIJEV

Transparent Table Application Table
37 Fields 1 CDS Views

TD-Vehicle ~ Berth Master Data Events

OIJEV is an SAP database table in S/4HANA. TD-Vehicle ~ Berth Master Data Events. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_VehicleEvent view_entity from BASIC Bulk Transport Vehicle Event

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY app_area OI0_APPAREA Application Area
KEY object_id OIG_OBJID Object ID
KEY event_nr OI0_EVNR Evenr No.
type OI0_EVTYPE Event Type
drivercode OIG_DRVNMR Driver no.
cparid OIJ_PARTNR Loc.partner
rpart OIJ_RPART Role part. type
loc_id OIJ_LOCID Location ID
doc_type OIG_EVDCTY Document type
doc_number OIG_ASGDOC Document no.
updflag TRTYP Transact. type
ev_seq OIG_EVSEQ Seq. number
status OI0_EVSTAT Event Status
pstdtf OIG_PSTDTF PlndStartDateFr
psttmf OIG_PSTTMF PlndStTimeFrom
pstdtt OIG_PSTDTT PlndStartDateTo
psttmt OIG_PSTTMT PlndStTime-To
peddtf OIG_PEDDTF PlEndDateFr
pedtmf OIG_PEDTMF PlEndTimeFr
peddtt OIG_PEDDTT PlEndDateTo
pedtmt OIG_PEDTMT PlEndTimeTo
cre_date ERDAT Created On
cre_time ERZET Time
cre_name ERNAM Created By
cha_name AENAM Changed By
cha_date AEDAT Changed On
cha_time AEZET Time of change
astdtf OIG_ASTDTF Strt Date-From
asttmf OIG_ASTTMF Strt Time-From
astdtt OIG_ASTDTT Start Date-To
asttmt OIG_ASTTMT Start Time - To
aeddtf OIG_AEDDTF ActEndDateFr
aedtmf OIG_AEDTMF ActEndTimeFr
aeddtt OIG_AEDDTT ActEndDateTo
aedtmt OIG_AEDTMT ActEndTimeTo
longtext OIG_EVLT Long text 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.

-- TD-Vehicle ~ Berth Master Data Events
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJEV (
    CLIENT,      -- Client [MANDT]
    APP_AREA,    -- Application Area [OI0_APPAREA]
    OBJECT_ID,   -- Object ID [OIG_OBJID]
    EVENT_NR,    -- Evenr No. [OI0_EVNR]
    TYPE,        -- Event Type [OI0_EVTYPE]
    DRIVERCODE,  -- Driver no. [OIG_DRVNMR]
    CPARID,      -- Loc.partner [OIJ_PARTNR]
    RPART,       -- Role part. type [OIJ_RPART]
    LOC_ID,      -- Location ID [OIJ_LOCID]
    DOC_TYPE,    -- Document type [OIG_EVDCTY]
    DOC_NUMBER,  -- Document no. [OIG_ASGDOC]
    UPDFLAG,     -- Transact. type [TRTYP]
    EV_SEQ,      -- Seq. number [OIG_EVSEQ]
    STATUS,      -- Event Status [OI0_EVSTAT]
    PSTDTF,      -- PlndStartDateFr [OIG_PSTDTF]
    PSTTMF,      -- PlndStTimeFrom [OIG_PSTTMF]
    PSTDTT,      -- PlndStartDateTo [OIG_PSTDTT]
    PSTTMT,      -- PlndStTime-To [OIG_PSTTMT]
    PEDDTF,      -- PlEndDateFr [OIG_PEDDTF]
    PEDTMF,      -- PlEndTimeFr [OIG_PEDTMF]
    PEDDTT,      -- PlEndDateTo [OIG_PEDDTT]
    PEDTMT,      -- PlEndTimeTo [OIG_PEDTMT]
    CRE_DATE,    -- Created On [ERDAT]
    CRE_TIME,    -- Time [ERZET]
    CRE_NAME,    -- Created By [ERNAM]
    CHA_NAME,    -- Changed By [AENAM]
    CHA_DATE,    -- Changed On [AEDAT]
    CHA_TIME,    -- Time of change [AEZET]
    ASTDTF,      -- Strt Date-From [OIG_ASTDTF]
    ASTTMF,      -- Strt Time-From [OIG_ASTTMF]
    ASTDTT,      -- Start Date-To [OIG_ASTDTT]
    ASTTMT,      -- Start Time - To [OIG_ASTTMT]
    AEDDTF,      -- ActEndDateFr [OIG_AEDDTF]
    AEDTMF,      -- ActEndTimeFr [OIG_AEDTMF]
    AEDDTT,      -- ActEndDateTo [OIG_AEDDTT]
    AEDTMT,      -- ActEndTimeTo [OIG_AEDTMT]
    LONGTEXT,    -- Long text ind. [OIG_EVLT]
    PRIMARY KEY (CLIENT, APP_AREA, OBJECT_ID, EVENT_NR)
);

Learn More