SAP ABAP Table V_OIJNMHI (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OIJNMHI	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	NOMTK	☑	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key
3	NOMNR	☑	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
4	NOMIT	☑	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item
5	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system
6	NMSHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper
7	NMCARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier
8	CYCLE	☐	OIJ_CYCLE	CHAR10	CHAR	10	0	Nomination Pipeline cycle ID
9	NOMST	☐	OIJ_NOMST	OIJ_ISTAT	CHAR	1	0	Nomination header status	OIJSTAT
10	QTYIN	☐	OIJ_QTYIN	MENG13	QUAN	13	3	Qty received in TS
11	UNIT	☐	OIJ_NMUNIT	MEINS	UNIT	3	0	Nomination(pipe) UoM
12	QTYOUT	☐	OIJ_QTYOUT	MENG13	QUAN	13	3	Qty delivered from TS
13	WORKLIST	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
14	SENTDAT	☐	OIJ_SENDAT	DATUM	DATS	8	0	Last header action date
15	SENTTIME	☐	OIJ_SENTIM	UZEIT	TIMS	6	0	Last header action time
16	SENTNAM	☐	OIJ_SENNAM	USNAM	CHAR	12	0	Last user who worked on object
17	NMSHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	TOIGS
18	EV_SEQ_UNI	☐	OIG_EVSEQU	OIG_DLNMCK	CHAR	1	0	TD Event sequence number (unique)
19	EV_GROUP	☐	OIG_EVGRP	OIG_EVGRP	CHAR	4	0	TD - event default group
20	NMWERK	☐	OIJ_WERK	WERKS	CHAR	4	0	Transport system In-transit Plant	T001W
21	NMLGORT	☐	OIJ_LGORT	LGORT	CHAR	4	0	Transport system In-transit Storage Location	T001L
22	NMTPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
23	NMVEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
24	NMVESSEL	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
25	NMBLOCK	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
26	NMBALCH	☐	OIJ_BALCH	XFELD	CHAR	1	0	Balance check indicator (default)
27	ITEMS	☐	OIJ_ITEMCOUNTER	NUM04	NUMC	4	0	Nomination item counter
28	COUNTER1	☐	OIJ_PLANNEDITEMS	NUM04	NUMC	4	0	Nomination planned item Counter
29	COUNTER2	☐	OIJ_SCHEDULEDITEMS	NUM04	NUMC	4	0	Nomination scheduled Item Counter
30	COUNTER3	☐	OIJ_REJECTEDITEMS	NUM04	NUMC	4	0	Nomination rejected Item Counter
31	COUNTER4	☐	OIJ_CONFIRMEDITEMS	NUM04	NUMC	4	0	Nomination confirmed Item Counter
32	COUNTER5	☐	OIJ_PARTCOMPLETEITEMS	NUM04	NUMC	4	0	Nomination partially complete Item Counter
33	COUNTER6	☐	OIJ_COMPLETEDITEMS	NUM04	NUMC	4	0	Nomination completed Item Counter
34	SHNUM	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
35	BOOKTS	☐	OIJ_BOOKTS	XFELD	CHAR	1	0	Book TS indicator
36	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	T173
37	VKTRA	☐	VKTRA	VKTRA	CHAR	2	0	Mode of transport	TVTR
38	SHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	TOIGS
39	VEHID	☐	OIJ_DEFVEH	OIG_VHLNMR	CHAR	10	0	Default vehicle number	OIGV
40	TSSUOMV	☐	OIJ_TSUOMV	MEINS	UNIT	3	0	TS standard volume UoM	T006
41	TSSUOMM	☐	OIJ_TSUOMM	MEINS	UNIT	3	0	TS standard weight UoM	T006
42	CYCPERD	☐	OIJ_CYCDUR	OIJ_CYCPD	QUAN	10	0	TS cycle duration
43	CYCPUOM	☐	OIJ_CYDUOM	MEINS	UNIT	3	0	TS cycle duration UoM	T006
44	CARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	LFA1
45	WERK	☐	OIJ_WERK	WERKS	CHAR	4	0	Transport system In-transit Plant	T001W
46	LGORT	☐	OIJ_LGORT	LGORT	CHAR	4	0	Transport system In-transit Storage Location	T001L
47	NOMMSK	☐	OIJ_NOMMSK	OIJ_NOMMSK	CHAR	10	0	Nomination mask
48	SHIPPER	☐	OIJ_SHPPER	OIJ_SHPPER	CHAR	10	0	Default TS shipper code
49	CONLTM	☐	OIJ_CONLTM	OIJ_CONLTM	QUAN	3	0	Carrier lead time
50	CONLUOM	☐	OIJ_CONTUM	MEINS	UNIT	3	0	Confirmation lead time UoM	T006
51	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
52	BOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
53	BUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
54	BOTOLABS	☐	OIJ_TOLABO	MENG13	QUAN	13	3	Absolute tolerance qty over
55	BUTOLABS	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
56	BULTOLUOM	☐	OIJ_TOLUOM	MEINS	UNIT	3	0	Absolute tolerance UoM	T006
57	UNLIMITED	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
58	BALCH	☐	OIJ_BALCH	XFELD	CHAR	1	0	Balance check indicator (default)
59	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
60	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
61	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
62	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
63	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
64	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
65	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
66	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
67	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
68	ISTAT	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	OIJSTAT
69	ISUBSTAT	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	OIJSUBSTAT
70	IDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
71	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
72	LOCNAM	☐	OIJ_LOCNAM	OIJ_LOCNAM	CHAR	60	0	Location name (used by system owner)
73	PLANIND	☐	OIJ_PLANIN	XFELD	CHAR	1	0	Planning location flag
74	LOCPT	☐	OIJ_LOCPT	WERKS	CHAR	4	0	Location Partner Plant	T001W
75	LOCSL	☐	OIJ_LOCSL	LGORT	CHAR	4	0	Location Partner Storage Location	T001L
76	MATNR_I	☐	OIJ_MATNRI	MATNR	CHAR	18	0	Demand material	MARA
77	MENGE	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
78	UNIT_I	☐	OIJ_UNITI	MEINS	UNIT	3	0	Scheduled UoM	T006
79	DOCIND	☐	OIJ_DOCIND	OIJ_DOCIND	CHAR	1	0	Reference document indicator (PSX)
80	DOCNR	☐	OIJ_DOCNR	OIJ_DOCNR	CHAR	10	0	Nomination Reference Document
81	DOCTYP	☐	OIJ_DOCTYP	CHAR04	CHAR	4	0	Reference Document Type
82	WORKLIST_I	☐	OIJ_WORKLT	XFELD	CHAR	1	0	Worklist entry indicator
83	TANK	☐	OIJ_TANKAGE	OIJ_PARTNR	CHAR	10	0	Tankage Partner
84	CONS	☐	OIJ_CONSIGNEE	OIJ_PARTNR	CHAR	10	0	Consignee Partner
85	PARTNR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
86	CONPAT	☐	OIJ_CONPAT	OIJ_PARTNR	CHAR	10	0	Contract Partner
87	INSPE	☐	OIJ_INSPECTOR	OIJ_PARTNR	CHAR	10	0	Inspector
88	IMPOEXPO	☐	OIJ_IMEXPO	LIFNR	CHAR	10	0	Import / Export Partner	LFA1
89	FLAG_IMEX	☐	OIJ_IMEXFL	OIJ_IMEXFL	CHAR	2	0	Import / Export Partner Indicator	OIJIMEX
90	OWNER	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
91	CHARG_O	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location
92	CHARG_D	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location
93	S_MATNR_I	☐	OIJ_SMATNR	MATNR	CHAR	18	0	Scheduled material	MARA
94	RVP	☐	OIJ_RVP	DEC2_1	DEC	3	1	RVP value
95	DOCITM	☐	OIJ_DOCITM	NUM06	NUMC	6	0	Nomination Reference Document Item
96	SHNUM_I	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
97	SHITEM	☐	OIG_SHITM	OIG_SHITM	NUMC	4	0	Shipment item	OIGSI
98	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
99	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
100	ILOCK	☐	OIJ_ILOCK	XFELD	CHAR	1	0	Nomination item complete flag
101	ACTDAT	☐	OIJ_ACTDAT	DATUM	DATS	8	0	Last item action date
102	ACTTIME	☐	OIJ_ACTIME	UZEIT	TIMS	6	0	Last item action time
103	ACTUALS	☐	OIJ_ACTUAL	XFELD	CHAR	1	0	Nomination item partially complete
104	ACTUALQTY	☐	OIJ_ACTQTY	MENG13	QUAN	13	3	Actual posted quantity
105	ACTUALUOM	☐	OIJ_ACTUOM	MEINS	UNIT	3	0	Actual posted quantity Unit of Measure	T006
106	ITBOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
107	ITBUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
108	ITBOTOLABS	☐	OIJ_TOLABO	MENG13	QUAN	13	3	Absolute tolerance qty over
109	ITBUTOLABS	☐	OIJ_TOLABS	MENG13	QUAN	13	3	Absolute tolerance qty under
110	ITTOLUNIT	☐	OIJ_TOLUOM	MEINS	UNIT	3	0	Absolute tolerance UoM	T006
111	UNLTD	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
112	ERDAT_I	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
113	ERZEIT_I	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
114	ERNAM_I	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
115	AEDAT_I	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
116	AEZEIT_I	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
117	AENAM_I	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
118	BLOIND_I	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
119	DELIND_I	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
120	UPDATEXDOK	☐	OIJ_EXDOK	FLAG	CHAR	1	0	Update external details failure flag
121	VALUATIONTYPE_O	☐	OIJ_BWTAR_O	BWTAR	CHAR	10	0	Valuation Type Origin Loc.	T149D
122	VALUATIONTYPE_D	☐	OIJ_BWTAR_D	BWTAR	CHAR	10	0	Valuation Type Destination Loc.	T149D
123	INCOMPLETE_FLAG	☐	OIJ_INCOMPLETE_FLAG	OIJ_INCOMPLETE_FLAG	CHAR	1	0	Incompletion Flag
124	SCHED_TST_FROM	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
125	SCHED_TST_TO	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
126	NOMCL	☐	OIJ_NOMCL	OIJ_NOMCL	CHAR	2	0	Nomination Class
127	TST_FROM_MIN	☐	OIJ_SCHED_F	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch Start Timestamp
128	TST_TO_MAX	☐	OIJ_SCHED_T	TZNTSTMPS	DEC	15	0	Scheduled / Acceptance / Pipe Batch End Timestamp
129	STAGES_ID	☐	GUID_22	SYSUUID_22	CHAR	22	0	GUID in 'CHAR' format with upper-/lowercase (!)
130	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_OIJNMHI	ACTUALUOM	T006	MSEHI	KEY	1	CN
2	V_OIJNMHI	BULTOLUOM	T006	MSEHI	KEY	1	CN
3	V_OIJNMHI	CARRIER	LFA1	LIFNR	KEY	1	CN
4	V_OIJNMHI	CONLUOM	T006	MSEHI	KEY	1	CN
5	V_OIJNMHI	CYCPUOM	T006	MSEHI	KEY	1	CN
6	V_OIJNMHI	FLAG_IMEX	OIJIMEX	FLAG_IMEX	KEY	1	CN
7	V_OIJNMHI	IMPOEXPO	LFA1	LIFNR	KEY	1	CN
8	V_OIJNMHI	ISTAT	OIJSTAT	STATUS	KEY	1	CN
9	V_OIJNMHI	ISUBSTAT	OIJSUBSTAT	SUBSTATUS	KEY	1	CN
10	V_OIJNMHI	ITTOLUNIT	T006	MSEHI	KEY	1	CN
11	V_OIJNMHI	LGORT	T001L	LGORT	KEY	1	CN
12	V_OIJNMHI	LOCID	OIJLOC	LOCID	KEY	1	CN
13	V_OIJNMHI	LOCPT	T001W	WERKS	KEY	1	CN
14	V_OIJNMHI	LOCSL	T001L	LGORT	KEY	1	CN
15	V_OIJNMHI	MANDT	T000	MANDT
16	V_OIJNMHI	MATNR_I	MARA	MATNR	KEY	1	CN
17	V_OIJNMHI	NMLGORT	T001L	LGORT	KEY	1	CN
18	V_OIJNMHI	NMSHTYPE	TOIGS	SHTYP	KEY	1	CN
19	V_OIJNMHI	NMTPLST	TTDS	TPLST	KEY	1	CN
20	V_OIJNMHI	NMVEHICLE	OIGV	VEHICLE	KEY	1	CN
21	V_OIJNMHI	NMWERK	T001W	WERKS	KEY	1	CN
22	V_OIJNMHI	NOMST	OIJSTAT	STATUS
23	V_OIJNMHI	OWNER	T149D	BWTAR	KEY	1	CN
24	V_OIJNMHI	POSNR	VBUP	POSNR	KEY	1	CN
25	V_OIJNMHI	ROUTE	TVRO	ROUTE
26	V_OIJNMHI	SHITEM	OIGSI	SHITEM	KEY	1	CN
27	V_OIJNMHI	SHNUM	OIGS	SHNUMBER
28	V_OIJNMHI	SHNUM_I	OIGS	SHNUMBER	KEY	1	CN
29	V_OIJNMHI	SHTYPE	TOIGS	SHTYP	KEY	1	CN
30	V_OIJNMHI	SITYP	TOIJ_EL_SITYPES	SITYP
31	V_OIJNMHI	S_MATNR_I	MARA	MATNR	KEY	1	CN
32	V_OIJNMHI	TPLST	TTDS	TPLST	KEY	1	CN
33	V_OIJNMHI	TSSUOMM	T006	MSEHI	KEY	1	CN
34	V_OIJNMHI	TSSUOMV	T006	MSEHI	KEY	1	CN
35	V_OIJNMHI	UNIT_I	T006	MSEHI	KEY	1	CN
36	V_OIJNMHI	VALUATIONTYPE_D	T149D	BWTAR
37	V_OIJNMHI	VALUATIONTYPE_O	T149D	BWTAR
38	V_OIJNMHI	VBELN	VBUK	VBELN	KEY	1	CN
39	V_OIJNMHI	VEHID	OIGV	VEHICLE	KEY	1	CN
40	V_OIJNMHI	VKTRA	TVTR	VKTRA	KEY	1	CN
41	V_OIJNMHI	VSART	T173	VSART	KEY	1	CN
42	V_OIJNMHI	WERK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in