SAP ABAP Table OIJ_EL_ETS_NOMI (APO-TSW: Nomination Item Structure for ETS-Communication)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ_EL (Package) TSW Trader's and Scheduler's Workbench - Execution Layer

Basic Data

Table Category	INTTAB	Structure
Structure	OIJ_EL_ETS_NOMI	Table Relationship Diagram
Short Description	APO-TSW: Nomination Item Structure for ETS-Communication

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	TSW Nomination Item Data
2	NOMINATIONNUMBER_SAP	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	OIJNOMH
3	ITEMNUMBER	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	OIJNOMI
4	ITEMTYPE	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
5	ITEMSTATUS	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	OIJSTAT
6	ITEMSUBSTATUS	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	*
7	SCHEDULEDDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
8	LOCATIONID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
9	PLANNINGLOCATIONINDICATOR	☐	OIJ_PLANIN	XFELD	CHAR	1	0	Planning location flag
10	LOCATIONPLANT	☐	OIJ_LOCPT	WERKS	CHAR	4	0	Location Partner Plant	T001W
11	LOCATIONSTORAGELOCATION	☐	OIJ_LOCSL	LGORT	CHAR	4	0	Location Partner Storage Location	T001L
12	DEMANDMATERIAL	☐	OIJ_MATNRI	MATNR	CHAR	18	0	Demand material	MARA
13	SCHEDULEMATERIAL	☐	OIJ_SMATNR	MATNR	CHAR	18	0	Scheduled material	MARA
14	NOMINATEDQUANTITY	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
15	QUANTITYUNIT_SAP	☐	OIJ_UNITI	MEINS	UNIT	3	0	Scheduled UoM	T006
16	QUANTITYUNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
17	DOCUMENTINDICATOR	☐	OIJ_DOCIND	OIJ_DOCIND	CHAR	1	0	Reference document indicator (PSX)
18	DOCUMENTNUMBER	☐	OIJ_DOCNR	OIJ_DOCNR	CHAR	10	0	Nomination Reference Document
19	DOCUMENTTYPE	☐	OIJ_DOCTYP	CHAR04	CHAR	4	0	Reference Document Type
20	DOCUMENTITEM	☐	OIJ_DOCITM	NUM06	NUMC	6	0	Nomination Reference Document Item
21	DOCUMENTSCHEDULELINE	☐	OIJ_DOCSCHEDLN	EETEN	NUMC	4	0	Nomination Reference Document Schedule line	*
22	WORKLISTINDICATOR	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
23	TANKAGE	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
24	CONSIGNEE	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
25	LOCATIONPARTNER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
26	CONTRACTPARTNER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
27	INSPECTOR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
28	IMPORTEREXPORTER	☐	OIJ_IMEXPO	LIFNR	CHAR	10	0	Import / Export Partner	LFA1
29	IMPORTEREXPORTERFLAG	☐	OIJ_IMEXFL	OIJ_IMEXFL	CHAR	2	0	Import / Export Partner Indicator	*
30	BATCHORIGIN	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location	*
31	VALUATIONTYPEORIGIN	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
32	BATCHDESTINATION	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location	*
33	VALUATIONTYPEDESTINATION	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
34	BATCHDESTINATIONCREATE	☐	OIJ_CHARG_D_C	XFELD	CHAR	1	0	Destination Batch create new flag
35	BATCHATLOADING	☐	OIJ_CHARGL	CHARG	CHAR	10	0	Batch load	*
36	BATCHATLOADINGCREATE	☐	OIJ_CHARG_L_C	XFELD	CHAR	1	0	Load Batch create new flag
37	REEDVAPOURPRESSURE	☐	OIJ_RVP	DEC2_1	DEC	3	1	RVP value
38	SHIPMENTNUMBER	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
39	SHIPMENTITEM	☐	OIG_SHITM	OIG_SHITM	NUMC	4	0	Shipment item	OIGSI
40	ITEMPARTCOMPLETEFLAG	☐	OIJ_ACTUAL	XFELD	CHAR	1	0	Nomination item partially complete
41	ITEMCOMPLETEFLAG	☐	OIJ_ILOCK	XFELD	CHAR	1	0	Nomination item complete flag
42	ACTUALQUANTITY	☐	OIJ_ACTQTY	MENG13	QUAN	13	3	Actual posted quantity
43	ACTUALQUANTITYUNIT_SAP	☐	OIJ_ACTUOM	MEINS	UNIT	3	0	Actual posted quantity Unit of Measure	*
44	ACTUALQUANTITYUNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
45	LASTITEMACTION	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
46	OVERTOLERANCEPERCT	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
47	UNDERTOLERANCEPERCT	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
48	OVERTOLERANCEABSOLUTE	☐	OIJ_TOLABO	MENG13	QUAN	13	3	Absolute tolerance qty over
49	UNDERTOLERANCEABSOLUTE	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
50	TOLERANCEUNIT_SAP	☐	OIJ_TOLUOM	MEINS	UNIT	3	0	Absolute tolerance UoM	T006
51	TOLERANCEUNIT_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
52	UNLIMITEDTOLERANCE	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
53	CREATION	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
54	CREATEDBY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
55	MODIFICATION	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
56	CHANGEDBY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
57	AUTOCONFIRM	☐	OIJ_CHANGE	XFELD	CHAR	1	0	OIL-TSW: Change item indicator
58	BLOCKINGINDICATOR	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
59	DELETIONINDICATOR	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
60	INCOMPLETE_FLAG	☐	OIJ_INCOMPLETE_FLAG	OIJ_INCOMPLETE_FLAG	CHAR	1	0	Incompletion Flag
61	NOMINATIONSCHEDULEDATEFROM	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
62	NOMINATIONSCHEDULEDATETO	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
63	SCH_STARTDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
64	SCH_STARTTIME	☐	OIJ_EL_ST_TIME		TIMS	6	0	APO-TSW: Start time
65	SCH_ENDDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
66	SCH_ENDTTIME	☐	OIJ_EL_END_TIME		TIMS	6	0	APO-TSW: End Time
67	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJ_EL_ETS_NOMI	DEMANDMATERIAL	MARA	MATNR
2	OIJ_EL_ETS_NOMI	IMPORTEREXPORTER	LFA1	LIFNR
3	OIJ_EL_ETS_NOMI	ITEMNUMBER	OIJNOMI	NOMIT
4	OIJ_EL_ETS_NOMI	ITEMSTATUS	OIJSTAT	STATUS
5	OIJ_EL_ETS_NOMI	ITEMTYPE	TOIJ_EL_SITYPES	SITYP
6	OIJ_EL_ETS_NOMI	LOCATIONID	OIJLOC	LOCID
7	OIJ_EL_ETS_NOMI	LOCATIONPLANT	T001W	WERKS
8	OIJ_EL_ETS_NOMI	LOCATIONSTORAGELOCATION	T001L	LGORT
9	OIJ_EL_ETS_NOMI	NOMINATIONNUMBER_SAP	OIJNOMH	NOMTK
10	OIJ_EL_ETS_NOMI	QUANTITYUNIT_SAP	T006	MSEHI
11	OIJ_EL_ETS_NOMI	SCHEDULEMATERIAL	MARA	MATNR
12	OIJ_EL_ETS_NOMI	SHIPMENTITEM	OIGSI	SHITEM
13	OIJ_EL_ETS_NOMI	SHIPMENTNUMBER	OIGS	SHNUMBER
14	OIJ_EL_ETS_NOMI	TOLERANCEUNIT_SAP	T006	MSEHI
15	OIJ_EL_ETS_NOMI	VALUATIONTYPEDESTINATION	T149D	BWTAR
16	OIJ_EL_ETS_NOMI	VALUATIONTYPEORIGIN	T149D	BWTAR

History

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