OIJ05_SCHED_SIM

Transparent Table Application Table
171 Fields 3 CDS Views

Marker table

OIJ05_SCHED_SIM is an SAP database table in S/4HANA. Marker table. It contains 171 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
OIJ05_GSCHED_SIM view from Global simulations marker entries
Oij05_Oijsched_Sim view from CDSV for OIJ05_SCHED_SIM
Oij07_Oij_Sched_Mk view from Marker table

Fields (171)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sim_sched_id OIJ_SIMID Sim ID
KEY sim_sched_ln OIJ_SIMLN Sim Line
KEY sim_version OIJ_SIMVERS Sim Version
sim_sched_typ OIJ_SIM_SCHED_TYP Schedule cat.
sched_stat OIJ_SIMSTAT Sim Status
sched_acf OIJ_SIM_AUTO_CREATE Auto-create flag
nomtk OIJ_NOMTK Nomination key
nomit OIJ_ITEM Nom. key item
sched_comm CHAR1 Single-Character Flag
nomcl CHAR1 Single-Character Flag
nomtyp CHAR1 Single-Character Flag
bustyp CHAR1 Single-Character Flag
nomnr CHAR1 Single-Character Flag
nomst CHAR1 Single-Character Flag
nmshtype CHAR1 Single-Character Flag
nmbalch CHAR1 Single-Character Flag
stages_id CHAR1 Single-Character Flag
worklist CHAR1 Single-Character Flag
sentdat CHAR1 Single-Character Flag
senttime CHAR1 Single-Character Flag
sentnam CHAR1 Single-Character Flag
items CHAR1 Single-Character Flag
counter1 CHAR1 Single-Character Flag
counter2 CHAR1 Single-Character Flag
counter3 CHAR1 Single-Character Flag
counter4 CHAR1 Single-Character Flag
counter5 CHAR1 Single-Character Flag
counter6 CHAR1 Single-Character Flag
apo_shipment_id CHAR1 Single-Character Flag
apo_shipment_num CHAR1 Single-Character Flag
nmblock CHAR1 Single-Character Flag
nomtypdesc CHAR1 Single-Character Flag
shtyp CHAR1 Single-Character Flag
tknum CHAR1 Single-Character Flag
lov_gl CHAR1 Single-Character Flag
tsyst CHAR1 Single-Character Flag
nmshipper CHAR1 Single-Character Flag
nmcarrier CHAR1 Single-Character Flag
cycle CHAR1 Single-Character Flag
nmwerk CHAR1 Single-Character Flag
nmlgort CHAR1 Single-Character Flag
nmvehicle CHAR1 Single-Character Flag
nmvessel CHAR1 Single-Character Flag
nmtplst CHAR1 Single-Character Flag
route CHAR1 Single-Character Flag
bookts CHAR1 Single-Character Flag
ev_group CHAR1 Single-Character Flag
vktra CHAR1 Single-Character Flag
qtyin CHAR1 Single-Character Flag
qtyout CHAR1 Single-Character Flag
unit CHAR1 Single-Character Flag
tst_from_min CHAR1 Single-Character Flag
tst_to_max CHAR1 Single-Character Flag
sityp CHAR1 Single-Character Flag
istat CHAR1 Single-Character Flag
isubstat CHAR1 Single-Character Flag
idate CHAR1 Single-Character Flag
sched_tst_from CHAR1 Single-Character Flag
sched_tst_to CHAR1 Single-Character Flag
locid CHAR1 Single-Character Flag
s_matnr_i CHAR1 Single-Character Flag
matnr_i CHAR1 Single-Character Flag
menge CHAR1 Single-Character Flag
unit_i CHAR1 Single-Character Flag
unit_i_t CHAR1 Single-Character Flag
docind CHAR1 Single-Character Flag
docnr CHAR1 Single-Character Flag
docitm CHAR1 Single-Character Flag
docschedln CHAR1 Single-Character Flag
qtyfcr CHAR1 Single-Character Flag
qtyfcr_uom CHAR1 Single-Character Flag
worklist_i CHAR1 Single-Character Flag
tank CHAR1 Single-Character Flag
cons CHAR1 Single-Character Flag
partnr CHAR1 Single-Character Flag
conpat CHAR1 Single-Character Flag
inspe CHAR1 Single-Character Flag
impoexpo CHAR1 Single-Character Flag
flag_imex CHAR1 Single-Character Flag
owner CHAR1 Single-Character Flag
charg_o CHAR1 Single-Character Flag
charg_d CHAR1 Single-Character Flag
rvp CHAR1 Single-Character Flag
valuationtype_o CHAR1 Single-Character Flag
valuationtype_d CHAR1 Single-Character Flag
shnum CHAR1 Single-Character Flag
shitem CHAR1 Single-Character Flag
ilock CHAR1 Single-Character Flag
prorateqty CHAR1 Single-Character Flag
assignedqty CHAR1 Single-Character Flag
actdat CHAR1 Single-Character Flag
acttime CHAR1 Single-Character Flag
actuals CHAR1 Single-Character Flag
actualqty CHAR1 Single-Character Flag
actualuom CHAR1 Single-Character Flag
itbotol CHAR1 Single-Character Flag
itbutol CHAR1 Single-Character Flag
itbotolabs CHAR1 Single-Character Flag
itbutolabs CHAR1 Single-Character Flag
ittolunit CHAR1 Single-Character Flag
unlimited CHAR1 Single-Character Flag
bloind CHAR1 Single-Character Flag
delind CHAR1 Single-Character Flag
updatexdok CHAR1 Single-Character Flag
incomplete_flag CHAR1 Single-Character Flag
doctyp CHAR1 Single-Character Flag
ldrate CHAR1 Single-Character Flag
ldquom CHAR1 Single-Character Flag
ldtuom CHAR1 Single-Character Flag
third_nomnr CHAR1 Single-Character Flag
upmat CHAR1 Single-Character Flag
refitem CHAR1 Single-Character Flag
stlty CHAR1 Single-Character Flag
stlkn CHAR1 Single-Character Flag
charg_d_create CHAR1 Single-Character Flag
charg_o_create CHAR1 Single-Character Flag
co_carr CHAR1 Single-Character Flag
co_ship CHAR1 Single-Character Flag
co_tsyst CHAR1 Single-Character Flag
commctl CHAR1 Single-Character Flag
soldto CHAR1 Single-Character Flag
prorate_routine CHAR1 Single-Character Flag
charg_l CHAR1 Single-Character Flag
charg_l_create CHAR1 Single-Character Flag
tcnum CHAR1 Single-Character Flag
tcitm CHAR1 Single-Character Flag
ga_nmshipper CHAR1 Single-Character Flag
ga_conf_qty CHAR1 Single-Character Flag
ga_conf_uom CHAR1 Single-Character Flag
ga_techsch_qty CHAR1 Single-Character Flag
ga_techsch_uom CHAR1 Single-Character Flag
ga_conf_qty_cal CHAR1 Single-Character Flag
ga_tsch_qty_cal CHAR1 Single-Character Flag
ga_allocated_qty CHAR1 Single-Character Flag
ga_allocated_uom CHAR1 Single-Character Flag
ga_rank CHAR1 Single-Character Flag
cycle_item CHAR1 Single-Character Flag
lesshnum CHAR1 Single-Character Flag
lestpnum CHAR1 Single-Character Flag
atl_delv_number CHAR1 Single-Character Flag
atl_delv_itm CHAR1 Single-Character Flag
atl_crdt_qty CHAR1 Single-Character Flag
atl_crdt_uom CHAR1 Single-Character Flag
atl_crdt_val CHAR1 Single-Character Flag
atl_crdt_curr CHAR1 Single-Character Flag
pre_exist_ind CHAR1 Single-Character Flag
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
flttnomtk CHAR1 Single-Character Flag
updkz UPDKZ_D Update indicator
user_id OIJ05_USERID User ID
scenario_id OIJ05_SCNID Scenario ID
ipw_txt CHAR1 Single-Character Flag
locpt CHAR1 Single-Character Flag
locsl CHAR1 Single-Character Flag
actualqty_par CHAR1 Single-Character Flag
actualuom_par CHAR1 Single-Character Flag
bloind_i CHAR1 Single-Character Flag
delind_i CHAR1 Single-Character Flag
shnum_i CHAR1 Single-Character Flag
itime CHAR1 Single-Character Flag
idate_to CHAR1 Single-Character Flag
itime_to CHAR1 Single-Character Flag
quickconf CHAR1 Single-Character Flag
pegid OIJ_PEGID Peg ID
pegtype OIJ_PEGTYPE Peg type

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.

-- Marker table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ05_SCHED_SIM (
    MANDT,             -- Client [MANDT]
    SIM_SCHED_ID,      -- Sim ID [OIJ_SIMID]
    SIM_SCHED_LN,      -- Sim Line [OIJ_SIMLN]
    SIM_VERSION,       -- Sim Version [OIJ_SIMVERS]
    SIM_SCHED_TYP,     -- Schedule cat. [OIJ_SIM_SCHED_TYP]
    SCHED_STAT,        -- Sim Status [OIJ_SIMSTAT]
    SCHED_ACF,         -- Auto-create flag [OIJ_SIM_AUTO_CREATE]
    NOMTK,             -- Nomination key [OIJ_NOMTK]
    NOMIT,             -- Nom. key item [OIJ_ITEM]
    SCHED_COMM,        -- Single-Character Flag [CHAR1]
    NOMCL,             -- Single-Character Flag [CHAR1]
    NOMTYP,            -- Single-Character Flag [CHAR1]
    BUSTYP,            -- Single-Character Flag [CHAR1]
    NOMNR,             -- Single-Character Flag [CHAR1]
    NOMST,             -- Single-Character Flag [CHAR1]
    NMSHTYPE,          -- Single-Character Flag [CHAR1]
    NMBALCH,           -- Single-Character Flag [CHAR1]
    STAGES_ID,         -- Single-Character Flag [CHAR1]
    WORKLIST,          -- Single-Character Flag [CHAR1]
    SENTDAT,           -- Single-Character Flag [CHAR1]
    SENTTIME,          -- Single-Character Flag [CHAR1]
    SENTNAM,           -- Single-Character Flag [CHAR1]
    ITEMS,             -- Single-Character Flag [CHAR1]
    COUNTER1,          -- Single-Character Flag [CHAR1]
    COUNTER2,          -- Single-Character Flag [CHAR1]
    COUNTER3,          -- Single-Character Flag [CHAR1]
    COUNTER4,          -- Single-Character Flag [CHAR1]
    COUNTER5,          -- Single-Character Flag [CHAR1]
    COUNTER6,          -- Single-Character Flag [CHAR1]
    APO_SHIPMENT_ID,   -- Single-Character Flag [CHAR1]
    APO_SHIPMENT_NUM,  -- Single-Character Flag [CHAR1]
    NMBLOCK,           -- Single-Character Flag [CHAR1]
    NOMTYPDESC,        -- Single-Character Flag [CHAR1]
    SHTYP,             -- Single-Character Flag [CHAR1]
    TKNUM,             -- Single-Character Flag [CHAR1]
    LOV_GL,            -- Single-Character Flag [CHAR1]
    TSYST,             -- Single-Character Flag [CHAR1]
    NMSHIPPER,         -- Single-Character Flag [CHAR1]
    NMCARRIER,         -- Single-Character Flag [CHAR1]
    CYCLE,             -- Single-Character Flag [CHAR1]
    NMWERK,            -- Single-Character Flag [CHAR1]
    NMLGORT,           -- Single-Character Flag [CHAR1]
    NMVEHICLE,         -- Single-Character Flag [CHAR1]
    NMVESSEL,          -- Single-Character Flag [CHAR1]
    NMTPLST,           -- Single-Character Flag [CHAR1]
    ROUTE,             -- Single-Character Flag [CHAR1]
    BOOKTS,            -- Single-Character Flag [CHAR1]
    EV_GROUP,          -- Single-Character Flag [CHAR1]
    VKTRA,             -- Single-Character Flag [CHAR1]
    QTYIN,             -- Single-Character Flag [CHAR1]
    QTYOUT,            -- Single-Character Flag [CHAR1]
    UNIT,              -- Single-Character Flag [CHAR1]
    TST_FROM_MIN,      -- Single-Character Flag [CHAR1]
    TST_TO_MAX,        -- Single-Character Flag [CHAR1]
    SITYP,             -- Single-Character Flag [CHAR1]
    ISTAT,             -- Single-Character Flag [CHAR1]
    ISUBSTAT,          -- Single-Character Flag [CHAR1]
    IDATE,             -- Single-Character Flag [CHAR1]
    SCHED_TST_FROM,    -- Single-Character Flag [CHAR1]
    SCHED_TST_TO,      -- Single-Character Flag [CHAR1]
    LOCID,             -- Single-Character Flag [CHAR1]
    S_MATNR_I,         -- Single-Character Flag [CHAR1]
    MATNR_I,           -- Single-Character Flag [CHAR1]
    MENGE,             -- Single-Character Flag [CHAR1]
    UNIT_I,            -- Single-Character Flag [CHAR1]
    UNIT_I_T,          -- Single-Character Flag [CHAR1]
    DOCIND,            -- Single-Character Flag [CHAR1]
    DOCNR,             -- Single-Character Flag [CHAR1]
    DOCITM,            -- Single-Character Flag [CHAR1]
    DOCSCHEDLN,        -- Single-Character Flag [CHAR1]
    QTYFCR,            -- Single-Character Flag [CHAR1]
    QTYFCR_UOM,        -- Single-Character Flag [CHAR1]
    WORKLIST_I,        -- Single-Character Flag [CHAR1]
    TANK,              -- Single-Character Flag [CHAR1]
    CONS,              -- Single-Character Flag [CHAR1]
    PARTNR,            -- Single-Character Flag [CHAR1]
    CONPAT,            -- Single-Character Flag [CHAR1]
    INSPE,             -- Single-Character Flag [CHAR1]
    IMPOEXPO,          -- Single-Character Flag [CHAR1]
    FLAG_IMEX,         -- Single-Character Flag [CHAR1]
    OWNER,             -- Single-Character Flag [CHAR1]
    CHARG_O,           -- Single-Character Flag [CHAR1]
    CHARG_D,           -- Single-Character Flag [CHAR1]
    RVP,               -- Single-Character Flag [CHAR1]
    VALUATIONTYPE_O,   -- Single-Character Flag [CHAR1]
    VALUATIONTYPE_D,   -- Single-Character Flag [CHAR1]
    SHNUM,             -- Single-Character Flag [CHAR1]
    SHITEM,            -- Single-Character Flag [CHAR1]
    ILOCK,             -- Single-Character Flag [CHAR1]
    PRORATEQTY,        -- Single-Character Flag [CHAR1]
    ASSIGNEDQTY,       -- Single-Character Flag [CHAR1]
    ACTDAT,            -- Single-Character Flag [CHAR1]
    ACTTIME,           -- Single-Character Flag [CHAR1]
    ACTUALS,           -- Single-Character Flag [CHAR1]
    ACTUALQTY,         -- Single-Character Flag [CHAR1]
    ACTUALUOM,         -- Single-Character Flag [CHAR1]
    ITBOTOL,           -- Single-Character Flag [CHAR1]
    ITBUTOL,           -- Single-Character Flag [CHAR1]
    ITBOTOLABS,        -- Single-Character Flag [CHAR1]
    ITBUTOLABS,        -- Single-Character Flag [CHAR1]
    ITTOLUNIT,         -- Single-Character Flag [CHAR1]
    UNLIMITED,         -- Single-Character Flag [CHAR1]
    BLOIND,            -- Single-Character Flag [CHAR1]
    DELIND,            -- Single-Character Flag [CHAR1]
    UPDATEXDOK,        -- Single-Character Flag [CHAR1]
    INCOMPLETE_FLAG,   -- Single-Character Flag [CHAR1]
    DOCTYP,            -- Single-Character Flag [CHAR1]
    LDRATE,            -- Single-Character Flag [CHAR1]
    LDQUOM,            -- Single-Character Flag [CHAR1]
    LDTUOM,            -- Single-Character Flag [CHAR1]
    THIRD_NOMNR,       -- Single-Character Flag [CHAR1]
    UPMAT,             -- Single-Character Flag [CHAR1]
    REFITEM,           -- Single-Character Flag [CHAR1]
    STLTY,             -- Single-Character Flag [CHAR1]
    STLKN,             -- Single-Character Flag [CHAR1]
    CHARG_D_CREATE,    -- Single-Character Flag [CHAR1]
    CHARG_O_CREATE,    -- Single-Character Flag [CHAR1]
    CO_CARR,           -- Single-Character Flag [CHAR1]
    CO_SHIP,           -- Single-Character Flag [CHAR1]
    CO_TSYST,          -- Single-Character Flag [CHAR1]
    COMMCTL,           -- Single-Character Flag [CHAR1]
    SOLDTO,            -- Single-Character Flag [CHAR1]
    PRORATE_ROUTINE,   -- Single-Character Flag [CHAR1]
    CHARG_L,           -- Single-Character Flag [CHAR1]
    CHARG_L_CREATE,    -- Single-Character Flag [CHAR1]
    TCNUM,             -- Single-Character Flag [CHAR1]
    TCITM,             -- Single-Character Flag [CHAR1]
    GA_NMSHIPPER,      -- Single-Character Flag [CHAR1]
    GA_CONF_QTY,       -- Single-Character Flag [CHAR1]
    GA_CONF_UOM,       -- Single-Character Flag [CHAR1]
    GA_TECHSCH_QTY,    -- Single-Character Flag [CHAR1]
    GA_TECHSCH_UOM,    -- Single-Character Flag [CHAR1]
    GA_CONF_QTY_CAL,   -- Single-Character Flag [CHAR1]
    GA_TSCH_QTY_CAL,   -- Single-Character Flag [CHAR1]
    GA_ALLOCATED_QTY,  -- Single-Character Flag [CHAR1]
    GA_ALLOCATED_UOM,  -- Single-Character Flag [CHAR1]
    GA_RANK,           -- Single-Character Flag [CHAR1]
    CYCLE_ITEM,        -- Single-Character Flag [CHAR1]
    LESSHNUM,          -- Single-Character Flag [CHAR1]
    LESTPNUM,          -- Single-Character Flag [CHAR1]
    ATL_DELV_NUMBER,   -- Single-Character Flag [CHAR1]
    ATL_DELV_ITM,      -- Single-Character Flag [CHAR1]
    ATL_CRDT_QTY,      -- Single-Character Flag [CHAR1]
    ATL_CRDT_UOM,      -- Single-Character Flag [CHAR1]
    ATL_CRDT_VAL,      -- Single-Character Flag [CHAR1]
    ATL_CRDT_CURR,     -- Single-Character Flag [CHAR1]
    PRE_EXIST_IND,     -- Single-Character Flag [CHAR1]
    ERDAT,             -- Created On [ERDAT]
    ERZEIT,            -- Created [OI0_ERTIM]
    ERNAM,             -- Created By [ERNAM]
    AEDAT,             -- Changed On [AEDAT]
    AEZEIT,            -- Changed [OI0_AETIM]
    AENAM,             -- Changed By [AENAM]
    FLTTNOMTK,         -- Single-Character Flag [CHAR1]
    UPDKZ,             -- Update indicator [UPDKZ_D]
    USER_ID,           -- User ID [OIJ05_USERID]
    SCENARIO_ID,       -- Scenario ID [OIJ05_SCNID]
    IPW_TXT,           -- Single-Character Flag [CHAR1]
    LOCPT,             -- Single-Character Flag [CHAR1]
    LOCSL,             -- Single-Character Flag [CHAR1]
    ACTUALQTY_PAR,     -- Single-Character Flag [CHAR1]
    ACTUALUOM_PAR,     -- Single-Character Flag [CHAR1]
    BLOIND_I,          -- Single-Character Flag [CHAR1]
    DELIND_I,          -- Single-Character Flag [CHAR1]
    SHNUM_I,           -- Single-Character Flag [CHAR1]
    ITIME,             -- Single-Character Flag [CHAR1]
    IDATE_TO,          -- Single-Character Flag [CHAR1]
    ITIME_TO,          -- Single-Character Flag [CHAR1]
    QUICKCONF,         -- Single-Character Flag [CHAR1]
    PEGID,             -- Peg ID [OIJ_PEGID]
    PEGTYPE,           -- Peg type [OIJ_PEGTYPE]
    PRIMARY KEY (MANDT, SIM_SCHED_ID, SIM_SCHED_LN, SIM_VERSION)
);

Learn More