SAP ABAP Table OIJ_SCHED (Planned Schedule Lines)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIJ_SCHED	Table Relationship Diagram
Short Description	Planned Schedule Lines

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SIM_SCHED_ID	☑	OIJ_SIMID	OIJ_NOMTK	CHAR	20	0	TSW: Nomination Simulation ID	*
3	SIM_SCHED_LN	☑	OIJ_SIMLN	OIJ_ITEMNO	NUMC	10	0	TSW: Nomination Simulation Line item
4	SIM_VERSION	☑	OIJ_SIMVERS	OIJ_SIMVERS	NUMC	3	0	TSW: Simulation Version
5	SIM_SCHED_TYP	☐	OIJ_SIM_SCHED_TYP	OIJ_SIM_SCHED_TYP	CHAR	2	0	Simulation Schedule category
6	SCHED_STAT	☐	OIJ_SIMSTAT	OIJ_SIMSTAT	CHAR	1	0	TSW: Status of Simulated Schedule line
7	SCHED_ACF	☐	OIJ_SIM_AUTO_CREATE	XFLAG	CHAR	1	0	TSW: Flag for automatically created entries
8	NOMTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	*
9	NOMIT	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	*
10	SCHED_COMM	☐	OIJ_SIM_SC	CHAR80	CHAR	80	0	Short comment
11	.INCLUDE	☐				0	0	Nomination Header Basic Fields
12	NOMCL	☐	OIJ_NOMCL	OIJ_NOMCL	CHAR	2	0	Nomination Class
13	NOMTYP	☐	OIJ_NOMTYP	OIJ_NOMTYP	CHAR	4	0	Nomination type	TOIJNOMTYP
14	BUSTYP	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
15	NOMNR	☐	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
16	NOMST	☐	OIJ_NOMST	OIJ_ISTAT	CHAR	1	0	Nomination header status	*
17	NMSHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	TOIGS
18	NMBALCH	☐	OIJ_BALCH	XFELD	CHAR	1	0	Balance check indicator (default)
19	STAGES_ID	☐	GUID_22	SYSUUID_22	CHAR	22	0	GUID in 'CHAR' format with upper-/lowercase (!)
20	WORKLIST	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
21	SENTDAT	☐	OIJ_SENDAT	DATUM	DATS	8	0	Last header action date
22	SENTTIME	☐	OIJ_SENTIM	UZEIT	TIMS	6	0	Last header action time
23	SENTNAM	☐	OIJ_SENNAM	USNAM	CHAR	12	0	Last user who worked on object
24	ITEMS	☐	OIJ_ITEMCOUNTER	NUM04	NUMC	4	0	Nomination item counter
25	COUNTER1	☐	OIJ_PLANNEDITEMS	NUM04	NUMC	4	0	Nomination planned item Counter
26	COUNTER2	☐	OIJ_SCHEDULEDITEMS	NUM04	NUMC	4	0	Nomination scheduled Item Counter
27	COUNTER3	☐	OIJ_REJECTEDITEMS	NUM04	NUMC	4	0	Nomination rejected Item Counter
28	COUNTER4	☐	OIJ_CONFIRMEDITEMS	NUM04	NUMC	4	0	Nomination confirmed Item Counter
29	COUNTER5	☐	OIJ_PARTCOMPLETEITEMS	NUM04	NUMC	4	0	Nomination partially complete Item Counter
30	COUNTER6	☐	OIJ_COMPLETEDITEMS	NUM04	NUMC	4	0	Nomination completed Item Counter
31	APO_SHIPMENT_ID	☐	GUID_22	SYSUUID_22	CHAR	22	0	GUID in 'CHAR' format with upper-/lowercase (!)
32	APO_SHIPMENT_NUM	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
33	NMBLOCK	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
34	.INCLUDE	☐				0	0	Nomination Header Default Fields
35	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
36	NMSHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	LFA1
37	NMCARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	LFA1
38	CYCLE	☐	OIJ_CYCLE	CHAR10	CHAR	10	0	Nomination Pipeline cycle ID
39	NMWERK	☐	OIJ_WERK	WERKS	CHAR	4	0	Transport system In-transit Plant	T001W
40	NMLGORT	☐	OIJ_LGORT	LGORT	CHAR	4	0	Transport system In-transit Storage Location	T001L
41	NMVEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
42	NMVESSEL	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
43	NMTPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
44	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
45	BOOKTS	☐	OIJ_BOOKTS	XFELD	CHAR	1	0	Book TS indicator
46	EV_GROUP	☐	OIG_EVGRP	OIG_EVGRP	CHAR	4	0	TD - event default group
47	VKTRA	☐	VKTRA	VKTRA	CHAR	2	0	Mode of transport	TVTR
48	QTYIN	☐	OIJ_QTYIN	MENG13	QUAN	13	3	Qty received in TS
49	QTYOUT	☐	OIJ_QTYOUT	MENG13	QUAN	13	3	Qty delivered from TS
50	UNIT	☐	OIJ_NMUNIT	MEINS	UNIT	3	0	Nomination(pipe) UoM	*
51	TST_FROM_MIN	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
52	TST_TO_MAX	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
53	.INCLUDE	☐				0	0	Nomination Item Required Fields
54	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
55	ISTAT	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	OIJSTAT
56	ISUBSTAT	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	OIJSUBSTAT
57	IDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
58	SCHED_TST_FROM	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
59	SCHED_TST_TO	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
60	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
61	S_MATNR_I	☐	OIJ_SMATNR	MATNR	CHAR	18	0	Scheduled material	MARA
62	MATNR_I	☐	OIJ_MATNRI	MATNR	CHAR	18	0	Demand material	MARA
63	MENGE	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
64	UNIT_I	☐	OIJ_UNITI	MEINS	UNIT	3	0	Scheduled UoM	T006
65	UNIT_I_T	☐	OIJ_UNITI_T	MEINS	UNIT	3	0	Scheduled UoM Time	*
66	DOCIND	☐	OIJ_DOCIND	OIJ_DOCIND	CHAR	1	0	Reference document indicator (PSX)
67	DOCNR	☐	OIJ_DOCNR	OIJ_DOCNR	CHAR	10	0	Nomination Reference Document
68	DOCITM	☐	OIJ_DOCITM	NUM06	NUMC	6	0	Nomination Reference Document Item
69	DOCSCHEDLN	☐	OIJ_DOCSCHEDLN	EETEN	NUMC	4	0	Nomination Reference Document Schedule line	*
70	QTYFCR	☐	OIJ_QTYFCR	MENG13	QUAN	13	3	First requested quantity
71	QTYFCR_UOM	☐	OIJ_QTYFCR_UOM	MEINS	UNIT	3	0	First Requested Quantity UoM	*
72	WORKLIST_I	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
73	TANK	☐	OIJ_TANKAGE	OIJ_PARTNR	CHAR	10	0	Tankage Partner
74	CONS	☐	OIJ_CONSIGNEE	OIJ_PARTNR	CHAR	10	0	Consignee Partner
75	PARTNR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
76	CONPAT	☐	OIJ_CONPAT	OIJ_PARTNR	CHAR	10	0	Contract Partner
77	INSPE	☐	OIJ_INSPECTOR	OIJ_PARTNR	CHAR	10	0	Inspector
78	IMPOEXPO	☐	OIJ_IMEXPO	LIFNR	CHAR	10	0	Import / Export Partner	LFA1
79	FLAG_IMEX	☐	OIJ_IMEXFL	OIJ_IMEXFL	CHAR	2	0	Import / Export Partner Indicator	OIJIMEX
80	OWNER	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
81	CHARG_O	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location	*
82	CHARG_D	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location	*
83	RVP	☐	OIJ_RVP	DEC2_1	DEC	3	1	RVP value
84	VALUATIONTYPE_O	☐	OIJ_BWTAR_O	BWTAR	CHAR	10	0	Valuation Type Origin Loc.	T149D
85	VALUATIONTYPE_D	☐	OIJ_BWTAR_D	BWTAR	CHAR	10	0	Valuation Type Destination Loc.	T149D
86	SHNUM	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
87	SHITEM	☐	OIG_SHITM	OIG_SHITM	NUMC	4	0	Shipment item	OIGSI
88	ILOCK	☐	OIJ_ILOCK	XFELD	CHAR	1	0	Nomination item complete flag
89	PRORATEQTY	☐	OIJ_PRRA_QTY	MENG13	QUAN	13	3	Prorated Quantity
90	ASSIGNEDQTY	☐	OIJ_ASSG_QTY	MENG13	QUAN	13	3	Assigned Quantity
91	ACTDAT	☐	OIJ_ACTDAT	DATUM	DATS	8	0	Last item action date
92	ACTTIME	☐	OIJ_ACTIME	UZEIT	TIMS	6	0	Last item action time
93	ACTUALS	☐	OIJ_ACTUAL	XFELD	CHAR	1	0	Nomination item partially complete
94	ACTUALQTY	☐	OIJ_ACTQTY	MENG13	QUAN	13	3	Actual posted quantity
95	ACTUALUOM	☐	OIJ_ACTUOM	MEINS	UNIT	3	0	Actual posted quantity Unit of Measure	T006
96	ITBOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
97	ITBUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
98	ITBOTOLABS	☐	OIJ_TOLABO	MENG13	QUAN	13	3	Absolute tolerance qty over
99	ITBUTOLABS	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
100	ITTOLUNIT	☐	OIJ_TOLUOM	MEINS	UNIT	3	0	Absolute tolerance UoM	T006
101	UNLIMITED	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
102	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
103	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
104	UPDATEXDOK	☐	OIJ_EXDOK	FLAG	CHAR	1	0	Update external details failure flag
105	INCOMPLETE_FLAG	☐	OIJ_INCOMPLETE_FLAG	OIJ_INCOMPLETE_FLAG	CHAR	1	0	Incompletion Flag
106	DOCTYP	☐	OIJ_DOCTYP	CHAR04	CHAR	4	0	Reference Document Type
107	LDRATE	☐	OIJ_EL_LDRATE	MENG13	QUAN	13	3	Planned load/discharge rate
108	LDQUOM	☐	OIJ_EL_LDQUOM	MEINS	UNIT	3	0	Planned load/discharge rate quantity UoM	*
109	LDTUOM	☐	OIJ_EL_LDTUOM	MEINS	UNIT	3	0	Planned load/discharge rate time UOM	*
110	THIRD_NOMNR	☐	OIJ_3RD_NOMNR	OIJ_NOMNR	CHAR	20	0	Partner Nomination number
111	UPMAT	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item	*
112	REFITEM	☐	OIJ_REF_BOM_ITEM	OIJ_ITEM	NUMC	10	0	Higher-level item in bill of material structures	*
113	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
114	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
115	CHARG_D_CREATE	☐	OIJ_CHARG_D_C	XFELD	CHAR	1	0	Destination Batch create new flag
116	CHARG_O_CREATE	☐	OIJ_CHARG_O_C	XFELD	CHAR	1	0	Origin Batch create new flag
117	CO_CARR	☐	OIJ_EL_CCA	LIFNR	CHAR	10	0	Connecting carrier	*
118	CO_SHIP	☐	OIJ_EL_CSH	LIFNR	CHAR	10	0	Connecting shipper	*
119	CO_TSYST	☐	OIJ_EL_CTSYST	OIJ_TSYST	CHAR	10	0	Connecting Transport System	*
120	COMMCTL	☐	OIJ_NOMCOMM	OIJ_NOMCOMM	CHAR	2	0	Nomination Communication Control
121	SOLDTO	☐	OIJ_SOLDTO	OIJ_SOLDTO	CHAR	10	0	Customer Sold-to or Vendor
122	PRORATE_ROUTINE	☐	OIJ_EL_DE_PR_RT	OIJ_EL_DM_PR_RT	CHAR	6	0	Prorate Calculation Routine Type	TOIJ_EL_PR_RT
123	CHARG_L	☐	OIJ_CHARGL	CHARG	CHAR	10	0	Batch load	*
124	CHARG_L_CREATE	☐	OIJ_CHARG_L_C	XFELD	CHAR	1	0	Load Batch create new flag
125	.INCLUDE	☐				0	0	Nomination Item Administration Fields
126	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
127	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
128	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
129	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
130	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
131	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJ_SCHED	ACTUALUOM	T006	MSEHI
2	OIJ_SCHED	BUSTYP	OIRARNBT	RNBT
3	OIJ_SCHED	FLAG_IMEX	OIJIMEX	FLAG_IMEX
4	OIJ_SCHED	IMPOEXPO	LFA1	LIFNR
5	OIJ_SCHED	ISTAT	OIJSTAT	STATUS
6	OIJ_SCHED	ISUBSTAT	OIJSUBSTAT	SUBSTATUS
7	OIJ_SCHED	ITTOLUNIT	T006	MSEHI
8	OIJ_SCHED	LOCID	OIJLOC	LOCID
9	OIJ_SCHED	MANDT	T000	MANDT	KEY	1	CN
10	OIJ_SCHED	MATNR_I	MARA	MATNR
11	OIJ_SCHED	NMCARRIER	LFA1	LIFNR
12	OIJ_SCHED	NMLGORT	T001L	LGORT
13	OIJ_SCHED	NMSHIPPER	LFA1	LIFNR
14	OIJ_SCHED	NMSHTYPE	TOIGS	SHTYP
15	OIJ_SCHED	NMTPLST	TTDS	TPLST
16	OIJ_SCHED	NMVEHICLE	OIGV	VEHICLE
17	OIJ_SCHED	NMWERK	T001W	WERKS
18	OIJ_SCHED	NOMTYP	TOIJNOMTYP	NOMTYP
19	OIJ_SCHED	OWNER	T149D	BWTAR
20	OIJ_SCHED	PRORATE_ROUTINE	TOIJ_EL_PR_RT	PRORATE_ROUTINE	REF
21	OIJ_SCHED	ROUTE	TVRO	ROUTE
22	OIJ_SCHED	SHITEM	OIGSI	SHITEM
23	OIJ_SCHED	SHNUM	OIGS	SHNUMBER
24	OIJ_SCHED	SITYP	TOIJ_EL_SITYPES	SITYP
25	OIJ_SCHED	S_MATNR_I	MARA	MATNR
26	OIJ_SCHED	TSYST	OIJTS	TSYST
27	OIJ_SCHED	UNIT_I	T006	MSEHI
28	OIJ_SCHED	VALUATIONTYPE_D	T149D	BWTAR
29	OIJ_SCHED	VALUATIONTYPE_O	T149D	BWTAR
30	OIJ_SCHED	VKTRA	TVTR	VKTRA

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C