- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
I_TranspOrdItemAnlytsDEXPrep
Transp Order Item Anlyts DEX Preparation
| view: ITRANSPORDANAIEP | TRAN
| Extraction:
Not supported
| Component: Analytics
Tables used:
/SCMTMS/D_TOREXE, /SCMTMS/D_TORROT, /SCMTMS/D_TORITE, /SCMTMS/D_TORSTP, MARA, BUT000, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP, TMFG, TMFGT, MARA, MAKT, /SCMB/HRP5561, T77S0, TTGR, TTGRT, /SCMTMS/C_TORTY
- 🔑 Keys (1)
- 💰 Amounts (1)
- ∑ Quantities (18)
- 📅 Dates (1)
- ☰ Categorical (20)
- Other (67)
- 🔗 Relations (6)
| Column Name | Description | |
|---|---|---|
| TransportationOrderItemUUID | UUID of Transportation Order Item with Conversion Exit |
| Column Name | Description | |
|---|---|---|
| 💲 Goods Value Currency (TranspOrdItemGoodsValueCrcy): | ||
| TranspOrdItemGoodsValue | Transportation Order Item Goods Value | |
| Column Name | Description | |
|---|---|---|
| 📏 Gross Weight Unit of Measure (TranspOrdGrossWeightUnit): | ||
| TranspOrdGrossWeight | Transportation Order Gross Weight | |
| 📏 Gross Volume Unit of Measure (TranspOrdGrossVolumeUnit): | ||
| TranspOrdGrossVolume | Transportation Order Gross Volume | |
| 📏 Net Weight Unit of Measure (TranspOrdNetWeightUnit): | ||
| TranspOrdNetWeight | Transportation Order Net Weight | |
| 📏 Tare Weight Unit of Measure (TranspOrdTareWeightUnit): | ||
| TranspOrdTareWeight | Transportation Order Tare Weight | |
| 📏 Number of TEU Unit of Measure (TranspOrdNumberOfCtnsUnit): | ||
| TranspOrdNumberOfCtns | Transportation Order Number Of Containers | |
| 📏 Unit of Measure for ADR 1.1.3.6 DG Exemption Points (TranspOrdDngrsGdsExmpPtsUnit): | ||
| TranspOrdDngrsGdsExmpPts | Transportation Order Dangerous Goods Exemption Points | |
| 📏 Transportation Order Distance Unit (TranspOrdDistanceUnit): | ||
| TranspOrdDistance | Transportation Order Distance | |
| 📏 Transportation Order Item Gross Weight Unit (TranspOrdItemGrossWeightUnit): | ||
| TranspOrdItemGrossWeight | Transportation Order Item Gross Weight | |
| 📏 Transportation Order Item Gross Volume Unit (TranspOrdItemGrossVolumeUnit): | ||
| TranspOrdItemGrossVolume | Transp Order Item Gross Volume | |
| 📏 Transportation Order Item Net Weight Unit (TranspOrdItemNetWeightUnit): | ||
| TranspOrdItemNetWeight | Transportation Order Item Net Weight | |
| 📏 Transportation Order Item Quantity Unit (TranspOrdItemQuantityUnit): | ||
| TranspOrdItemQuantity | Transportation Order Item Quantity | |
| 📏 Transportation Order Item Alternative Quantity Unit (TranspOrdItemAltvQtyUnit): | ||
| TranspOrdItemAltvQty | Transportation Order Item Alternative Quantity | |
| 📏 Transp Orde Item Base Quantity UoM (TranspOrdItemBaseQtyUnit): | ||
| TranspOrdItemBaseQty | Transportation Order Item Base Quantity | |
| 📏 Transportation Order Item Tare Weight Unit (TranspOrdItemTareWeightUnit): | ||
| TranspOrdItemTareWeight | Transportation Order Item Tare Weight | |
| 📏 Transportation Order Item Number Of Containers Unit (TranspOrdItemNumberOfCtnsUnit): | ||
| TranspOrdItemNumberOfCtns | Transportation Order Item Number Of Containers | |
| 📏 Transportation Order Item Length Unit (TranspOrdItemLengthUnit): | ||
| TranspOrdItemLength | Transportation Order Item Length | |
| TranspOrdItemWidth | Transportation Order Item Width | |
| TranspOrdItemHeight | Transportation Order Item Height | |
| Column Name | Description | |
|---|---|---|
| TranspOrdCreationDate | Transportation Order Creation Date |
| Column Name | Description | |
|---|---|---|
| TranspOrdItemSrceLocationType | Transportation Order Item Source Location Type | Show values |
| TranspOrdItemDestLocationType | Transportation Order Item Destination Location Type | Show values |
| TransportationOrderCategory | Transportation Order Category | Show values |
| DangerousGoodsAreContained | Transportation Order Dangerous Goods | Show values |
| TranspOrdPlanningBlock | Transportation Order Planning Block | Show values |
| TranspOrdExecutionIsBlocked | Transportation Order Execution Block | Show values |
| InvoicingIsBlocked | Transportation Order Invoicing is Blocked | Show values |
| CarrierOriginOfEntry | Carrier Origin of Entry | Show values |
| TranspOrdTrafficDirection | Traffic Direction | Show values |
| TranspOrdLifeCycleStatus | Transportation Order Life Cycle Status | Show values |
| TranspOrdPlanningStatus | Transportation Order Planning Status | Show values |
| TransportationOrderExecSts | Transportation Order Execution Status | Show values |
| TransportationRequestCategory | Category (Forwarding Order/Quotation or Trsp. Reqt) | Show values |
| TransportationModeCategory | Transportation Mode Category | Show values |
| TranspOrdItemCategory | Transportation Order Item Category | Show values |
| TranspOrdItemIsDangerousGood | Transportation Order Item is Dangerous Good | Show values |
| MultiItem | Multiple Item | Show values |
| CargoIsHighValue | High-Value Cargo | Show values |
| IsMainCargoItem | Main Cargo Item | Show values |
| TranspOrdTypeIsBusWrhsRlvt | Transportation Order Type is Business Warehouse Relevant | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| TransportationOrderUUID | Transportation Order UUID | /SCMTMS/VDM_TOR_DB_KEY | |
| TranspOrdItemParentItemUUID | Key of Transportation Order Item | ||
| SourceStopUUID | Transportation Order Item Source Stop UUID | /BOBF/CONF_KEY | |
| TranspOrdItemSrceLocation | Transportation Order Item Source Location | /SAPAPO/LOCNO | |
| DestinationStopUUID | Transportation Order Item Destination Stop UUID | /BOBF/CONF_KEY | |
| TranspOrdItemDestLocation | Transportation Order Item Destination Location | /SAPAPO/LOCNO | |
| TransportationOrder | Transportation Order | /SCMTMS/TOR_ID | |
| NumberOfTransportationOrders | Number of Transportation Orders | /SCMTMS/VDM_NUMBER_OF | |
| CreatedByUser | Created By | XUBNAME | |
| TranspOrdCreationDateTime | Transportation Order Creation Date Time | TZNTSTMPS | |
| LastChangedByUser | Changed By | XUBNAME | |
| ChangedDateTime | Changed On | TZNTSTMPS | |
| TranspOrdLfcycStsChgDteTime | Transportation Order Life Cycle Status Change Date Time | TZNTSTMPS | |
| TranspOrdPartnerReference | Partner Reference Number | CHAR35 | |
| TranspOrdResponsiblePerson | Transportation Order Responsible Person | UNAME | |
| TransportationServiceLevel | Transportation Service Level - Carrier | /SCMTMS/TRANSP_SLC_CARRIER | |
| Carrier | Carrier | /SCMTMS/BU_PARTNER | |
| CarrierUUID | Carrier UUID | /SCMTMS/VDM_DB_KEY | |
| CarrierAddressID | Carrier Address ID | ||
| StandardCarrierAlphaCode | Standard Carrier Alpha Code | /SCMTMS/SCACD | |
| TranspOrdAirlineIATACode | IATA Airline Code | /SCMTMS/AIRLC | |
| TranspOrdAirWayBill | Air Waybill Prefix | CHAR3 | |
| Shipper | Shipper | BU_PARTNER | |
| ShipperUUID | Shipper Universally Unique Identifier | /SCMTMS/VDM_DB_KEY | |
| ShipperAddressID | Shipper Address ID | ||
| Consignee | Ship-to Party | BU_PARTNER | |
| ConsigneeUUID | Ship-to Party UUID | /SCMTMS/VDM_BUPAUUID | |
| ConsigneeAddressID | Ship-to Party Address ID | ||
| TranspOrdShippingType | Shipping Type | /SCMTMS/SHIPPING_TYPE | |
| MovementType | Movement Type | /SCMTMS/MOVEMENT_TYPE | |
| 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 | |
| BusinessTransactionDocument | Base Business Transaction Document | /SCMTMS/BTD_ID | |
| TranspOrdMeansOfTransport | Transportation Order Means of Transport | /SCMTMS/TRANSMEANSTYPECODE | |
| TransportationMode | Transportation Mode | VKTRA | |
| TranspOrdMaxUtilznRatio | Maximum Utilization | ||
| TranspOrdMaxUtilznMassRatio | Transportation Order Maximum Utilization Mass Ratio | /SCMTMS/VDM_UTILIZATION | |
| TranspOrdMaxUtilznVolumeRatio | Transportation Order Max Utilization Volume Ratio | /SCMTMS/VDM_UTILIZATION | |
| TranspOrdMaxUtilznLengthRatio | Transportation Order Maximum Utilization Length Ratio | /SCMTMS/VDM_UTILIZATION | |
| TranspOrdNetDuration | Transportaton Order Net Duration | TSTRDURAH | |
| TranspOrdItem | Transportation Order Item | /SCMTMS/ITEM_ID | |
| TranspOrdItemDesc | Transportation Order Item Description | /SCMTMS/ITEM_DESCRIPTION | |
| TranspOrdItemType | Transportation Order Item Type | /SCMTMS/TOR_ITEM_TYPE | |
| TranspOrdItemShipper | Transportation Order Item Shipper | BU_PARTNER | |
| TranspOrdItemConsignee | Transportation Order Item Ship-to Party | BU_PARTNER | |
| TranspOrdItemTranspMode | Transportation Order Item Transportation Mode | ||
| TranspOrdItemTranspModeCat | Transportation Order Item Transportation Mode Category | ||
| PredecessorTransportationOrder | NodeID | /BOBF/CONF_KEY | |
| TranspOrdDocReferenceItmType | Base Document Item Type Code for Business Transaction | /SCMTMS/BTD_ITEM_TYPECODE | |
| TranspOrdDocReferenceID | Base Business Transaction Document | /SCMTMS/BTD_ID | |
| TranspOrdDocReferenceItmID | Base Document Item for Business Transaction | /SCMTMS/BTD_ITEM_ID | |
| ProductID | Product | MATNR | |
| ProductName | Product Description | TEXT40 | |
| TransportationGroupName | Transportation Group Name | TEXT20 | |
| TranspOrdItemMeansOfTransport | Transportation Order Item Means of Transport | /SCMTMS/TRANSMEANSTYPECODE | |
| TranspOrdItemSorting | Transportation Order Item Sorting | /SCMTMS/VDM_TOR_ITEM_SORT_ID | |
| TranspOrdItemShipperUUID | Transportation Order Item Shipper UUID | /SCMTMS/VDM_DB_KEY | |
| TranspOrdItemConsigneeAddrID | Transportation Order Item Consignee Address ID | ||
| TranspOrdItemConsigneeUUID | Transportation Order Item Ship-to Party UUID | /SCMTMS/VDM_DB_KEY | |
| ProductUUID | Product GUID | ||
| TranspOrdItemVoyage | Transportation Order Item Voyage | /SCMTMS/VOYAGE_ID | |
| TranspOrdItemFlight | Transportation Order Item Flight | /SCMTMS/FLIGHT_CODE | |
| TranspOrdItemVessel | Transportation Order Item Vessel | /SCMTMS/VESSEL_ID | |
| TranspOrdItemIMOShip | Transportation Order Item IMO Ship | /SCMTMS/IMO_ID | |
| Plant | Plant | WERKS |
| Master Data Relations | Join Conditions |
|---|---|
Base Document Type for Business Transaction
|
|
Incoterm
| |
Base Document Type for Business Transaction
|
|
Goods Value Currency
| |
Transportation Group
| |
Transportation Order Type
|
|