OIJ_SCHED - Planned Schedule Lines

Planned Schedule Lines information is stored in SAP table OIJ_SCHED.
It is part of development package OIJ in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Traders and Schedulers Workbench".

Fields for table OIJ_SCHED

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SIM_SCHED_ID	TSW: Nomination Simulation ID	X	OIJ_SIMID	CHAR	40
SIM_SCHED_LN	TSW: Nomination Simulation Line item	X	OIJ_SIMLN	NUMC	20
SIM_VERSION	TSW: Simulation Version	X	OIJ_SIMVERS	NUMC	6
SIM_SCHED_TYP	Simulation Schedule category		OIJ_SIM_SCHED_TYP	CHAR	4
SCHED_STAT	TSW: Status of Simulated Schedule line		OIJ_SIMSTAT	CHAR	2
SCHED_ACF	TSW: Flag for automatically created entries		OIJ_SIM_AUTO_CREATE	CHAR	2
NOMTK	Nomination (technical) Key		OIJ_NOMTK	CHAR	40
NOMIT	Nomination Key Item		OIJ_ITEM	NUMC	20
SCHED_COMM	Short comment		OIJ_SIM_SC	CHAR	160
.INCLUDE				ROIJNOMH_R	0
NOMCL	Nomination Class		OIJ_NOMCL	CHAR	4
NOMTYP	Nomination type		OIJ_NOMTYP	CHAR	8	TOIJNOMTYP
BUSTYP	Business type		OIRA_RNBT	CHAR	8	OIRARNBT
NOMNR	Nomination number		OIJ_NOMNR	CHAR	40
NOMST	Nomination header status		OIJ_NOMST	CHAR	2	*
NMSHTYPE	TD shipment type		OIG_TDSTYP	CHAR	8	TOIGS
NMBALCH	Balance check indicator (default)		OIJ_BALCH	CHAR	2
STAGES_ID	GUID in 'CHAR' format with upper-/lowercase (!)		GUID_22	CHAR	44
WORKLIST	Worklist entry indicator		OIJ_WORKLT	CHAR	2
SENTDAT	Last header action date		OIJ_SENDAT	DATS	16
SENTTIME	Last header action time		OIJ_SENTIM	TIMS	12
SENTNAM	Last user who worked on object		OIJ_SENNAM	CHAR	24
ITEMS	Nomination item counter		OIJ_ITEMCOUNTER	NUMC	8
COUNTER1	Nomination planned item Counter		OIJ_PLANNEDITEMS	NUMC	8
COUNTER2	Nomination scheduled Item Counter		OIJ_SCHEDULEDITEMS	NUMC	8
COUNTER3	Nomination rejected Item Counter		OIJ_REJECTEDITEMS	NUMC	8
COUNTER4	Nomination confirmed Item Counter		OIJ_CONFIRMEDITEMS	NUMC	8
COUNTER5	Nomination partially complete Item Counter		OIJ_PARTCOMPLETEITEMS	NUMC	8
COUNTER6	Nomination completed Item Counter		OIJ_COMPLETEDITEMS	NUMC	8
APO_SHIPMENT_ID	GUID in 'CHAR' format with upper-/lowercase (!)		GUID_22	CHAR	44
APO_SHIPMENT_NUM	Shipment Number		TKNUM	CHAR	20
NMBLOCK	Blocking indicator		OIJ_BLOIND	CHAR	2
NOMTYPDESC	IS-Oil: Descriptive text		OI0_TEXT	CHAR	72
SHTYP	Shipment type		SHTYP	CHAR	8	TVTK
TKNUM	Shipment Number		TKNUM	CHAR	20	VTTK
LOV_GL	Gain Loss LOV posting indicator		OIJ03_GLLOVPOST	CHAR	2
NMSELECT	Flag to Set Nomination Selectable		OIJ_NMSELECT	CHAR	2
.INCLUDE				ROIJNOMH_D	0
TSYST	Transport system		OIJ_TSYST	CHAR	20	OIJTS
NMSHIPPER	Shipper		OIJ_SHIPNR	CHAR	20	LFA1
NMCARRIER	Transport system Carrier		OIJ_CARRNR	CHAR	20	LFA1
CYCLE	Nomination Pipeline cycle ID		OIJ_CYCLE	CHAR	20
NMWERK	Transport system In-transit Plant		OIJ_WERK	CHAR	8	T001W
NMLGORT	Transport system In-transit Storage Location		OIJ_LGORT	CHAR	8	T001L
NMVEHICLE	TD Vehicle Number		OIG_VHLNMR	CHAR	20	OIGV
NMVESSEL	TD vehicle identifier		OIG_VEHID	CHAR	36
NMTPLST	Transportation planning point		TPLST	CHAR	8	TTDS
ROUTE	Route		ROUTE	CHAR	12	TVRO
BOOKTS	Book TS indicator		OIJ_BOOKTS	CHAR	2
EV_GROUP	TD - event default group		OIG_EVGRP	CHAR	8
VKTRA	Mode of Transport		VKTRA	CHAR	4	TVTR
QTYIN	Qty received in TS		OIJ_QTYIN	QUAN	7
QTYOUT	Qty delivered from TS		OIJ_QTYOUT	QUAN	7
UNIT	Nomination(pipe) UoM		OIJ_NMUNIT	UNIT	6	*
TST_FROM_MIN	Scheduled / Acceptance / Pipe Batch Start Timestamp		OIJ_SCHED_F	DEC	8
TST_TO_MAX	Scheduled / Acceptance / Pipe Batch End Timestamp		OIJ_SCHED_T	DEC	8
.INCLUDE				ROIJNOMI_R	0
SITYP	Schedule type		OIJ_SITYP	CHAR	4	TOIJ_EL_SITYPES
ISTAT	Nomination Item status		OIJ_ISTAT	CHAR	2	OIJSTAT
ISUBSTAT	Nomination Item sub-status		OIJ_SSTAT	CHAR	2	OIJSUBSTAT
IDATE	Scheduled date		OIJ_IDATE	DATS	16
SCHED_TST_FROM	Scheduled / Acceptance / Pipe Batch Start Timestamp		OIJ_SCHED_F	DEC	8
SCHED_TST_TO	Scheduled / Acceptance / Pipe Batch End Timestamp		OIJ_SCHED_T	DEC	8
LOCID	Location ID		OIJ_LOCID	CHAR	20	OIJLOC
S_MATNR_I	Scheduled material		OIJ_SMATNR	CHAR	80	MARA
MATNR_I	Demand material		OIJ_MATNRI	CHAR	80	MARA
MENGE	Scheduled qty		OIJ_MENGE	QUAN	7
UNIT_I	Scheduled UoM		OIJ_UNITI	UNIT	6	T006
UNIT_I_T	Scheduled UoM Time		OIJ_UNITI_T	UNIT	6	*
DOCIND	Reference document indicator (PSX)		OIJ_DOCIND	CHAR	2
DOCNR	Nomination Reference Document		OIJ_DOCNR	CHAR	20
DOCITM	Nomination Reference Document Item		OIJ_DOCITM	NUMC	12
DOCSCHEDLN	Nomination Reference Document Schedule line		OIJ_DOCSCHEDLN	NUMC	8	*
QTYFCR	First requested quantity		OIJ_QTYFCR	QUAN	7
QTYFCR_UOM	First Requested Quantity UoM		OIJ_QTYFCR_UOM	UNIT	6	*
WORKLIST_I	Worklist entry indicator		OIJ_WORKLT	CHAR	2
TANK	Tankage Partner		OIJ_TANKAGE	CHAR	20
CONS	Consignee Partner		OIJ_CONSIGNEE	CHAR	20
PARTNR	Location Partner		OIJ_PARTNR	CHAR	20
CONPAT	Contract Partner		OIJ_CONPAT	CHAR	20
INSPE	Inspector		OIJ_INSPECTOR	CHAR	20
IMPOEXPO	Import / Export Partner		OIJ_IMEXPO	CHAR	20	LFA1
FLAG_IMEX	Import / Export Partner Indicator		OIJ_IMEXFL	CHAR	4	OIJIMEX
OWNER	Valuation Type		BWTAR_D	CHAR	20	T149D
CHARG_O	Batch origin Location		OIJ_CHARGO	CHAR	20	*
CHARG_D	Batch destination Location		OIJ_CHARGD	CHAR	20	*
RVP	RVP value		OIJ_RVP	DEC	3
VALUATIONTYPE_O	Valuation Type Origin Loc.		OIJ_BWTAR_O	CHAR	20	T149D
VALUATIONTYPE_D	Valuation Type Destination Loc.		OIJ_BWTAR_D	CHAR	20	T149D
SHNUM	TD shipment number		OIG_SHNUM	CHAR	20	OIGS
SHITEM	Shipment item		OIG_SHITM	NUMC	8	OIGSI
ILOCK	Nomination item complete flag		OIJ_ILOCK	CHAR	2
PRORATEQTY	Prorated Quantity		OIJ_PRRA_QTY	QUAN	7
ASSIGNEDQTY	Assigned Quantity		OIJ_ASSG_QTY	QUAN	7
ACTDAT	Last item action date		OIJ_ACTDAT	DATS	16
ACTTIME	Last item action time		OIJ_ACTIME	TIMS	12
ACTUALS	Nomination item partially complete		OIJ_ACTUAL	CHAR	2
ACTUALQTY	Actual posted quantity		OIJ_ACTQTY	QUAN	7
ACTUALUOM	Actual posted quantity Unit of Measure		OIJ_ACTUOM	UNIT	6	T006
ITBOTOL	Quantity tolerance over (percentage)		OIJ_BOTOL	DEC	3
ITBUTOL	Quantity tolerance under (%)		OIJ_BUTOL	DEC	3
ITBOTOLABS	Absolute tolerance qty over		OIJ_TOLABO	QUAN	7
ITBUTOLABS	Absolute tolerance qty under		OIJ_TOLABS	QUAN	7
ITTOLUNIT	Absolute tolerance UoM		OIJ_TOLUOM	UNIT	6	T006
UNLIMITED	Unlimited Overdelivery Allowed		UEBTK	CHAR	2
BLOIND	Blocking indicator		OIJ_BLOIND	CHAR	2
DELIND	Deletion indicator		OIJ_DELIND	CHAR	2
UPDATEXDOK	Update external details failure flag		OIJ_EXDOK	CHAR	2
INCOMPLETE_FLAG	Incompletion Flag		OIJ_INCOMPLETE_FLAG	CHAR	2
DOCTYP	Reference Document Type		OIJ_DOCTYP	CHAR	8
LDRATE	Planned load/discharge rate		OIJ_EL_LDRATE	QUAN	7
LDQUOM	Planned load/discharge rate quantity UoM		OIJ_EL_LDQUOM	UNIT	6	*
LDTUOM	Planned load/discharge rate time UOM		OIJ_EL_LDTUOM	UNIT	6	*
THIRD_NOMNR	Partner Nomination number		OIJ_3RD_NOMNR	CHAR	40
UPMAT	Pricing reference material of main item		UPMAT	CHAR	80	*
REFITEM	Higher-level item in bill of material structures		OIJ_REF_BOM_ITEM	NUMC	20	*
STLTY	BOM category		STLTY	CHAR	2
STLKN	BOM item node number		STLKN	NUMC	16
CHARG_D_CREATE	Destination Batch create new flag		OIJ_CHARG_D_C	CHAR	2
CHARG_O_CREATE	Origin Batch create new flag		OIJ_CHARG_O_C	CHAR	2
CO_CARR	Connecting carrier		OIJ_EL_CCA	CHAR	20	*
CO_SHIP	Connecting shipper		OIJ_EL_CSH	CHAR	20	*
CO_TSYST	Connecting Transport System		OIJ_EL_CTSYST	CHAR	20	*
COMMCTL	Nomination Communication Control		OIJ_NOMCOMM	CHAR	4
SOLDTO	Customer Sold-to or Vendor		OIJ_SOLDTO	CHAR	20
PRORATE_ROUTINE	Prorate Calculation Routine Type		OIJ_EL_DE_PR_RT	CHAR	12	TOIJ_EL_PR_RT
CHARG_L	Batch load		OIJ_CHARGL	CHAR	20	*
CHARG_L_CREATE	Load Batch create new flag		OIJ_CHARG_L_C	CHAR	2
TCNUM	TSW :Trading Contract number		OIJ_TCNR	CHAR	20
TCITM	TSW: Trading contract item number		OIJ_TCITM	NUMC	12
GA_NMSHIPPER	Shipper		OIJ_SHIPNR	CHAR	20	*
GA_CONF_QTY	Confirmed Quantity		OIJ_CONFQTY	QUAN	7
GA_CONF_UOM	Unit of Measure for Confirmed Quantity Field		OIJ_CONFUOM	UNIT	6	*
GA_TECHSCH_QTY	Technical Scheduled Quantity Field		OIJ_TECHSCHQTY	QUAN	7
GA_TECHSCH_UOM	Unit of Measure for Technical Scheduled Quantity Field		OIJ_TECHSCHUOM	UNIT	6	*
GA_CONF_QTY_CAL	Calculated Values of Confirmed Quantity Field		OIJ_CONFQTY_CAL	QUAN	7
GA_TSCH_QTY_CAL	Calculated Values of Technical Scheduled Quantity Field		OIJ_TECHSCH_QTY_CAL	QUAN	7
GA_ALLOCATED_QTY	Allocated Quantity		OIJ_ALLOCATED_QTY	QUAN	7
GA_ALLOCATED_UOM	Unit of Measure for Allocated Quantity Field		OIJ_ALLOCATED_UOM	UNIT	6	*
GA_RANK	Rank		OIJ_RANK	INT1	1
CYCLE_ITEM	Nomination Pipeline cycle ID at Item Level		OIJ_ITEMCYCLE	CHAR	20
LESSHNUM	Shipment Number		TKNUM	CHAR	20	VTTK
LESTPNUM	Shipment item		TPNUM	NUMC	8	VTTP
ATL_DELV_NUMBER	ATL credit check delivery number		OIJ_ATL_DELV	CHAR	20
ATL_DELV_ITM	ATL credit check delivery item		OIJ_ATL_DELV_ITM	NUMC	12
ATL_CRDT_QTY	ATL Credit Quantity		OIJ_ATL_CREDIT_QTY	QUAN	7
ATL_CRDT_UOM	Base Unit of Measure		MEINS	UNIT	6	*
ATL_CRDT_VAL	ATL Credit Amount		OIJ_ATL_CREDIT_AMT	CURR	8
ATL_CRDT_CURR	ATL Credit Currency		OIJ_ATL_CREDIT_CURR	CUKY	10	*
PRE_EXIST_IND	ATL Preexisting Delivery Indicator		OIJ_ATL_PREEXIST_IND	CHAR	2
.INCLUDE				ROIJNOMI_A	0
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERZEIT	Time of creation		OI0_ERTIM	TIMS	12
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
AEDAT	Last Changed On		AEDAT	DATS	16
AEZEIT	Time of day the record was changed		OI0_AETIM	TIMS	12
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24
.INCLUDE				ROIJ02_FRGT_NOM	0
FLTTNOMTK	Nomination (technical) Key		OIJ_NOMTK	CHAR	40
.INCLUDE				OIJ05_SIM	0
UPDKZ	Update indicator		UPDKZ_D	CHAR	2
USER_ID	User ID		OIJ05_USERID	CHAR	30
SCENARIO_ID	Scenario ID		OIJ05_SCNID	CHAR	30
IPW_TXT	NPW/IPW: User comment / text		OIJ05_IPWTXT	CHAR	2048
LOC_PT	Location Partner Plant		OIJ_LOCPT	CHAR	8	*
LOC_SL	Location Partner Storage Location		OIJ_LOCSL	CHAR	8	*
QUICKCONF	Quick Confirm check box		OIJ_QC	CHAR	2
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16
.INCLUDE				DEMAND_NOM_SCHED_INCL_EEW_PS	0
DUMMY_DNOM_SCHED_INCL_EEW_PS	Data Element for Extension Fields: Sample		OIJ09_SCHDASST_EXTN	NUMC	20