C_NominationTicketDetail

Nomination Ticket Detail | view: CNOMTICKETDET | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMH, OIJNOMI, OIJPEG, OIJ_EL_TKT_I_O2, OIJ_EL_TICKET_H, OIJ_EL_TICKET_I, OIJNMTC1, TOIJ_EL_MVSCEN, ADRC, OIFSPBL, OIJTS
Column Name Description
NominationDoc FK Nomination (technical) Key
NominationDocItem Nomination Key Item
Column Name Description
Column Name Description
📏 Base Unit of Measure (NominationTicketActualQtyUoM):
ScheduledQuantity Scheduled qty
NominationTicketActualQuantity Scheduled qty
NominationInProcessQuantity null
ActualScheduledQuantity Actual posted quantity
Column Name Description
NominationScheduleDate Scheduled date
NominationTicketLoadStartDate null
NominationTicketLoadStartTime null
NominationTicketLoadEndDate null
NominationTicketLoadEndTime null
TicketCreationDate Date on which the record was created
TicketCreationTime Time of creation
Column Name Description
NominationIsClosed IS OIL TSW: Indicator close nomination Show values
NominationItemIsComplete Nomination item complete flag Show values
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
NominationLastTicketStatus OIL-TSW: Ticket process return code Show values
NominationDocIsBlocked Flag to Set Nomination Selectable Show values
Column Name Description Domain name
NominationExtNumber Nomination number OIJ_NOMNR
OilMovementScenario TSW: Movement scenario number NUM02
NominationInspector Inspector OIJ_PARTNR
NominationOriginLocation null
NominationDestinationLocation null
NominationTicketLoadStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NominationTicketLoadEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NominationTicketStatus null
NominationHasTicket null
NominationTicketItem OIL-TSW: Ticket item number OIJ_EL_TKT_POSNR
NominationTicketVersion OIL-TSW: Ticket version OIJ_EL_TKT_VERSION
LocationIDDesc null
NominationOriginLocationDesc null
NominationDestLocationDesc null
NominationModeOfTransportDesc null
NominationScheduleTypeDesc null
TransportSystemDesc null
VehicleIdDesc null
NominationTicketActlQtyUoMDesc null
ScheduledQuantityUnitDesc null
NominationInProcessUoMDesc null
ActualSchedldQuantityUnitDesc null
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Actual posted quantity Unit of Measure
  • Client
  • C_NOMINATIONTICKETDETAIL.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
  • C_NOMINATIONTICKETDETAIL.MANDT == T006.MANDT
TD shipment type
  • TD shipment type
  • Client
  • C_NOMINATIONTICKETDETAIL.BULKSHIPMENTTYPE == TOIGS.SHTYP
  • C_NOMINATIONTICKETDETAIL.MANDT == TOIGS.CLIENT
Location ID
  • Location ID
  • Client
  • C_NOMINATIONTICKETDETAIL.LOCATIONID == OIJLOC.LOCID
  • C_NOMINATIONTICKETDETAIL.MANDT == OIJLOC.MANDT
Mode of Transport
  • Mode of Transport
  • Client
  • C_NOMINATIONTICKETDETAIL.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
  • C_NOMINATIONTICKETDETAIL.MANDT == TVTR.MANDT
Schedule type
  • Schedule type
  • Client
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_NOMINATIONTICKETDETAIL.MANDT == T006.MANDT
  • C_NOMINATIONTICKETDETAIL.NOMINATIONTICKETACTUALQTYUOM == T006.MSEHI
Location Partner Plant
  • Location Partner Plant
  • Client
  • C_NOMINATIONTICKETDETAIL.OILLOCATIONPARTNERPLANT == T001W.WERKS
  • C_NOMINATIONTICKETDETAIL.MANDT == T001W.MANDT
Location Partner Storage Location
  • Location Partner Plant
  • Location Partner Storage Location
  • Client
  • C_NOMINATIONTICKETDETAIL.OILLOCATIONPARTNERPLANT == T001L.WERKS
  • C_NOMINATIONTICKETDETAIL.OILLOCATIONPARTNERSTORAGELOC == T001L.LGORT
  • C_NOMINATIONTICKETDETAIL.MANDT == T001L.MANDT
Scheduled material
  • Scheduled material
  • Client
  • C_NOMINATIONTICKETDETAIL.SCHEDULEDMATERIAL == MARA.MATNR
  • C_NOMINATIONTICKETDETAIL.MANDT == MARA.MANDT
Scheduled UoM
  • Scheduled UoM
  • Client
  • C_NOMINATIONTICKETDETAIL.SCHEDULEDQUANTITYUNIT == T006.MSEHI
  • C_NOMINATIONTICKETDETAIL.MANDT == T006.MANDT
Address time zone
  • Client
  • Address time zone
  • C_NOMINATIONTICKETDETAIL.MANDT == TTZZ.CLIENT
  • C_NOMINATIONTICKETDETAIL.TIMEZONEID == TTZZ.TZONE
TD Vehicle Number
  • TD Vehicle Number
  • Client
  • C_NOMINATIONTICKETDETAIL.VEHICLEID == OIGV.VEHICLE
  • C_NOMINATIONTICKETDETAIL.MANDT == OIGV.CLIENT