I_NominationAnalysisPath

View for APF Nominations | view: ANALYSISPATH | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMH, OIJNOMI, OIJNE, OIGV, OIJTS
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
📏 Absolute tolerance UoM (ToleranceUnitAbs):
ToleranceOverAbs Absolute tolerance qty over
ToleranceUnderAbs Absolute tolerance qty under
📏 Absolute tolerance UoM (ToleranceUnitAbsTs):
ToleranceOverAbsTs Absolute tolerance qty over
ToleranceUnderAbsTs Absolute tolerance qty under
Column Name Description
NominationLastHeaderActionDate Last header action date
NominationChangedDate Last Changed On
NominationCreationDate Date on which the record was created
NominationCreationTime Time of creation
NominationScheduleDate Scheduled date
NominationEventChangedDate null
NominationEventChangedTime null
Column Name Description
IsReferenceDocument Reference document indicator (PSX) Show values
VehicleIsBlocked Business Purpose Completed Indicator for Vehicle Show values
IsBookedTransportSystem Book TS indicator Show values
NominationIsBlocked Blocking indicator Show values
NominationIsMarkedForDeletion Deletion indicator Show values
IsNominationWorklistEntry Worklist entry indicator Show values
QuickConfirmationCode Quick Confirm check box Show values
NominationItemIsComplete Nomination item complete flag Show values
IsNominationActual Nomination item partially complete Show values
IsUnlimited Unlimited Overdelivery Allowed Show values
IsUnlimitedTs Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
NominationExtNumber Nomination number OIJ_NOMNR
NominationReferenceDocument Nomination Reference Document OIJ_DOCNR
NominationPipelineCycleID Nomination Pipeline cycle ID CHAR10
NominationEventDefaultGroup TD - event default group OIG_EVGRP
NominationCreatedByUser Name of Person Responsible for Creating the Object USNAM
ContractPartner Contract Partner OIJ_PARTNR
ConsigneePartner Consignee Partner OIJ_PARTNR
NominationReferenceDocItem Nomination Reference Document Item NUM06
NominationReferenceDocType Reference Document Type CHAR04
NominationIsIncomplete null
NominationInspector Inspector OIJ_PARTNR
LocationPartner Location Partner OIJ_PARTNR
VehicleIdentifier TD vehicle identifier OIG_LICNMR
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
ToleranceOver Quantity tolerance over (percentage) DEC3_1
ToleranceUnder Quantity tolerance under (%) DEC3_1
ToleranceOverTs Quantity tolerance over (percentage) DEC3_1
ToleranceUnderTs Quantity tolerance under (%) DEC3_1
NominationEventType null
NominationEventComments Text field length 200 CHAR200
NominationGeneralComments Text field length 200 CHAR200
NominationTicketStatus Comment TEXT50
NumberOfNominationTickets 3-Byte field CHAR3
NominationEventNumber null
NominationEvents null
NominationDocComments null
NominationLoadIsToBeCopied null
NominationIsUpdated null
NominationIsToBeCopied null
NominationItemIsToBeCopied null
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Actual posted quantity Unit of Measure
  • Client
  • I_NOMINATIONANALYSISPATH.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
  • I_NOMINATIONANALYSISPATH.MANDT == T006.MANDT
TD shipment type
  • Client
  • TD shipment type
  • I_NOMINATIONANALYSISPATH.MANDT == TOIGS.CLIENT
  • I_NOMINATIONANALYSISPATH.BULKSHIPMENTTYPE == TOIGS.SHTYP
Business type
  • Client
  • Business type
  • I_NOMINATIONANALYSISPATH.MANDT == OIRARNBT.MANDT
  • I_NOMINATIONANALYSISPATH.BUSINESSTYPE == OIRARNBT.RNBT
Destination city code
  • Client
  • ?
  • Destination city code
  • ?
  • I_NOMINATIONANALYSISPATH.MANDT == T005G.MANDT
  • I_NOMINATIONANALYSISPATH.[column in domain "LAND1"] == T005G.LAND1
  • I_NOMINATIONANALYSISPATH.DESTINATIONCITYCODE == T005G.CITYC
  • I_NOMINATIONANALYSISPATH.[column in domain "REGIO"] == T005G.REGIO
Demand material
  • Client
  • Demand material
  • Demand material
  • I_NOMINATIONANALYSISPATH.MANDT == MARA.MANDT
  • I_NOMINATIONANALYSISPATH.DISCHARGEDEMANDMATERIALID == MARA.MATNR
  • I_NOMINATIONANALYSISPATH.LOADDEMANDMATERIALID == MARA.MATNR
Import / Export Partner
  • Import / Export Partner
  • Client
  • I_NOMINATIONANALYSISPATH.IMPORTEXPORTPARTNER == LFA1.LIFNR
  • I_NOMINATIONANALYSISPATH.MANDT == LFA1.MANDT
Transport system In-transit Plant
  • Client
  • Transport system In-transit Plant
  • I_NOMINATIONANALYSISPATH.MANDT == T001W.MANDT
  • I_NOMINATIONANALYSISPATH.INTRANSITPLANT == T001W.WERKS
Transport system In-transit Storage Location
  • Client
  • Transport system In-transit Plant
  • Transport system In-transit Storage Location
  • I_NOMINATIONANALYSISPATH.MANDT == T001L.MANDT
  • I_NOMINATIONANALYSISPATH.INTRANSITPLANT == T001L.WERKS
  • I_NOMINATIONANALYSISPATH.INTRANSITSTORAGELOCATION == T001L.LGORT
Import / Export Partner Indicator
  • Import / Export Partner Indicator
  • Client
  • I_NOMINATIONANALYSISPATH.ISIMPORTEXPORTPARTNER == OIJIMEX.FLAG_IMEX
  • I_NOMINATIONANALYSISPATH.MANDT == OIJIMEX.MANDT
Demand material
  • Client
  • Demand material
  • Demand material
  • I_NOMINATIONANALYSISPATH.MANDT == MARA.MANDT
  • I_NOMINATIONANALYSISPATH.DISCHARGEDEMANDMATERIALID == MARA.MATNR
  • I_NOMINATIONANALYSISPATH.LOADDEMANDMATERIALID == MARA.MATNR
Location ID
  • Client
  • Location ID
  • I_NOMINATIONANALYSISPATH.MANDT == OIJLOC.MANDT
  • I_NOMINATIONANALYSISPATH.LOCATIONID == OIJLOC.LOCID
Location Partner Plant
  • Client
  • Location Partner Plant
  • I_NOMINATIONANALYSISPATH.MANDT == T001W.MANDT
  • I_NOMINATIONANALYSISPATH.LOCATIONPLANT == T001W.WERKS
Nomination header status
  • Client
  • ?
  • Nomination header status
  • I_NOMINATIONANALYSISPATH.MANDT == OIJSTAT.MANDT
  • I_NOMINATIONANALYSISPATH.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • I_NOMINATIONANALYSISPATH.NOMINATIONHEADERSTATUS == OIJSTAT.STATUS
Nomination Item status
  • Client
  • ?
  • Nomination Item status
  • I_NOMINATIONANALYSISPATH.MANDT == OIJSTAT.MANDT
  • I_NOMINATIONANALYSISPATH.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • I_NOMINATIONANALYSISPATH.NOMINATIONITEMSTATUS == OIJSTAT.STATUS
Nomination Item sub-status
  • Nomination Item sub-status
  • Client
  • ?
  • Nomination Item status
  • I_NOMINATIONANALYSISPATH.NOMINATIONITEMSUBSTATUS == OIJSUBSTAT.SUBSTATUS
  • I_NOMINATIONANALYSISPATH.MANDT == OIJSUBSTAT.MANDT
  • I_NOMINATIONANALYSISPATH.[column in domain "OIJ_REFTAB"] == OIJSUBSTAT.TABNAME
  • I_NOMINATIONANALYSISPATH.NOMINATIONITEMSTATUS == OIJSUBSTAT.STATUS
Mode of Transport
  • Client
  • Mode of Transport
  • I_NOMINATIONANALYSISPATH.MANDT == TVTR.MANDT
  • I_NOMINATIONANALYSISPATH.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
Schedule type
  • Client
  • Schedule type
Nomination type
  • Client
  • Nomination type
  • I_NOMINATIONANALYSISPATH.MANDT == TOIJNOMTYP.MANDT
  • I_NOMINATIONANALYSISPATH.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Origin city code
  • Client
  • ?
  • Origin city code
  • ?
  • I_NOMINATIONANALYSISPATH.MANDT == T005G.MANDT
  • I_NOMINATIONANALYSISPATH.[column in domain "REGIO"] == T005G.REGIO
  • I_NOMINATIONANALYSISPATH.ORIGINCITYCODE == T005G.CITYC
  • I_NOMINATIONANALYSISPATH.[column in domain "LAND1"] == T005G.LAND1
Scheduled material
  • Client
  • Scheduled material
  • I_NOMINATIONANALYSISPATH.MANDT == MARA.MANDT
  • I_NOMINATIONANALYSISPATH.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • I_NOMINATIONANALYSISPATH.MANDT == T006.MANDT
  • I_NOMINATIONANALYSISPATH.SCHEDULEDQUANTITYUNIT == T006.MSEHI
Route
  • Client
  • Route
  • I_NOMINATIONANALYSISPATH.MANDT == TVRO.MANDT
  • I_NOMINATIONANALYSISPATH.SHIPPINGROUTE == TVRO.ROUTE
Absolute tolerance UoM
  • Client
  • Absolute tolerance UoM
  • I_NOMINATIONANALYSISPATH.MANDT == T006.MANDT
  • I_NOMINATIONANALYSISPATH.TOLERANCEUNITABS == T006.MSEHI
Absolute tolerance UoM
  • Absolute tolerance UoM
  • Client
  • I_NOMINATIONANALYSISPATH.TOLERANCEUNITABSTS == T006.MSEHI
  • I_NOMINATIONANALYSISPATH.MANDT == T006.MANDT
Transportation planning point
  • Client
  • Transportation planning point
  • I_NOMINATIONANALYSISPATH.MANDT == TTDS.MANDT
  • I_NOMINATIONANALYSISPATH.TRANSPORTATIONPLANNINGPOINT == TTDS.TPLST
Valuation Type
  • Client
  • Valuation Type
  • I_NOMINATIONANALYSISPATH.MANDT == T149D.MANDT
  • I_NOMINATIONANALYSISPATH.VALUATIONTYPE == T149D.BWTAR
Valuation Type Destination Loc.
  • Client
  • Valuation Type Destination Loc.
  • I_NOMINATIONANALYSISPATH.MANDT == T149D.MANDT
  • I_NOMINATIONANALYSISPATH.VALUATIONTYPEDESTINATION == T149D.BWTAR
Valuation Type Origin Loc.
  • Client
  • Valuation Type Origin Loc.
  • I_NOMINATIONANALYSISPATH.MANDT == T149D.MANDT
  • I_NOMINATIONANALYSISPATH.VALUATIONTYPEORIGIN == T149D.BWTAR
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_NOMINATIONANALYSISPATH.MANDT == OIGV.CLIENT
  • I_NOMINATIONANALYSISPATH.VEHICLEID == OIGV.VEHICLE