OIJNE_SIM

Transparent Table Application Table
57 Fields 3 CDS Views

Nomination Events

OIJNE_SIM is an SAP database table in S/4HANA. Nomination Events. It contains 57 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Cds_Oijne view from CDS combining OIJNE & OIJNE_SIM
Cds_Oijne view union_all CDS combining OIJNE & OIJNE_SIM
Oij07_Oijne_Sim view from Event simulations

Fields (57)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY event_sim_sched_id OIJ_SIMID Sim ID
KEY nomtk OIJ_NOMTK Nomination key
KEY nomit OIJ_ITEM Nom. key item
KEY event_nr OIG_EVNR Event number
KEY scenario_id OIJ05_SCNID Scenario ID
KEY sim_version OIJ_SIMVERS Sim Version
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
user_id OIJ05_USERID User ID
updkz UPDKZ_D Update indicator
event_sim CHAR1 Single-Character Flag
sched_stat OIJ_SIMSTAT Sim Status

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_SIM (
    CLIENT,              -- Client [MANDT]
    EVENT_SIM_SCHED_ID,  -- Sim ID [OIJ_SIMID]
    NOMTK,               -- Nomination key [OIJ_NOMTK]
    NOMIT,               -- Nom. key item [OIJ_ITEM]
    EVENT_NR,            -- Event number [OIG_EVNR]
    SCENARIO_ID,         -- Scenario ID [OIJ05_SCNID]
    SIM_VERSION,         -- Sim Version [OIJ_SIMVERS]
    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]
    USER_ID,             -- User ID [OIJ05_USERID]
    UPDKZ,               -- Update indicator [UPDKZ_D]
    EVENT_SIM,           -- Single-Character Flag [CHAR1]
    SCHED_STAT,          -- Sim Status [OIJ_SIMSTAT]
    PRIMARY KEY (CLIENT, EVENT_SIM_SCHED_ID, NOMTK, NOMIT, EVENT_NR, SCENARIO_ID, SIM_VERSION)
);

Learn More