I_TranspOrdExecForBusDshbrdC

TOR Exec Analytics for SAC Dshbrd - Cube | view: ITOREXESACCANA | TRAN | Extraction: Not supported | Component: Analytics
Column Name Description
TransportationOrderEventUUID Transportation Order Event UUID
Column Name Description
Column Name Description
📏 Transportation Order Event Delay Unit of Measure (TranspOrdEventDelayUnit):
TranspOrdEventDelayInHours Transportation Order Event Delay in Display Unit
TranspOrdEventReqActlDlyInHrs Transp Order Event Delay (Requested-Actual) in Display Unit
TranspOrdEvtConfdActlDlyInHrs Transp Order Event Delay (Confirmed-Actual) in Display Unit
📏 Transportation Order Event Delay Display Unit (TranspOrdEventDelayDisplayUnit):
TranspOrdEventDelayDsp Transportation Order Event Delay in Display Unit
TranspOrdEventReqActlDelayDsp Transp Order Event Delay (Requested-Actual) in Display Unit
TranspOrdEventConfdActlDlyDsp Transp Order Event Delay (Confirmed-Actual) in Display Unit
Column Name Description
TranspOrdCreationDate Transportation Order Creation Date
Column Name Description
TranspOrdEventStatus Event Status Show values
TranspOrdEventIsRecalled Event Has Been Recalled Show values
TransportationOrderCategory Transportation Order Category Show values
TransportationOrderExecSts Transportation Order Execution Status Show values
TranspOrdEvtReqConfdIsOnTime Transp Order Event is on-time (requested vs confirmed) Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID /SCMTMS/VDM_TOR_DB_KEY
TransportationOrderStopUUID Transportation Order Stop UUID /BOBF/CONF_KEY
TransportationOrderItemUUID Transportation Order Item UUID /BOBF/CONF_KEY
TranspOrdExecution Transportation Order Execution ID /SCMTMS/ITEM_ID
TranspOrdEventCode Event Occuring for a Transportation Activity /SCMTMS/TOR_EVENT
TranspOrdEventReasonCode Transportation Order Event Reason Code /SCMTMS/EVT_REASON_INT_CODE
TranspOrdEventReasonDesc Transportation Order Event Reason Description /SCMTMS/TEXT100
TranspOrdEvtActualDateTime Transportation Order Event Actual Date Time TZNTSTMPS
TranspOrdEvtExpdEndDateTime Transportation Order Event Expected End Date Time TZNTSTMPS
TranspOrdCreationYearWeek Transportation Order Creation Year Week NUM6
TranspOrdCreationYearMonth Transportation Order Creation Year Month NUM6
TranspOrdCreationYearQuarter Transportation Order Creation Year Quarter NUM5
TranspOrdCreationYear Transportation Order Creation Year NUM4
FreightOrder Freight Order /SCMTMS/TOR_ID
Carrier Carrier /SCMTMS/BU_PARTNER
Shipper Shipper BU_PARTNER
Consignee Ship-to Party BU_PARTNER
TransportationOrderStop Transportation Order Stop /SCMTMS/STOP_ID
TranspOrdStopPlanTranspDteTme Transportation Order Stop Plan Transportation Date Time TZNTSTMPS
TranspOrdStopReqStartDteTme Transportation Order Stop Requested Start Date Time TZNTSTMPS
TranspOrdStopReqEndDteTme Transportation Order Stop Requested End Date Time TZNTSTMPS
TranspStopCarrConfStrtDteTme Transportation Order Stop Carrier Conf Start Date Time TZNTSTMPS
TranspStopCarrConfEndDteTme Transportation Stop Carrier Conf End Date Time TZNTSTMPS
TranspOrdStageSrceLocation Transportation Order Stage Source Location /SAPAPO/LOCNO
TranspOrdStageDestLocation Transportation Order Stage Destination Location /SAPAPO/LOCNO
NumberOfTranspOrdEvents Number of Transportation Order Events /SCMTMS/VDM_NUMBER_OF
NumberOfOnTimeTranspOrdEvents Number of On Time Events /SCMTMS/VDM_NUMBER_OF
NmbrOfOnTimeTranspEvtReqActl Number of On Time Transp Ord Events (requested vs actual) /SCMTMS/VDM_NUMBER_OF
NmbrOfOnTimeTranspEvtConfdActl Number of On Time Transp Ord Events (confirmed vs actual) /SCMTMS/VDM_NUMBER_OF
NmbrOfOnTimeTranspEvtReqConfd Number of On Time Transp Ord Events (requested vs confirmed) /SCMTMS/VDM_NUMBER_OF
HundredInPercent Hundred In Percent DEC3
NumberOfFreightOrders Number of Freight Orders /SCMTMS/VDM_NUMBER_OF
NumberOfDelayedFreightOrders Number of Delayed Freight Orders /SCMTMS/VDM_NUMBER_OF
Master Data Relations Join Conditions
Transportation Activity
  • Client
  • Transportation Activity
  • I_TRANSPORDEXECFORBUSDSHBRDC.MANDT == /SCMTMS/C_TRAC.MANDT
  • I_TRANSPORDEXECFORBUSDSHBRDC.TRANSPORTATIONACTIVITY == /SCMTMS/C_TRAC.TRANSP_ACTIVITY
Transportation Order Type
  • Client
  • Transportation Order Type