I_VisualNominations

Visual Nominations | view: IVISUALNOM | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMHOIJNOMIOIJNETOIGETT001TKA02KNA1OIJLOCMAKTMARAOIGVOIJTSTVTRTOIJLOCMATT001WT001KLFA1ADRC
Column Name Description
NominationDoc Nomination (technical) Key
NominationDocItem Nomination Key Item
Column Name Description
ShipmentLoadCost Logistics Cost in Document Currency
ShipmentDischargeCost Logistics Cost in Document Currency
Column Name Description
📏 Scheduled UoM (ScheduledQuantityUnit):
ScheduledQuantity Scheduled qty
DischargeSchedQuantity null
ActualDischargeQuantity null
SafetyStock OIl-TSW: Planning safety inventory level
CapacityStock OIL-TSW: Planning maximum inventory level
📏 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
NominationScheduleDate Scheduled date
NominationScheduledTime null
PlannedDischargeDate null
NominationDischargeTime null
NominationEventChangedDate null
NominationEventChangedTime null
ActualStartDateFrom TD - Actual Start Date of Event (From)
ActualStartTimeFrom TD - Actual Start Time of Event (From)
DischargeDate null
DischargeTime null
ActualStartDateTo TD - Actual Start Date of Event (To)
ActualStartTimeTo TD - Actual Start Time of Event (To)
ActualEndDateFrom TD Event actual end date from
ActualEndTimeFrom TD Event actual end time from
ActualEndDateTo TD Event actual end date to
ActualEndTimeTo TD Event actual end time to
NominationTicketLoadStartDate null
NominationTicketLoadStartTime null
NominationTicketDischargeDate null
NominationTicketDischargeTime null
Column Name Description
IsReferenceDocument Reference document indicator (PSX) Show values
IsNominationActual Nomination item partially complete Show values
IsBookedTransportSystem Book TS indicator Show values
NominationItemIsComplete Nomination item complete flag Show values
IsUnlimited Unlimited Overdelivery Allowed Show values
IsUnlimitedTs Unlimited Overdelivery Allowed Show values
NominationPeggingTypeUsage Pegging Type Usage Show values
NotificationStatusObject Email notification status Show values
Column Name Description Domain name
NominationDocDischargeItem null
NominationExtNumber Nomination number OIJ_NOMNR
VehicleDescription null
ModeOfTransportText Description TEXT20
CarrierName null
LocationDischargeId null
LocationName Internal name field CHAR35
DestinationLocationName null
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
DischargeBatchStartDateTime null
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
DischargeQuantityUnit null
ActualDischargeQuantityUnit null
ContractPartner Contract Partner OIJ_PARTNR
LocationPartner Location Partner OIJ_PARTNR
NominationReferenceDocument Nomination Reference Document OIJ_DOCNR
NominationReferenceDocItem Nomination Reference Document Item NUM06
NominationReferenceDocType Reference Document Type CHAR04
MaterialDesc Material Description TEXT40
DischargeNominationItemStatus Single-Character Flag CHAR1
NominationItemStatusDesc Comment TEXT50
ItemDischargeStatusText Comment TEXT50
MaterialGroupName Comment TEXT50
ProductHierarchyName Comment TEXT50
Customer Customer Number KUNNR
CustomerName null
SupplierAccount Account Number of Supplier LIFNR
SupplierName null
CustAddressNumber Address Number AD_ADDRNUM
CustomerCityName City TEXT40
AddressNumber Address Number AD_ADDRNUM
SupplierCityName City TEXT40
CityName City TEXT40
CountryName Country/Region Name TEXT50
Region Description TEXT20
BusinessPartnerRoleType OIL-TSW: Role partner type OIJ_RPART
FromLatitude Char 20 CHAR20
FromLongitude Char 20 CHAR20
ToLatitude Char 20 CHAR20
ToLongitude Char 20 CHAR20
ConnectionPoints User variant STRING
LocationPosition User variant STRING
RouteText 30 Characters CHAR30
IsAlert Component of the Version Number CHAR2
AlertText Char255 CHAR255
DischargeQtyAlertText Char255 CHAR255
IsLoadTimeAlert Component of the Version Number CHAR2
LoadTimeAlertText Char255 CHAR255
IsDischargeTimeAlert Component of the Version Number CHAR2
DischargeTimeAlertText Char255 CHAR255
IsLocationAlert Single-Character Flag CHAR1
LocationAlertDesc Char255 CHAR255
IsDischargeLocAlert Single-Character Flag CHAR1
DischargeLocAlertDesc Char255 CHAR255
IsLoad Component of the Version Number CHAR2
IsNominationDocItem Character Field with Length 10 CHAR10
IsPegged Single-Character Flag CHAR1
NominationEventNumber TD - event number OIG_EVNR
NominationEventType null
NominationEventSequence TD - event sequence number OIG_EVSEQ
ActualStartDateTime 19 Characters CHAR19
DischargeEventNumber Undefined range (can be used for patch levels) CHAR4
DischargeEventType Undefined range (can be used for patch levels) CHAR4
DischargeStartDateTime 19 Characters CHAR19
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
DestinationLocation null
IsVariant Single-Character Flag CHAR1
IsNominationLoad Single-Character Flag CHAR1
IsNominationDischarge Single-Character Flag CHAR1
NominationPegID Pegging identifier OIJ_PEGID
TransshipmentGroupID null
DischargeReferenceDocument Single-Character Flag CHAR1
NominationDischargeSchedType Component of the Version Number CHAR2
DischargeContractPartner Character Field with Length 10 CHAR10
DischargeLocationPartner Character Field with Length 10 CHAR10
DischargeLocationPlant Undefined range (can be used for patch levels) CHAR4
StatusObject Component of the Version Number CHAR2
NotificationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NotificationText Character Field with Length 10 CHAR10
MaintenanceNotificationText Character Field with Length 10 CHAR10
IndicatorValue Component of the Version Number CHAR2
IsCloudSystem Component of the Version Number CHAR2
Simulation Component of the Version Number CHAR2
Comments null
LoadDemandMaterialDesc Material Description TEXT40
DischargeDemandMaterialDesc Material Description TEXT40
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • I_VISUALNOMINATIONS.MANDT == T006.MANDT
  • I_VISUALNOMINATIONS.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
Company code
  • Company Code
  • Client
  • I_VISUALNOMINATIONS.COMPANYCODE == T001.BUKRS
  • I_VISUALNOMINATIONS.MANDT == T001.MANDT
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_VISUALNOMINATIONS.MANDT == T005.MANDT
  • I_VISUALNOMINATIONS.CUSTOMERCOUNTRY == T005.LAND1
  • I_VISUALNOMINATIONS.SOURCELOCATIONCOUNTRY == T005.LAND1
Demand material
  • Client
  • Demand material
  • Demand material
  • I_VISUALNOMINATIONS.MANDT == MARA.MANDT
  • I_VISUALNOMINATIONS.DISCHARGEDEMANDMATERIALID == MARA.MATNR
  • I_VISUALNOMINATIONS.LOADDEMANDMATERIALID == MARA.MATNR
Demand material
  • Client
  • Demand material
  • Demand material
  • I_VISUALNOMINATIONS.MANDT == MARA.MANDT
  • I_VISUALNOMINATIONS.DISCHARGEDEMANDMATERIALID == MARA.MATNR
  • I_VISUALNOMINATIONS.LOADDEMANDMATERIALID == MARA.MATNR
Location ID
  • Client
  • Location ID
  • I_VISUALNOMINATIONS.MANDT == OIJLOC.MANDT
  • I_VISUALNOMINATIONS.LOCATIONID == OIJLOC.LOCID
Location Partner Plant
  • Location Partner Plant
  • Client
  • I_VISUALNOMINATIONS.LOCATIONPLANT == T001W.WERKS
  • I_VISUALNOMINATIONS.MANDT == T001W.MANDT
Material Group
  • Client
  • Material Group
  • I_VISUALNOMINATIONS.MANDT == T023.MANDT
  • I_VISUALNOMINATIONS.MATERIALGROUP == T023.MATKL
Nomination header status
  • Client
  • Nomination header status
  • ?
  • I_VISUALNOMINATIONS.MANDT == OIJSTAT.MANDT
  • I_VISUALNOMINATIONS.NOMINATIONHEADERSTATUS == OIJSTAT.STATUS
  • I_VISUALNOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
Nomination Item status
  • Client
  • ?
  • Nomination Item status
  • I_VISUALNOMINATIONS.MANDT == OIJSTAT.MANDT
  • I_VISUALNOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • I_VISUALNOMINATIONS.NOMINATIONITEMSTATUS == OIJSTAT.STATUS
Mode of Transport
  • Client
  • Mode of Transport
  • I_VISUALNOMINATIONS.MANDT == TVTR.MANDT
  • I_VISUALNOMINATIONS.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
Schedule type
  • Client
  • Schedule type
Nomination type
  • Client
  • Nomination type
  • I_VISUALNOMINATIONS.MANDT == TOIJNOMTYP.MANDT
  • I_VISUALNOMINATIONS.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Product Hierarchy
  • Client
  • Product hierarchy
  • I_VISUALNOMINATIONS.MANDT == T179.MANDT
  • I_VISUALNOMINATIONS.PRODUCTHIERARCHY == T179.PRODH
Scheduled material
  • Client
  • Scheduled material
  • I_VISUALNOMINATIONS.MANDT == MARA.MANDT
  • I_VISUALNOMINATIONS.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • I_VISUALNOMINATIONS.MANDT == T006.MANDT
  • I_VISUALNOMINATIONS.SCHEDULEDQUANTITYUNIT == T006.MSEHI
Route
  • Client
  • Route
  • I_VISUALNOMINATIONS.MANDT == TVRO.MANDT
  • I_VISUALNOMINATIONS.SHIPPINGROUTE == TVRO.ROUTE
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_VISUALNOMINATIONS.MANDT == T005.MANDT
  • I_VISUALNOMINATIONS.CUSTOMERCOUNTRY == T005.LAND1
  • I_VISUALNOMINATIONS.SOURCELOCATIONCOUNTRY == T005.LAND1
Absolute tolerance UoM
  • Client
  • Absolute tolerance UoM
  • I_VISUALNOMINATIONS.MANDT == T006.MANDT
  • I_VISUALNOMINATIONS.TOLERANCEUNITABS == T006.MSEHI
Absolute tolerance UoM
  • Client
  • Absolute tolerance UoM
  • I_VISUALNOMINATIONS.MANDT == T006.MANDT
  • I_VISUALNOMINATIONS.TOLERANCEUNITABSTS == T006.MSEHI
Valuation Type
  • Client
  • Valuation Type
  • I_VISUALNOMINATIONS.MANDT == T149D.MANDT
  • I_VISUALNOMINATIONS.VALUATIONTYPE == T149D.BWTAR
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_VISUALNOMINATIONS.MANDT == OIGV.CLIENT
  • I_VISUALNOMINATIONS.VEHICLEID == OIGV.VEHICLE