SAP ABAP View V_OIJNMHI (OIL-TSW: nom header + nom item)

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

View Type	D	Database View
Database View	V_OIJNMHI
Short Description	OIL-TSW: nom header + nom item
Root table	OIJNOMH	Nomination Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIJNOMH	OIJNOMH
2	OIJNOMI

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIJNOMH	MANDT	JL	EQ				0	0
2	OIJNOMI	MANDT	JR	EQ			AND	0	0
3	OIJNOMH	NOMTK	JL	EQ				0	0
4	OIJNOMI	NOMTK	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in