SAP ABAP Table OIJNOMC (OIL-TSW: Nomination copy table)

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	OIJNOMC	Table Relationship Diagram
Short Description	OIL-TSW: Nomination copy table

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	NOMTK	☑	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	OIJNOMH
3	NOMIT	☑	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	OIJNOMI
4	.INCLUDE	☐				0	0	Nomination Item Required Fields
5	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
6	ISTAT	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	OIJSTAT
7	ISUBSTAT	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	OIJSUBSTAT
8	IDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
9	SCHED_TST_FROM	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
10	SCHED_TST_TO	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
11	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
12	S_MATNR_I	☐	OIJ_SMATNR	MATNR	CHAR	18	0	Scheduled material	MARA
13	MATNR_I	☐	OIJ_MATNRI	MATNR	CHAR	18	0	Demand material	MARA
14	MENGE	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
15	UNIT_I	☐	OIJ_UNITI	MEINS	UNIT	3	0	Scheduled UoM	T006
16	UNIT_I_T	☐	OIJ_UNITI_T	MEINS	UNIT	3	0	Scheduled UoM Time	*
17	DOCIND	☐	OIJ_DOCIND	OIJ_DOCIND	CHAR	1	0	Reference document indicator (PSX)
18	DOCNR	☐	OIJ_DOCNR	OIJ_DOCNR	CHAR	10	0	Nomination Reference Document
19	DOCITM	☐	OIJ_DOCITM	NUM06	NUMC	6	0	Nomination Reference Document Item
20	DOCSCHEDLN	☐	OIJ_DOCSCHEDLN	EETEN	NUMC	4	0	Nomination Reference Document Schedule line	*
21	QTYFCR	☐	OIJ_QTYFCR	MENG13	QUAN	13	3	First requested quantity
22	QTYFCR_UOM	☐	OIJ_QTYFCR_UOM	MEINS	UNIT	3	0	First Requested Quantity UoM	*
23	WORKLIST_I	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
24	TANK	☐	OIJ_TANKAGE	OIJ_PARTNR	CHAR	10	0	Tankage Partner
25	CONS	☐	OIJ_CONSIGNEE	OIJ_PARTNR	CHAR	10	0	Consignee Partner
26	PARTNR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
27	CONPAT	☐	OIJ_CONPAT	OIJ_PARTNR	CHAR	10	0	Contract Partner
28	INSPE	☐	OIJ_INSPECTOR	OIJ_PARTNR	CHAR	10	0	Inspector
29	IMPOEXPO	☐	OIJ_IMEXPO	LIFNR	CHAR	10	0	Import / Export Partner	LFA1
30	FLAG_IMEX	☐	OIJ_IMEXFL	OIJ_IMEXFL	CHAR	2	0	Import / Export Partner Indicator	OIJIMEX
31	OWNER	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
32	CHARG_O	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location	MCH1
33	CHARG_D	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location	MCH1
34	RVP	☐	OIJ_RVP	DEC2_1	DEC	3	1	RVP value
35	VALUATIONTYPE_O	☐	OIJ_BWTAR_O	BWTAR	CHAR	10	0	Valuation Type Origin Loc.	T149D
36	VALUATIONTYPE_D	☐	OIJ_BWTAR_D	BWTAR	CHAR	10	0	Valuation Type Destination Loc.	T149D
37	SHNUM	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
38	SHITEM	☐	OIG_SHITM	OIG_SHITM	NUMC	4	0	Shipment item	OIGSI
39	ILOCK	☐	OIJ_ILOCK	XFELD	CHAR	1	0	Nomination item complete flag
40	PRORATEQTY	☐	OIJ_PRRA_QTY	MENG13	QUAN	13	3	Prorated Quantity
41	ASSIGNEDQTY	☐	OIJ_ASSG_QTY	MENG13	QUAN	13	3	Assigned Quantity
42	ACTDAT	☐	OIJ_ACTDAT	DATUM	DATS	8	0	Last item action date
43	ACTTIME	☐	OIJ_ACTIME	UZEIT	TIMS	6	0	Last item action time
44	ACTUALS	☐	OIJ_ACTUAL	XFELD	CHAR	1	0	Nomination item partially complete
45	ACTUALQTY	☐	OIJ_ACTQTY	MENG13	QUAN	13	3	Actual posted quantity
46	ACTUALUOM	☐	OIJ_ACTUOM	MEINS	UNIT	3	0	Actual posted quantity Unit of Measure	T006
47	ITBOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
48	ITBUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
49	ITBOTOLABS	☐	OIJ_TOLABO	MENG13	QUAN	13	3	Absolute tolerance qty over
50	ITBUTOLABS	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
51	ITTOLUNIT	☐	OIJ_TOLUOM	MEINS	UNIT	3	0	Absolute tolerance UoM	T006
52	UNLIMITED	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
53	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
54	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
55	UPDATEXDOK	☐	OIJ_EXDOK	FLAG	CHAR	1	0	Update external details failure flag
56	INCOMPLETE_FLAG	☐	OIJ_INCOMPLETE_FLAG	OIJ_INCOMPLETE_FLAG	CHAR	1	0	Incompletion Flag
57	DOCTYP	☐	OIJ_DOCTYP	CHAR04	CHAR	4	0	Reference Document Type
58	LDRATE	☐	OIJ_EL_LDRATE	MENG13	QUAN	13	3	Planned load/discharge rate
59	LDQUOM	☐	OIJ_EL_LDQUOM	MEINS	UNIT	3	0	Planned load/discharge rate quantity UoM	*
60	LDTUOM	☐	OIJ_EL_LDTUOM	MEINS	UNIT	3	0	Planned load/discharge rate time UOM	*
61	THIRD_NOMNR	☐	OIJ_3RD_NOMNR	OIJ_NOMNR	CHAR	20	0	Partner Nomination number
62	UPMAT	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item	*
63	REFITEM	☐	OIJ_REF_BOM_ITEM	OIJ_ITEM	NUMC	10	0	Higher-level item in bill of material structures	*
64	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
65	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
66	CHARG_D_CREATE	☐	OIJ_CHARG_D_C	XFELD	CHAR	1	0	Destination Batch create new flag
67	CHARG_O_CREATE	☐	OIJ_CHARG_O_C	XFELD	CHAR	1	0	Origin Batch create new flag
68	CO_CARR	☐	OIJ_EL_CCA	LIFNR	CHAR	10	0	Connecting carrier	*
69	CO_SHIP	☐	OIJ_EL_CSH	LIFNR	CHAR	10	0	Connecting shipper	*
70	CO_TSYST	☐	OIJ_EL_CTSYST	OIJ_TSYST	CHAR	10	0	Connecting Transport System	*
71	COMMCTL	☐	OIJ_NOMCOMM	OIJ_NOMCOMM	CHAR	2	0	Nomination Communication Control
72	SOLDTO	☐	OIJ_SOLDTO	OIJ_SOLDTO	CHAR	10	0	Customer Sold-to or Vendor
73	PRORATE_ROUTINE	☐	OIJ_EL_DE_PR_RT	OIJ_EL_DM_PR_RT	CHAR	6	0	Prorate Calculation Routine Type	TOIJ_EL_PR_RT
74	CHARG_L	☐	OIJ_CHARGL	CHARG	CHAR	10	0	Batch load	*
75	CHARG_L_CREATE	☐	OIJ_CHARG_L_C	XFELD	CHAR	1	0	Load Batch create new flag
76	.INCLUDE	☐				0	0	Nomination Item Control Fields
77	PLANIND	☐	OIJ_PLANIN	XFELD	CHAR	1	0	Planning location flag
78	LOCPT	☐	OIJ_LOCPT	WERKS	CHAR	4	0	Location Partner Plant	T001W
79	LOCSL	☐	OIJ_LOCSL	LGORT	CHAR	4	0	Location Partner Storage Location	T001L
80	QUICKCONF	☐	OIJ_QC	FLAG	CHAR	1	0	Quick Confirm check box
81	.INCLUDE	☐				0	0	Nomination Item Administration Fields
82	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
83	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
84	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
85	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
86	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
87	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
88	.INCLUDE	☐				0	0	Nomination Item O Fields
89	LOCNAM	☐	OIJ_LOCNAM	OIJ_LOCNAM	CHAR	60	0	Location name (used by system owner)
90	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
91	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJNOMC	ACTUALUOM	T006	MSEHI	KEY	1	CN
2	OIJNOMC	CHARG_D	MCH1	CHARG	KEY	1	CN
3	OIJNOMC	CHARG_O	MCH1	CHARG	KEY	1	CN
4	OIJNOMC	FLAG_IMEX	OIJIMEX	FLAG_IMEX	KEY	1	CN
5	OIJNOMC	IMPOEXPO	LFA1	LIFNR	KEY	1	CN
6	OIJNOMC	ISTAT	OIJSTAT	STATUS	KEY	1	CN
7	OIJNOMC	ISUBSTAT	OIJSUBSTAT	SUBSTATUS	KEY	1	CN
8	OIJNOMC	ITTOLUNIT	T006	MSEHI	KEY	1	CN
9	OIJNOMC	LOCID	OIJLOC	LOCID	KEY	1	CN
10	OIJNOMC	LOCPT	T001W	WERKS	KEY	1	CN
11	OIJNOMC	LOCSL	T001L	LGORT	KEY	1	CN
12	OIJNOMC	MANDT	T000	MANDT	KEY	1	CN
13	OIJNOMC	MATNR_I	MARA	MATNR	KEY	1	CN
14	OIJNOMC	NOMIT	OIJNOMI	NOMIT	KEY	1	CN
15	OIJNOMC	NOMTK	OIJNOMH	NOMTK	KEY	1	CN
16	OIJNOMC	OWNER	T149D	BWTAR	KEY	1	CN
17	OIJNOMC	POSNR	VBUP	POSNR	KEY	1	CN
18	OIJNOMC	PRORATE_ROUTINE	TOIJ_EL_PR_RT	PRORATE_ROUTINE	REF
19	OIJNOMC	SHITEM	OIGSI	SHITEM	KEY	1	CN
20	OIJNOMC	SHNUM	OIGS	SHNUMBER	KEY	1	CN
21	OIJNOMC	SITYP	TOIJ_EL_SITYPES	SITYP
22	OIJNOMC	S_MATNR_I	MARA	MATNR	KEY	1	CN
23	OIJNOMC	UNIT_I	T006	MSEHI	KEY	1	CN
24	OIJNOMC	VALUATIONTYPE_D	T149D	BWTAR
25	OIJNOMC	VALUATIONTYPE_O	T149D	BWTAR
26	OIJNOMC	VBELN	VBUK	VBELN	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in