OIJ_SCHED

Transparent Table Application Table
11 Fields 9 CDS Views

Planned Schedule Lines

OIJ_SCHED is an SAP database table in S/4HANA. Planned Schedule Lines. It contains 11 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
Cds_Nom_Sim view union_all Actual Nominations & Simulated Nominations
Cds_Oijsched view from CDS to retrieve from OIJ_SCHED based on user_id
E_DemandNominationSchedule view from EXTENSION Extension include view for Demand Nominations
I_NominationSimulation view from BASIC I_NominationSimulation
OIJ05_GSCHED_LO view from CDS for Location Balancing Global Sim in OIJ_SCHED
OIJ05_GSIMSCHEDID view from Simulation Schedule IDs for Global Simulations
Oij05_Nwb view union_all To fetch distinct nomtk
Oij05_Oijsched view from CDSV for OIJSCHED
Oij07_Oij_Sched view from Nomination simulation data

Fields (11)

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 oij_sim_sc Short Comment
_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.

-- Planned Schedule Lines
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_SCHED (
    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,     -- Short Comment [oij_sim_sc]
    _DATAAGING,     -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, SIM_SCHED_ID, SIM_SCHED_LN, SIM_VERSION)
);

Learn More