SAP ABAP View V_OIJRDNOM (Combined nomination header + item for Stock projection)

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_OIJRDNOM
Short Description	Combined nomination header + item for Stock projection
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	NOMIT	OIJNOMI	NOMIT		☐	OIJ_ITEM	☐	Nomination Key Item
4	NOMTYP	OIJNOMH	NOMTYP		☐	OIJ_NOMTYP	☐	Nomination type
5	NOMNR	OIJNOMH	NOMNR		☐	OIJ_NOMNR	☐	Nomination number
6	TSYST	OIJNOMH	TSYST		☐	OIJ_TSYST	☐	Transport system
7	NMSHIPPER	OIJNOMH	NMSHIPPER		☐	OIJ_SHIPNR	☐	Shipper
8	NMCARRIER	OIJNOMH	NMCARRIER		☐	OIJ_CARRNR	☐	Transport system Carrier
9	CYCLE	OIJNOMH	CYCLE		☐	OIJ_CYCLE	☐	Nomination Pipeline cycle ID
10	NOMST	OIJNOMH	NOMST		☐	OIJ_NOMST	☐	Nomination header status
11	SITYP	OIJNOMI	SITYP		☐	OIJ_SITYP	☐	Schedule type
12	ISTAT	OIJNOMI	ISTAT		☐	OIJ_ISTAT	☐	Nomination Item status
13	IDATE	OIJNOMI	IDATE		☐	OIJ_IDATE	☐	Scheduled date
14	LOCID	OIJNOMI	LOCID		☐	OIJ_LOCID	☐	Location ID
15	LOCNAM	OIJNOMI	LOCNAM		☐	OIJ_LOCNAM	☐	Location name (used by system owner)
16	LOCPT	OIJNOMI	LOCPT		☐	OIJ_LOCPT	☐	Location Partner Plant
17	MATNR_I	OIJNOMI	MATNR_I		☐	OIJ_MATNRI	☐	Demand material
18	MENGE	OIJNOMI	MENGE		☐	OIJ_MENGE	☐	Scheduled qty
19	UNIT_I	OIJNOMI	UNIT_I		☐	OIJ_UNITI	☐	Scheduled UoM
20	DOCIND	OIJNOMI	DOCIND		☐	OIJ_DOCIND	☐	Reference document indicator (PSX)
21	DOCNR	OIJNOMI	DOCNR		☐	OIJ_DOCNR	☐	Nomination Reference Document
22	DOCTYP	OIJNOMI	DOCTYP		☐	OIJ_DOCTYP	☐	Reference Document Type
23	WORKLIST_I	OIJNOMI	WORKLIST_I		☐	OIJ_WORKLT	☐	Worklist entry indicator
24	TANK	OIJNOMI	TANK		☐	OIJ_TANKAGE	☐	Tankage Partner
25	CONS	OIJNOMI	CONS		☐	OIJ_CONSIGNEE	☐	Consignee Partner
26	PARTNR	OIJNOMI	PARTNR		☐	OIJ_PARTNR	☐	Location Partner
27	CONPAT	OIJNOMI	CONPAT		☐	OIJ_CONPAT	☐	Contract Partner
28	INSPE	OIJNOMI	INSPE		☐	OIJ_INSPECTOR	☐	Inspector
29	OWNER	OIJNOMI	OWNER		☐	BWTAR_D	☐	Valuation type
30	RVP	OIJNOMI	RVP		☐	OIJ_RVP	☐	RVP value
31	DOCITM	OIJNOMI	DOCITM		☐	OIJ_DOCITM	☐	Nomination Reference Document Item
32	SHNUM	OIJNOMI	SHNUM		☐	OIG_SHNUM	☐	TD shipment number
33	SHITEM	OIJNOMI	SHITEM		☐	OIG_SHITM	☐	Shipment item
34	ILOCK	OIJNOMI	ILOCK		☐	OIJ_ILOCK	☐	Nomination item complete flag
35	ACTUALS	OIJNOMI	ACTUALS		☐	OIJ_ACTUAL	☐	Nomination item partially complete
36	ACTUALQTY	OIJNOMI	ACTUALQTY		☐	OIJ_ACTQTY	☐	Actual posted quantity
37	ACTUALUOM	OIJNOMI	ACTUALUOM		☐	OIJ_ACTUOM	☐	Actual posted quantity Unit of Measure
38	ITBUTOL	OIJNOMI	ITBUTOL		☐	OIJ_BUTOL	☐	Quantity tolerance under (%)
39	ITBUTOLABS	OIJNOMI	ITBUTOLABS		☐	OIJ_TOLABS	☐	Absolute tolerance qty under
40	ITTOLUNIT	OIJNOMI	ITTOLUNIT		☐	OIJ_TOLUOM	☐	Absolute tolerance UoM
41	S_MATNR_I	OIJNOMI	S_MATNR_I		☐	OIJ_SMATNR	☐	Scheduled material
42	DELIND_H	OIJNOMH	DELIND		☐	OIJ_DELIND	☐	Deletion indicator
43	DELIND_I	OIJNOMI	DELIND		☐	OIJ_DELIND	☐	Deletion indicator
44	CHARG_O	OIJNOMI	CHARG_O		☐	OIJ_CHARGO	☐	Batch origin Location
45	CHARG_D	OIJNOMI	CHARG_D		☐	OIJ_CHARGD	☐	Batch destination Location
46	VALUATIONTYPE_O	OIJNOMI	VALUATIONTYPE_O		☐	OIJ_BWTAR_O	☐	Valuation Type Origin Loc.
47	VALUATIONTYPE_D	OIJNOMI	VALUATIONTYPE_D		☐	OIJ_BWTAR_D	☐	Valuation Type Destination Loc.
48	NOMCL	OIJNOMH	NOMCL		☐	OIJ_NOMCL	☐	Nomination Class
49	VEHID	OIJNOMH	VEHID		☐	OIJ_DEFVEH	☐	Default vehicle number
50	SCHED_TST_FROM	OIJNOMI	SCHED_TST_FROM		☐	OIJ_SCHED_F	☐	Scheduled / Acceptance / Pipe Batch Start Timestamp
51	SCHED_TST_TO	OIJNOMI	SCHED_TST_TO		☐	OIJ_SCHED_T	☐	Scheduled / Acceptance / Pipe Batch End Timestamp

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