I_TranspOrdExecutionSts

Transportation Order Execution 1 | view: IEXECUTIONSTS | Extraction: Not supported | Component: Analytics
Column Name Description
TransportationOrderUUID Transportation Order UUID
TransportationOrderBlockUUID Transportaton Order Block UUID
Column Name Description
Column Name Description
📏 Transportation Order Event Delay Unit of Measure (TranspOrdDelayUnit):
TranspOrdDelay Transportation Order Delay
TranspOrdGrossWeight Transportation Order Gross Weight
TranspOrdGrossVolume Transportation Order Gross Volume
TranspOrdQuantity Transportation Order Quantity
TranspOrdNumberOfCtns Transportation Order Number Of Containers
Column Name Description
TranspOrdLfcycStsChgDte Transportation Order Lifecycle Status Change Date
Column Name Description
TransportationOrderCategory Business Document Category Show values
DangerousGoodsAreContained Dangerous Goods Show values
TranspOrdPlanningBlock Planning Block Show values
TranspOrdPlanningBlockCat Transportation Order Planning Block Category Show values
TranspOrdExecutionIsBlocked Execution Block Show values
TranspOrdExecBlockCategory Transportation Order Execution Block Category Show values
InvoicingIsBlocked Freight Settlement Document Block Show values
CarrierBusPurposeIsCompleted Carrier Business Purpose is Completed Show values
CarrierOriginOfEntry Carrier Origin of Entry Show values
ShipperBusPurposeIsCompleted Shipper Business Purpose Is Completed Show values
ConsigneeBusPurposeIsCompleted Ship-To Party Business Purpose is Completed Show values
TranspOrdTrafficDirection Traffic Direction Show values
TranspOrdLifeCycleStatus Life Cycle Status Show values
TranspOrdPlanningStatus Planning Status Show values
TransportationOrderExecSts Execution Status Show values
SourceLocationType Source Location Type Show values
DestinationLocationType Destination Location Type Show values
TransportationModeCategory Transportation Mode Category Show values
TranspOrdIsInTransit Transportation Order Is In Transit Show values
TranspOrdIsDlydInTransit Transportation Order is Delayed In Transit Show values
Column Name Description Domain name
TransportationOrder Document /SCMTMS/TOR_ID
TranspOrdResponsiblePerson Person Responsible UNAME
TranspOrdPlanningBlockRsn Reason for Planning Block /SCMTMS/BLOCK_REASON_CODE
TranspOrdExecBlockReason Reason for Execution Block /SCMTMS/BLOCK_REASON_CODE
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
PlngAndExecGroup Planning and Execution Group HROBJID
PlngAndExecOrgExternalID Transportation Execution Organization /SCMB/ORG_EXT_ID
PlngAndExecGroupExternalID Transportation Execution Group /SCMB/ORG_EXT_ID
PurchasingOrgExternalID Transportation Purchasing Organization /SCMB/ORG_EXT_ID
PurchasingGroupExternalID Transportation Purchasing Group /SCMB/ORG_EXT_ID
TranspOrdLfcycStsChgDteTime Created on Timestamp TZNTSTMPS
TranspOrdLfcycStsChgDteYrWeek Transp Order Life Cycle Status Change Date Year Week NUMC6
TranspOrdLfcycStsChgDteYrMnth Transportation Order Lifecycle Status Change Date Year Month NUMC6
TranspOrdLfcycStsChgDteYearQtr Transportation Order Lifecycle Status Change Dte Year Qtr NUMC5
TranspOrdLfcycStsChgDteYear Transportation Order Lifecycle Status Change Date Year NUMC4
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
MeansOfTransport Means of Transport /SAPAPO/TR_TRATY
TransportationMode Transportation Mode VKTRA
NumberOfTranspOrdsInTransit Number of Transportation Orders In Transit /SCMTMS/VDM_NUMBER_OF
NmbrOfDelayedTranspOrdsInTrnst Number of Delayed Transportation Orders In Transit /SCMTMS/VDM_NUMBER_OF
StandardSAPIconURI Std SAP Icon Uniform Resource Identifier AD_URI_BW
Master Data Relations Join Conditions
Country key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • I_TRANSPORDEXECUTIONSTS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDEXECUTIONSTS.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDEXECUTIONSTS.MANDT == T005.MANDT
Region code
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • Destination Location Region
  • Source Location Region
  • I_TRANSPORDEXECUTIONSTS.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTIONSTS.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTIONSTS.MANDT == T005S.MANDT
  • I_TRANSPORDEXECUTIONSTS.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TRANSPORDEXECUTIONSTS.SOURCELOCATIONREGION == T005S.BLAND
Purchasing Group
  • Client
  • Purchasing Group
  • ?
  • ?
  • I_TRANSPORDEXECUTIONSTS.MANDT == PLOGI.MANDT
  • I_TRANSPORDEXECUTIONSTS.PURCHASINGGROUP == PLOGI.OBJID
  • I_TRANSPORDEXECUTIONSTS.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORDEXECUTIONSTS.[column in domain "OTYPE"] == PLOGI.OTYPE
Purchasing Organization
  • Client
  • ?
  • ?
  • Purchasing Organization
  • I_TRANSPORDEXECUTIONSTS.MANDT == PLOGI.MANDT
  • I_TRANSPORDEXECUTIONSTS.[column in domain "PLVAR"] == PLOGI.PLVAR
  • I_TRANSPORDEXECUTIONSTS.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_TRANSPORDEXECUTIONSTS.PURCHASINGORGANIZATION == PLOGI.OBJID
Country key
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • I_TRANSPORDEXECUTIONSTS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDEXECUTIONSTS.SOURCELOCATIONCOUNTRY == T005.LAND1
  • I_TRANSPORDEXECUTIONSTS.MANDT == T005.MANDT
Region code
  • Destination Location Country/Region
  • Source Location Country/Region
  • Client
  • Destination Location Region
  • Source Location Region
  • I_TRANSPORDEXECUTIONSTS.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTIONSTS.SOURCELOCATIONCOUNTRY == T005S.LAND1
  • I_TRANSPORDEXECUTIONSTS.MANDT == T005S.MANDT
  • I_TRANSPORDEXECUTIONSTS.DESTINATIONLOCATIONREGION == T005S.BLAND
  • I_TRANSPORDEXECUTIONSTS.SOURCELOCATIONREGION == T005S.BLAND
Business Document Type
  • Client
  • Business Document Type