I_TicketItemTP

Ticket Items | view: ITICKETITEMTP | 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
📏 Base Unit of Measure (BaseUnit):
ScheduledQuantity Scheduled qty
StopMeterCalculationQuantity Stop meter calculation Quantity
CalculatedGaugeQuantity Calculated Gauge Quantity
ActualScheduledQuantity Actual posted quantity
NominationSchedQuantity Scheduled qty
Column Name Description
TicketCreationDate Date on which the record was created
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
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
NominationTicketStatus OIL-TSW: Ticket process return code Show values
TicketCorruptMode Boolean Variable (X = True, - = False, Space = Unknown) Show values
TicketReverseMode Boolean Variable (X = True, - = False, Space = Unknown) Show values
TicketCorrectionMode Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsNominationItemClosed Boolean Variable (X = True, - = False, Space = Unknown) 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
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
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
GaugeOpenDipReading null
OpenTankDipDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GaugeCloseDipReading null
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
TicketCreationTimeStmp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
TicketChangedByUser Name of Person Who Changed Object USNAM
LatestTicketStatus null
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
  • Actual posted quantity Unit of Measure
  • Client
  • I_TICKETITEMTP.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
  • I_TICKETITEMTP.MANDT == T006.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_TICKETITEMTP.MANDT == T006.MANDT
  • I_TICKETITEMTP.BASEUNIT == T006.MSEHI
TD shipment type
  • Client
  • TD shipment type
  • I_TICKETITEMTP.MANDT == TOIGS.CLIENT
  • I_TICKETITEMTP.BULKSHIPMENTTYPE == TOIGS.SHTYP
Demand material
  • Client
  • Demand material
  • I_TICKETITEMTP.MANDT == MARA.MANDT
  • I_TICKETITEMTP.DEMANDMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_TICKETITEMTP.MANDT == T001W.MANDT
  • I_TICKETITEMTP.DESTINATIONPLANT == T001W.WERKS
Storage location
  • Client
  • Plant
  • Storage location
  • I_TICKETITEMTP.MANDT == T001L.MANDT
  • I_TICKETITEMTP.DESTINATIONPLANT == T001L.WERKS
  • I_TICKETITEMTP.DESTINATIONSTORAGELOCATION == T001L.LGORT
Transport system In-transit Plant
  • Client
  • Transport system In-transit Plant
  • I_TICKETITEMTP.MANDT == T001W.MANDT
  • I_TICKETITEMTP.INTRANSITPLANT == T001W.WERKS
Location ID
  • Client
  • Location ID
  • I_TICKETITEMTP.MANDT == OIJLOC.MANDT
  • I_TICKETITEMTP.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_TICKETITEMTP.MANDT == T001W.MANDT
  • I_TICKETITEMTP.ORIGINPLANT == T001W.WERKS
Storage location
  • Client
  • Plant
  • Storage location
  • I_TICKETITEMTP.MANDT == T001L.MANDT
  • I_TICKETITEMTP.ORIGINPLANT == T001L.WERKS
  • I_TICKETITEMTP.ORIGINSTORAGELOCATION == T001L.LGORT
Material Number
  • Client
  • Material Number
  • I_TICKETITEMTP.MANDT == MARA.MANDT
  • I_TICKETITEMTP.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • I_TICKETITEMTP.MANDT == T006.MANDT
  • I_TICKETITEMTP.SCHEDULEDQUANTITYUNIT == T006.MSEHI
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_TICKETITEMTP.MANDT == OIGV.CLIENT
  • I_TICKETITEMTP.VEHICLEID == OIGV.VEHICLE