OIJ_SCHED

Planned Schedule Lines | #transactional | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
SIM_SCHED_ID TSW: Nomination Simulation ID
SIM_SCHED_LN TSW: Nomination Simulation Line item
SIM_VERSION TSW: Simulation Version
Column Name Description
💲 ATL Credit Currency (ATL_CRDT_CURR):
ATL_CRDT_VAL ATL Credit Amount
Column Name Description
📏 Nomination(pipe) UoM (UNIT):
QTYIN Qty received in TS
QTYOUT Qty delivered from TS
📏 Scheduled UoM (UNIT_I):
MENGE Scheduled qty
PRORATEQTY Prorated Quantity
ASSIGNEDQTY Assigned Quantity
📏 First Requested Quantity UoM (QTYFCR_UOM):
QTYFCR First requested quantity
📏 Actual posted quantity Unit of Measure (ACTUALUOM):
ACTUALQTY Actual posted quantity
📏 Absolute tolerance UoM (ITTOLUNIT):
ITBOTOLABS Absolute tolerance qty over
ITBUTOLABS Absolute tolerance qty under
📏 Planned load/discharge rate quantity UoM (LDQUOM):
LDRATE Planned load/discharge rate
📏 Unit of Measure for Confirmed Quantity Field (GA_CONF_UOM):
GA_CONF_QTY Confirmed Quantity
GA_CONF_QTY_CAL Calculated Values of Confirmed Quantity Field
📏 Unit of Measure for Technical Scheduled Quantity Field (GA_TECHSCH_UOM):
GA_TECHSCH_QTY Technical Scheduled Quantity Field
GA_TSCH_QTY_CAL Calculated Values of Technical Scheduled Quantity Field
📏 Unit of Measure for Allocated Quantity Field (GA_ALLOCATED_UOM):
GA_ALLOCATED_QTY Allocated Quantity
📏 Base Unit of Measure (ATL_CRDT_UOM):
ATL_CRDT_QTY ATL Credit Quantity
Column Name Description
SENTDAT Last header action date
SENTTIME Last header action time
IDATE Scheduled date
ACTDAT Last item action date
ACTTIME Last item action time
ERDAT Date on which the record was created
ERZEIT Time of creation
AEDAT Last Changed On
AEZEIT Time of day the record was changed
_DATAAGING Data Filter Value for Data Aging
Column Name Description
SIM_SCHED_TYP Simulation Schedule category Show values
SCHED_STAT TSW: Status of Simulated Schedule line Show values
SCHED_ACF TSW: Flag for automatically created entries Show values
NOMCL Nomination Class Show values
NMBALCH Balance check indicator (default) Show values
WORKLIST Worklist entry indicator Show values
NMBLOCK Blocking indicator Show values
LOV_GL Gain Loss LOV posting indicator Show values
NMSELECT Flag to Set Nomination Selectable Show values
BOOKTS Book TS indicator Show values
DOCIND Reference document indicator (PSX) Show values
WORKLIST_I Worklist entry indicator Show values
ILOCK Nomination item complete flag Show values
ACTUALS Nomination item partially complete Show values
UNLIMITED Unlimited Overdelivery Allowed Show values
BLOIND Blocking indicator Show values
DELIND Deletion indicator Show values
UPDATEXDOK Update external details failure flag Show values
INCOMPLETE_FLAG Incompletion Flag Show values
STLTY BOM category Show values
CHARG_D_CREATE Destination Batch create new flag Show values
CHARG_O_CREATE Origin Batch create new flag Show values
COMMCTL Nomination Communication Control Show values
CHARG_L_CREATE Load Batch create new flag Show values
PRE_EXIST_IND ATL Preexisting Delivery Indicator Show values
QUICKCONF Quick Confirm check box Show values
Column Name Description Domain name
NOMTK Nomination (technical) Key OIJ_NOMTK
NOMIT Nomination Key Item OIJ_ITEM
SCHED_COMM Short comment CHAR80
NOMNR Nomination number OIJ_NOMNR
STAGES_ID GUID in 'CHAR' format with upper-/lowercase (!) SYSUUID_22
SENTNAM Last user who worked on object USNAM
ITEMS Nomination item counter NUM04
COUNTER1 Nomination planned item Counter NUM04
COUNTER2 Nomination scheduled Item Counter NUM04
COUNTER3 Nomination rejected Item Counter NUM04
COUNTER4 Nomination confirmed Item Counter NUM04
COUNTER5 Nomination partially complete Item Counter NUM04
COUNTER6 Nomination completed Item Counter NUM04
APO_SHIPMENT_ID GUID in 'CHAR' format with upper-/lowercase (!) SYSUUID_22
APO_SHIPMENT_NUM Shipment Number TKNUM
NOMTYPDESC IS-Oil: Descriptive text OI0_TEXT
CYCLE Nomination Pipeline cycle ID CHAR10
NMVESSEL TD vehicle identifier OIG_LICNMR
EV_GROUP TD - event default group OIG_EVGRP
TST_FROM_MIN Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
TST_TO_MAX Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
SCHED_TST_FROM Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
SCHED_TST_TO Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
DOCNR Nomination Reference Document OIJ_DOCNR
DOCITM Nomination Reference Document Item NUM06
DOCSCHEDLN Nomination Reference Document Schedule line EETEN
TANK Tankage Partner OIJ_PARTNR
CONS Consignee Partner OIJ_PARTNR
PARTNR Location Partner OIJ_PARTNR
CONPAT Contract Partner OIJ_PARTNR
INSPE Inspector OIJ_PARTNR
CHARG_O Batch origin Location CHARG
CHARG_D Batch destination Location CHARG
RVP RVP value DEC3_1
ITBOTOL Quantity tolerance over (percentage) DEC3_1
ITBUTOL Quantity tolerance under (%) DEC3_1
DOCTYP Reference Document Type CHAR04
THIRD_NOMNR Partner Nomination number OIJ_NOMNR
UPMAT Pricing reference material of main item MATNR
REFITEM Higher-level item in bill of material structures OIJ_ITEM
STLKN BOM item node number KNTNR
CO_TSYST Connecting Transport System OIJ_TSYST
SOLDTO Customer Sold-to or Vendor OIJ_SOLDTO
CHARG_L Batch load CHARG
TCNUM TSW :Trading Contract number OIJ_TCNR
TCITM TSW: Trading contract item number OIJ_TCITM
GA_NMSHIPPER Shipper LIFNR
GA_RANK Rank OIJ_RANK
CYCLE_ITEM Nomination Pipeline cycle ID at Item Level CHAR10
ATL_DELV_NUMBER ATL credit check delivery number VBELN
ATL_DELV_ITM ATL credit check delivery item POSNR
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
FLTTNOMTK Nomination (technical) Key OIJ_NOMTK
UPDKZ Update indicator UPDKZ
USER_ID User ID OIJ05_USER
SCENARIO_ID Scenario ID OIJ05_SCN_ID
IPW_TXT NPW/IPW: User comment / text TEXTA1024
LOC_PT Location Partner Plant WERKS
LOC_SL Location Partner Storage Location LGORT
DUMMY_DNOM_SCHED_INCL_EEW_PS Data Element for Extension Fields: Sample NUMC10
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • OIJ_SCHED.MANDT == T006.MANDT
  • OIJ_SCHED.ACTUALUOM == T006.MSEHI
Business type
  • Business type
  • Client
Import / Export Partner Indicator
  • Import / Export Partner Indicator
  • Client
  • OIJ_SCHED.FLAG_IMEX == OIJIMEX.FLAG_IMEX
  • OIJ_SCHED.MANDT == OIJIMEX.MANDT
Import / Export Partner
  • OIJ_SCHED.MANDT == LFA1.MANDT
  • OIJ_SCHED.IMPOEXPO == LFA1.LIFNR
Nomination Item status
  • Nomination Item status
  • Client
  • ?
  • OIJ_SCHED.ISTAT == OIJSTAT.STATUS
  • OIJ_SCHED.MANDT == OIJSTAT.MANDT
  • OIJ_SCHED.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
Nomination Item sub-status
  • Nomination Item status
  • Nomination Item sub-status
  • Client
  • ?
Absolute tolerance UoM
  • OIJ_SCHED.MANDT == T006.MANDT
  • OIJ_SCHED.ITTOLUNIT == T006.MSEHI
Location ID
  • OIJ_SCHED.MANDT == OIJLOC.MANDT
  • OIJ_SCHED.LOCID == OIJLOC.LOCID
Client OIJ_SCHED.MANDT == T000.MANDT
Demand material
  • Demand material
  • Client
  • OIJ_SCHED.MATNR_I == MARA.MATNR
  • OIJ_SCHED.MANDT == MARA.MANDT
Carrier check table
  • OIJ_SCHED.MANDT == LFA1.MANDT
  • OIJ_SCHED.NMCARRIER == LFA1.LIFNR
Transport system In-transit Storage Location
  • Transport system In-transit Storage Location
  • Client
  • Transport system In-transit Plant
  • OIJ_SCHED.NMLGORT == T001L.LGORT
  • OIJ_SCHED.MANDT == T001L.MANDT
  • OIJ_SCHED.NMWERK == T001L.WERKS
Shipper Check Table
  • OIJ_SCHED.MANDT == LFA1.MANDT
  • OIJ_SCHED.NMSHIPPER == LFA1.LIFNR
TD shipment type
  • OIJ_SCHED.MANDT == TOIGS.CLIENT
  • OIJ_SCHED.NMSHTYPE == TOIGS.SHTYP
Transportation planning point
  • Transportation planning point
  • Client
  • OIJ_SCHED.NMTPLST == TTDS.TPLST
  • OIJ_SCHED.MANDT == TTDS.MANDT
TD Vehicle Number
  • OIJ_SCHED.MANDT == OIGV.CLIENT
  • OIJ_SCHED.NMVEHICLE == OIGV.VEHICLE
Transport system In-transit Plant
  • OIJ_SCHED.MANDT == T001W.MANDT
  • OIJ_SCHED.NMWERK == T001W.WERKS
Nomination type
  • Nomination type
  • Client
Valuation Type
  • OIJ_SCHED.MANDT == T149D.MANDT
  • OIJ_SCHED.OWNER == T149D.BWTAR
Prorate Calculation Routine Type OIJ_SCHED.PRORATE_ROUTINE == TOIJ_EL_PR_RT.PRORATE_ROUTINE
Route
  • OIJ_SCHED.MANDT == TVRO.MANDT
  • OIJ_SCHED.ROUTE == TVRO.ROUTE
Shipment type
  • OIJ_SCHED.MANDT == TVTK.MANDT
  • OIJ_SCHED.SHTYP == TVTK.SHTYP
Schedule type
Scheduled material
  • Scheduled material
  • Client
  • OIJ_SCHED.S_MATNR_I == MARA.MATNR
  • OIJ_SCHED.MANDT == MARA.MANDT
Transport System Check Table
  • OIJ_SCHED.MANDT == OIJTS.MANDT
  • OIJ_SCHED.TSYST == OIJTS.TSYST
Scheduled UoM
  • OIJ_SCHED.MANDT == T006.MANDT
  • OIJ_SCHED.UNIT_I == T006.MSEHI
Valuation Type Destination Loc.
  • OIJ_SCHED.MANDT == T149D.MANDT
  • OIJ_SCHED.VALUATIONTYPE_D == T149D.BWTAR
Valuation Type Origin Loc.
  • OIJ_SCHED.MANDT == T149D.MANDT
  • OIJ_SCHED.VALUATIONTYPE_O == T149D.BWTAR
Mode of Transport
  • OIJ_SCHED.MANDT == TVTR.MANDT
  • OIJ_SCHED.VKTRA == TVTR.VKTRA