C_NominationLineItem

Nomination Line Item | view: CNOMLINEITEM | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMH, OIJNOMI, OIJ_EL_TICKET_H, OIJ_EL_TICKET_I, OIJ_EL_ERROR_LOG, MAKT
Column Name Description
NominationDoc FK Nomination (technical) Key
NominationDocItem Nomination Key Item
Column Name Description
Column Name Description
📏 Scheduled UoM (ScheduledQuantityUnit):
ScheduledQuantity Scheduled qty
📏 Actual posted quantity Unit of Measure (ActualScheduledQuantityUnit):
ActualScheduledQuantity Actual posted quantity
Column Name Description
NominationScheduleDate Scheduled date
NominationCreationDate Date on which the record was created
NominationChangedDate Last Changed On
NominationCreationTime Time of creation
Column Name Description
NominationTicketPurpose OIL-TSW: Ticket Purpose Show values
TicketActionMode 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
NominationTicketVersion null
NominationExtNumber Nomination number
TicketStatusColorCode null
LatestTicketStatus null
NominationCreatedByUser Name of Person Responsible for Creating the Object
LastChangedByUser Name of Person Who Changed Object
LocationName Location name (used by system owner)
MaterialDesc Material Description in Uppercase for Matchcodes
TicketItemStatus Values for Domains: Single Value/Lower Limit
NumberOfTickets null
NominationReferenceDocType Reference document indicator (PSX)
VehicleIdentifier TD vehicle identifier
NominationReferenceDocItem Nomination Reference Document Item
NominationReferenceDocument Nomination Reference Document
LocationPartner Location Partner
NominationPipelineCycleID Nomination Pipeline cycle ID
NominationIsBlocked Blocking indicator
NominationIsMarkedForDeletion Deletion indicator
ContractPartner Contract Partner
ConsigneePartner Consignee Partner
NominationInspector Inspector
IsNominationWorklistEntry Worklist entry indicator
QuickConfirm Quick Confirm check box
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp
NominationItemIsComplete Nomination item complete flag
NominationIsIncomplete null
NominationRefDocCode Reference Document Type
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • C_NOMINATIONLINEITEM.MANDT == T006.MANDT
  • C_NOMINATIONLINEITEM.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
TD shipment type
  • Client
  • TD shipment type
  • C_NOMINATIONLINEITEM.MANDT == TOIGS.CLIENT
  • C_NOMINATIONLINEITEM.BULKSHIPMENTTYPE == TOIGS.SHTYP
Business type
  • Client
  • Business type
  • C_NOMINATIONLINEITEM.MANDT == OIRARNBT.MANDT
  • C_NOMINATIONLINEITEM.BUSINESSTYPE == OIRARNBT.RNBT
Demand material
  • Client
  • Demand material
  • C_NOMINATIONLINEITEM.MANDT == MARA.MANDT
  • C_NOMINATIONLINEITEM.DEMANDMATERIAL == MARA.MATNR
Import / Export Partner
  • Client
  • Import / Export Partner
  • C_NOMINATIONLINEITEM.MANDT == LFA1.MANDT
  • C_NOMINATIONLINEITEM.IMPORTEXPORTPARTNER == LFA1.LIFNR
Transport system In-transit Plant
  • Client
  • Transport system In-transit Plant
  • C_NOMINATIONLINEITEM.MANDT == T001W.MANDT
  • C_NOMINATIONLINEITEM.INTRANSITPLANT == T001W.WERKS
Transport system In-transit Storage Location
  • Client
  • Transport system In-transit Storage Location
  • Transport system In-transit Plant
  • C_NOMINATIONLINEITEM.MANDT == T001L.MANDT
  • C_NOMINATIONLINEITEM.INTRANSITSTORAGELOCATION == T001L.LGORT
  • C_NOMINATIONLINEITEM.INTRANSITPLANT == T001L.WERKS
Import / Export Partner Indicator
  • Client
  • Import / Export Partner Indicator
  • C_NOMINATIONLINEITEM.MANDT == OIJIMEX.MANDT
  • C_NOMINATIONLINEITEM.ISIMPORTEXPORTPARTNER == OIJIMEX.FLAG_IMEX
Location ID
  • Client
  • Location ID
  • C_NOMINATIONLINEITEM.MANDT == OIJLOC.MANDT
  • C_NOMINATIONLINEITEM.LOCATIONID == OIJLOC.LOCID
Nomination Item status
  • Nomination Item status
  • Client
  • ?
  • C_NOMINATIONLINEITEM.NOMINATIONITEMSTATUS == OIJSTAT.STATUS
  • C_NOMINATIONLINEITEM.MANDT == OIJSTAT.MANDT
  • C_NOMINATIONLINEITEM.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
Nomination Item sub-status
  • Nomination Item status
  • Client
  • ?
  • Nomination Item sub-status
  • C_NOMINATIONLINEITEM.NOMINATIONITEMSTATUS == OIJSUBSTAT.STATUS
  • C_NOMINATIONLINEITEM.MANDT == OIJSUBSTAT.MANDT
  • C_NOMINATIONLINEITEM.[column in domain "OIJ_REFTAB"] == OIJSUBSTAT.TABNAME
  • C_NOMINATIONLINEITEM.NOMINATIONITEMSUBSTATUS == OIJSUBSTAT.SUBSTATUS
Mode of Transport
  • Client
  • Mode of Transport
  • C_NOMINATIONLINEITEM.MANDT == TVTR.MANDT
  • C_NOMINATIONLINEITEM.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
Schedule type
  • Client
  • Schedule type
Nomination type
  • Client
  • Nomination type
  • C_NOMINATIONLINEITEM.MANDT == TOIJNOMTYP.MANDT
  • C_NOMINATIONLINEITEM.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Scheduled UoM
  • Client
  • Scheduled UoM
  • C_NOMINATIONLINEITEM.MANDT == T006.MANDT
  • C_NOMINATIONLINEITEM.SCHEDULEDQUANTITYUNIT == T006.MSEHI
Transportation planning point
  • Client
  • Transportation planning point
  • C_NOMINATIONLINEITEM.MANDT == TTDS.MANDT
  • C_NOMINATIONLINEITEM.TRANSPORTATIONPLANNINGPOINT == TTDS.TPLST
Valuation Type Destination Loc.
  • Client
  • Valuation Type Destination Loc.
  • C_NOMINATIONLINEITEM.MANDT == T149D.MANDT
  • C_NOMINATIONLINEITEM.VALUATIONTYPEDESTINATION == T149D.BWTAR
Valuation Type Origin Loc.
  • Client
  • Valuation Type Origin Loc.
  • C_NOMINATIONLINEITEM.MANDT == T149D.MANDT
  • C_NOMINATIONLINEITEM.VALUATIONTYPEORIGIN == T149D.BWTAR
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • C_NOMINATIONLINEITEM.MANDT == OIGV.CLIENT
  • C_NOMINATIONLINEITEM.VEHICLEID == OIGV.VEHICLE