SAP TABLES | Industry Solution Oil | Trader's and Scheduler's Workbench(IS-OIL-DS-TSW) SAP IS

OIJ_SCHED SAP Planned Schedule Lines Table and data







OIJ_SCHED is a standard SAP Table which is used to store Planned Schedule Lines data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP OIJ_SCHED Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP OIJ_SCHED Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
SIM_SCHED_IDOIJ_SIMIDCHAR20
*
TSW: Nomination Simulation IDALPHA
SIM_SCHED_LNOIJ_SIMLNNUMC10 TSW: Nomination Simulation Line item
SIM_VERSIONOIJ_SIMVERSNUMC3 TSW: Simulation Version
SIM_SCHED_TYPOIJ_SIM_SCHED_TYPCHAR2 Simulation Schedule category
SCHED_STATOIJ_SIMSTATCHAR1 TSW: Status of Simulated Schedule line
SCHED_ACFOIJ_SIM_AUTO_CREATECHAR1 TSW: Flag for automatically created entries
NOMTKOIJ_NOMTKCHAR20
*
Nomination (technical) KeyALPHA
NOMITOIJ_ITEMNUMC10
*
Nomination Key Item
SCHED_COMMOIJ_SIM_SCCHAR80 Short comment
.INCLUDEROIJNOMH_R Nomination Header Basic Fields
NOMCLOIJ_NOMCLCHAR2 Nomination Class
NOMTYPOIJ_NOMTYPCHAR4 TOIJNOMTYPNomination type
BUSTYPOIRA_RNBTCHAR4 OIRARNBTBusiness type
NOMNROIJ_NOMNRCHAR20 Nomination number
NOMSTOIJ_NOMSTCHAR1
*
Nomination header status
NMSHTYPEOIG_TDSTYPCHAR4 TOIGSTD shipment type
NMBALCHOIJ_BALCHCHAR1 Balance check indicator (default)
STAGES_IDGUID_22CHAR22 GUID in 'CHAR' format with upper-/lowercase (!)
WORKLISTOIJ_WORKLTCHAR1 Worklist entry indicator
SENTDATOIJ_SENDATDATS8 Last header action date
SENTTIMEOIJ_SENTIMTIMS6 Last header action time
SENTNAMOIJ_SENNAMCHAR12 Last user who worked on object
ITEMSOIJ_ITEMCOUNTERNUMC4 Nomination item counter
COUNTER1OIJ_PLANNEDITEMSNUMC4 Nomination planned item Counter
COUNTER2OIJ_SCHEDULEDITEMSNUMC4 Nomination scheduled Item Counter
COUNTER3OIJ_REJECTEDITEMSNUMC4 Nomination rejected Item Counter
COUNTER4OIJ_CONFIRMEDITEMSNUMC4 Nomination confirmed Item Counter
COUNTER5OIJ_PARTCOMPLETEITEMSNUMC4 Nomination partially complete Item Counter
COUNTER6OIJ_COMPLETEDITEMSNUMC4 Nomination completed Item Counter
APO_SHIPMENT_IDGUID_22CHAR22 GUID in 'CHAR' format with upper-/lowercase (!)
APO_SHIPMENT_NUMTKNUMCHAR10
*
Shipment NumberALPHA
NMBLOCKOIJ_BLOINDCHAR1 Blocking indicator
NOMTYPDESCOI0_TEXTCHAR36 IS-Oil: Descriptive textALPHA
SHTYPSHTYPCHAR4 TVTKShipment type
TKNUMTKNUMCHAR10 VTTKShipment NumberALPHA
LOV_GLOIJ03_GLLOVPOSTCHAR1 Gain Loss LOV posting indicator
.INCLUDEROIJNOMH_D Nomination Header Default Fields
TSYSTOIJ_TSYSTCHAR10 OIJTSTransport system


NMSHIPPEROIJ_SHIPNRCHAR10 LFA1ShipperALPHA
NMCARRIEROIJ_CARRNRCHAR10 LFA1Transport system CarrierALPHA
CYCLEOIJ_CYCLECHAR10 Nomination Pipeline cycle ID
NMWERKOIJ_WERKCHAR4 T001WTransport system In-transit Plant
NMLGORTOIJ_LGORTCHAR4 T001LTransport system In-transit Storage Location
NMVEHICLEOIG_VHLNMRCHAR10 OIGVTD Vehicle NumberALPHA
NMVESSELOIG_VEHIDCHAR18 TD vehicle identifier
NMTPLSTTPLSTCHAR4 TTDSTransportation planning point
ROUTEROUTECHAR6 TVRORoute
BOOKTSOIJ_BOOKTSCHAR1 Book TS indicator
EV_GROUPOIG_EVGRPCHAR4 TD - event default group
VKTRAVKTRACHAR2 TVTRMode of transport
QTYINOIJ_QTYINQUAN13(3) Qty received in TS
QTYOUTOIJ_QTYOUTQUAN13(3) Qty delivered from TS
UNITOIJ_NMUNITUNIT3
*
Nomination(pipe) UoMCUNIT
TST_FROM_MINOIJ_SCHED_FDEC15 Scheduled / Acceptance / Pipe Batch Start Timestamp
TST_TO_MAXOIJ_SCHED_TDEC15 Scheduled / Acceptance / Pipe Batch End Timestamp
.INCLUDEROIJNOMI_R Nomination Item Required Fields
SITYPOIJ_SITYPCHAR2 TOIJ_EL_SITYPESSchedule type
ISTATOIJ_ISTATCHAR1 OIJSTATNomination Item status
ISUBSTATOIJ_SSTATCHAR1 OIJSUBSTATNomination Item sub-status
IDATEOIJ_IDATEDATS8 Scheduled date
SCHED_TST_FROMOIJ_SCHED_FDEC15 Scheduled / Acceptance / Pipe Batch Start Timestamp
SCHED_TST_TOOIJ_SCHED_TDEC15 Scheduled / Acceptance / Pipe Batch End Timestamp
LOCIDOIJ_LOCIDCHAR10 OIJLOCLocation ID
S_MATNR_IOIJ_SMATNRCHAR18 MARAScheduled materialMATN1
MATNR_IOIJ_MATNRICHAR18 MARADemand materialMATN1
MENGEOIJ_MENGEQUAN13(3) Scheduled qty
UNIT_IOIJ_UNITIUNIT3 T006Scheduled UoMCUNIT
UNIT_I_TOIJ_UNITI_TUNIT3
*
Scheduled UoM TimeCUNIT
DOCINDOIJ_DOCINDCHAR1 Reference document indicator (PSX)
DOCNROIJ_DOCNRCHAR10 Nomination Reference DocumentALPHA
DOCITMOIJ_DOCITMNUMC6 Nomination Reference Document Item
DOCSCHEDLNOIJ_DOCSCHEDLNNUMC4
*
Nomination Reference Document Schedule line
QTYFCROIJ_QTYFCRQUAN13(3) First requested quantity
QTYFCR_UOMOIJ_QTYFCR_UOMUNIT3
*
First Requested Quantity UoMCUNIT
WORKLIST_IOIJ_WORKLTCHAR1 Worklist entry indicator
TANKOIJ_TANKAGECHAR10 Tankage PartnerALPHA
CONSOIJ_CONSIGNEECHAR10 Consignee PartnerALPHA


PARTNROIJ_PARTNRCHAR10 Location PartnerALPHA
CONPATOIJ_CONPATCHAR10 Contract PartnerALPHA
INSPEOIJ_INSPECTORCHAR10 InspectorALPHA
IMPOEXPOOIJ_IMEXPOCHAR10 LFA1Import / Export PartnerALPHA
FLAG_IMEXOIJ_IMEXFLCHAR2 OIJIMEXImport / Export Partner Indicator
OWNERBWTAR_DCHAR10 T149DValuation Type
CHARG_OOIJ_CHARGOCHAR10
*
Batch origin Location
CHARG_DOIJ_CHARGDCHAR10
*
Batch destination Location
RVPOIJ_RVPDEC4(1) RVP value
VALUATIONTYPE_OOIJ_BWTAR_OCHAR10 T149DValuation Type Origin Loc.
VALUATIONTYPE_DOIJ_BWTAR_DCHAR10 T149DValuation Type Destination Loc.
SHNUMOIG_SHNUMCHAR10 OIGSTD shipment numberALPHA
SHITEMOIG_SHITMNUMC4 OIGSIShipment item
ILOCKOIJ_ILOCKCHAR1 Nomination item complete flag
PRORATEQTYOIJ_PRRA_QTYQUAN13(3) Prorated Quantity
ASSIGNEDQTYOIJ_ASSG_QTYQUAN13(3) Assigned Quantity
ACTDATOIJ_ACTDATDATS8 Last item action date
ACTTIMEOIJ_ACTIMETIMS6 Last item action time
ACTUALSOIJ_ACTUALCHAR1 Nomination item partially complete
ACTUALQTYOIJ_ACTQTYQUAN13(3) Actual posted quantity
ACTUALUOMOIJ_ACTUOMUNIT3 T006Actual posted quantity Unit of MeasureCUNIT
ITBOTOLOIJ_BOTOLDEC4(1) Quantity tolerance over (percentage)
ITBUTOLOIJ_BUTOLDEC4(1) Quantity tolerance under (%)
ITBOTOLABSOIJ_TOLABOQUAN13(3) Absolute tolerance qty over
ITBUTOLABSOIJ_TOLABSQUAN13(3) Absolute tolerance qty under
ITTOLUNITOIJ_TOLUOMUNIT3 T006Absolute tolerance UoMCUNIT
UNLIMITEDUEBTKCHAR1 Indicator: Unlimited Overdelivery Allowed
BLOINDOIJ_BLOINDCHAR1 Blocking indicator
DELINDOIJ_DELINDCHAR1 Deletion indicator
UPDATEXDOKOIJ_EXDOKCHAR1 Update external details failure flag
INCOMPLETE_FLAGOIJ_INCOMPLETE_FLAGCHAR1 Incompletion Flag
DOCTYPOIJ_DOCTYPCHAR4 Reference Document Type
LDRATEOIJ_EL_LDRATEQUAN13(3) Planned load/discharge rate
LDQUOMOIJ_EL_LDQUOMUNIT3
*
Planned load/discharge rate quantity UoMCUNIT
LDTUOMOIJ_EL_LDTUOMUNIT3
*
Planned load/discharge rate time UOMCUNIT
THIRD_NOMNROIJ_3RD_NOMNRCHAR20 Partner Nomination number
UPMATUPMATCHAR18
*
Pricing reference material of main itemMATN1
REFITEMOIJ_REF_BOM_ITEMNUMC10
*
Higher-level item in bill of material structures
STLTYSTLTYCHAR1 BOM category

STLKNSTLKNNUMC8 BOM item node number
CHARG_D_CREATEOIJ_CHARG_D_CCHAR1 Destination Batch create new flag
CHARG_O_CREATEOIJ_CHARG_O_CCHAR1 Origin Batch create new flag
CO_CARROIJ_EL_CCACHAR10
*
Connecting carrierALPHA
CO_SHIPOIJ_EL_CSHCHAR10
*
Connecting shipperALPHA
CO_TSYSTOIJ_EL_CTSYSTCHAR10
*
Connecting Transport System
COMMCTLOIJ_NOMCOMMCHAR2 Nomination Communication Control
SOLDTOOIJ_SOLDTOCHAR10 Customer Sold-to or VendorALPHA
PRORATE_ROUTINEOIJ_EL_DE_PR_RTCHAR6 TOIJ_EL_PR_RTProrate Calculation Routine Type
CHARG_LOIJ_CHARGLCHAR10
*
Batch load
CHARG_L_CREATEOIJ_CHARG_L_CCHAR1 Load Batch create new flag
TCNUMOIJ_TCNRCHAR10 TSW :Trading Contract numberALPHA
TCITMOIJ_TCITMNUMC6 TSW: Trading contract item number
GA_NMSHIPPEROIJ_SHIPNRCHAR10
*
ShipperALPHA
GA_CONF_QTYOIJ_CONFQTYQUAN13(3) Confirmed Quantity
GA_CONF_UOMOIJ_CONFUOMUNIT3
*
Unit of Measure for Confirmed Quantity FieldCUNIT
GA_TECHSCH_QTYOIJ_TECHSCHQTYQUAN13(3) Technical Scheduled Quantity Field
GA_TECHSCH_UOMOIJ_TECHSCHUOMUNIT3
*
Unit of Measure for Technical Scheduled Quantity FieldCUNIT
GA_CONF_QTY_CALOIJ_CONFQTY_CALQUAN13(3) Calculated Values of Confirmed Quantity Field
GA_TSCH_QTY_CALOIJ_TECHSCH_QTY_CALQUAN13(3) Calculated Values of Technical Scheduled Quantity Field
GA_ALLOCATED_QTYOIJ_ALLOCATED_QTYQUAN13(3) Allocated Quantity
GA_ALLOCATED_UOMOIJ_ALLOCATED_UOMUNIT3
*
Unit of Measure for Allocated Quantity FieldCUNIT
GA_RANKOIJ_RANKINT13 Rank
CYCLE_ITEMOIJ_ITEMCYCLECHAR10 Nomination Pipeline cycle ID at Item Level
LESSHNUMTKNUMCHAR10 VTTKShipment NumberALPHA
LESTPNUMTPNUMNUMC4 VTTPShipment item
ATL_DELV_NUMBEROIJ_ATL_DELVCHAR10
*
ATL credit check delivery numberALPHA
ATL_DELV_ITMOIJ_ATL_DELV_ITMNUMC6
*
ATL credit check delivery item
ATL_CRDT_QTYOIJ_ATL_CREDIT_QTYQUAN13(3) ATL Credit Quantity
ATL_CRDT_UOMMEINSUNIT3
*
Base Unit of MeasureCUNIT
ATL_CRDT_VALOIJ_ATL_CREDIT_AMTCURR15(2) ATL Credit Amount
ATL_CRDT_CURROIJ_ATL_CREDIT_CURRCUKY5
*
ATL Credit Currency
PRE_EXIST_INDOIJ_ATL_PREEXIST_INDCHAR1 ATL Preexisting Delivery Indicator
.INCLUDEROIJNOMI_A Nomination Item Administration Fields
ERDATERDATDATS8 Date on Which Record Was Created
ERZEITOI0_ERTIMTIMS6 Time of creation
ERNAMERNAMCHAR12 Name of Person who Created the Object
AEDATAEDATDATS8 Changed On
AEZEITOI0_AETIMTIMS6 Time of day the record was changed
AENAMAENAMCHAR12 Name of Person Who Changed Object
.INCLUDEROIJ02_FRGT_NOM Freight Liner Nomination
FLTTNOMTKOIJ_NOMTKCHAR20
*
Nomination (technical) KeyALPHA



Key field
Non-key field