VOIJ_SCHED

161 Fields 1 CDS Views

Generated Table for View

VOIJ_SCHED is an SAP database table in S/4HANA. Generated Table for View. It contains 161 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_VisualSimulation view from COMPOSITE IPW Simulation in Visualization

Fields (161)

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
nomcl OIJ_NOMCL Nom. class
nomtyp OIJ_NOMTYP Nomination type
bustyp OIRA_RNBT Business type
nomnr OIJ_NOMNR Nomination no.
nomst OIJ_NOMST Header status
nmshtype OIG_TDSTYP Bulk shipm.type
nmbalch OIJ_BALCH Balance check
stages_id GUID_22 GUID 22
worklist OIJ_WORKLT Worklist indic.
sentdat OIJ_SENDAT Hdr.Action date
senttime OIJ_SENTIM Hdr.Action time
sentnam OIJ_SENNAM Hdr.Action by
items OIJ_ITEMCOUNTER Item counter
counter1 OIJ_PLANNEDITEMS Plan. Item Cnt.
counter2 OIJ_SCHEDULEDITEMS Sched. item cnt
counter3 OIJ_REJECTEDITEMS Reject. Cnt.
counter4 OIJ_CONFIRMEDITEMS Conf. Item Cnt.
counter5 OIJ_PARTCOMPLETEITEMS Par.Cmpl. Cnt
counter6 OIJ_COMPLETEDITEMS Compl. ItemCnt.
apo_shipment_id GUID_22 GUID 22
apo_shipment_num TKNUM Shipment Number
nmblock OIJ_BLOIND Blocking ind.
nomtypdesc OI0_TEXT Description
shtyp SHTYP Shipment Type
tknum TKNUM Shipment Number
lov_gl OIJ03_GLLOVPOST Inv. Post.
tsyst OIJ_TSYST Trans system
nmshipper OIJ_SHIPNR Shipper
nmcarrier OIJ_CARRNR Carrier
cycle OIJ_CYCLE Cycle ID
nmwerk OIJ_WERK Intr. plant
nmlgort OIJ_LGORT Intr.S.Loc
nmvehicle OIG_VHLNMR Vehicle Number
nmvessel OIG_VEHID Ext. identifier
nmtplst TPLST TransportPlanPt
route ROUTE Route
bookts OIJ_BOOKTS Book TS
ev_group OIG_EVGRP Event def.group
vktra VKTRA Mode of Transp.
qtyin OIJ_QTYIN Qty
qtyout OIJ_QTYOUT Qty
unit OIJ_NMUNIT UoM
tst_from_min OIJ_SCHED_F TST From
tst_to_max OIJ_SCHED_T TST To
sityp OIJ_SITYP Sched.type
istat OIJ_ISTAT Item status
isubstat OIJ_SSTAT Item sub-status
idate OIJ_IDATE SchedDate
sched_tst_from OIJ_SCHED_F TST From
sched_tst_to OIJ_SCHED_T TST To
locid OIJ_LOCID Location ID
s_matnr_i OIJ_SMATNR Sched.Material
matnr_i OIJ_MATNRI DemandMat
menge OIJ_MENGE SchedQty
unit_i OIJ_UNITI SchedUoM
unit_i_t OIJ_UNITI_T SchedUoMTime
docind OIJ_DOCIND Ref.Doc.Ind.
docnr OIJ_DOCNR Ref. doc.
docitm OIJ_DOCITM Ref.Doc.Item
docschedln OIJ_DOCSCHEDLN Schedule line
qtyfcr OIJ_QTYFCR First Req. Qty
qtyfcr_uom OIJ_QTYFCR_UOM F.Qty UOM
worklist_i OIJ_WORKLT Worklist indic.
tank OIJ_TANKAGE Tankage partner
cons OIJ_CONSIGNEE ConsigneePartnr
partnr OIJ_PARTNR Loc.partner
conpat OIJ_CONPAT ContrPartner
inspe OIJ_INSPECTOR Inspector
impoexpo OIJ_IMEXPO ImEx Partner
flag_imex OIJ_IMEXFL ImpExp P. Flag
owner BWTAR_D Valuation Type
charg_o OIJ_CHARGO Batch orig
charg_d OIJ_CHARGD Batch dest.
rvp OIJ_RVP RVP
valuationtype_o OIJ_BWTAR_O Val.Type Origin
valuationtype_d OIJ_BWTAR_D Val.Type Dest.
shnum OIG_SHNUM Bulk shipment
shitem OIG_SHITM Shipment item
ilock OIJ_ILOCK Complete
prorateqty OIJ_PRRA_QTY Prorated Qty.
assignedqty OIJ_ASSG_QTY Assigned Qty.
actdat OIJ_ACTDAT Itm.Action date
acttime OIJ_ACTIME Itm.Action time
actuals OIJ_ACTUAL Part. complete
actualqty OIJ_ACTQTY Actual Qty
actualuom OIJ_ACTUOM ActualUoM
itbotol OIJ_BOTOL Over %
itbutol OIJ_BUTOL Under %
itbotolabs OIJ_TOLABO Abs.tol.qty.ovr
itbutolabs OIJ_TOLABS Abs.tol.Q under
ittolunit OIJ_TOLUOM Abs.tol.UoM
unlimited UEBTK Unlimited
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
updatexdok OIJ_EXDOK ExDtl fail
incomplete_flag OIJ_INCOMPLETE_FLAG Incompl. flag
doctyp OIJ_DOCTYP Ref. doc. type
ldrate OIJ_EL_LDRATE LD rate
ldquom OIJ_EL_LDQUOM LD Quantity UoM
ldtuom OIJ_EL_LDTUOM LD Time UoM
third_nomnr OIJ_3RD_NOMNR Partner Nom. no.
upmat UPMAT Pr.Ref.Material
refitem OIJ_REF_BOM_ITEM BOM ref. item
stlty STLTY BOM category
stlkn STLKN Item node
charg_d_create OIJ_CHARG_D_C Batch create
charg_o_create OIJ_CHARG_O_C Batch create
co_carr OIJ_EL_CCA Con. carrier
co_ship OIJ_EL_CSH Con. shipper
co_tsyst OIJ_EL_CTSYST Con.Trans.system
commctl OIJ_NOMCOMM Comm Contr.
soldto OIJ_SOLDTO SoldTo / Vendor
prorate_routine OIJ_EL_DE_PR_RT ProratRoutinTyp
charg_l OIJ_CHARGL Batch load
charg_l_create OIJ_CHARG_L_C Ld. Btch create
tcnum OIJ_TCNR Trad.Contr
tcitm OIJ_TCITM Trad.Contr Item no.
ga_nmshipper OIJ_SHIPNR Shipper
ga_conf_qty OIJ_CONFQTY Confirmed Quantity
ga_conf_uom OIJ_CONFUOM Unit of Measure
ga_techsch_qty OIJ_TECHSCHQTY Technical Sched qty
ga_techsch_uom OIJ_TECHSCHUOM Technical Scheduling Unit of Measure
ga_conf_qty_cal OIJ_CONFQTY_CAL Conf Qty Calculated
ga_tsch_qty_cal OIJ_TECHSCH_QTY_CAL Tech. Schd Qty calc
ga_allocated_qty OIJ_ALLOCATED_QTY Allocated Qty
ga_allocated_uom OIJ_ALLOCATED_UOM Allocated UOM
ga_rank OIJ_RANK Rank
cycle_item OIJ_ITEMCYCLE Item Cycle ID
lesshnum TKNUM Shipment Number
lestpnum TPNUM Item
atl_delv_number OIJ_ATL_DELV ATL CC Delivery
atl_delv_itm OIJ_ATL_DELV_ITM ATL CC Delivery item
atl_crdt_qty OIJ_ATL_CREDIT_QTY ATL credit qty
atl_crdt_uom MEINS Base Unit
atl_crdt_val OIJ_ATL_CREDIT_AMT ATL credit amount
atl_crdt_curr OIJ_ATL_CREDIT_CURR ATL credit currency
pre_exist_ind OIJ_ATL_PREEXIST_IND ATL pre-ex delv ind
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 OIJ_NOMTK Nomination key
updkz UPDKZ_D Update indicator
user_id OIJ05_USERID User ID
scenario_id OIJ05_SCNID Scenario ID
ipw_txt OIJ05_IPWTXT Comment
loc_pt OIJ_LOCPT Loc.Partn.Plant
loc_sl OIJ_LOCSL Loc.Partn.SLoc
quickconf OIJ_QC Confirm

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VOIJ_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]
    NOMCL,             -- Nom. class [OIJ_NOMCL]
    NOMTYP,            -- Nomination type [OIJ_NOMTYP]
    BUSTYP,            -- Business type [OIRA_RNBT]
    NOMNR,             -- Nomination no. [OIJ_NOMNR]
    NOMST,             -- Header status [OIJ_NOMST]
    NMSHTYPE,          -- Bulk shipm.type [OIG_TDSTYP]
    NMBALCH,           -- Balance check [OIJ_BALCH]
    STAGES_ID,         -- GUID 22 [GUID_22]
    WORKLIST,          -- Worklist indic. [OIJ_WORKLT]
    SENTDAT,           -- Hdr.Action date [OIJ_SENDAT]
    SENTTIME,          -- Hdr.Action time [OIJ_SENTIM]
    SENTNAM,           -- Hdr.Action by [OIJ_SENNAM]
    ITEMS,             -- Item counter [OIJ_ITEMCOUNTER]
    COUNTER1,          -- Plan. Item Cnt. [OIJ_PLANNEDITEMS]
    COUNTER2,          -- Sched. item cnt [OIJ_SCHEDULEDITEMS]
    COUNTER3,          -- Reject. Cnt. [OIJ_REJECTEDITEMS]
    COUNTER4,          -- Conf. Item Cnt. [OIJ_CONFIRMEDITEMS]
    COUNTER5,          -- Par.Cmpl. Cnt [OIJ_PARTCOMPLETEITEMS]
    COUNTER6,          -- Compl. ItemCnt. [OIJ_COMPLETEDITEMS]
    APO_SHIPMENT_ID,   -- GUID 22 [GUID_22]
    APO_SHIPMENT_NUM,  -- Shipment Number [TKNUM]
    NMBLOCK,           -- Blocking ind. [OIJ_BLOIND]
    NOMTYPDESC,        -- Description [OI0_TEXT]
    SHTYP,             -- Shipment Type [SHTYP]
    TKNUM,             -- Shipment Number [TKNUM]
    LOV_GL,            -- Inv. Post. [OIJ03_GLLOVPOST]
    TSYST,             -- Trans system [OIJ_TSYST]
    NMSHIPPER,         -- Shipper [OIJ_SHIPNR]
    NMCARRIER,         -- Carrier [OIJ_CARRNR]
    CYCLE,             -- Cycle ID [OIJ_CYCLE]
    NMWERK,            -- Intr. plant [OIJ_WERK]
    NMLGORT,           -- Intr.S.Loc [OIJ_LGORT]
    NMVEHICLE,         -- Vehicle Number [OIG_VHLNMR]
    NMVESSEL,          -- Ext. identifier [OIG_VEHID]
    NMTPLST,           -- TransportPlanPt [TPLST]
    ROUTE,             -- Route [ROUTE]
    BOOKTS,            -- Book TS [OIJ_BOOKTS]
    EV_GROUP,          -- Event def.group [OIG_EVGRP]
    VKTRA,             -- Mode of Transp. [VKTRA]
    QTYIN,             -- Qty [OIJ_QTYIN]
    QTYOUT,            -- Qty [OIJ_QTYOUT]
    UNIT,              -- UoM [OIJ_NMUNIT]
    TST_FROM_MIN,      -- TST From [OIJ_SCHED_F]
    TST_TO_MAX,        -- TST To [OIJ_SCHED_T]
    SITYP,             -- Sched.type [OIJ_SITYP]
    ISTAT,             -- Item status [OIJ_ISTAT]
    ISUBSTAT,          -- Item sub-status [OIJ_SSTAT]
    IDATE,             -- SchedDate [OIJ_IDATE]
    SCHED_TST_FROM,    -- TST From [OIJ_SCHED_F]
    SCHED_TST_TO,      -- TST To [OIJ_SCHED_T]
    LOCID,             -- Location ID [OIJ_LOCID]
    S_MATNR_I,         -- Sched.Material [OIJ_SMATNR]
    MATNR_I,           -- DemandMat [OIJ_MATNRI]
    MENGE,             -- SchedQty [OIJ_MENGE]
    UNIT_I,            -- SchedUoM [OIJ_UNITI]
    UNIT_I_T,          -- SchedUoMTime [OIJ_UNITI_T]
    DOCIND,            -- Ref.Doc.Ind. [OIJ_DOCIND]
    DOCNR,             -- Ref. doc. [OIJ_DOCNR]
    DOCITM,            -- Ref.Doc.Item [OIJ_DOCITM]
    DOCSCHEDLN,        -- Schedule line [OIJ_DOCSCHEDLN]
    QTYFCR,            -- First Req. Qty [OIJ_QTYFCR]
    QTYFCR_UOM,        -- F.Qty UOM [OIJ_QTYFCR_UOM]
    WORKLIST_I,        -- Worklist indic. [OIJ_WORKLT]
    TANK,              -- Tankage partner [OIJ_TANKAGE]
    CONS,              -- ConsigneePartnr [OIJ_CONSIGNEE]
    PARTNR,            -- Loc.partner [OIJ_PARTNR]
    CONPAT,            -- ContrPartner [OIJ_CONPAT]
    INSPE,             -- Inspector [OIJ_INSPECTOR]
    IMPOEXPO,          -- ImEx Partner [OIJ_IMEXPO]
    FLAG_IMEX,         -- ImpExp P. Flag [OIJ_IMEXFL]
    OWNER,             -- Valuation Type [BWTAR_D]
    CHARG_O,           -- Batch orig [OIJ_CHARGO]
    CHARG_D,           -- Batch dest. [OIJ_CHARGD]
    RVP,               -- RVP [OIJ_RVP]
    VALUATIONTYPE_O,   -- Val.Type Origin [OIJ_BWTAR_O]
    VALUATIONTYPE_D,   -- Val.Type Dest. [OIJ_BWTAR_D]
    SHNUM,             -- Bulk shipment [OIG_SHNUM]
    SHITEM,            -- Shipment item [OIG_SHITM]
    ILOCK,             -- Complete [OIJ_ILOCK]
    PRORATEQTY,        -- Prorated Qty. [OIJ_PRRA_QTY]
    ASSIGNEDQTY,       -- Assigned Qty. [OIJ_ASSG_QTY]
    ACTDAT,            -- Itm.Action date [OIJ_ACTDAT]
    ACTTIME,           -- Itm.Action time [OIJ_ACTIME]
    ACTUALS,           -- Part. complete [OIJ_ACTUAL]
    ACTUALQTY,         -- Actual Qty [OIJ_ACTQTY]
    ACTUALUOM,         -- ActualUoM [OIJ_ACTUOM]
    ITBOTOL,           -- Over % [OIJ_BOTOL]
    ITBUTOL,           -- Under % [OIJ_BUTOL]
    ITBOTOLABS,        -- Abs.tol.qty.ovr [OIJ_TOLABO]
    ITBUTOLABS,        -- Abs.tol.Q under [OIJ_TOLABS]
    ITTOLUNIT,         -- Abs.tol.UoM [OIJ_TOLUOM]
    UNLIMITED,         -- Unlimited [UEBTK]
    BLOIND,            -- Blocking ind. [OIJ_BLOIND]
    DELIND,            -- Deletion ind. [OIJ_DELIND]
    UPDATEXDOK,        -- ExDtl fail [OIJ_EXDOK]
    INCOMPLETE_FLAG,   -- Incompl. flag [OIJ_INCOMPLETE_FLAG]
    DOCTYP,            -- Ref. doc. type [OIJ_DOCTYP]
    LDRATE,            -- LD rate [OIJ_EL_LDRATE]
    LDQUOM,            -- LD Quantity UoM [OIJ_EL_LDQUOM]
    LDTUOM,            -- LD Time UoM [OIJ_EL_LDTUOM]
    THIRD_NOMNR,       -- Partner Nom. no. [OIJ_3RD_NOMNR]
    UPMAT,             -- Pr.Ref.Material [UPMAT]
    REFITEM,           -- BOM ref. item [OIJ_REF_BOM_ITEM]
    STLTY,             -- BOM category [STLTY]
    STLKN,             -- Item node [STLKN]
    CHARG_D_CREATE,    -- Batch create [OIJ_CHARG_D_C]
    CHARG_O_CREATE,    -- Batch create [OIJ_CHARG_O_C]
    CO_CARR,           -- Con. carrier [OIJ_EL_CCA]
    CO_SHIP,           -- Con. shipper [OIJ_EL_CSH]
    CO_TSYST,          -- Con.Trans.system [OIJ_EL_CTSYST]
    COMMCTL,           -- Comm Contr. [OIJ_NOMCOMM]
    SOLDTO,            -- SoldTo / Vendor [OIJ_SOLDTO]
    PRORATE_ROUTINE,   -- ProratRoutinTyp [OIJ_EL_DE_PR_RT]
    CHARG_L,           -- Batch load [OIJ_CHARGL]
    CHARG_L_CREATE,    -- Ld. Btch create [OIJ_CHARG_L_C]
    TCNUM,             -- Trad.Contr [OIJ_TCNR]
    TCITM,             -- Trad.Contr Item no. [OIJ_TCITM]
    GA_NMSHIPPER,      -- Shipper [OIJ_SHIPNR]
    GA_CONF_QTY,       -- Confirmed Quantity [OIJ_CONFQTY]
    GA_CONF_UOM,       -- Unit of Measure [OIJ_CONFUOM]
    GA_TECHSCH_QTY,    -- Technical Sched qty [OIJ_TECHSCHQTY]
    GA_TECHSCH_UOM,    -- Technical Scheduling Unit of Measure [OIJ_TECHSCHUOM]
    GA_CONF_QTY_CAL,   -- Conf Qty Calculated [OIJ_CONFQTY_CAL]
    GA_TSCH_QTY_CAL,   -- Tech. Schd Qty calc [OIJ_TECHSCH_QTY_CAL]
    GA_ALLOCATED_QTY,  -- Allocated Qty [OIJ_ALLOCATED_QTY]
    GA_ALLOCATED_UOM,  -- Allocated UOM [OIJ_ALLOCATED_UOM]
    GA_RANK,           -- Rank [OIJ_RANK]
    CYCLE_ITEM,        -- Item Cycle ID [OIJ_ITEMCYCLE]
    LESSHNUM,          -- Shipment Number [TKNUM]
    LESTPNUM,          -- Item [TPNUM]
    ATL_DELV_NUMBER,   -- ATL CC Delivery [OIJ_ATL_DELV]
    ATL_DELV_ITM,      -- ATL CC Delivery item [OIJ_ATL_DELV_ITM]
    ATL_CRDT_QTY,      -- ATL credit qty [OIJ_ATL_CREDIT_QTY]
    ATL_CRDT_UOM,      -- Base Unit [MEINS]
    ATL_CRDT_VAL,      -- ATL credit amount [OIJ_ATL_CREDIT_AMT]
    ATL_CRDT_CURR,     -- ATL credit currency [OIJ_ATL_CREDIT_CURR]
    PRE_EXIST_IND,     -- ATL pre-ex delv ind [OIJ_ATL_PREEXIST_IND]
    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,         -- Nomination key [OIJ_NOMTK]
    UPDKZ,             -- Update indicator [UPDKZ_D]
    USER_ID,           -- User ID [OIJ05_USERID]
    SCENARIO_ID,       -- Scenario ID [OIJ05_SCNID]
    IPW_TXT,           -- Comment [OIJ05_IPWTXT]
    LOC_PT,            -- Loc.Partn.Plant [OIJ_LOCPT]
    LOC_SL,            -- Loc.Partn.SLoc [OIJ_LOCSL]
    QUICKCONF,         -- Confirm [OIJ_QC]
    PRIMARY KEY (MANDT, SIM_SCHED_ID, SIM_SCHED_LN, SIM_VERSION)
);

Learn More