I_TicketInfoFld

Ticket Information Fields | view: ITICKETINFOFLD | TRAN | Extraction: Not supported | Component: Downstream
Column Name Description
NominationTicketKey FK OIL-TSW: Ticket key
NominationTicketItem OIL-TSW: Ticket item number
NominationTicketVersion OIL-TSW: Ticket version
Column Name Description
Column Name Description
📏 Scheduled UoM (ScheduledQuantityUnit):
NominationSchedQuantity Scheduled qty
📏 Actual posted quantity Unit of Measure (ActualScheduledQuantityUnit):
ActualScheduledQuantity Actual posted quantity
📏 Base Unit of Measure (BaseUnit):
ScheduledQuantity Scheduled qty
📏 Stop meter calculation UOM (StopMeterUnitOfMeasure):
StopMeterCalculationQuantity Stop meter calculation Quantity
OpenDipReading Open dip reading
CloseDipReading Close Dip reading
CalculatedGaugeQuantity Calculated Gauge Quantity
Column Name Description
TicketDocumentPostingDate Posting Date in the Document
TSWTicketStartDate null
TSWTicketStartTime null
TSWTicketEndDate null
TSWTicketEndTime null
TSWTicketPostingDate Posting Date in the Document
TSWTicketPostingTime Posting time in the document
TicketCreationDate Date on which the record was created
TicketCreationTime Time of creation
TicketChangedDate Last Changed On
NominationEventDate OIL-TSW: Event date
Column Name Description
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
TicketMessageType Message Type Show values
NominationItemStatus Nomination Item status Show values
NominationItemSubStatus Nomination Item sub-status Show values
NominationTicketStatus OIL-TSW: Ticket process return code 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
IsNominationItemClosed Boolean Variable (X = True, - = False, Space = Unknown) Show values
NominationDocIsBlocked Flag to Set Nomination Selectable Show values
NominationTicketIsBlocked Flag to Set Tickets Selectable Show values
Column Name Description Domain name
NominationExtNumber Nomination number OIJ_NOMNR
LocationName Location name (used by system owner) OIJ_LOCNAM
LatestTicketStatus null
TicketStatusColorCode null
QuantityStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
QuantityEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
QuantityPostingDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GeneralMeterNumber GMM: Number of general meter OII_GMMNR
MeterOpenQuantity Character Field of Length 12 CHAR12
EndCounterMeterReading GMM: End counter reading OII_MCOUNT
OpenMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CloseMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
TankSequenceNumber Sequence number of tank assigned to a business location OII_SEQNR
StorageObjectSegmentNumber SOC: Storage object characteristic segment number OII_SOCNR
OpenTankDipDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CloseTankDipDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GaugeTimeZone Character field of length 6 CHAR6
TicketCreatedByUser Name of Person Responsible for Creating the Object USNAM
TicketChangedByUser Name of Person Who Changed Object USNAM
TypeOfMovement Short Text for Fixed Values DDTEXT
TicketNumber External Ticket Number CHAR10
TicketExternalNumber OIL-TSW: External ticket number OIJ_TKTNR
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • I_TICKETINFOFLD.MANDT == T006.MANDT
  • I_TICKETINFOFLD.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_TICKETINFOFLD.MANDT == T006.MANDT
  • I_TICKETINFOFLD.BASEUNIT == T006.MSEHI
TD shipment type
  • Client
  • TD shipment type
  • I_TICKETINFOFLD.MANDT == TOIGS.CLIENT
  • I_TICKETINFOFLD.BULKSHIPMENTTYPE == TOIGS.SHTYP
Demand material
  • Client
  • Demand material
  • I_TICKETINFOFLD.MANDT == MARA.MANDT
  • I_TICKETINFOFLD.DEMANDMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_TICKETINFOFLD.MANDT == T001W.MANDT
  • I_TICKETINFOFLD.DESTINATIONPLANT == T001W.WERKS
Storage location
  • Client
  • Plant
  • Storage location
  • I_TICKETINFOFLD.MANDT == T001L.MANDT
  • I_TICKETINFOFLD.DESTINATIONPLANT == T001L.WERKS
  • I_TICKETINFOFLD.DESTINATIONSTORAGELOCATION == T001L.LGORT
Transport system In-transit Plant
  • Client
  • Transport system In-transit Plant
  • I_TICKETINFOFLD.MANDT == T001W.MANDT
  • I_TICKETINFOFLD.INTRANSITPLANT == T001W.WERKS
Location ID
  • Client
  • Location ID
  • I_TICKETINFOFLD.MANDT == OIJLOC.MANDT
  • I_TICKETINFOFLD.LOCATIONID == OIJLOC.LOCID
Schedule type
  • Client
  • Schedule type
OIL-TSW: Ticket type
  • Client
  • OIL-TSW: Ticket type
Nomination type
  • Client
  • Nomination type
Plant
  • Client
  • Plant
  • I_TICKETINFOFLD.MANDT == T001W.MANDT
  • I_TICKETINFOFLD.ORIGINPLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • I_TICKETINFOFLD.ORIGINSTORAGELOCATION == T001L.LGORT
  • I_TICKETINFOFLD.MANDT == T001L.MANDT
  • I_TICKETINFOFLD.ORIGINPLANT == T001L.WERKS
Material Number
  • Client
  • Material Number
  • I_TICKETINFOFLD.MANDT == MARA.MANDT
  • I_TICKETINFOFLD.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • I_TICKETINFOFLD.MANDT == T006.MANDT
  • I_TICKETINFOFLD.SCHEDULEDQUANTITYUNIT == T006.MSEHI
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_TICKETINFOFLD.MANDT == OIGV.CLIENT
  • I_TICKETINFOFLD.VEHICLEID == OIGV.VEHICLE