SAP ABAP View V_OIJNOMHI (OIL-TSW: Nomination and its Items view (for Worklist engine))
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_OIJNOMHI  
Short Description OIL-TSW: Nomination and its Items view (for Worklist engine)    
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 AEZEIT OIJNOMH AEZEIT   OI0_AETIM Time of day the record was changed
7 AENAM OIJNOMH AENAM   AENAM Name of Person Who Changed Object
8 AEDAT OIJNOMH AEDAT   AEDAT Last Changed On
9 NOMST OIJNOMH NOMST   OIJ_NOMST Nomination header status
10 WORKLIST OIJNOMH WORKLIST   OIJ_WORKLT Worklist entry indicator
11 SENTDAT OIJNOMH SENTDAT   OIJ_SENDAT Last header action date
12 NMWERK OIJNOMH NMWERK   OIJ_WERK Transport system In-transit Plant
13 NMLGORT OIJNOMH NMLGORT   OIJ_LGORT Transport system In-transit Storage Location
14 NMVESSEL OIJNOMH NMVESSEL   OIG_VEHID TD vehicle identifier
15 NMBALCH OIJNOMH NMBALCH   OIJ_BALCH Balance check indicator (default)
16 BOOKTS OIJNOMH BOOKTS   OIJ_BOOKTS Book TS indicator
17 VKTRA OIJNOMH VKTRA   VKTRA Mode of transport
18 CONLTM OIJNOMH CONLTM   OIJ_CONLTM Carrier lead time
19 CONLUOM OIJNOMH CONLUOM   OIJ_CONTUM Confirmation lead time UoM
20 DELIND OIJNOMH DELIND   OIJ_DELIND Deletion indicator
21 SITYP OIJNOMI SITYP   OIJ_SITYP Schedule type
22 IDATE OIJNOMI IDATE   OIJ_IDATE Scheduled date
23 LOCID OIJNOMI LOCID   OIJ_LOCID Location ID
24 LOCPT OIJNOMI LOCPT   OIJ_LOCPT Location Partner Plant
25 LOCSL OIJNOMI LOCSL   OIJ_LOCSL Location Partner Storage Location
26 DOCIND OIJNOMI DOCIND   OIJ_DOCIND Reference document indicator (PSX)
27 DOCNR OIJNOMI DOCNR   OIJ_DOCNR Nomination Reference Document
28 WORKLIST_I OIJNOMI WORKLIST_I   OIJ_WORKLT Worklist entry indicator
29 PARTNR OIJNOMI PARTNR   OIJ_PARTNR Location Partner
30 S_MATNR_I OIJNOMI S_MATNR_I   OIJ_SMATNR Scheduled material
31 DOCITM OIJNOMI DOCITM   OIJ_DOCITM Nomination Reference Document Item
32 ILOCK OIJNOMI ILOCK   OIJ_ILOCK Nomination item complete flag
33 ACTUALS OIJNOMI ACTUALS   OIJ_ACTUAL Nomination item partially complete
34 DELIND_I OIJNOMI DELIND   OIJ_DELIND Deletion indicator
35 UPDATEXDOK OIJNOMI UPDATEXDOK   OIJ_EXDOK Update external details failure flag
36 ACTUALUOM OIJNOMI ACTUALUOM   OIJ_ACTUOM Actual posted quantity Unit of Measure
37 ACTUALQTY OIJNOMI ACTUALQTY   OIJ_ACTQTY Actual posted quantity
38 ERDAT_I OIJNOMI ERDAT   ERDAT Date on which the record was created
39 AEDAT_I OIJNOMI AEDAT   AEDAT Last Changed On
40 AEZEIT_I OIJNOMI AEZEIT   OI0_AETIM Time of day the record was changed
41 AENAM_I OIJNOMI AENAM   AENAM Name of Person Who Changed Object
42 ISTAT OIJNOMI ISTAT   OIJ_ISTAT Nomination Item status
43 MENGE OIJNOMI MENGE   OIJ_MENGE Scheduled qty
44 ITBOTOLABS OIJNOMI ITBOTOLABS   OIJ_TOLABO Absolute tolerance qty over
45 ITBUTOLABS OIJNOMI ITBUTOLABS   OIJ_TOLABS Absolute tolerance qty under
46 UNLIMITED OIJNOMI UNLIMITED   UEBTK Indicator: Unlimited Overdelivery Allowed
47 UNIT_I OIJNOMI UNIT_I   OIJ_UNITI Scheduled UoM
48 ITTOLUNIT OIJNOMI ITTOLUNIT   OIJ_TOLUOM Absolute tolerance UoM
49 INCOMPLETE_FLAG OIJNOMI INCOMPLETE_FLAG   OIJ_INCOMPLETE_FLAG Incompletion Flag
50 NMVEHICLE OIJNOMH NMVEHICLE   OIG_VHLNMR TD Vehicle Number
                 
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