I_TicketItemFld

Ticket Items Fields | view: ITICKETITEMFLDS | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJ_EL_TICKET_I
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
📏 Stop meter calculation UOM (StopMeterUnitOfMeasure):
StopMeterCalculationQuantity Stop meter calculation Quantity
📏 Length UoM (Oil BDRP) (OpenDipUnitOfMeasure):
OpenDipReading Open dip reading
CloseDipReading Close Dip reading
📏 Stop gauge calculation UOM (StopGaugeUnitOfMeasure):
StopGaugeCalculationQuantity Stop gauge calculation - Quantity
📏 Gauge Calculation UoM (GaugeCalculationUoM):
CalculatedGaugeQuantity Calculated Gauge Quantity
Column Name Description
TicketCreationDate Date on which the record was created
TicketCreationTime Time of creation
TicketChangedDate Last Changed On
TicketDocumentPostingDate Posting Date in the Document
NominationEventDate OIL-TSW: Event date
TicketDocumentPostingTime Posting time in the document
TicketQuantityStartDate null
TicketQuantityStartTime null
TicketQuantityEndDate null
TicketQuantityEndTime null
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
IsNominationItemClosed Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
NominationTicketExtNumber External position number CHAR6
NominationExtNumber Nomination number OIJ_NOMNR
TankSequenceNumber Sequence number of tank assigned to a business location OII_SEQNR
TicketCreatedByUser Name of Person Responsible for Creating the Object USNAM
TicketChangedByUser Name of Person Who Changed Object USNAM
GeneralMeterNumber GMM: Number of general meter OII_GMMNR
OpenMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CloseMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
EndCounterMeterReading GMM: End counter reading OII_MCOUNT
StorageObjectSegmentNumber SOC: Storage object characteristic segment number OII_SOCNR
OpenTankDipDateTime Tank dip time stamp OII_TIMEST
CloseTankDipDateTime Tank dip time stamp OII_TIMEST
QuantityStartDateTime Time at Which Data Was Created (Date and Time) CHAR14
QuantityEndDateTime Time at Which Data Was Created (Date and Time) CHAR14
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_TICKETITEMFLD.MANDT == T006.MANDT
  • I_TICKETITEMFLD.BASEUNIT == T006.MSEHI
Batch destination Location
  • Batch destination Location
  • Client
  • Material Number
  • I_TICKETITEMFLD.BATCHDESTINATIONLOCATION == MCH1.CHARG
  • I_TICKETITEMFLD.MANDT == MCH1.MANDT
  • I_TICKETITEMFLD.SCHEDULEDMATERIAL == MCH1.MATNR
TD shipment type
  • Client
  • TD shipment type
  • I_TICKETITEMFLD.MANDT == TOIGS.CLIENT
  • I_TICKETITEMFLD.BULKSHIPMENTTYPE == TOIGS.SHTYP
Plant
  • Client
  • Plant
  • I_TICKETITEMFLD.MANDT == T001W.MANDT
  • I_TICKETITEMFLD.DESTINATIONPLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • I_TICKETITEMFLD.DESTINATIONSTORAGELOCATION == T001L.LGORT
  • I_TICKETITEMFLD.MANDT == T001L.MANDT
  • I_TICKETITEMFLD.DESTINATIONPLANT == T001L.WERKS
Location ID
  • Client
  • Location ID
  • I_TICKETITEMFLD.MANDT == OIJLOC.MANDT
  • I_TICKETITEMFLD.LOCATIONID == OIJLOC.LOCID
TSW: Movement scenario number
  • Client
  • TSW: Movement scenario number
Schedule type
  • Schedule type
  • Client
Plant
  • Client
  • Plant
  • I_TICKETITEMFLD.MANDT == T001W.MANDT
  • I_TICKETITEMFLD.ORIGINPLANT == T001W.WERKS
Storage location
  • Client
  • Storage location
  • Plant
  • I_TICKETITEMFLD.MANDT == T001L.MANDT
  • I_TICKETITEMFLD.ORIGINSTORAGELOCATION == T001L.LGORT
  • I_TICKETITEMFLD.ORIGINPLANT == T001L.WERKS
Material Number
  • Client
  • Material Number
  • I_TICKETITEMFLD.MANDT == MARA.MANDT
  • I_TICKETITEMFLD.SCHEDULEDMATERIAL == MARA.MATNR
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_TICKETITEMFLD.MANDT == OIGV.CLIENT
  • I_TICKETITEMFLD.VEHICLEID == OIGV.VEHICLE