I_VisualSimulation

IPW Simulation in Visualization | view: IVISUSIM | Extraction: Not supported | Component: Downstream
Tables used: OIJNE, OIJNOMH, OIJNOMI, TOIGET, KNA1, OIJLOC, MAKT, MARA, TVTRT, OIJTS, OIJLOCMAT, LFA1, ADRC, T001K, T001W
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
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
ActualStartDateFrom TD - Actual Start Date of Event (From)
ActualStartTimeFrom TD - Actual Start Time of Event (From)
NominationEventChangedDate null
NominationEventChangedTime null
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
NominationScheduledTime null
PlannedDischargeDate null
NominationDischargeTime null
Column Name Description
NominationHeaderStatus Nomination header status Show values
IsReferenceDocument Reference document indicator (PSX) Show values
IsBookedTransportSystem Book TS indicator Show values
NominationIsBlocked Blocking indicator Show values
NominationIsMarkedForDeletion Deletion indicator Show values
NominationIsIncomplete Incompletion Flag Show values
NominationItemStatus Nomination Item status Show values
NominationItemSubStatus Nomination Item sub-status Show values
IsNominationWorklistEntry Worklist entry indicator Show values
NominationItemIsComplete Nomination item complete flag Show values
IsNominationActual Nomination item partially complete Show values
NominationPeggingTypeUsage Pegging Type Usage Show values
NotificationStatusObject Email notification status Show values
Simulation Simulation Schedule category Show values
Column Name Description Domain name
NominationDocDischargeItem null
NominationExtNumber Nomination number OIJ_NOMNR
NominationType Nomination type OIJ_NOMTYP
LocationId Location ID OIJ_LOCID
LocationName Internal name field CHAR35
LocationDischargeId null
DestinationLocationName null
ScheduledMaterial Scheduled material MATNR
DischargeQuantityUnit null
NominationReferenceDocument Nomination Reference Document OIJ_DOCNR
NominationPipelineCycleID Nomination Pipeline cycle ID CHAR10
NominationShipper Shipper LIFNR
NominationCarrier Transport system Carrier LIFNR
CarrierName null
InTransitPlant Transport system In-transit Plant WERKS
InTransitStorageLocation Transport system In-transit Storage Location LGORT
VehicleId TD Vehicle Number OIG_VHLNMR
VehicleDescription null
TransportSystem Transport system OIJ_TSYST
TransportationPlanningPoint Transportation planning point TPLST
ShippingRoute Route ROUTE
NominationEventDefaultGroup TD - event default group OIG_EVGRP
BulkShipmentType TD shipment type OIG_TDSTYP
NominationModeOfTransport Mode of Transport VKTRA
ModeOfTransportText Description TEXT20
BusinessType Business type OIRA_RNBT
VehicleIdentifier TD vehicle identifier OIG_LICNMR
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
IsImportExportPartner Import / Export Partner Indicator OIJ_IMEXFL
BatchOriginLocation Batch origin Location CHARG
BatchDestinationLocation Batch destination Location CHARG
ImportExportPartner Import / Export Partner LIFNR
NominationInspector Inspector OIJ_PARTNR
LoadDemandMaterialId Demand material MATNR
DischargeDemandMaterialId Demand material MATNR
LocationPartner Location Partner OIJ_PARTNR
LocationPlant null
NominationScheduleType Schedule type OIJ_SITYP
ValuationType Valuation Type BWTAR
ValuationTypeDestination Valuation Type Destination Loc. BWTAR
ValuationTypeOrigin Valuation Type Origin Loc. BWTAR
ActualDischargeQuantityUnit null
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
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
DischargeBatchStartDateTime null
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
Comments null
LoadDemandMaterialDesc Material Description TEXT40
DischargeDemandMaterialDesc Material Description TEXT40
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • I_VISUALSIMULATION.COMPANYCODE == T001.BUKRS
  • I_VISUALSIMULATION.MANDT == T001.MANDT
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_VISUALSIMULATION.MANDT == T005.MANDT
  • I_VISUALSIMULATION.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_VISUALSIMULATION.CUSTOMERCOUNTRY == T005.LAND1
Material Group
  • Client
  • Material Group
  • I_VISUALSIMULATION.MANDT == T023.MANDT
  • I_VISUALSIMULATION.MATERIALGROUP == T023.MATKL
Product Hierarchy
  • Client
  • Product hierarchy
  • I_VISUALSIMULATION.MANDT == T179.MANDT
  • I_VISUALSIMULATION.PRODUCTHIERARCHY == T179.PRODH
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_VISUALSIMULATION.MANDT == T005.MANDT
  • I_VISUALSIMULATION.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_VISUALSIMULATION.CUSTOMERCOUNTRY == T005.LAND1