C_PlanVsActualNomination

Plan Vs Actual Shipments | view: CPLANVSACTUAL | Extraction: Not supported | Component: Downstream
Tables used: OIJNOMHOIJNOMIT023TOIGVMARALFA1TVTRTADRCT001KT001W
Column Name Description
NominationDoc Nomination (technical) Key
NominationDocItem Nomination Key Item
Column Name Description
Column Name Description
📏 Scheduled UoM (PlndQtyUoM):
PlannedQuantity Scheduled qty
📏 Actual posted quantity Unit of Measure (ActualScheduledQuantityUnit):
ActualScheduledQuantity Actual posted quantity
Column Name Description
PlannedStartDate null
PlannedStartTime null
ActualStartDateFrom null
ActualStartTimeFrom null
NominationLocationActualDate null
NominationLocationActualTime null
NominationTicketLoadStartDate null
NominationTicketLoadStartTime null
NominationActualDate null
NominationActualTime null
Column Name Description
NominationTicketChecked Check Ticket date Show values
VehicleIsBlocked Business Purpose Completed Indicator for Vehicle Show values
Column Name Description Domain name
NominationExtNumber Nomination number
IsLoad null
IsBookedTransportSystem Book TS indicator
IsReferenceDocument Reference document indicator (PSX)
LocationName Internal name field
LocationType Business Location Type (IS-Oil MRN)
MaterialGroupName Product Group Description
CarrierName null
ModeOfTransportText Transportation Mode Description
VehicleDescription null
PlannedStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp
NominationLocActlStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ActualStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
NominationDeltaActualPlan null
PlannedTransitTime null
ActualTransitTime null
DeltaTransitTime null
DeltaTransitTimeInPercent null
NominationLocSpcfcDvtn null
IsNominationLocationUnique null
NominationDeltaQuantity null
NominationEventType Transit Time Event Type
Events Location Event Type
NominationInspector Inspector OIJ_PARTNR
ConsigneePartner Consignee Partner OIJ_PARTNR
ContractPartner Contract Partner OIJ_PARTNR
LocationPartner Location Partner OIJ_PARTNR
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • C_PLANVSACTUALNOMINATION.MANDT == T006.MANDT
  • C_PLANVSACTUALNOMINATION.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
Import / Export Partner
  • Client
  • Import / Export Partner
  • C_PLANVSACTUALNOMINATION.MANDT == LFA1.MANDT
  • C_PLANVSACTUALNOMINATION.IMPORTEXPORTPARTNER == LFA1.LIFNR
Location ID
  • Location ID
  • Client
  • C_PLANVSACTUALNOMINATION.LOCATIONID == OIJLOC.LOCID
  • C_PLANVSACTUALNOMINATION.MANDT == OIJLOC.MANDT
Material Group
  • Client
  • Material Group
  • C_PLANVSACTUALNOMINATION.MANDT == T023.MANDT
  • C_PLANVSACTUALNOMINATION.MATERIALGROUP == T023.MATKL
Mode of Transport
  • Mode of Transport
  • Client
  • C_PLANVSACTUALNOMINATION.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
  • C_PLANVSACTUALNOMINATION.MANDT == TVTR.MANDT
Schedule type
  • Client
  • Schedule type
Scheduled UoM
  • Scheduled UoM
  • Client
  • C_PLANVSACTUALNOMINATION.PLNDQTYUOM == T006.MSEHI
  • C_PLANVSACTUALNOMINATION.MANDT == T006.MANDT
Scheduled material
  • Scheduled material
  • Client
  • C_PLANVSACTUALNOMINATION.SCHEDULEDMATERIAL == MARA.MATNR
  • C_PLANVSACTUALNOMINATION.MANDT == MARA.MANDT
Route
  • Route
  • Client
  • C_PLANVSACTUALNOMINATION.SHIPPINGROUTE == TVRO.ROUTE
  • C_PLANVSACTUALNOMINATION.MANDT == TVRO.MANDT
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • C_PLANVSACTUALNOMINATION.MANDT == OIGV.CLIENT
  • C_PLANVSACTUALNOMINATION.VEHICLEID == OIGV.VEHICLE