I_VisualAnalysis

Visual Analysis | view: IVISUALANALYSIS | Extraction: Not supported | Component: Downstream
Column Name Description
NominationDoc Nomination (technical) Key
NominationDocItem Nomination Key Item
Column Name Description
Column Name Description
ActualDischargeQuantity null
DeltaLoadQuantity null
DeltaDischargeQuantity null
📏 Scheduled UoM (ScheduledQuantityUnit):
ScheduledQuantity Scheduled qty
📏 Actual posted quantity Unit of Measure (ActualScheduledQuantityUnit):
ActualScheduledQuantity Actual posted quantity
Column Name Description
NominationScheduleDate Scheduled date
ActualStartDateFrom TD - Actual Start Date of Event (From)
ActualStartTimeFrom TD - Actual Start Time of Event (From)
DischargeDate null
DischargeTime 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
Column Name Description Domain name
NominationDocDischargeItem null
IsNominationDocItem Character Field with Length 10 CHAR10
IsLoad Component of the Version Number CHAR2
ModeOfTransportText Description TEXT20
DestinationLocation null
NominationReferenceDocument Nomination Reference Document OIJ_DOCNR
NominationCalendarWeek Year Week NUM6
NominationCalendarMonth Year Month NUM6
NominationCalendarYear Calendar Year NUM4
ScheduledBatchStartDateTime Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
TransitTime null
DischargeBatchStartDateTime null
DeltaLoadDischargeTime null
NominationOverallLoad null
NominationOvrlDischarge null
NominationDocItmIndicator Component of the Version Number CHAR2
DeltaText Char 15 CHAR15
DeltaDischargeText Char 15 CHAR15
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
  • Actual posted quantity Unit of Measure
  • Client
  • I_VISUALANALYSIS.ACTUALSCHEDULEDQUANTITYUNIT == T006.MSEHI
  • I_VISUALANALYSIS.MANDT == T006.MANDT
Company code
  • Client
  • Company Code
  • I_VISUALANALYSIS.MANDT == T001.MANDT
  • I_VISUALANALYSIS.COMPANYCODE == T001.BUKRS
Import / Export Partner
  • Client
  • Import / Export Partner
  • I_VISUALANALYSIS.MANDT == LFA1.MANDT
  • I_VISUALANALYSIS.IMPORTEXPORTPARTNER == LFA1.LIFNR
Location ID
  • Client
  • Location ID
  • I_VISUALANALYSIS.MANDT == OIJLOC.MANDT
  • I_VISUALANALYSIS.LOCATIONID == OIJLOC.LOCID
Material Group
  • Client
  • Material Group
  • I_VISUALANALYSIS.MANDT == T023.MANDT
  • I_VISUALANALYSIS.MATERIALGROUP == T023.MATKL
Nomination Item status
  • ?
  • Nomination Item status
  • Client
  • I_VISUALANALYSIS.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • I_VISUALANALYSIS.NOMINATIONITEMSTATUS == OIJSTAT.STATUS
  • I_VISUALANALYSIS.MANDT == OIJSTAT.MANDT
Mode of Transport
  • Client
  • Mode of Transport
  • I_VISUALANALYSIS.MANDT == TVTR.MANDT
  • I_VISUALANALYSIS.NOMINATIONMODEOFTRANSPORT == TVTR.VKTRA
Schedule type
  • Client
  • Schedule type
Scheduled material
  • Client
  • Scheduled material
  • I_VISUALANALYSIS.MANDT == MARA.MANDT
  • I_VISUALANALYSIS.SCHEDULEDMATERIAL == MARA.MATNR
Scheduled UoM
  • Client
  • Scheduled UoM
  • I_VISUALANALYSIS.MANDT == T006.MANDT
  • I_VISUALANALYSIS.SCHEDULEDQUANTITYUNIT == T006.MSEHI
Route
  • Client
  • Route
  • I_VISUALANALYSIS.MANDT == TVRO.MANDT
  • I_VISUALANALYSIS.SHIPPINGROUTE == TVRO.ROUTE
TD Vehicle Number
  • Client
  • TD Vehicle Number
  • I_VISUALANALYSIS.MANDT == OIGV.CLIENT
  • I_VISUALANALYSIS.VEHICLEID == OIGV.VEHICLE