I_Oij06_My_Nominations

My Nominations | view: IOIJ06_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
NominationCreationDate Date on which the record was created
NominationChangedDate Last Changed On
NominationScheduleDate Scheduled date
NominationCreationTime Time of creation
NominationLastHeaderActionDate Last header action date
NominationEventChangedDate null
NominationEventChangedTime null
Column Name Description
NominationDocIsBlocked Flag to Set Nomination Selectable Show values
IsNominationWorklistEntry Worklist entry indicator Show values
NominationIsBlocked Blocking indicator Show values
NominationIsMarkedForDeletion Deletion indicator Show values
NominationItemIsComplete Nomination item complete flag Show values
IsBookedTransportSystem Book TS indicator Show values
IsReferenceDocument Reference document indicator (PSX) Show values
IsNominationActual Nomination item partially complete Show values
QuickConfirmationCode Quick Confirm check box 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
IsNominationItmOriginBatCrted Origin Batch create new flag Show values
NominationItmDestBatIsCreated Destination Batch create new flag Show values
NominationItmLoadBatIsCreated Load Batch create new flag Show values
Column Name Description Domain name
NominationExtNumber Nomination number OIJ_NOMNR
NominationPipelineCycleID Nomination Pipeline cycle ID CHAR10
VehicleIdentifier TD vehicle identifier OIG_LICNMR
NominationCreatedByUser Name of Person Responsible for Creating the Object USNAM
LocationPartner Location Partner OIJ_PARTNR
NominationReferenceDocument Nomination Reference Document OIJ_DOCNR
NominationReferenceDocItem Nomination Reference Document Item NUM06
NominationInspector Inspector OIJ_PARTNR
NominationIsIncomplete null
ContractPartner Contract Partner OIJ_PARTNR
ConsigneePartner Consignee Partner OIJ_PARTNR
NominationReferenceDocType Reference Document Type CHAR04
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
NominationEventDefaultGroup TD - event default group OIG_EVGRP
NominationEventType null
NominationEventComments Text field length 200 CHAR200
NominationHeaderComment Text field length 200 CHAR200
NominationGeneralComments Text field length 200 CHAR200
NominationTicketStatus null
NumberOfNominationTickets null
NominationEventNumber null
NominationEvents null
NominationDocComments null
NominationLoadIsToBeCopied null
NominationIsUpdated null
NominationIsToBeCopied null
NominationItemIsToBeCopied null
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
BatchLoad Batch load CHARG
NominationScheduleEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • I_OIJ06_MY_NOMINATIONS.MANDT == T006.MANDT
  • I_OIJ06_MY_NOMINATIONS.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
TD shipment type
  • Client
  • TD shipment type
  • I_OIJ06_MY_NOMINATIONS.MANDT == TOIGS.CLIENT
  • I_OIJ06_MY_NOMINATIONS.BULKSHIPMENTTYPE == TOIGS.SHTYP
Business type
  • Client
  • Business type
  • I_OIJ06_MY_NOMINATIONS.MANDT == OIRARNBT.MANDT
  • I_OIJ06_MY_NOMINATIONS.BUSINESSTYPE == OIRARNBT.RNBT
Demand material
  • Client
  • Demand material
  • I_OIJ06_MY_NOMINATIONS.MANDT == MARA.MANDT
  • I_OIJ06_MY_NOMINATIONS.DEMANDMATERIAL == MARA.MATNR
Destination city code
  • Client
  • Destination city code
  • ?
  • ?
  • I_OIJ06_MY_NOMINATIONS.MANDT == T005G.MANDT
  • I_OIJ06_MY_NOMINATIONS.DESTINATIONCITYCODE == T005G.CITYC
  • I_OIJ06_MY_NOMINATIONS.[column in domain "LAND1"] == T005G.LAND1
  • I_OIJ06_MY_NOMINATIONS.[column in domain "REGIO"] == T005G.REGIO
Import / Export Partner
  • Client
  • Import / Export Partner
  • I_OIJ06_MY_NOMINATIONS.MANDT == LFA1.MANDT
  • I_OIJ06_MY_NOMINATIONS.IMPORTEXPORTPARTNER == LFA1.LIFNR
Transport system In-transit Plant
  • Client
  • Transport system In-transit Plant
  • I_OIJ06_MY_NOMINATIONS.MANDT == T001W.MANDT
  • I_OIJ06_MY_NOMINATIONS.INTRANSITPLANT == T001W.WERKS
Transport system In-transit Storage Location
  • Client
  • Transport system In-transit Plant
  • Transport system In-transit Storage Location
  • I_OIJ06_MY_NOMINATIONS.MANDT == T001L.MANDT
  • I_OIJ06_MY_NOMINATIONS.INTRANSITPLANT == T001L.WERKS
  • I_OIJ06_MY_NOMINATIONS.INTRANSITSTORAGELOCATION == T001L.LGORT
Import / Export Partner Indicator
  • Client
  • Import / Export Partner Indicator
  • I_OIJ06_MY_NOMINATIONS.MANDT == OIJIMEX.MANDT
  • I_OIJ06_MY_NOMINATIONS.ISIMPORTEXPORTPARTNER == OIJIMEX.FLAG_IMEX
Location ID
  • Location ID
  • Client
  • I_OIJ06_MY_NOMINATIONS.LOCATIONID == OIJLOC.LOCID
  • I_OIJ06_MY_NOMINATIONS.MANDT == OIJLOC.MANDT
Nomination header status
  • Client
  • ?
  • Nomination header status
  • I_OIJ06_MY_NOMINATIONS.MANDT == OIJSTAT.MANDT
  • I_OIJ06_MY_NOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • I_OIJ06_MY_NOMINATIONS.NOMINATIONHEADERSTATUS == OIJSTAT.STATUS
Nomination Item status
  • Nomination Item status
  • Client
  • ?
  • I_OIJ06_MY_NOMINATIONS.NOMINATIONITEMSTATUS == OIJSTAT.STATUS
  • I_OIJ06_MY_NOMINATIONS.MANDT == OIJSTAT.MANDT
  • I_OIJ06_MY_NOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
Nomination Item sub-status
  • Nomination Item status
  • Nomination Item sub-status
  • Client
  • ?
  • I_OIJ06_MY_NOMINATIONS.NOMINATIONITEMSTATUS == OIJSUBSTAT.STATUS
  • I_OIJ06_MY_NOMINATIONS.NOMINATIONITEMSUBSTATUS == OIJSUBSTAT.SUBSTATUS
  • I_OIJ06_MY_NOMINATIONS.MANDT == OIJSUBSTAT.MANDT
  • I_OIJ06_MY_NOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSUBSTAT.TABNAME
Mode of Transport
  • Client
  • Mode of Transport
  • I_OIJ06_MY_NOMINATIONS.MANDT == TVTR.MANDT
  • I_OIJ06_MY_NOMINATIONS.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
Schedule type
  • Client
  • Schedule type
Nomination type
  • Client
  • Nomination type
  • I_OIJ06_MY_NOMINATIONS.MANDT == TOIJNOMTYP.MANDT
  • I_OIJ06_MY_NOMINATIONS.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Origin city code
  • Client
  • ?
  • Origin city code
  • ?
  • I_OIJ06_MY_NOMINATIONS.MANDT == T005G.MANDT
  • I_OIJ06_MY_NOMINATIONS.[column in domain "LAND1"] == T005G.LAND1
  • I_OIJ06_MY_NOMINATIONS.ORIGINCITYCODE == T005G.CITYC
  • I_OIJ06_MY_NOMINATIONS.[column in domain "REGIO"] == T005G.REGIO
Scheduled material
  • Client
  • Scheduled material
  • I_OIJ06_MY_NOMINATIONS.MANDT == MARA.MANDT
  • I_OIJ06_MY_NOMINATIONS.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • I_OIJ06_MY_NOMINATIONS.MANDT == T006.MANDT
  • I_OIJ06_MY_NOMINATIONS.SCHEDULEDQUANTITYUNIT == T006.MSEHI
Route
  • Client
  • Route
  • I_OIJ06_MY_NOMINATIONS.MANDT == TVRO.MANDT
  • I_OIJ06_MY_NOMINATIONS.SHIPPINGROUTE == TVRO.ROUTE
Transportation planning point
  • Client
  • Transportation planning point
  • I_OIJ06_MY_NOMINATIONS.MANDT == TTDS.MANDT
  • I_OIJ06_MY_NOMINATIONS.TRANSPORTATIONPLANNINGPOINT == TTDS.TPLST
Valuation Type
  • Client
  • Valuation Type
  • I_OIJ06_MY_NOMINATIONS.MANDT == T149D.MANDT
  • I_OIJ06_MY_NOMINATIONS.VALUATIONTYPE == T149D.BWTAR
Valuation Type Destination Loc.
  • Client
  • Valuation Type Destination Loc.
  • I_OIJ06_MY_NOMINATIONS.MANDT == T149D.MANDT
  • I_OIJ06_MY_NOMINATIONS.VALUATIONTYPEDESTINATION == T149D.BWTAR
Valuation Type Origin Loc.
  • Client
  • Valuation Type Origin Loc.
  • I_OIJ06_MY_NOMINATIONS.MANDT == T149D.MANDT
  • I_OIJ06_MY_NOMINATIONS.VALUATIONTYPEORIGIN == T149D.BWTAR
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_OIJ06_MY_NOMINATIONS.MANDT == OIGV.CLIENT
  • I_OIJ06_MY_NOMINATIONS.VEHICLEID == OIGV.VEHICLE