I_PlanVsActualNomination

Plan Vs Actual Shipments | view: IPLANVSACTUAL | TRAN | Extraction: Not supported | Component: Downstream

Tables used: OIJNOMH, OIJNOMI, T023T, OIGV, MARA, LFA1, TVTRT, ADRC, T001K, T001W

🔑 Keys (2)
💰 Amounts
∑ Quantities (2)
📅 Dates (10)
☰ Categorical (4)
Other (26)
🔗 Relations (10)

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
IsBookedTransportSystem	Book TS indicator	Show values
IsReferenceDocument	Reference document indicator (PSX)	Show values
VehicleIsBlocked	Business Purpose Completed Indicator for Vehicle	Show values
NominationTicketChecked	Check Ticket date	Show values

Column Name	Description	Domain name
NominationExtNumber	Nomination number	OIJ_NOMNR
IsLoad	null
LocationName	Internal name field	CHAR35
LocationType	Business Location Type (IS-Oil MRN)	OIF_PBLTYP
MaterialGroupName	Product Group Description	TEXT20
CarrierName	null
ModeOfTransportText	Transportation Mode Description
VehicleDescription	null
PlannedStartDateTime	Scheduled / Acceptance / Pipe Batch Start Timestamp	TZNTSTMPS
NominationLocActlStrtDteTme	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
ActualStartDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
NominationDeltaActualPlan	null
DeltaLoadDischargeTime	null
PlannedTransitTime	null
ActualTransitTime	null
DeltaTransitTime	null
DeltaTransitTimeInPercent	null
NominationLocSpcfcDvtn	null
IsNominationLocationUnique	null
NominationDeltaQuantity	null
NominationEventType	Transit Time Event Type	OIJ07_EVTYPE
Events	Location Event Type	OIJ07_EVTYPE
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	`I_PLANVSACTUALNOMINATION.MANDT == T006.MANDT` `I_PLANVSACTUALNOMINATION.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI`
Import / Export Partner Client Import / Export Partner	`I_PLANVSACTUALNOMINATION.MANDT == LFA1.MANDT` `I_PLANVSACTUALNOMINATION.IMPORTEXPORTPARTNER == LFA1.LIFNR`
Location ID Client Location ID	`I_PLANVSACTUALNOMINATION.MANDT == OIJLOC.MANDT` `I_PLANVSACTUALNOMINATION.LOCATIONID == OIJLOC.LOCID`
Material Group Client Material Group	`I_PLANVSACTUALNOMINATION.MANDT == T023.MANDT` `I_PLANVSACTUALNOMINATION.MATERIALGROUP == T023.MATKL`
Mode of Transport Client Mode of Transport	`I_PLANVSACTUALNOMINATION.MANDT == TVTR.MANDT` `I_PLANVSACTUALNOMINATION.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA`
Schedule type Client Schedule type	`I_PLANVSACTUALNOMINATION.MANDT == TOIJ_EL_SITYPES.CLIENT` `I_PLANVSACTUALNOMINATION.NOMINATIONSCHEDULETYPE == TOIJ_EL_SITYPES.SITYP`
Scheduled UoM Client Scheduled UoM	`I_PLANVSACTUALNOMINATION.MANDT == T006.MANDT` `I_PLANVSACTUALNOMINATION.PLNDQTYUOM == T006.MSEHI`
Scheduled material Client Scheduled material	`I_PLANVSACTUALNOMINATION.MANDT == MARA.MANDT` `I_PLANVSACTUALNOMINATION.SCHEDULEDMATERIAL == MARA.MATNR`
Route Client Route	`I_PLANVSACTUALNOMINATION.MANDT == TVRO.MANDT` `I_PLANVSACTUALNOMINATION.SHIPPINGROUTE == TVRO.ROUTE`
TD Vehicle Number Client TD Vehicle Number	`I_PLANVSACTUALNOMINATION.MANDT == OIGV.CLIENT` `I_PLANVSACTUALNOMINATION.VEHICLEID == OIGV.VEHICLE`