1. SAP Tutorial
  2. Oil & Gas

OIJ_SCHED SAP table for – Planned Schedule Lines

Here we would like to draw your attention to OIJ_SCHED table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJ_SCHED is a SAP standard transp table used for storing Planned Schedule Lines related data in SAP. It comes under the package OIJ.

SAP OIJ_SCHED table

Table OIJ_SCHED technical data

TableOIJ_SCHED
Data storingPlanned Schedule Lines
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJ_SCHED Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIJ_SCHED table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SIM_SCHED_ID : TSW: Nomination Simulation ID
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • SIM_SCHED_LN : TSW: Nomination Simulation Line item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • SIM_VERSION : TSW: Simulation Version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SIM_SCHED_TYP : Simulation Schedule category
    Its data type is CHAR (Character String) with field length 2
  • SCHED_STAT : TSW: Status of Simulated Schedule line
    Its data type is CHAR (Character String) with field length 1
  • SCHED_ACF : TSW: Flag for automatically created entries
    Its data type is CHAR (Character String) with field length 1
  • NOMTK : Nomination (technical) Key
    Its data type is CHAR (Character String) with field length 20
  • NOMIT : Nomination Key Item
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • SCHED_COMM : Short comment
    Its data type is CHAR (Character String) with field length 80
  • .INCLUDE : Nomination Header Basic Fields
  • NOMCL : Nomination Class
    Its data type is CHAR (Character String) with field length 2
  • NOMTYP : Nomination type
    Its data type is CHAR (Character String) with field length 4
  • BUSTYP : Business type
    Its data type is CHAR (Character String) with field length 4
  • NOMNR : Nomination number
    Its data type is CHAR (Character String) with field length 20
  • NOMST : Nomination header status
    Its data type is CHAR (Character String) with field length 1
  • NMSHTYPE : TD shipment type
    Its data type is CHAR (Character String) with field length 4
  • NMBALCH : Balance check indicator (default)
    Its data type is CHAR (Character String) with field length 1
  • STAGES_ID : GUID in ‘CHAR’ format with upper-/lowercase (!)
    Its data type is CHAR (Character String) with field length 22
  • WORKLIST : Worklist entry indicator
    Its data type is CHAR (Character String) with field length 1
  • SENTDAT : Last header action date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SENTTIME : Last header action time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • SENTNAM : Last user who worked on object
    Its data type is CHAR (Character String) with field length 12
  • ITEMS : Nomination item counter
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • COUNTER1 : Nomination planned item Counter
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • COUNTER2 : Nomination scheduled Item Counter
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • COUNTER3 : Nomination rejected Item Counter
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • COUNTER4 : Nomination confirmed Item Counter
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • COUNTER5 : Nomination partially complete Item Counter
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • COUNTER6 : Nomination completed Item Counter
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • APO_SHIPMENT_ID : GUID in ‘CHAR’ format with upper-/lowercase (!)
    Its data type is CHAR (Character String) with field length 22
  • APO_SHIPMENT_NUM : Shipment Number
    Its data type is CHAR (Character String) with field length 10
  • NMBLOCK : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Nomination Header Default Fields
  • TSYST : Transport system
    Its data type is CHAR (Character String) with field length 10
  • NMSHIPPER : Shipper
    Its data type is CHAR (Character String) with field length 10
  • NMCARRIER : Transport system Carrier
    Its data type is CHAR (Character String) with field length 10
  • CYCLE : Nomination Pipeline cycle ID
    Its data type is CHAR (Character String) with field length 10
  • NMWERK : Transport system In-transit Plant
    Its data type is CHAR (Character String) with field length 4
  • NMLGORT : Transport system In-transit Storage Location
    Its data type is CHAR (Character String) with field length 4
  • NMVEHICLE : TD Vehicle Number
    Its data type is CHAR (Character String) with field length 10
  • NMVESSEL : TD vehicle identifier
    Its data type is CHAR (Character String) with field length 18
  • NMTPLST : Transportation planning point
    Its data type is CHAR (Character String) with field length 4
  • ROUTE : Route
    Its data type is CHAR (Character String) with field length 6
  • BOOKTS : Book TS indicator
    Its data type is CHAR (Character String) with field length 1
  • EV_GROUP : TD – event default group
    Its data type is CHAR (Character String) with field length 4
  • VKTRA : Mode of transport
    Its data type is CHAR (Character String) with field length 2
  • QTYIN : Qty received in TS
    Its data type is QUAN (Quantity field) with field length 13
  • QTYOUT : Qty delivered from TS
    Its data type is QUAN (Quantity field) with field length 13
  • UNIT : Nomination(pipe) UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TST_FROM_MIN : Scheduled / Acceptance / Pipe Batch Start Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TST_TO_MAX : Scheduled / Acceptance / Pipe Batch End Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Nomination Item Required Fields
  • SITYP : Schedule type
    Its data type is CHAR (Character String) with field length 2
  • ISTAT : Nomination Item status
    Its data type is CHAR (Character String) with field length 1
  • ISUBSTAT : Nomination Item sub-status
    Its data type is CHAR (Character String) with field length 1
  • IDATE : Scheduled date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SCHED_TST_FROM : Scheduled / Acceptance / Pipe Batch Start Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SCHED_TST_TO : Scheduled / Acceptance / Pipe Batch End Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LOCID : Location ID
    Its data type is CHAR (Character String) with field length 10
  • S_MATNR_I : Scheduled material
    Its data type is CHAR (Character String) with field length 18
  • MATNR_I : Demand material
    Its data type is CHAR (Character String) with field length 18
  • MENGE : Scheduled qty
    Its data type is QUAN (Quantity field) with field length 13
  • UNIT_I : Scheduled UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UNIT_I_T : Scheduled UoM Time
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DOCIND : Reference document indicator (PSX)
    Its data type is CHAR (Character String) with field length 1
  • DOCNR : Nomination Reference Document
    Its data type is CHAR (Character String) with field length 10
  • DOCITM : Nomination Reference Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • DOCSCHEDLN : Nomination Reference Document Schedule line
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • QTYFCR : First requested quantity
    Its data type is QUAN (Quantity field) with field length 13
  • QTYFCR_UOM : First Requested Quantity UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • WORKLIST_I : Worklist entry indicator
    Its data type is CHAR (Character String) with field length 1
  • TANK : Tankage Partner
    Its data type is CHAR (Character String) with field length 10
  • CONS : Consignee Partner
    Its data type is CHAR (Character String) with field length 10
  • PARTNR : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • CONPAT : Contract Partner
    Its data type is CHAR (Character String) with field length 10
  • INSPE : Inspector
    Its data type is CHAR (Character String) with field length 10
  • IMPOEXPO : Import / Export Partner
    Its data type is CHAR (Character String) with field length 10
  • FLAG_IMEX : Import / Export Partner Indicator
    Its data type is CHAR (Character String) with field length 2
  • OWNER : Valuation type
    Its data type is CHAR (Character String) with field length 10
  • CHARG_O : Batch origin Location
    Its data type is CHAR (Character String) with field length 10
  • CHARG_D : Batch destination Location
    Its data type is CHAR (Character String) with field length 10
  • RVP : RVP value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • VALUATIONTYPE_O : Valuation Type Origin Loc.
    Its data type is CHAR (Character String) with field length 10
  • VALUATIONTYPE_D : Valuation Type Destination Loc.
    Its data type is CHAR (Character String) with field length 10
  • SHNUM : TD shipment number
    Its data type is CHAR (Character String) with field length 10
  • SHITEM : Shipment item
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ILOCK : Nomination item complete flag
    Its data type is CHAR (Character String) with field length 1
  • PRORATEQTY : Prorated Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ASSIGNEDQTY : Assigned Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ACTDAT : Last item action date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACTTIME : Last item action time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ACTUALS : Nomination item partially complete
    Its data type is CHAR (Character String) with field length 1
  • ACTUALQTY : Actual posted quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ACTUALUOM : Actual posted quantity Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ITBOTOL : Quantity tolerance over (percentage)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • ITBUTOL : Quantity tolerance under (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • ITBOTOLABS : Absolute tolerance qty over
    Its data type is QUAN (Quantity field) with field length 13
  • ITBUTOLABS : Absolute tolerance qty under
    Its data type is QUAN (Quantity field) with field length 13
  • ITTOLUNIT : Absolute tolerance UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UNLIMITED : Indicator: Unlimited Overdelivery Allowed
    Its data type is CHAR (Character String) with field length 1
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • UPDATEXDOK : Update external details failure flag
    Its data type is CHAR (Character String) with field length 1
  • INCOMPLETE_FLAG : Incompletion Flag
    Its data type is CHAR (Character String) with field length 1
  • DOCTYP : Reference Document Type
    Its data type is CHAR (Character String) with field length 4
  • LDRATE : Planned load/discharge rate
    Its data type is QUAN (Quantity field) with field length 13
  • LDQUOM : Planned load/discharge rate quantity UoM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LDTUOM : Planned load/discharge rate time UOM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • THIRD_NOMNR : Partner Nomination number
    Its data type is CHAR (Character String) with field length 20
  • UPMAT : Pricing reference material of main item
    Its data type is CHAR (Character String) with field length 18
  • REFITEM : Higher-level item in bill of material structures
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • STLTY : BOM Category
    Its data type is CHAR (Character String) with field length 1
  • STLKN : BOM Item Node Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • CHARG_D_CREATE : Destination Batch create new flag
    Its data type is CHAR (Character String) with field length 1
  • CHARG_O_CREATE : Origin Batch create new flag
    Its data type is CHAR (Character String) with field length 1
  • CO_CARR : Connecting carrier
    Its data type is CHAR (Character String) with field length 10
  • CO_SHIP : Connecting shipper
    Its data type is CHAR (Character String) with field length 10
  • CO_TSYST : Connecting Transport System
    Its data type is CHAR (Character String) with field length 10
  • COMMCTL : Nomination Communication Control
    Its data type is CHAR (Character String) with field length 2
  • SOLDTO : Customer Sold-to or Vendor
    Its data type is CHAR (Character String) with field length 10
  • PRORATE_ROUTINE : Prorate Calculation Routine Type
    Its data type is CHAR (Character String) with field length 6
  • CHARG_L : Batch load
    Its data type is CHAR (Character String) with field length 10
  • CHARG_L_CREATE : Load Batch create new flag
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Nomination Item Administration Fields
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12

    • OIJ_SCHED related tables

    • OIJTHPUTFC : Rack issue / Throughput forecast
    • TOIJ_NOM_QSF : Nomination Quick Search Fields
    • TOIJ_ST_GAUG_RTT : description of stop meter calculation routine values
    • OIJ_NOMEV_PREREQ : Event prerequisite check routines
    • OIJHCT01 : OIL-TSW: Ticket Holding Table (Draft version 1) – OBSOLETE
    • B450 : OIL-TSW: Carrier/Shipping Type
    • OIJ_EL_TKT_I_O2 : Appendix: TSW Ticket item – Additional Quantities
    • OIJRD : OIL-TSW: Rundown table
    • OIJFCPRF : OIL-TSW: Rack issue forecast profile
    • OIJWL : OIL-TSW: Worklist
    • OIJNOM_FIELDST : Nomination field status locking
    • TOIJ_REF_DOC_UPD : OIL-TSW: Update of scheduled documents – Technical settings
    • OIJ_PLBUCKPROFT : Oil-TSW: Planning Buckets Profile Text
    • OIJ_RDHEAD : Stock Projection header
    • OIJWLRC : Worklist reason codes / NOT USED ANYMORE
    • OIJ_NOMEV_CHK_R : Nomination item check routines
    • OIJTSY_RANGE : Oil-TSW: Release profile – Transport systems range table
    • OIJHTNR : OIL-TSW: Ticket Number Rules
    • TOIJNOM_ST15 : Nomination Business Proc./status prereq’s
    • OIJ_NOMST_PREREQ : Status prerequisite check routines

    OIJ_SCHED related transaction codes under SAP package OIJ

    • S_SOG_81000056 : IMG activity: SIMG_OIJ_TSW_071
    • S_SO5_65000253 : IMG activity: SIMG_TSW_0001
    • O5TNR_NOM_VERS : Number range maintenance: OIJ_VERS
    • S_SO6_65000879 : OIL-TSW: Generate production/sales f
    • O5T8 : Update fields in field catalog – NOM
    • O4NCN : Create Nomination
    • O4NV : Change Nomination
    • S_SO5_65000256 : IMG activity: SIMG_TSW_0020
    • S_SOG_81000087 : IMG activity: SIMG_OIJ_TSW_102
    • S_SOG_81000113 : IMG activity: SIMG_OIJ_TSW_1115
    • S_SOG_81000075 : IMG activity: SIMG_OIJ_TSW_0006
    • S_SO7_65001280 : IMG activity: SIMG_OIJ_TSW_047
    • S_SO7_65001270 : IMG activity: SIMG_OIJ_TSW_041
    • O4TENCORR : Correct ticket
    • S_SOG_81000079 : IMG activity: SIMG_OIJ_TSW_0003
    • S_SO7_65001296 : IMG activity: SIMG_OIJ_TSW_049
    • S_SO7_65001269 : IMG activity: SIMG_OIJ_TSW_040
    • S_SOG_81000082 : IMG activity: SIMG_OIJ_TSW_0004
    • O4TO : Worklist
    • O4TX_TREE : Drill-down planning locations

    Related References

    Related Tutorials

    OIJ_SCHEDR SAP table for – Planned Schedule Lines Reference Documents

    OIJ_SCHEDR table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Planned Schedule Lines...

    OIJBRDDOC SAP table for – Rundown item / document X-ref table for Batch – WILL EXPIR

    OIJBRDDOC table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Rundown item /...

    OIJRDDOC SAP table for – Rundown item / document X-ref table/ WILL EXPIRE IN FUTURE

    OIJRDDOC table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Rundown item /...

    OIJHUOM SAP table for – OIL-TSW: Ticket additional units of measure

    OIJHUOM table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: Ticket additional...

    OIJDOCFL SAP table for – OIL-TSW : TICKET DOCUMENT FLOW TABLE Obsolete, do not use

    OIJDOCFL table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW : TICKET...

    OIJNOMCOMM SAP table for – Nomination Partner Communication

    OIJNOMCOMM table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Nomination Partner Communication....

    OIJ_PEG SAP table for – obsolete table (will be cleaned up)

    OIJ_PEG table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of obsolete table (will...

    «
    »