SAP ABAP Table OIJWL (OIL-TSW: Worklist)

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	OIJWL	Table Relationship Diagram
Short Description	OIL-TSW: Worklist

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	WLITEM	☑	OIJ_WLITEM	OIJ_WLITEM	NUMC	10	0	TSW: Worklist item number
3	WLRC	☐	OIJ_WLRC	OIJ_WLRC	CHAR	3	0	TSW: Worklist reason code	OIJWLRCN
4	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
5	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	NOMNR	☐	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
8	NOMTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	OIJNOMH
9	NOMIT	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	OIJNOMI
10	PTSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	*
11	PLOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*
12	DATUM	☐	OIJ_DATUM	DATUM	DATS	8	0	TSW: Date
13	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
14	WARN	☐	OIJ_WARN	CHAR1_X	CHAR	1	0	TSW: Reason code warning indicator
15	DELET	☐	OIJ_DELET	CHAR1_X	CHAR	1	0	TSW: Worklist item deletion indicator
16	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
17	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
18	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
19	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
21	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
22	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
23	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
24	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJWL	LOCID	OIJLOC	LOCID
2	OIJWL	MANDT	T000	MANDT
3	OIJWL	MATNR	MARA	MATNR
4	OIJWL	NOMIT	OIJNOMI	NOMIT
5	OIJWL	NOMTK	OIJNOMH	NOMTK
6	OIJWL	SITYP	TOIJ_EL_SITYPES	SITYP
7	OIJWL	TSYST	OIJTS	TSYST
8	OIJWL	WLRC	OIJWLRCN	WLRC

History

Last changed by/on	SAP	20050224
SAP Release Created in