C_VisualNominations

Visual Nominations | view: CVISUALNOM | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMHOIJNOMIOIJNETOIGETT001TKA02KNA1OIJLOCMAKTMARAOIGVOIJTSTVTRTOIJLOCMATT001WT001KLFA1ADRC
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
NotificationStatusObject Email notification status Show values
Column Name Description Domain name
NominationDocDischargeItem null
LocationName Internal name field
LocationDischargeId null
DestinationLocationName null
VehicleDescription null
ModeOfTransportText Description
NominationExtNumber Nomination number
MaterialDesc Material Description
MaterialGroupName Comment
ProductHierarchyName Comment
CarrierName null
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp
DischargeBatchStartDateTime null
ScheduledBatchEndDateTime Scheduled / Acceptance / Pipe Batch End Timestamp
DischargeQuantityUnit null
ActualDischargeQuantityUnit null
NominationReferenceDocument Nomination Reference Document OIJ_DOCNR
NominationReferenceDocItem Nomination Reference Document Item NUM06
NominationReferenceDocType Reference Document Type CHAR04
DischargeReferenceDocument Single-Character Flag
NominationDischargeSchedType Component of the Version Number
ContractPartner Contract Partner OIJ_PARTNR
LocationPartner Location Partner OIJ_PARTNR
DischargeContractPartner Character Field with Length 10
DischargeLocationPartner Character Field with Length 10
DischargeLocationPlant Undefined range (can be used for patch levels)
Customer Customer Number KUNNR
CustomerName null
CustAddressNumber Address Number
CustomerCityName City
AddressNumber Address Number AD_ADDRNUM
SupplierAccount Account Number of Supplier
SupplierName null
SupplierCityName City
CityName City TEXT40
CountryName Country/Region Name TEXT50
Region Description
FromLatitude Char 20
FromLongitude Char 20
ToLatitude Char 20
ToLongitude Char 20
ConnectionPoints User variant
LocationPosition User variant
IsAlert Component of the Version Number
AlertText Char255
DischargeQtyAlertText Char255
IsLoadTimeAlert Component of the Version Number
LoadTimeAlertText Char255
IsDischargeTimeAlert Component of the Version Number
DischargeTimeAlertText Char255
IsLocationAlert Single-Character Flag
LocationAlertDesc Char255
IsDischargeLocAlert Single-Character Flag
DischargeLocAlertDesc Char255
NominationEventNumber TD - event number
NominationEventType null
NominationEventSequence TD - event sequence number
ActualStartDateTime 19 Characters
DischargeEventNumber Undefined range (can be used for patch levels)
DischargeEventType Undefined range (can be used for patch levels)
DischargeStartDateTime 19 Characters
DestinationLocation null
RouteText 30 Characters
IsLoad Component of the Version Number
IsNominationDocItem Character Field with Length 10
IsPegged Single-Character Flag
IsVariant Single-Character Flag
IsNominationLoad Single-Character Flag
IsNominationDischarge Single-Character Flag
BusinessPartnerRoleType OIL-TSW: Role partner type
NominationPegID Pegging identifier OIJ_PEGID
TransshipmentGroupID null
IsNominationActual Nomination item partially complete
IsBookedTransportSystem Book TS indicator
NominationItemIsComplete Nomination item complete flag
NominationItemStatusDesc Comment
DischargeNominationItemStatus Single-Character Flag
ItemDischargeStatusText Comment
IndicatorValue Component of the Version Number
StatusObject Component of the Version Number
NotificationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
NotificationText Character Field with Length 10
MaintenanceNotificationText Character Field with Length 10
IsCloudSystem Component of the Version Number
Simulation Component of the Version Number
Comments null
LoadDemandMaterialDesc Material Description
DischargeDemandMaterialDesc Material Description
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Actual posted quantity Unit of Measure
  • Client
  • C_VISUALNOMINATIONS.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
  • C_VISUALNOMINATIONS.MANDT == T006.MANDT
Company code
  • Company Code
  • Client
  • C_VISUALNOMINATIONS.COMPANYCODE == T001.BUKRS
  • C_VISUALNOMINATIONS.MANDT == T001.MANDT
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_VISUALNOMINATIONS.MANDT == T005.MANDT
  • C_VISUALNOMINATIONS.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_VISUALNOMINATIONS.CUSTOMERCOUNTRY == T005.LAND1
Demand material
  • Client
  • Demand material
  • Demand material
  • C_VISUALNOMINATIONS.MANDT == MARA.MANDT
  • C_VISUALNOMINATIONS.DISCHARGEDEMANDMATERIALID == MARA.MATNR
  • C_VISUALNOMINATIONS.LOADDEMANDMATERIALID == MARA.MATNR
Demand material
  • Client
  • Demand material
  • Demand material
  • C_VISUALNOMINATIONS.MANDT == MARA.MANDT
  • C_VISUALNOMINATIONS.DISCHARGEDEMANDMATERIALID == MARA.MATNR
  • C_VISUALNOMINATIONS.LOADDEMANDMATERIALID == MARA.MATNR
Location ID
  • Location ID
  • Client
  • C_VISUALNOMINATIONS.LOCATIONID == OIJLOC.LOCID
  • C_VISUALNOMINATIONS.MANDT == OIJLOC.MANDT
Location Partner Plant
  • Client
  • Location Partner Plant
  • C_VISUALNOMINATIONS.MANDT == T001W.MANDT
  • C_VISUALNOMINATIONS.LOCATIONPLANT == T001W.WERKS
Material Group
  • Client
  • Material Group
  • C_VISUALNOMINATIONS.MANDT == T023.MANDT
  • C_VISUALNOMINATIONS.MATERIALGROUP == T023.MATKL
Nomination header status
  • ?
  • Client
  • Nomination header status
  • C_VISUALNOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • C_VISUALNOMINATIONS.MANDT == OIJSTAT.MANDT
  • C_VISUALNOMINATIONS.NOMINATIONHEADERSTATUS == OIJSTAT.STATUS
Nomination Item status
  • ?
  • Client
  • Nomination Item status
  • C_VISUALNOMINATIONS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • C_VISUALNOMINATIONS.MANDT == OIJSTAT.MANDT
  • C_VISUALNOMINATIONS.NOMINATIONITEMSTATUS == OIJSTAT.STATUS
Mode of Transport
  • Mode of Transport
  • Client
  • C_VISUALNOMINATIONS.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
  • C_VISUALNOMINATIONS.MANDT == TVTR.MANDT
Schedule type
  • Client
  • Schedule type
Nomination type
  • Client
  • Nomination type
  • C_VISUALNOMINATIONS.MANDT == TOIJNOMTYP.MANDT
  • C_VISUALNOMINATIONS.NOMINATIONTYPE == TOIJNOMTYP.NOMTYP
Product Hierarchy
  • Client
  • Product hierarchy
  • C_VISUALNOMINATIONS.MANDT == T179.MANDT
  • C_VISUALNOMINATIONS.PRODUCTHIERARCHY == T179.PRODH
Scheduled material
  • Client
  • Scheduled material
  • C_VISUALNOMINATIONS.MANDT == MARA.MANDT
  • C_VISUALNOMINATIONS.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Scheduled UoM
  • Client
  • C_VISUALNOMINATIONS.SCHEDULEDQUANTITYUNIT == T006.MSEHI
  • C_VISUALNOMINATIONS.MANDT == T006.MANDT
Route
  • Route
  • Client
  • C_VISUALNOMINATIONS.SHIPPINGROUTE == TVRO.ROUTE
  • C_VISUALNOMINATIONS.MANDT == TVRO.MANDT
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • C_VISUALNOMINATIONS.MANDT == T005.MANDT
  • C_VISUALNOMINATIONS.SOURCELOCATIONCOUNTRY == T005.LAND1
  • C_VISUALNOMINATIONS.CUSTOMERCOUNTRY == T005.LAND1
Valuation Type
  • Client
  • Valuation Type
  • C_VISUALNOMINATIONS.MANDT == T149D.MANDT
  • C_VISUALNOMINATIONS.VALUATIONTYPE == T149D.BWTAR
TD Vehicle Number
  • TD Vehicle Number
  • Client
  • C_VISUALNOMINATIONS.VEHICLEID == OIGV.VEHICLE
  • C_VISUALNOMINATIONS.MANDT == OIGV.CLIENT