C_TicketItemTP

Tickets Items | view: CTICKETITEMTP | TRAN | Extraction: Not supported | Component: Downstream
Column Name Description
NominationTicketItem OIL-TSW: Ticket item number
NominationTicketKey FK OIL-TSW: Ticket key
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
📏 Actual posted quantity Unit of Measure (ActualScheduledQuantityUnit):
ActualScheduledQuantity Actual posted quantity
📏 Scheduled UoM (ScheduledQuantityUnit):
NominationSchedQuantity Scheduled qty
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
TicketChangedDate Last Changed On
NominationEventDate OIL-TSW: Event date
Column Name Description
Column Name Description Domain name
NominationTicketPurpose OIL-TSW: Ticket Purpose
TicketExternalNumber OIL-TSW: External ticket number
TicketStatusColorCode null
LatestTicketStatus null
NominationTicketStatus OIL-TSW: Ticket process return code
NominationExtNumber Nomination number
LocationName Location name (used by system owner)
TicketCorruptMode Boolean Variable (X = True, - = False, Space = Unknown)
TicketReverseMode Boolean Variable (X = True, - = False, Space = Unknown)
TicketCorrectionMode Boolean Variable (X = True, - = False, Space = Unknown)
TypeOfMovement Short Text for Fixed Values
QuantityStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
QuantityEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
QuantityPostingDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
GeneralMeterNumber GMM: Number of general meter
MeterOpenQuantity Character Field of Length 12
EndCounterMeterReading GMM: End counter reading
OpenMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
CloseMeterDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
TankSequenceNumber Sequence number of tank assigned to a business location
StorageObjectSegmentNumber SOC: Storage object characteristic segment number
GaugeTimeZone Character field of length 6
OpenTankDipDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
CloseTankDipDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
GaugeOpenDipReading null
GaugeCloseDipReading null
IsNominationItemClosed Boolean Variable (X = True, - = False, Space = Unknown)
TicketCreatedByUser Name of Person Responsible for Creating the Object
TicketCreationTimeStmp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
TicketChangedByUser Name of Person Who Changed Object
NominationItemStatus Nomination Item status
NominationItemSubStatus Nomination Item sub-status
NominationTicketIsBlocked Flag to Set Tickets Selectable
NominationDocIsBlocked Flag to Set Nomination Selectable
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Actual posted quantity Unit of Measure
  • Client
  • C_TICKETITEMTP.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
  • C_TICKETITEMTP.MANDT == T006.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_TICKETITEMTP.MANDT == T006.MANDT
  • C_TICKETITEMTP.BASEUNIT == T006.MSEHI
TD shipment type
  • TD shipment type
  • Client
  • C_TICKETITEMTP.BULKSHIPMENTTYPE == TOIGS.SHTYP
  • C_TICKETITEMTP.MANDT == TOIGS.CLIENT
Demand material
  • Client
  • Demand material
  • C_TICKETITEMTP.MANDT == MARA.MANDT
  • C_TICKETITEMTP.DEMANDMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_TICKETITEMTP.MANDT == T001W.MANDT
  • C_TICKETITEMTP.DESTINATIONPLANT == T001W.WERKS
Transport system In-transit Plant
  • Client
  • Transport system In-transit Plant
  • C_TICKETITEMTP.MANDT == T001W.MANDT
  • C_TICKETITEMTP.INTRANSITPLANT == T001W.WERKS
Location ID
  • Client
  • Location ID
  • C_TICKETITEMTP.MANDT == OIJLOC.MANDT
  • C_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
  • C_TICKETITEMTP.MANDT == T001W.MANDT
  • C_TICKETITEMTP.ORIGINPLANT == T001W.WERKS
Storage location
  • Client
  • Plant
  • Storage location
  • C_TICKETITEMTP.MANDT == T001L.MANDT
  • C_TICKETITEMTP.ORIGINPLANT == T001L.WERKS
  • C_TICKETITEMTP.ORIGINSTORAGELOCATION == T001L.LGORT
Material Number
  • Client
  • Material Number
  • C_TICKETITEMTP.MANDT == MARA.MANDT
  • C_TICKETITEMTP.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • C_TICKETITEMTP.MANDT == T006.MANDT
  • C_TICKETITEMTP.SCHEDULEDQUANTITYUNIT == T006.MSEHI