C_VisualSimulation

IPW Simulation in Visualization | view: CVISUSIM | 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
💲 Currency of the Shipment Cost Item (ShipmentLoadCostCrcy):
ShipmentLoadCost Logistics Cost in Document Currency
💲 Currency of the Shipment Cost Item (ShipmentDischargeCostCrcy):
ShipmentDischargeCost Logistics Cost in Document Currency
Column Name Description
📏 Scheduled UoM (ScheduledQuantityUnit):
ScheduledQuantity Scheduled qty
📏 Actual posted quantity Unit of Measure (ActualScheduledQuantityUnit):
ActualScheduledQuantity Actual posted quantity
DischargeSchedQuantity null
ActualDischargeQuantity null
SafetyStock OIl-TSW: Planning safety inventory level
CapacityStock OIL-TSW: Planning maximum inventory level
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
ActualEndDateTo TD Event actual end date to
NominationTicketLoadStartDate null
NominationTicketLoadStartTime null
NominationTicketDischargeDate null
NominationTicketDischargeTime null
Column Name Description
IsReferenceDocument Reference document indicator (PSX) Show values
NominationPeggingTypeUsage Pegging Type Usage Show values
IsNominationActual Nomination item partially complete Show values
IsBookedTransportSystem Book TS indicator Show values
NominationItemIsComplete Nomination item complete flag Show values
NominationItemStatus Nomination Item status Show values
NotificationStatusObject Email notification status Show values
Simulation Simulation Schedule category Show values
Column Name Description Domain name
NominationDocDischargeItem null
LocationId Location ID
LocationName Internal name field CHAR35
LocationDischargeId null
DestinationLocationName null
NominationModeOfTransport Mode of Transport
VehicleId TD Vehicle Number
VehicleDescription null
TransportSystem Transport system
ModeOfTransportText Description TEXT20
NominationHeaderStatus Nomination header status
NominationExtNumber Nomination number
NominationType Nomination type
ScheduledMaterial Scheduled material
MaterialDesc Material Description TEXT40
MaterialGroupName Comment TEXT50
ProductHierarchyName Comment TEXT50
NominationCarrier Transport system Carrier LIFNR
CarrierName null
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
DischargeBatchStartDateTime null
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
DischargeQuantityUnit null
ActualDischargeQuantityUnit null
NominationScheduleType Schedule type OIJ_SITYP
NominationReferenceDocument Nomination Reference Document OIJ_DOCNR
NominationReferenceDocItem Nomination Reference Document Item NUM06
NominationReferenceDocType Reference Document Type CHAR04
DischargeReferenceDocument Single-Character Flag CHAR1
NominationDischargeSchedType Component of the Version Number CHAR2
ContractPartner Contract Partner OIJ_PARTNR
LocationPartner Location Partner OIJ_PARTNR
LocationPlant null
DischargeContractPartner Character Field with Length 10 CHAR10
DischargeLocationPartner Character Field with Length 10 CHAR10
DischargeLocationPlant Undefined range (can be used for patch levels) CHAR4
Customer Customer Number KUNNR
CustomerName null
CustAddressNumber Address Number AD_ADDRNUM
CustomerCityName City TEXT40
AddressNumber Address Number AD_ADDRNUM
SupplierAccount Account Number of Supplier LIFNR
SupplierName null
SupplierCityName City TEXT40
CityName City TEXT40
CountryName Country/Region Name TEXT50
Region Description TEXT20
FromLatitude Char 20 CHAR20
FromLongitude Char 20 CHAR20
ToLatitude Char 20 CHAR20
ToLongitude Char 20 CHAR20
ConnectionPoints User variant STRING
LocationPosition User variant STRING
ShippingRoute Route ROUTE
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
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
DestinationLocation null
RouteText 30 Characters CHAR30
IsLoad Component of the Version Number CHAR2
IsNominationDocItem Character Field with Length 10 CHAR10
IsPegged Single-Character Flag CHAR1
IsVariant Single-Character Flag CHAR1
IsNominationLoad Single-Character Flag CHAR1
IsNominationDischarge Single-Character Flag CHAR1
BusinessPartnerRoleType OIL-TSW: Role partner type OIJ_RPART
ValuationType Valuation Type BWTAR
NominationPegID Pegging identifier OIJ_PEGID
TransshipmentGroupID null
NominationItemStatusDesc Comment TEXT50
DischargeNominationItemStatus Single-Character Flag CHAR1
ItemDischargeStatusText Comment TEXT50
IndicatorValue Component of the Version Number CHAR2
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
IsCloudSystem Component of the Version Number CHAR2
Comments null
LoadDemandMaterialId Demand material MATNR
DischargeDemandMaterialId Demand material MATNR
LoadDemandMaterialDesc Material Description TEXT40
DischargeDemandMaterialDesc Material Description TEXT40
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • C_VISUALSIMULATION.MANDT == T001.MANDT
  • C_VISUALSIMULATION.COMPANYCODE == T001.BUKRS
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_VISUALSIMULATION.MANDT == T005.MANDT
  • C_VISUALSIMULATION.CUSTOMERCOUNTRY == T005.LAND1
  • C_VISUALSIMULATION.SOURCELOCATIONCOUNTRY == T005.LAND1
Material Group
  • Client
  • Material Group
  • C_VISUALSIMULATION.MANDT == T023.MANDT
  • C_VISUALSIMULATION.MATERIALGROUP == T023.MATKL
Product Hierarchy
  • Client
  • Product hierarchy
  • C_VISUALSIMULATION.MANDT == T179.MANDT
  • C_VISUALSIMULATION.PRODUCTHIERARCHY == T179.PRODH
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_VISUALSIMULATION.MANDT == T005.MANDT
  • C_VISUALSIMULATION.CUSTOMERCOUNTRY == T005.LAND1
  • C_VISUALSIMULATION.SOURCELOCATIONCOUNTRY == T005.LAND1