I_NominationTicketItemList

Nomination Ticket Item List View | view: ITKTITLST | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMH, OIJNOMI, OIJ_EL_TICKET_H, OIJ_EL_TICKET_I, OIJ_EL_ERROR_LOG
Column Name Description
NominationTicketKey FK OIL-TSW: Ticket key
NominationTicketItem OIL-TSW: Ticket item number
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
NominationTicketVersion OIL-TSW: Ticket version
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ScheduledQuantity Scheduled qty
Column Name Description
TicketCreationDate Date on which the record was created
TicketDocumentPostingDate Posting Date in the Document
TicketCreationTime Time of creation
TicketChangedDate Last Changed On
NominationEventDate OIL-TSW: Event date
Column Name Description
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
NominationItemStatus Nomination Item status Show values
NominationItemSubStatus Nomination Item sub-status Show values
QuantityIsMarked Boolean Variable (X = True, - = False, Space = Unknown) Show values
MeterIsMarked Boolean Variable (X = True, - = False, Space = Unknown) Show values
GaugeIsMarked Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
NominationExtNumber Nomination number OIJ_NOMNR
LocationName Location name (used by system owner) OIJ_LOCNAM
TicketStatusColorCode null
TicketCreatedByUser Name of Person Responsible for Creating the Object USNAM
TicketChangedByUser Name of Person Who Changed Object USNAM
LatestTicketStatus null
TypeOfMovement null
TicketNumber External Ticket Number CHAR10
TicketExternalNumber OIL-TSW: External ticket number OIJ_TKTNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_NOMINATIONTICKETITEMLIST.MANDT == T006.MANDT
  • I_NOMINATIONTICKETITEMLIST.BASEUNIT == T006.MSEHI
TD shipment type
  • Client
  • TD shipment type
  • I_NOMINATIONTICKETITEMLIST.MANDT == TOIGS.CLIENT
  • I_NOMINATIONTICKETITEMLIST.BULKSHIPMENTTYPE == TOIGS.SHTYP
Demand material
  • Client
  • Demand material
  • I_NOMINATIONTICKETITEMLIST.MANDT == MARA.MANDT
  • I_NOMINATIONTICKETITEMLIST.DEMANDMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_NOMINATIONTICKETITEMLIST.MANDT == T001W.MANDT
  • I_NOMINATIONTICKETITEMLIST.DESTINATIONPLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • I_NOMINATIONTICKETITEMLIST.DESTINATIONSTORAGELOCATION == T001L.LGORT
  • I_NOMINATIONTICKETITEMLIST.MANDT == T001L.MANDT
  • I_NOMINATIONTICKETITEMLIST.DESTINATIONPLANT == T001L.WERKS
Location ID
  • Client
  • Location ID
  • I_NOMINATIONTICKETITEMLIST.MANDT == OIJLOC.MANDT
  • I_NOMINATIONTICKETITEMLIST.LOCATIONID == OIJLOC.LOCID
Schedule type
  • Client
  • Schedule type
OIL-TSW: Ticket type
  • Client
  • OIL-TSW: Ticket type
  • I_NOMINATIONTICKETITEMLIST.MANDT == TOIJ_TKT_TYPE.CLIENT
  • I_NOMINATIONTICKETITEMLIST.NOMINATIONTICKETTYPE == TOIJ_TKT_TYPE.TKT_TYPE
Nomination type
  • Client
  • Nomination type
  • I_NOMINATIONTICKETITEMLIST.MANDT == TOIJNOMTYP.MANDT
  • I_NOMINATIONTICKETITEMLIST.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Plant
  • Client
  • Plant
  • I_NOMINATIONTICKETITEMLIST.MANDT == T001W.MANDT
  • I_NOMINATIONTICKETITEMLIST.ORIGINPLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • I_NOMINATIONTICKETITEMLIST.ORIGINSTORAGELOCATION == T001L.LGORT
  • I_NOMINATIONTICKETITEMLIST.MANDT == T001L.MANDT
  • I_NOMINATIONTICKETITEMLIST.ORIGINPLANT == T001L.WERKS
Material Number
  • Material Number
  • Client
  • I_NOMINATIONTICKETITEMLIST.SCHEDULEDMATERIAL == MARA.MATNR
  • I_NOMINATIONTICKETITEMLIST.MANDT == MARA.MANDT
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_NOMINATIONTICKETITEMLIST.MANDT == OIGV.CLIENT
  • I_NOMINATIONTICKETITEMLIST.VEHICLEID == OIGV.VEHICLE