SAP ABAP Table ROIJNOMIVERS_VB (Nomination Item Version DB Update structure)

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	INTTAB	Structure
Structure	ROIJNOMIVERS_VB	Table Relationship Diagram
Short Description	Nomination Item Version DB Update structure

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

History

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