I_TranspOrdExecution2

Transportation Order Execution 2 | view: ITOREXECUTION2 | TRAN | Extraction: Not supported | Component: Analytics
Tables used: SCAL_TT_DATE, /SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORSTP, ADCP, ADRC, BUT000, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, /SCMB/HRP5561, T77S0
Column Name Description
TransportationOrderEventUUID NodeID
Column Name Description
Column Name Description
📏 Transportation Order Event Delay Unit of Measure (TranspOrdEventDelayUnit):
TranspOrdEventDelay Transportation Order Event Delay
📏 Transportation Order Execution Gross Weight Unit (TranspOrdExecGrossWeightUnit):
TranspOrdExecGrossWeight Transportation Order Execution Gross Weight
📏 Transportation Order Execution Gross Volume Unit (TranspOrdExecGrossVolumeUnit):
TranspOrdExecGrossVolume Transportation Order Execution Gross Volume
📏 Transportation Order Execution Net Weight Unit (TranspOrdExecNetWeightUnit):
TranspOrdExecNetWeight Transportation Order Execution Net Weight
📏 Transportation Order Execution Quantity Unit (TranspOrdExecQuantityUnit):
TranspOrdExecQuantity Transportation Order Execution Quantity
📏 Transportation Order Execution Alternative Quantity Unit (TranspOrdExecAltvQtyUnit):
TranspOrdExecAltvQty Transportation Order Execution Alternative Quantity
📏 Transportation Order Execution Base Quantity Unit (TranspOrdExecBaseQtyUnit):
TranspOrdExecBaseQty Transportation Order Execution Base Qantity
📏 Transportation Order Execution Tare Weight Unit (TranspOrdExecTareWeightUnit):
TranspOrdExecTareWeight Transportation Order Execution Tare Weight
📏 Transportation Order Execution Number of Containers Unit (TranspOrdExecNumberOfCtnsUnit):
TranspOrdExecNumberOfCtns Transportation Order Execution Number of Containers
📏 Transp Order Execution Dangerous Goods Exemptionpoints Unit (TranspOrdExecDngrsGdsExmppUnit):
TranspOrdExecDngrsGdsExmpp Transp Order Execution Dangerous Goods Exemptionpoints
📏 Transportation Order Execution Length Unit (TranspOrdExecLengthUnit):
TranspOrdExecLength Transportation Order Execution Length
TranspOrdExecWidth Transportation Order Execution Width
TranspOrdExecHeight Transportation Order Execution Height
Column Name Description
TranspOrdEvtActualDate Transportation Order Event Actual Date
TranspOrdEvtExpdEndDate Transportation Order Event Expected End Date
Column Name Description
TranspOrdEventIsTimeRelevant Transportation Order Event Is Time Relevant Show values
TranspOrdEventIsOnTime Transportation Order Event Is On Time Show values
TranspOrdEventIsDelayed Transportation Order Event is Delayed Show values
TranspOrdEventStatus Event Status Show values
TranspOrdEventIsRecalled Event Has Been Recalled Show values
TranspOrdHasQtyDiscrepancy Occurrence of Quantity Discrepancy Show values
TranspOrdIsDiscrepant Discrepancy Show values
TranspOrdIsDscrptWthoutBlk Discrepancy Type Leads to Block or Not Show values
TransportationOrderCategory Business Document Category Show values
DangerousGoodsAreContained Dangerous Goods Show values
CarrierOriginOfEntry Carrier Origin of Entry Show values
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
TranspOrdPlanningStatus Planning Status Show values
TransportationOrderExecSts Execution Status Show values
TransportationModeCategory Transportation Mode Category Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
Column Name Description Domain name
TransportationOrderUUID Transportation Order UUID /SCMTMS/VDM_TOR_DB_KEY
TranspOrdExecution Transportation Order Execution ID /SCMTMS/ITEM_ID
TransportationOrderStopUUID UUID of Stop of Transportation Order with Conversion Exit /SCMTMS/TORSTOPUUID
TransportationOrderItemUUID UUID of Transportation Order Item with Conversion Exit /SCMTMS/TORITMUUID
NumberOfTimeRlvtTranspOrdEvts Number of Time Relevant Transportation Order Events /SCMTMS/VDM_NUMBER_OF
NumberOfOnTimeTranspOrdEvents Number of On Time Events /SCMTMS/VDM_NUMBER_OF
NumberOfDelayedTranspOrdEvents Number of Delayed Transportation Order Events /SCMTMS/VDM_NUMBER_OF
CreatedByUser Created By XUBNAME
CreationDateTime Creation Date Time TZNTSTMPS
LastChangedByUser Changed By XUBNAME
ChangedDateTime Changed On TZNTSTMPS
TranspOrdEventCode Event Occuring for a Transportation Activity /SCMTMS/TOR_EVENT
TranspOrdEventReasonCode Event Reason Internal Code /SAPTRX/INTERNAL_CODE
TranspOrdEventReasonDesc Reason of Event Occuring for a Transportation Activity /SCMTMS/TEXT100
TranspOrdEvtActualDateTime Transportation Order Event Actual Date Time TZNTSTMPS
TranspOrdEvtActualDateTimeZone Transp Order Event Actual Time Zone TZNZONE
TranspOrdEvtActualDateYear Transportation Order Event Actual Year NUM4
TranspOrdEvtActualDateYearMnth Transportation Order Event Actual Year Month NUM6
TranspOrdEvtActualDateYearQtr Transportation Order Event Actual Year Quarter NUM5
TranspOrdEvtActualDateYearWeek Transportation Order Event Actual Year Week NUM6
TranspOrdEvtExpdEndDateTime Transportation Order Event Expected End Date Time TZNTSTMPS
TranspOrdEvtEstimatedDateTime Transportation Order Event Estimated Date Time TZNTSTMPS
LocationUUID Location UUID (CHAR 22) /SAPAPO/LOCID
GeographicalLocationLatitude Geographical Location Latitude /SCMTMS/VDM_GEOLAT
GeographicalLocationLongitude Geographical Location Longitude /SCMTMS/VDM_GEOLON
GeographicalLocationAltitude Geographical Location Altitude /SCMTMS/VDM_GEOALT
DiscrepancyType Discrepancy Type /SCMTMS/DISCREPANCY_TYPE
TranspOrdIsDiscrepantWithinTol Quantity Discrepancy Is Within Tolerance
ShippersLoadAndCountQuantity Shipper's Load and Count (SLAC)
TransportationOrder Document /SCMTMS/TOR_ID
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
TranspOrdResponsiblePerson Person Responsible UNAME
CarrierUUID Business Partner GUID SYSUUID
Carrier Carrier /SCMTMS/BU_PARTNER
ShipperUUID Business Partner GUID SYSUUID
Shipper Shipper BU_PARTNER
ConsigneeUUID Business Partner GUID SYSUUID
Consignee Ship-to Party BU_PARTNER
TranspOrdShippingType Shipping Type /SCMTMS/SHIPPING_TYPE
PlngAndExecOrganization Planning and Execution Organization HROBJID
PlngAndExecOrgExternalID Transportation Execution Organization /SCMB/ORG_EXT_ID
PlngAndExecGroup Planning and Execution Group HROBJID
PlngAndExecGroupExternalID Transportation Execution Group /SCMB/ORG_EXT_ID
PurchasingOrgExternalID Transportation Purchasing Organization /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Transportation Purchasing Group /SCMB/ORG_EXT_ID
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
TransportationMode Transportation Mode VKTRA
SourceLocationUUID Source Location Universally Unique Identifier (CHAR 22) /SAPAPO/LOCID
SourceLocation Transportation Order Source Location /SAPAPO/LOCNO
DestinationLocationUUID Destination Location UUID (CHAR 22) /SAPAPO/LOCID
DestinationLocation Transportation Order Destination Location /SAPAPO/LOCNO
Master Data Relations Join Conditions
Country key
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • I_TRANSPORDEXECUTION2.MANDT == T005.MANDT
  • I_TRANSPORDEXECUTION2.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDEXECUTION2.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Source Location Region
  • I_TRANSPORDEXECUTION2.MANDT == T005S.MANDT
  • I_TRANSPORDEXECUTION2.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTION2.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTION2.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TRANSPORDEXECUTION2.SOURCELOCATIONREGION == T005S.BLAND
Purchasing Group
  • Client
  • Purchasing Group
  • ?
  • ?
  • I_TRANSPORDEXECUTION2.MANDT == PLOGI.MANDT
  • I_TRANSPORDEXECUTION2.PURCHASINGGROUP == PLOGI.OBJID
  • I_TRANSPORDEXECUTION2.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORDEXECUTION2.[column in domain "OTYPE"] == PLOGI.OTYPE
Purchasing Organization
  • Client
  • ?
  • ?
  • Purchasing Organization
  • I_TRANSPORDEXECUTION2.MANDT == PLOGI.MANDT
  • I_TRANSPORDEXECUTION2.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORDEXECUTION2.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_TRANSPORDEXECUTION2.PURCHASINGORGANIZATION == PLOGI.OBJID
Country key
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • I_TRANSPORDEXECUTION2.MANDT == T005.MANDT
  • I_TRANSPORDEXECUTION2.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDEXECUTION2.SOURCELOCATIONCOUNTRY == T005.LAND1
Region code
  • Client
  • Destination Location Country/Region
  • Source Location Country/Region
  • Destination Location Region
  • Source Location Region
  • I_TRANSPORDEXECUTION2.MANDT == T005S.MANDT
  • I_TRANSPORDEXECUTION2.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTION2.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTION2.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TRANSPORDEXECUTION2.SOURCELOCATIONREGION == T005S.BLAND
Transportation Activity
  • Client
  • Transportation Activity
Business Document Type
  • Client
  • Business Document Type