OIJNE

Transparent Table Application Table
51 Fields 5 CDS Views

Nomination Events

OIJNE is an SAP database table in S/4HANA. Nomination Events. It contains 51 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_NominationEvent view from BASIC Nomination Events
I_Oij06_Events view from BASIC Events Consumption View
I_Oij06_Max_DATE_Events view from BASIC Maximum event changed date
I_Oij06_Max_Events view from BASIC Maximum event
I_Oij06_Recent_Event view from BASIC Nomination recent events

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY nomtk OIJ_NOMTK Nomination key
KEY nomit OIJ_ITEM Nom. key item
KEY event_nr OIG_EVNR Event number
nomnr OIJ_NOMNR Nomination no.
type OIG_EVTYPE Event type
doc_type OIG_EVDCTY Document type
updflag TRTYP Transact. type
ev_seq OIG_EVSEQ Seq. number
doc_number OIG_ASGDOC Document no.
shitem OIG_SHITM Shipment item
status OIG_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_name ERNAM Created By
cre_date ERDAT Created On
cre_time ERZET Time
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
defaulted XFELD Checkbox
veh_nr OIG_VEHNR Vehicle Seq. No
tsrfo TSRFO Seq.stage
ticket_key OIJ_EL_TKT_KEY Ticket key
ticket_item OIJ_EL_TKT_POSNR Item number
ticket_ev_nr OIG_EVNR Event number
tpnum TPNUM Item
delind OIJ_DELIND Deletion ind.
driver OIG_DRVNMR Driver no.
cparid OIJ_PARTNR Loc.partner
add_qty OIJ_ADD_QTY AddQuantity
adq_uom OIJ_ADD_UOM UoM of Additional Quantity
matnr MATNR Material
lt_evoppoint OIJ_EV_OPPOINT LT Event Marker
bernr OIJ_BERNR Berth Number
berid OIJ_BERID Berth Identifier
_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.

-- Nomination Events
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJNE (
    CLIENT,        -- Client [MANDT]
    NOMTK,         -- Nomination key [OIJ_NOMTK]
    NOMIT,         -- Nom. key item [OIJ_ITEM]
    EVENT_NR,      -- Event number [OIG_EVNR]
    NOMNR,         -- Nomination no. [OIJ_NOMNR]
    TYPE,          -- Event type [OIG_EVTYPE]
    DOC_TYPE,      -- Document type [OIG_EVDCTY]
    UPDFLAG,       -- Transact. type [TRTYP]
    EV_SEQ,        -- Seq. number [OIG_EVSEQ]
    DOC_NUMBER,    -- Document no. [OIG_ASGDOC]
    SHITEM,        -- Shipment item [OIG_SHITM]
    STATUS,        -- Event status [OIG_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_NAME,      -- Created By [ERNAM]
    CRE_DATE,      -- Created On [ERDAT]
    CRE_TIME,      -- Time [ERZET]
    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]
    DEFAULTED,     -- Checkbox [XFELD]
    VEH_NR,        -- Vehicle Seq. No [OIG_VEHNR]
    TSRFO,         -- Seq.stage [TSRFO]
    TICKET_KEY,    -- Ticket key [OIJ_EL_TKT_KEY]
    TICKET_ITEM,   -- Item number [OIJ_EL_TKT_POSNR]
    TICKET_EV_NR,  -- Event number [OIG_EVNR]
    TPNUM,         -- Item [TPNUM]
    DELIND,        -- Deletion ind. [OIJ_DELIND]
    DRIVER,        -- Driver no. [OIG_DRVNMR]
    CPARID,        -- Loc.partner [OIJ_PARTNR]
    ADD_QTY,       -- AddQuantity [OIJ_ADD_QTY]
    ADQ_UOM,       -- UoM of Additional Quantity [OIJ_ADD_UOM]
    MATNR,         -- Material [MATNR]
    LT_EVOPPOINT,  -- LT Event Marker [OIJ_EV_OPPOINT]
    BERNR,         -- Berth Number [OIJ_BERNR]
    BERID,         -- Berth Identifier [OIJ_BERID]
    _DATAAGING,    -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, NOMTK, NOMIT, EVENT_NR)
);

Learn More