C_Oij06_MyNominations

My Nominations | view: COIJ06_MYNOM | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMH, OIJNOMI, OIJ_EL_TICKET_H, OIJ_EL_TICKET_I, OIJNE, OIJ_EL_ERROR_LOG, BUT000, KNA1, OIJLOC, MAKT, OIJTS, OIGV, OIGVT, MARA, OIJLOCMAT, LFA1, CVI_VEND_LINK
Column Name Description
NominationDoc 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
NominationChangedDate Last Changed On
NominationCreationDate Date on which the record was created
NominationCreationTime Time of creation
NominationLastHeaderActionDate Last header action date
NominationEventChangedDate null
NominationEventChangedTime null
Column Name Description
NominationIsBlocked Blocking indicator Show values
IsBookedTransportSystem Book TS indicator Show values
VehicleIsBlocked Business Purpose Completed Indicator for Vehicle Show values
NominationIsEditEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
NominationIsCopyEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
NominationIsAdvCopyEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
NominationDocIsBlocked Flag to Set Nomination Selectable Show values
NominationBatOrignIsChangeable Boolean Variable (X = True, - = False, Space = Unknown) Show values
NominationBatDestIsChangeable Boolean Variable (X = True, - = False, Space = Unknown) Show values
NominationBatLoadIsChangeable Boolean Variable (X = True, - = False, Space = Unknown) Show values
NominationFldIsNotChangeable Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
NominationExtNumber Nomination number
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp
VehicleIdentifier TD vehicle identifier
IsReferenceDocument Reference document indicator (PSX)
NominationReferenceDocument Nomination Reference Document
NominationReferenceDocItem Nomination Reference Document Item
NominationReferenceDocType Reference Document Type
NominationPipelineCycleID Nomination Pipeline cycle ID
ContractPartner Contract Partner
ConsigneePartner Consignee Partner
NominationInspector Inspector
LocationPartner Location Partner
QuickConfirmationCode Quick Confirm check box
NominationItemIsComplete Nomination item complete flag
NominationIsMarkedForDeletion Deletion indicator
NominationIsIncomplete null
IsNominationWorklistEntry Worklist entry indicator
NominationCreatedByUser Name of Person Responsible for Creating the Object
BatchLoad Batch load
IsNominationItmOriginBatCrted Origin Batch create new flag
NominationItmDestBatIsCreated Destination Batch create new flag
NominationItmLoadBatIsCreated Load Batch create new flag
NominationEventType null
NominationEventDefaultGroup TD - event default group OIG_EVGRP
NominationDocComments null
NominationHeaderComment Text field length 200 CHAR200
NominationGeneralComments Text field length 200 CHAR200
NominationTicketStatus null
NumberOfNominationTickets null
NominationEventNumber null
NominationEvents null
NominationEventComments Text field length 200 CHAR200
NominationLoadIsToBeCopied null
NominationIsUpdated null
NominationIsToBeCopied null
NominationItemIsToBeCopied null
NominationEventLogUpdate UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MaterialDesc Material Description TEXT40
LocationName Location name (used by system owner) OIJ_LOCNAM
NominationExtDocItem null
LoadDemandMaterialDesc Material Description TEXT40
TransportSystemDesc OIL-TSW: Transport system name OIJ_TSNAM
ContractPartnerDescription Name of Customer TEXT80
ConsigneePartnerDescription Name of Customer TEXT80
NominationShipperDesc Name 1 NAME
NominationCarrierDesc Name 1 NAME
PartnerDescription Name of Customer TEXT80
VehicleDescription TD vehicle header text OIG_TEXT
IsNominationActual Nomination item partially complete
NominationScheduleEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Actual posted quantity Unit of Measure
  • Client
  • C_OIJ06_MYNOMINATIONS.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
  • C_OIJ06_MYNOMINATIONS.MANDT == T006.MANDT
TD shipment type
  • TD shipment type
  • Client
  • C_OIJ06_MYNOMINATIONS.BULKSHIPMENTTYPE == TOIGS.SHTYP
  • C_OIJ06_MYNOMINATIONS.MANDT == TOIGS.CLIENT
Business type
  • Business type
  • Client
  • C_OIJ06_MYNOMINATIONS.BUSINESSTYPE == OIRARNBT.RNBT
  • C_OIJ06_MYNOMINATIONS.MANDT == OIRARNBT.MANDT
Demand material
  • Demand material
  • Client
  • C_OIJ06_MYNOMINATIONS.DEMANDMATERIAL == MARA.MATNR
  • C_OIJ06_MYNOMINATIONS.MANDT == MARA.MANDT
Destination city code
  • Destination city code
  • ?
  • ?
  • Client
  • C_OIJ06_MYNOMINATIONS.DESTINATIONCITYCODE == T005G.CITYC
  • C_OIJ06_MYNOMINATIONS.[column in domain "LAND1"] == T005G.LAND1
  • C_OIJ06_MYNOMINATIONS.[column in domain "REGIO"] == T005G.REGIO
  • C_OIJ06_MYNOMINATIONS.MANDT == T005G.MANDT
Import / Export Partner
  • Import / Export Partner
  • Client
  • C_OIJ06_MYNOMINATIONS.IMPORTEXPORTPARTNER == LFA1.LIFNR
  • C_OIJ06_MYNOMINATIONS.MANDT == LFA1.MANDT
Transport system In-transit Plant
  • Client
  • Transport system In-transit Plant
  • C_OIJ06_MYNOMINATIONS.MANDT == T001W.MANDT
  • C_OIJ06_MYNOMINATIONS.INTRANSITPLANT == T001W.WERKS
Transport system In-transit Storage Location
  • Client
  • Transport system In-transit Storage Location
  • Transport system In-transit Plant
  • C_OIJ06_MYNOMINATIONS.MANDT == T001L.MANDT
  • C_OIJ06_MYNOMINATIONS.INTRANSITSTORAGELOCATION == T001L.LGORT
  • C_OIJ06_MYNOMINATIONS.INTRANSITPLANT == T001L.WERKS
Import / Export Partner Indicator
  • Import / Export Partner Indicator
  • Client
  • C_OIJ06_MYNOMINATIONS.ISIMPORTEXPORTPARTNER == OIJIMEX.FLAG_IMEX
  • C_OIJ06_MYNOMINATIONS.MANDT == OIJIMEX.MANDT
Location ID
  • Location ID
  • Client
  • C_OIJ06_MYNOMINATIONS.LOCATIONID == OIJLOC.LOCID
  • C_OIJ06_MYNOMINATIONS.MANDT == OIJLOC.MANDT
Nomination header status
  • Nomination header status
  • ?
  • Client
  • C_OIJ06_MYNOMINATIONS.NOMINATIONHEADERSTATUS == OIJSTAT.STATUS
  • C_OIJ06_MYNOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • C_OIJ06_MYNOMINATIONS.MANDT == OIJSTAT.MANDT
Nomination Item status
  • ?
  • Nomination Item status
  • Client
  • C_OIJ06_MYNOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • C_OIJ06_MYNOMINATIONS.NOMINATIONITEMSTATUS == OIJSTAT.STATUS
  • C_OIJ06_MYNOMINATIONS.MANDT == OIJSTAT.MANDT
Nomination Item sub-status
  • ?
  • Nomination Item status
  • Nomination Item sub-status
  • Client
  • C_OIJ06_MYNOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSUBSTAT.TABNAME
  • C_OIJ06_MYNOMINATIONS.NOMINATIONITEMSTATUS == OIJSUBSTAT.STATUS
  • C_OIJ06_MYNOMINATIONS.NOMINATIONITEMSUBSTATUS == OIJSUBSTAT.SUBSTATUS
  • C_OIJ06_MYNOMINATIONS.MANDT == OIJSUBSTAT.MANDT
Mode of Transport
  • Mode of Transport
  • Client
  • C_OIJ06_MYNOMINATIONS.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
  • C_OIJ06_MYNOMINATIONS.MANDT == TVTR.MANDT
Schedule type
  • Client
  • Schedule type
Nomination type
  • Client
  • Nomination type
  • C_OIJ06_MYNOMINATIONS.MANDT == TOIJNOMTYP.MANDT
  • C_OIJ06_MYNOMINATIONS.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Origin city code
  • ?
  • Origin city code
  • ?
  • Client
  • C_OIJ06_MYNOMINATIONS.[column in domain "REGIO"] == T005G.REGIO
  • C_OIJ06_MYNOMINATIONS.ORIGINCITYCODE == T005G.CITYC
  • C_OIJ06_MYNOMINATIONS.[column in domain "LAND1"] == T005G.LAND1
  • C_OIJ06_MYNOMINATIONS.MANDT == T005G.MANDT
Scheduled material
  • Scheduled material
  • Client
  • C_OIJ06_MYNOMINATIONS.SCHEDULEDMATERIAL == MARA.MATNR
  • C_OIJ06_MYNOMINATIONS.MANDT == MARA.MANDT
Scheduled UoM
  • Scheduled UoM
  • Client
  • C_OIJ06_MYNOMINATIONS.SCHEDULEDQUANTITYUNIT == T006.MSEHI
  • C_OIJ06_MYNOMINATIONS.MANDT == T006.MANDT
Route
  • Client
  • Route
  • C_OIJ06_MYNOMINATIONS.MANDT == TVRO.MANDT
  • C_OIJ06_MYNOMINATIONS.SHIPPINGROUTE == TVRO.ROUTE
Transportation planning point
  • Transportation planning point
  • Client
  • C_OIJ06_MYNOMINATIONS.TRANSPORTATIONPLANNINGPOINT == TTDS.TPLST
  • C_OIJ06_MYNOMINATIONS.MANDT == TTDS.MANDT
Valuation Type Destination Loc.
  • Valuation Type Destination Loc.
  • Client
  • C_OIJ06_MYNOMINATIONS.VALUATIONTYPEDESTINATION == T149D.BWTAR
  • C_OIJ06_MYNOMINATIONS.MANDT == T149D.MANDT
Valuation Type Origin Loc.
  • Valuation Type Origin Loc.
  • Client
  • C_OIJ06_MYNOMINATIONS.VALUATIONTYPEORIGIN == T149D.BWTAR
  • C_OIJ06_MYNOMINATIONS.MANDT == T149D.MANDT
TD Vehicle Number
  • TD Vehicle Number
  • Client
  • C_OIJ06_MYNOMINATIONS.VEHICLEID == OIGV.VEHICLE
  • C_OIJ06_MYNOMINATIONS.MANDT == OIGV.CLIENT