sap transportation management (sap tm) - analytics
TRANSCRIPT
SAP Library
(C) SAP AG 1
SAP Transportation Management (SAP TM)
Release 9.0
(Analytics)
PUBLIC Document Version: 3.0 – March 2013
SAP Library
(C) SAP AG 2
Copyright © Copyright 2013 SAP AG. All rights reserved. SAP Library document classification: PUBLIC
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP AG and its affiliated companies (“SAP Group”) for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Please see http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.
SAP Library
(C) SAP AG 3
Icons in Body Text Icon Meaning
Caution
Example
Note
Recommendation
Syntax
Additional icons are used in SAP Library documentation to help you identify different types of
information at a glance. For more information, see Help on Help General Information Classes and Information Classes for Business Information Warehouse on the first page of any version of SAP Library.
Typographic Conventions Type Style Description
Example text Words or characters quoted from the screen. These include field names, screen titles, pushbuttons labels, menu names, menu paths, and menu options. Cross-references to other documentation.
Example text Emphasized words or phrases in body text, graphic titles, and table titles. EXAMPLE TEXT Technical names of system objects. These include report names, program
names, transaction codes, table names, and key concepts of a programming language when they are surrounded by body text, for example, SELECT and INCLUDE.
Example text Output on the screen. This includes file and directory names and their paths, messages, names of variables and parameters, source text, and names of installation, upgrade and database tools.
Example text Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.
<Example text> Variable user entry. Angle brackets indicate that you replace these words and characters with appropriate entries to make entries in the system.
EXAMPLE TEXT Keys on the keyboard, for example, F2 or ENTER.
SAP Library
(C) SAP AG 4
Table of Contents SAP Transportation Management (SAP TM) - Analytics........................................................... 8
1 Analytics .............................................................................................................................. 9 1.1 Business Intelligence Content .................................................................................... 10
1.1.1 DataSources ........................................................................................................ 11 1.1.1.1 DataSources for Master Data ....................................................................... 12
1.1.1.1.1 Agreement Party Role ............................................................................ 13 1.1.1.1.2 Airline Code ............................................................................................ 14 1.1.1.1.3 Allocation Load Type .............................................................................. 15 1.1.1.1.4 Bucket Type for Transportation Allocation ............................................. 16 1.1.1.1.5 Business Share Line Type ..................................................................... 17 1.1.1.1.6 Business Transaction Priority Code ....................................................... 18 1.1.1.1.7 Calculation Level .................................................................................... 19 1.1.1.1.8 Calculation Resolution Base .................................................................. 20 1.1.1.1.9 Calculation Resolution Instruction Code for Charge Type ..................... 21 1.1.1.1.10 Cargo Execution Status on Item Level ................................................. 22 1.1.1.1.11 Cargo Receipt Status on Item Level .................................................... 23 1.1.1.1.12 Charge Category .................................................................................. 24 1.1.1.1.13 Charge Item Category Code ................................................................ 25 1.1.1.1.14 Charge Item Subcategory Code ........................................................... 26 1.1.1.1.15 Charge Item Type Code ....................................................................... 27 1.1.1.1.16 Charge Subcategory ............................................................................ 28 1.1.1.1.17 Charge Type ......................................................................................... 29 1.1.1.1.18 Consolidation Type ............................................................................... 30 1.1.1.1.19 Contract Basis ...................................................................................... 31 1.1.1.1.20 Country-Specific Air Cargo Security Status ......................................... 32 1.1.1.1.21 Creation Type of Transportation Order ................................................ 33 1.1.1.1.22 Customs Activity Inbound ..................................................................... 34 1.1.1.1.23 Dangerous Goods Check Error ............................................................ 35 1.1.1.1.24 Discrepancy .......................................................................................... 36 1.1.1.1.25 Discrepancy Type ................................................................................. 37 1.1.1.1.26 Discrepancy Type Leads to Block or Not ............................................. 38 1.1.1.1.27 Distribution Category ............................................................................ 39 1.1.1.1.28 Distribution Level for Transportation Charge Distribution .................... 40 1.1.1.1.29 Distribution Rule ................................................................................... 41 1.1.1.1.30 Document Item Type for Business Transaction ................................... 42 1.1.1.1.31 Document Type for Business Transaction ........................................... 43 1.1.1.1.32 Equipment Group ................................................................................. 44 1.1.1.1.33 Equipment Type ................................................................................... 45 1.1.1.1.34 Execution Role Category ...................................................................... 46 1.1.1.1.35 Forwarding Settlement Document Category ........................................ 47 1.1.1.1.36 Forwarding Settlement Document Classification ................................. 48 1.1.1.1.37 Forwarding Settlement Document Credit Memo Reason Code ........... 49 1.1.1.1.38 Forwarding Settlement Document Life Cycle Status ........................... 50 1.1.1.1.39 Forwarding Settlement Document Type ............................................... 51 1.1.1.1.40 Freight Settlement Document Category ............................................... 52 1.1.1.1.41 Freight Settlement Document Creation Type ....................................... 53 1.1.1.1.42 Freight Settlement Document Invoice Document Type ....................... 54 1.1.1.1.43 Freight Settlement Document Item Confirmation Status ...................... 55 1.1.1.1.44 Freight Settlement Document Item Transfer Status ............................. 56 1.1.1.1.45 Freight Settlement Document Life Cycle Status .................................. 57 1.1.1.1.46 Freight Settlement Document Type ..................................................... 58 1.1.1.1.47 General Security Status ....................................................................... 59 1.1.1.1.48 Handling Execution Status on Stop Level ............................................ 60 1.1.1.1.49 IATA Aircraft Type Code ...................................................................... 61 1.1.1.1.50 IATA Location Code ............................................................................. 62 1.1.1.1.51 Incoterms Classification Code .............................................................. 63 1.1.1.1.52 Instruction Type .................................................................................... 64 1.1.1.1.53 Item Category ....................................................................................... 65
SAP Library
(C) SAP AG 5
1.1.1.1.54 Means of Transport .............................................................................. 66 1.1.1.1.55 Movement Type .................................................................................... 67 1.1.1.1.56 Multi-Stop ............................................................................................. 68 1.1.1.1.57 Organizational Unit: External ID ........................................................... 69 1.1.1.1.58 Origin of Entry ...................................................................................... 70 1.1.1.1.59 Package Type ...................................................................................... 71 1.1.1.1.60 Reason for Cancellation ....................................................................... 72 1.1.1.1.61 Relation Type of Trade Lane for BW .................................................... 73 1.1.1.1.62 Shipper Security Status ........................................................................ 74 1.1.1.1.63 Shipping Type ...................................................................................... 75 1.1.1.1.64 Source of Execution Information .......................................................... 76 1.1.1.1.65 Stage Type ........................................................................................... 77 1.1.1.1.66 Stop Assignment Category ................................................................... 78 1.1.1.1.67 Stop Category ...................................................................................... 79 1.1.1.1.68 Stop Origin............................................................................................ 80 1.1.1.1.69 Stop Role .............................................................................................. 81 1.1.1.1.70 Trade Lane Orientation for BW ............................................................ 82 1.1.1.1.71 Traffic Direction .................................................................................... 83 1.1.1.1.72 Transportation Activity .......................................................................... 84 1.1.1.1.73 Transportation Allocation Category ...................................................... 85 1.1.1.1.74 Transportation Allocation Description Text .......................................... 86 1.1.1.1.75 Transportation Allocation Line Type ..................................................... 87 1.1.1.1.76 Transportation Allocation Type Text .................................................... 88 1.1.1.1.77 Transportation Charge Distribution Line Type ..................................... 89 1.1.1.1.78 Transportation Mode Category............................................................. 90 1.1.1.1.79 Transportation Mode Code ................................................................... 91 1.1.1.1.80 Transportation Order Category ............................................................ 92 1.1.1.1.81 Transportation Order Consolidation Allowed? ..................................... 93 1.1.1.1.82 Transportation Order Event Status ...................................................... 94 1.1.1.1.83 Transportation Order Life Cycle Status ................................................ 95 1.1.1.1.84 Transportation Order Type ................................................................... 96 1.1.1.1.85 Transportation Request Category ........................................................ 97 1.1.1.1.86 Transportation Request Life Cycle Status ............................................ 98 1.1.1.1.87 Transportation Request Type ............................................................... 99 1.1.1.1.88 Transportation Service Level.............................................................. 100 1.1.1.1.89 Type of Transportation Request Item ................................................. 101 1.1.1.1.90 Unit Load Device Rate Class ............................................................. 102 1.1.1.1.91 Unit Load Device Rate Types............................................................. 103
1.1.1.2 DataSources for Transactional Data ........................................................... 104 1.1.1.2.1 Transactional Data of BO Business Share ........................................... 105 1.1.1.2.2 Transactional Data of BO Forwarding Settlement Document .............. 107 1.1.1.2.3 Transactional Data of BO Freight Settlement Document ..................... 110 1.1.1.2.4 Transactional Data of BO FSD for Planned Transportation Charges .. 113 1.1.1.2.5 Transactional Data of BO FSD Item IV Information (Actual Costs) ..... 115 1.1.1.2.6 Transactional Data of BO FWSD for Planned Transportation Charges 117 1.1.1.2.7 Transactional Data of BO Transportation Allocation ............................ 119 1.1.1.2.8 Transactional Data of BO Transportation Order .................................. 123 1.1.1.2.9 Transactional Data of BO Transportation Request .............................. 126 1.1.1.2.10 Transactional Data of Charge Distribution of BO FSD ....................... 128 1.1.1.2.11 Transactional Data of Charge Distribution of BO TO ......................... 131 1.1.1.2.12 Transactional Data of Execution Information of BO TO ..................... 134 1.1.1.2.13 Transactional Data of Stage Information of BO TO ........................... 137 1.1.1.2.14 Transactional Data of Stage Information of BO TR............................ 143 1.1.1.2.15 Transactional Data of Trade Lanes of BO Transportation Order ....... 145 1.1.1.2.16 Transactional Item Data of BO Forwarding Settlement Document .... 146 1.1.1.2.17 Transactional Item Data of BO Freight Settlement Document ........... 148 1.1.1.2.18 Transactional Item Data of BO Transportation Order ........................ 150 1.1.1.2.19 Transactional Item Data of BO Transportation Request .................... 155
1.1.1.3 DataSources for Operational Data Provisioning ......................................... 160 1.1.1.3.1 Operational Data Provider for Stage Information of BO TO ................. 161
SAP Library
(C) SAP AG 6
1.2 Operational Reporting in SAP TM (Operational Data Provisioning) ........................ 167 1.2.1 Queries .............................................................................................................. 168
1.2.1.1 Sustainability and Emissions Analysis ........................................................ 169 1.2.2 Search and Analytics Model .............................................................................. 171
1.2.2.1 Transportation Order Stage ........................................................................ 172 1.2.3 TransientProvider .............................................................................................. 174
1.2.3.1 Operational Data Provider for BO TO Stage .............................................. 175 1.2.4 Variables ............................................................................................................ 178
1.2.4.1 Changed On ................................................................................................ 179 1.2.4.2 Completion Date ......................................................................................... 180 1.2.4.3 Created On .................................................................................................. 181
1.2.5 Key Figures ........................................................................................................ 182 1.2.5.1 Acceptable End Date/Time at Stop (Destination) ....................................... 183 1.2.5.2 Acceptable End Date/Time at Stop (Destination, from TR) ........................ 184 1.2.5.3 Acceptable End Date/Time at Stop (Source) .............................................. 185 1.2.5.4 Acceptable End Date/Time at Stop (Source, from TR) ............................... 186 1.2.5.5 Acceptable Start Date/Time at Stop (Destination) ...................................... 187 1.2.5.6 Acceptable Start Date/Time at Stop (Destination, from TR) ....................... 188 1.2.5.7 Acceptable Start Date/Time at Stop (Source) ............................................. 189 1.2.5.8 Acceptable Start Date/Time at Stop (Source, from TR) .............................. 190 1.2.5.9 Base Quantity .............................................................................................. 191 1.2.5.10 Capacity Consumption of Handling Resource (Destination) .................... 192 1.2.5.11 Capacity Consumption of Handling Resource (Source) ........................... 193 1.2.5.12 Carbon Dioxide Emissions ........................................................................ 194 1.2.5.13 Cargo Cut-Off Date/Time .......................................................................... 195 1.2.5.14 Cargo Cut-Off Date/Time (Destination)..................................................... 196 1.2.5.15 Cargo Cut-Off Date/Time (Source) ........................................................... 197 1.2.5.16 Customs Documentation Cut-Off Date/Time ............................................ 198 1.2.5.17 Customs Documentation Cut-Off Date/Time (Destination) ....................... 199 1.2.5.18 Customs Documentation Cut-Off Date/Time (Source) ............................. 200 1.2.5.19 Dangerous Goods Documentation Cut-Off Date/Time ............................. 201 1.2.5.20 Dangerous Goods Documentation Cut-Off Date/Time (Destination) ........ 202 1.2.5.21 Dangerous Goods Documentation Cut-Off Date/Time (Source) .............. 203 1.2.5.22 Decimal Value ........................................................................................... 204 1.2.5.23 Document Cut-Off Date/Time ................................................................... 205 1.2.5.24 Document Cut-Off Date/Time (Destination) .............................................. 206 1.2.5.25 Document Cut-Off Date/Time (Source)..................................................... 207 1.2.5.26 Duration ..................................................................................................... 208 1.2.5.27 Duration (Destination) ............................................................................... 209 1.2.5.28 Duration (Source) ...................................................................................... 210 1.2.5.29 End of Pick-Up/Delivery Window Confirmed by Carrier (Destin.) ............. 211 1.2.5.30 End of Pick-Up/Delivery Window Confirmed by Carrier (Source) ............. 212 1.2.5.31 Fuel Consumption ..................................................................................... 213 1.2.5.32 Gross Volume ........................................................................................... 214 1.2.5.33 Gross Weight ............................................................................................ 215 1.2.5.34 Net Weight ................................................................................................ 216 1.2.5.35 Number of TEU ......................................................................................... 217 1.2.5.36 Pieces ....................................................................................................... 218 1.2.5.37 Pieces 2 .................................................................................................... 219 1.2.5.38 Requested End Date/Time at Stop (Destination) ...................................... 220 1.2.5.39 Requested End Date/Time at Stop (Destination, from TR) ...................... 221 1.2.5.40 Requested End Date/Time at Stop (Source) ............................................ 222 1.2.5.41 Requested End Date/Time at Stop (Source, from TR) ............................. 223 1.2.5.42 Requested Start Date/Time at Stop (Destination) .................................... 224 1.2.5.43 Requested Start Date/Time at Stop (Destination, from TR) ..................... 225 1.2.5.44 Requested Start Date/Time at Stop (Source) ........................................... 226 1.2.5.45 Requested Start Date/Time at Stop (Source, from TR) ............................ 227 1.2.5.46 Start of Pick-Up/Delivery Window Confirmed by Carrier (Destin.) ............ 228 1.2.5.47 Start of Pick-Up/Delivery Window Confirmed by Carrier (Source) ........... 229 1.2.5.48 Sustainability-Relevant Weight ................................................................. 230
SAP Library
(C) SAP AG 7
1.2.5.49 Tare Weight ............................................................................................... 231 1.2.5.50 Transportation Planning Date (End, Destination) ..................................... 232 1.2.5.51 Transportation Planning Date (End, Source) ............................................ 233 1.2.5.52 Transportation Planning Date (Start, Destination) .................................... 234 1.2.5.53 Transportation Planning Date (Start, Source) ........................................... 235
1.3 Business Context Viewer in SAP TM ....................................................................... 236
SAP Library
(C) SAP AG 9
1 Analytics
Analytics in SAP Transportation Management (SAP TM) enable you to collect and combine relevant data across different operational areas to answer business-related and specific questions. By analyzing these data, you get important insights and a higher transparency, which are crucial for your operational and strategic decision-making.
In this section you find information about the following topics:
Business Intelligence Content [Page 10]
You can use business intelligence content to provide certain users on all operational levels, such as transportation managers or supply chain executives, with the reporting information they need to carry out their tasks.
You find business intelligence content in SAP TM (DataSources) as well as in SAP NetWeaver Business Warehouse.
Operational Reporting in SAP TM (Operational Data Provisioning) [Page 167]
You can use operational reporting for real-time analyses of data from SAP TM. If you use operational data provisioning (ODP), you can access the data in your live system directly. Therefore, you always have real-time data for your evaluations and can react adequately and promptly.
Business Context Viewer in SAP TM [Page 236]
You can use this function to display SAP TM content in the Business Context Viewer (BCV). BCV is a framework that allows all SAP Business Suite applications to integrate different kinds of additional information into the context of their applications.
SAP Library
(C) SAP AG 10
1.1 Business Intelligence Content
BI Content in SAP TM
In this section you find the following business intelligence content that is located in SAP Transportation Management:
DataSources for master data [Page 12]
DataSources for transactional data [Page 104]
DataSources for Operational Data Provisioning [Page 160]
A DataSource contains a number of logically-related fields. The DataSources for master data (text DataSources) and transactional data contain the data that are transferred into SAP NetWeaver Business Warehouse (SAP NetWeaver BW). SAP NetWeaver BW is an independent Data Warehouse solution. It is used to retrieve data from SAP systems and external systems.
BI Content in SAP NetWeaver Business Warehouse
In SAP NetWeaver Business Warehouse, you find additional business intelligence content for SAP TM, for example:
Queries
MultiProvider
InfoCubes
DataStore Objects
Key Figures
Characteristics
Meta Chains and Process Chains
More Information
For more information about business intelligence content for SAP TM in SAP NetWeaver BW,
see SAP Help Portal at http://help.sap.com SAP NetWeaver BI Content .
SAP Library
(C) SAP AG 11
1.1.1 DataSources
A DataSource contains fields with data that are to be transferred into the BI System. The DataSource is located in the source system (here: Transportation Management). This section describes the DataSources used in SAP Transportation Management (SAP TM).
We distinguish these types of DataSources:
DataSources for master data [Page 12]
This type of DataSource extracts texts and descriptions. Therefore it is considered a text DataSource.
DataSources for transactional data [Page 104]
This type of DataSource extracts transactional data. In an operating business, the transactional data are subject to frequent changes.
DataSources for Operational Data Provisioning [Page 160]
This type of DataSource is used for ODP purposes.
SAP Library
(C) SAP AG 12
1.1.1.1 DataSources for Master Data
DataSources for master data extract texts and descriptions. Therefore they are considered as text DataSources.
SAP Library
(C) SAP AG 13
1.1.1.1.1 Agreement Party Role
DataSource Texts: 0SCM_TM_AGREEPARTROLE
This DataSource extracts the data of the agreement party.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 14
1.1.1.1.2 Airline Code
DataSource Texts: 0SCM_TM_AIRLINECD
This DataSource extracts data concerning the airline code.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AIRLC IATA Airline Code – –
SPRAS Language Key – –
TEXT Description (Short) – –
SAP Library
(C) SAP AG 15
1.1.1.1.3 Allocation Load Type
DataSource Texts: 0SCM_TM_TAL_LOAD_TYPE
This DataSource extracts data concerning the allocation load type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 16
1.1.1.1.4 Bucket Type for Transportation Allocation
DataSource Texts: 0SCM_TM_BUCKET_TYPE
This DataSource extracts data concerning the bucket type for the transportation allocation.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 17
1.1.1.1.5 Business Share Line Type
DataSource Texts: 0SCM_TM_BSHLINETYPE
This DataSource extracts data concerning the business share line type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 18
1.1.1.1.6 Business Transaction Priority Code
DataSource Texts: 0SCM_TM_BTPRCD
This DataSource extracts data concerning the business transaction priority code.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-to Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 19
1.1.1.1.7 Calculation Level
DataSource Texts: 0SCM_TM_CALCLEVEL
This DataSource extracts data concerning the calculation level.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 20
1.1.1.1.8 Calculation Resolution Base
DataSource Texts: 0SCM_TM_CALRES
This DataSource extracts data concerning the calculation resolution base.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION Description – –
LANGUAGE Language Key – –
RESOLUTION_BASE Calculation Resolution Base – –
SAP Library
(C) SAP AG 21
1.1.1.1.9 Calculation Resolution Instruction Code for Charge Type
DataSource Texts: 0SCM_TM_TCCRIC
This DataSource extracts data concerning the calculation resolution instruction code for the charge type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 22
1.1.1.1.10 Cargo Execution Status on Item Level
DataSource Texts: 0SCM_TM_HANDLCAR
This DataSource extracts data concerning the cargo execution status on item level.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 23
1.1.1.1.11 Cargo Receipt Status on Item Level
DataSource Texts: 0SCM_TM_CARGORCPT
This DataSource extracts data concerning the cargo receipt status on item level.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 24
1.1.1.1.12 Charge Category
DataSource Texts: 0SCM_TM_TCDCHRCAT
This DataSource extracts data concerning the charge category.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CHRGCATCD021_I Charge Category - -
DESCRIPTION Description (Short) - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 25
1.1.1.1.13 Charge Item Category Code
DataSource Texts: 0SCM_TM_TCCATC
This DataSource extracts data concerning the charge item category code.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
SPRAS Language Key - -
CHRGCATCD021_I Charge Category - -
DESCRIPTION Short Description - -
SAP Library
(C) SAP AG 26
1.1.1.1.14 Charge Item Subcategory Code
DataSource Texts: 0SCM_TM_TCCLSC
This DataSource extracts data concerning the charge item subcategory code.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION Description (Medium) - -
SPRAS Language Key - -
TCCLASS037 Charge Subcategory - -
SAP Library
(C) SAP AG 27
1.1.1.1.15 Charge Item Type Code
DataSource Texts: 0SCM_TM_TCETC
This DataSource extracts data concerning the charge item type code.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
MANDT Client - -
SPRAS Language Key - -
TCET084 Charge Type - -
TEXT Description (Medium) - -
SAP Library
(C) SAP AG 28
1.1.1.1.16 Charge Subcategory
DataSource Texts: 0SCM_TM_TCDCHRSCAT
This DataSource extracts data concerning the charge subcategory.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION Description (Medium) - -
SPRAS Language Key - -
TCCLASS037 Charge Subcategory - -
SAP Library
(C) SAP AG 29
1.1.1.1.17 Charge Type
DataSource Texts: 0SCM_TM_CHRTYPE
This DataSource extracts data concerning the charge type.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
SPRAS Language Key - -
TCET084 Charge Type - -
TEXT Description (Medium) - -
SAP Library
(C) SAP AG 30
1.1.1.1.18 Consolidation Type
DataSource Texts: 0SCM_TM_TORCONSOLTY
This DataSource extracts data concerning the consolidation type.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AIR_CONS_TYPE Air Waybill Type - -
DESCRIPTION_S Description (Short) - -
LANGU Language Key - -
SAP Library
(C) SAP AG 31
1.1.1.1.19 Contract Basis
DataSource Texts: 0SCM_TM_CONTRBAS
This DataSource extracts data concerning the contract basis.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CONTRACT_BASIS Contract Basis - -
SPRAS Language Key - -
TEXT Description (Short) - -
SAP Library
(C) SAP AG 32
1.1.1.1.20 Country-Specific Air Cargo Security Status
DataSource Texts: 0SCM_TM_NATSECSTS
This DataSource extracts data concerning the country-specific air cargo security status.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 33
1.1.1.1.21 Creation Type of Transportation Order
DataSource Texts: 0SCM_TM_CREATTYP
This DataSource extracts data concerning the creation type of the transportation order.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 34
1.1.1.1.22 Customs Activity Inbound
DataSource Texts: 0SCM_TM_TORCUSTACTINB
This DataSource extracts data concerning the inbound customs activity.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 35
1.1.1.1.23 Dangerous Goods Check Error
DataSource Texts: 0SCM_TM_DGOERROR
This DataSource extracts data concerning errors in the dangerous goods check.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 36
1.1.1.1.24 Discrepancy
DataSource Texts: 0SCM_TM_TORDISCR
This DataSource extracts data concerning discrepancies.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 37
1.1.1.1.25 Discrepancy Type
DataSource Texts: 0SCM_TM_TORDISCRTY
This DataSource extracts data concerning the discrepancy type.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION Discrepancy Type Description - -
DSC_TYPE Discrepancy Type - -
LANGU Language Key - -
SAP Library
(C) SAP AG 38
1.1.1.1.26 Discrepancy Type Leads to Block or Not
DataSource Texts: 0SCM_TM_TORDISCRBL
This DataSource extracts data that specify whether a discrepancy type leads to a block or not.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 39
1.1.1.1.27 Distribution Category
DataSource Texts: 0SCM_TM_DISTICAT
This DataSource extracts data concerning the distribution category.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 40
1.1.1.1.28 Distribution Level for Transportation Charge Distribution
DataSource Texts: 0SCM_TM_DISTLVL
This DataSource extracts data concerning the distribution level for the transportation charge distribution.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 41
1.1.1.1.29 Distribution Rule
DataSource Texts: 0SCM_TM_TCDDISRULE
This DataSource extracts data concerning the distribution rule.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 42
1.1.1.1.30 Document Item Type for Business Transaction
DataSource Texts: 0SCM_TM_BTD_ITEM_TYPECODE
This DataSources extracts the document item type for a business transaction.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BTDITM_TCO150 Business Transaction Document Item Type Code
- -
DESCRIPTION Description - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 43
1.1.1.1.31 Document Type for Business Transaction
DataSource Texts: 0SCM_TM_BTD_TYPE_CODE
This DataSource extracts the document type for a business transaction.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BTD_TCO129 Document Type for Business Transaction
- -
DESCRIPTION Description - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 44
1.1.1.1.32 Equipment Group
DataSource Texts: 0SCM_TM_TURESCAT
This DataSource extracts data concerning the equipment group.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCR Descriptive Text - -
EQUI_TYPE Equipment Group - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 45
1.1.1.1.33 Equipment Type
DataSource Texts: 0SCM_TM_TURESCO
This DataSource extracts data concerning the equipment type.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCR Descriptive Text - -
EQUI_CODE Equipment Type - -
EQUI_TYPE Equipment Group - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 46
1.1.1.1.34 Execution Role Category
DataSource Texts: 0SCM_TM_TOREXEROLECAT
This DataSource extracts data concerning the execution role category.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION Description (Short) - -
PARTY_ROLE012 Party Role - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 47
1.1.1.1.35 Forwarding Settlement Document Category
DataSource Texts: 0SCM_TM_CFIRCAT
This DataSource extracts data concerning the forwarding settlement document category.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 48
1.1.1.1.36 Forwarding Settlement Document Classification
DataSource Texts: 0SCM_TM_CFIRCLASS
This DataSource extracts data concerning the forwarding settlement document classification.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 49
1.1.1.1.37 Forwarding Settlement Document Credit Memo Reason Code
DataSource Texts: 0SCM_TM_CFIRCMRCD
This DataSource extracts data concerning the credit memo reason code of the forwarding settlement document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable -
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CM_REASON Credit Memo Reason Code - -
DESCRIPTION_S Description (Short) - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 50
1.1.1.1.38 Forwarding Settlement Document Life Cycle Status
DataSource Texts: 0SCM_TM_CFIRLCS
This DataSource extracts data concerning the forwarding settlement document life cycle status.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 51
1.1.1.1.39 Forwarding Settlement Document Type
DataSource Texts: 0SCM_TM_CFIRTYP
This DataSource extracts data concerning the forwarding settlement document type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable -
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CLIENT Client - -
TYPE Forwarding Settlement Document Type
- -
LANGU Language Key - -
DESCRIPTION_S Short Description - -
SAP Library
(C) SAP AG 52
1.1.1.1.40 Freight Settlement Document Category
DataSource Texts: 0SCM_TM_SFIRCAT
This DataSource extracts data concerning the freight settlement document category.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 53
1.1.1.1.41 Freight Settlement Document Creation Type
DataSource Texts: 0SCM_TM_SFIRCRT
This DataSource extracts data concerning the freight settlement document creation type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 54
1.1.1.1.42 Freight Settlement Document Invoice Document Type
DataSource Texts: 0SCM_TM_SFIRIVT
This DataSource extracts data concerning the invoice document type of an ERP invoice verification document saved in the freight settlement document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 55
1.1.1.1.43 Freight Settlement Document Item Confirmation Status
DataSource Texts: 0SCM_TM_SFIRCST
This DataSource extracts data concerning the freight settlement document item confirmation status.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 56
1.1.1.1.44 Freight Settlement Document Item Transfer Status
DataSource Texts: 0SCM_TM_SFIRTST
This DataSource extracts data concerning the freight settlement document item transfer status.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 57
1.1.1.1.45 Freight Settlement Document Life Cycle Status
DataSource Texts: 0SCM_TM_SFIRLCS
This DataSource extracts data concerning the freight settlement document life cycle status.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 58
1.1.1.1.46 Freight Settlement Document Type
DataSource Texts: 0SCM_TM_SFIRTYP
This DataSource extracts data concerning the freight settlement document type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CLIENT Client - -
TYPE Freight Settlement Document Type
- -
LANGU Language Key - -
DESCRIPTION_S Short Description - -
SAP Library
(C) SAP AG 59
1.1.1.1.47 General Security Status
DataSource Texts: 0SCM_TM_SECSTAT
This DataSource extracts data concerning the general security status.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 60
1.1.1.1.48 Handling Execution Status on Stop Level
DataSource Texts: 0SCM_TM_S_HDL_EXEC_STATUS
This DataSource extracts data concerning the handling of the execution status on the stop level.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 61
1.1.1.1.49 IATA Aircraft Type Code
DataSource Texts: BWBCT_DS_0SCM_TM_AIRCRACO
This DataSource extracts data concerning the IATA (International Air Transport Association) aircraft type code.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AIRCRAFTCODE IATA Aircraft Type Code – –
SPRAS Language Key – –
TEXT Description (Short) – –
SAP Library
(C) SAP AG 62
1.1.1.1.50 IATA Location Code
DataSource Texts: 0SCM_TM_IATACODE
This DataSource extracts data concerning the IATA (International Air Transport Association) location code.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
IATAC International Air Transport Association: Location
- -
SPRAS Language Key - -
TEXT Description (Short) - -
SAP Library
(C) SAP AG 63
1.1.1.1.51 Incoterms Classification Code
DataSource Texts: 0SCM_TM_INCCLCD
This DataSource extracts data concerning the incoterms classification code.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
MANDT Client - -
LANGU Language Key - -
INCO1 Incoterm - -
BEZEI Description - -
SAP Library
(C) SAP AG 64
1.1.1.1.52 Instruction Type
DataSource Texts: 0SCM_TM_INSTYPE
This DataSource extracts data concerning the instruction type.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 65
1.1.1.1.53 Item Category
DataSource Texts: 0SCM_TM_ITMCAT
This DataSource extracts data concerning the item category.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 66
1.1.1.1.54 Means of Transport
DataSource Texts: 0SCM_TM_TRMEANS
This DataSource extracts data concerning the means of transport.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 02
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key – –
TTYPE Means of Transport – –
TXTMDFL Means of Transport Description – –
SAP Library
(C) SAP AG 67
1.1.1.1.55 Movement Type
DataSource Texts: 0SCM_TM_MOVETYPE
This DataSource extracts data concerning the movement type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION_S Description (Short) - -
LANGU Language Key - -
MOVEM_TYPE Movement Type - -
SAP Library
(C) SAP AG 68
1.1.1.1.56 Multi-Stop
DataSource Texts: 0SCM_TM_MULTISTOP
This DataSource extracts data concerning the multi-stop.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 69
1.1.1.1.57 Organizational Unit: External ID
DataSource Texts: 0SCM_TM_ORGEXT
This DataSource extracts data concerning the external ID of the organizational unit.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BEGDA Start Date - -
ENDDA End Date - -
EXTERNAL_ID Organizational Unit: External ID - -
FUNCTION Organizational Unit Function - -
LANGU Language Key - -
ROLE Organizational Centre Function - -
STEXT Object Name - -
SAP Library
(C) SAP AG 70
1.1.1.1.58 Origin of Entry
DataSource Texts: 0SCM_TM_SET_BY_SERVICE
This DataSource extracts data concerning the origin of entry.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 71
1.1.1.1.59 Package Type
DataSource Texts: 0SCM_TM_PACKTYPE
This DataSource extracts data concerning the package type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION Description (Short) - -
PACK_TCO138 Package Type - -
SPRAS Language Key - -
SAP Library
(C) SAP AG 72
1.1.1.1.60 Reason for Cancellation
DataSource Texts: 0SCM_TM_RSNCNCLCO
This DataSource extracts data concerning the cancellation reason.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CNCL_RSN_CODE Reason for Cancellation - -
DESCR Reason for Cancellation (Description)
- -
LANGU Language Key - -
SAP Library
(C) SAP AG 73
1.1.1.1.61 Relation Type of Trade Lane for BW
DataSource Texts: 0SCM_TM_TORTDLRELTYPE
This DataSource extracts data concerning the trade lane relation type for the Business Warehouse.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 74
1.1.1.1.62 Shipper Security Status
DataSource Texts: 0SCM_TM_TRQSHIPSECSTAT
This DataSource extracts data concerning the shipper security status.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 75
1.1.1.1.63 Shipping Type
DataSource Texts: 0SCM_TM_SHIPTYPE
This DataSource extracts data concerning the shipping type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM90
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
SHIPPING_TYPE Shipping Type - -
SPRAS Language Key - -
TEXT Description (Short) - -
SAP Library
(C) SAP AG 76
1.1.1.1.64 Source of Execution Information
DataSource Texts: 0SCM_TM_TOREXECINFO
This DataSource extracts data concerning the source of execution information.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 77
1.1.1.1.65 Stage Type
DataSource Texts: 0SCM_TM_STAGETYPE
This DataSource extracts data concerning the stage type.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION_S Description (Short) - -
LANGU Language Key - -
STAGE_TYPE Stage Type - -
SAP Library
(C) SAP AG 78
1.1.1.1.66 Stop Assignment Category
DataSource Texts: 0SCM_TM_STOP_ASSGN_CAT
This DataSource extracts data concerning the stop assignment category.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 79
1.1.1.1.67 Stop Category
DataSource Texts: 0SCM_TM_STOP_CAT
This DataSource extracts data concerning the stop category.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 80
1.1.1.1.68 Stop Origin
DataSource Texts: 0SCM_TM_STOP_ORIGIN
This DataSource extracts data concerning the stop origin.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 81
1.1.1.1.69 Stop Role
DataSource Texts: 0SCM_TM_STOP_ROLE
This DataSource extracts data concerning the stop role.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 82
1.1.1.1.70 Trade Lane Orientation for BW
DataSource Texts: 0SCM_TM_ORIENTN_BW
This DataSource extracts data concerning the trade lane orientation for the Business Warehouse.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 83
1.1.1.1.71 Traffic Direction
DataSource Texts: 0SCM_TM_TRAFFICD
This DataSource extracts data concerning the traffic direction.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 84
1.1.1.1.72 Transportation Activity
DataSource Texts: 0SCM_TM_TOREXETRANSACT
This DataSource extracts data concerning the transportation activity.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION_S Description (Short) - -
LANGU Language Key - -
TRANSP_ACTIVITY Transportation Activity - -
SAP Library
(C) SAP AG 85
1.1.1.1.73 Transportation Allocation Category
DataSource Texts: 0SCM_TM_TALCAT
This DataSource extracts data concerning the transportation allocation category.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 86
1.1.1.1.74 Transportation Allocation Description Text
DataSource Texts: 0SCM_TM_TALDSC
This DataSource extracts data concerning the transportation allocation description text.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCRIPTION Transportation Allocation Description
- -
LANGUAGE_CODE Language Key - -
TAL_ID Transportation Allocation - -
SAP Library
(C) SAP AG 87
1.1.1.1.75 Transportation Allocation Line Type
DataSource Texts: 0SCM_TM_TALLINETYPE
This DataSource extracts data concerning the transportation allocation line type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM8.1; TM90
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 88
1.1.1.1.76 Transportation Allocation Type Text
DataSource Texts: 0SCM_TM_TALTYP
This DataSource extracts data concerning the transportation allocation type text.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCR Description of Allocation Type - -
LANGU Language Key - -
TYPE Allocation Type - -
SAP Library
(C) SAP AG 89
1.1.1.1.77 Transportation Charge Distribution Line Type
DataSource Texts: 0SCM_TM_TCDLNTP
This DataSource extracts data concerning the transportation charge distribution line type.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 90
1.1.1.1.78 Transportation Mode Category
DataSource Texts: 0SCM_TM_TMODECA
This DataSource extracts data concerning the transportation mode category.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 91
1.1.1.1.79 Transportation Mode Code
DataSource Texts: 0SCM_TM_TMODECD
This DataSource extracts data concerning the transportation mode code.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
MANDT Client - -
SPRAS Language Key - -
TRMODCODE Transportation Mode (TM specific)
- -
TRMODCODETXT Description of Transportation Mode
- -
SAP Library
(C) SAP AG 92
1.1.1.1.80 Transportation Order Category
DataSource Texts: BWBCT_DS_0SCM_TM_TORCAT
This DataSource extracts data concerning the transportation order category.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 93
1.1.1.1.81 Transportation Order Consolidation Allowed?
DataSource Texts: 0SCM_TM_TORCOAL
This DataSource extracts information as to whether the transportation order consolidation is allowed.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 94
1.1.1.1.82 Transportation Order Event Status
DataSource Texts: 0SCM_TM_TOREVENTSTATUS
This DataSource extracts data concerning the event status of the transportation order.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 95
1.1.1.1.83 Transportation Order Life Cycle Status
DataSource Texts: 0SCM_TM_TORLCS
This DataSource extracts data concerning the transportation order life cycle status.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 96
1.1.1.1.84 Transportation Order Type
DataSource Texts: 0SCM_TM_TORTYP
This DataSource extracts data concerning the transportation order type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
MANDT Client - -
LANGU Language Key - -
TYPE Business Document Type - -
DESCR Description of Document Type - -
SAP Library
(C) SAP AG 97
1.1.1.1.85 Transportation Request Category
DataSource Texts: 0SCM_TM_TRQCAT
This DataSource extracts data concerning the transportation request category.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 98
1.1.1.1.86 Transportation Request Life Cycle Status
DataSource Texts: 0SCM_TM_TRQLCS
This DataSource extracts data concerning the transportation request life cycle status.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
KEY1 Key Field for DataSource for Text
- -
DATETO Valid-To Date - -
DATEFROM Valid-From Date - -
TXTSH Short Description - -
TXTMD Medium Description - -
TXTLG Long Description - -
SAP Library
(C) SAP AG 99
1.1.1.1.87 Transportation Request Type
DataSource Texts: 0SCM_TM_TRQTYP
This DataSource extracts data concerning the transportation request type.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CLIENT Client - -
TYPE Business Document Type - -
LANGU Language Key - -
DESCRIPTION_S Short Description - -
SAP Library
(C) SAP AG 100
1.1.1.1.88 Transportation Service Level
DataSource Texts: 0SCM_TM_TRSLCD
This DataSource extracts data concerning the transportation service level code.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content version exists.
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
CLIENT Client - -
SPRAS Language Key - -
TRPPRIO135 Transportation Service Level Code
- -
DESCRIPTION Text, 40 Characters Long - -
SAP Library
(C) SAP AG 101
1.1.1.1.89 Type of Transportation Request Item
DataSource Texts: 0SCM_TM_TRQITEMT
This DataSource extracts data concerning the type of the transportation request item.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable No
Extraction from Archives No
Verifiable —
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LANGU Language Key - -
DESCRIPTION_S Description of an Item Type - -
ITEM_TYPE Item Type for Items in FWOs, FWQs, and Transportation Requirements
- -
SAP Library
(C) SAP AG 102
1.1.1.1.90 Unit Load Device Rate Class
DataSource Texts: 0SCM_TM_ULDCLASS
This DataSource extracts data concerning the unit load device rate class.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
KEY1 Key Field for DataSource for Text - -
LANGU Language Key - -
TXTLG Long Description - -
TXTMD Medium Description - -
TXTSH Short Description - -
SAP Library
(C) SAP AG 103
1.1.1.1.91 Unit Load Device Rate Types
DataSource Texts: 0SCM_TM_ULDTYPE
This DataSource extracts data concerning the unit load device rate types.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
DESCR Descriptive Text - -
SPRAS Language Key - -
ULD_RATE_TYPE Rate Type for Unit Load Device - -
SAP Library
(C) SAP AG 104
1.1.1.2 DataSources for Transactional Data
DataSources for transactional data extract data that are subject to frequent changes in an operational environment.
SAP Library
(C) SAP AG 105
1.1.1.2.1 Transactional Data of BO Business Share
DataSource Transactional Data: 0SCM_TM_BSH
This DataSource extracts transactional data from the business object Business Share.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BOOKED_CAPA_BSH Booked Business Share Quantity - -
BOOKED_CAPA_TSH Loading Quantity for Transportation Allocation/Business Share
- -
BS_ID Business Share - -
CREATED_BY Created by - -
CREATION_DATE Created on - -
CREATION_TSTMP Created on - -
DB_KEY_BSH Node ID - -
DB_KEY_REF_OBJ Node ID - -
DB_KEY_TS Node ID - -
EXCESS_PENCOST Penalty Costs for Exceeding Tolerance for Business Share
- -
GEO_FR_LOC_ID Location - -
GEO_FR_TYPE Geography Type - -
SAP Library
(C) SAP AG 106
GEO_FR_ZONE_ID Transportation Zone - -
GEO_TO_LOC_ID Location - -
GEO_TO_TYPE Geography Type - -
GEO_TO_ZONE_ID Transportation Zone - -
LINE_TYPE Business Share Line Type - -
LOAD_TYPE Allocation Load Type - -
MOT Transportation Mode - -
MTR Means of Transport - -
ORIENTATION Trade Lane Orientation for BW - -
QTY_VAL Loading Quantity for Transportation Allocation/Business Share
- -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SHORTG_PENCOST Penalty Costs for Tolerance Shortfall for Business Share
- -
TAGRET_VAL Target Value (%) for Business Share
- -
TDL_ID Trade Lane - -
TDL_UUID Node ID - -
TOL_NEG Negative Tolerance - -
TOL_POS Positive Tolerance - -
TOR_KEY Node ID - -
TOR_START_UTC Date/Time (UTC) for Transportation Allocation
- -
TSP Business Partner Number - -
UNIT Unit of Measure - -
VALID_FROM_DATE Validity Start Date - -
VALID_FROM_TSTMP Business Share: Start Time of Validity (UTC)
- -
VALID_TO_DATE Validity End Date - -
VALID_TO_TSTMP Business Share: End Time of Validity (UTC)
- -
SAP Library
(C) SAP AG 107
1.1.1.2.2 Transactional Data of BO Forwarding Settlement Document
DataSource Transactional Data: 0SCM_TM_CFIR
This DataSource extracts transactional data from the business object Forwarding Settlement Document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions 7.02 (TM 8.0); TM81 (TM 8.1)
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AMT_GDSV_CUR Goods Value Currency - -
AMT_GDSVC_VAL_2 Goods Value for Customs - -
AMT_GDSV_CUR Goods Value Currency - -
AMT_GDSVC_VAL_2 Goods Value - -
AMT_HVAL_CAR_IND High-Value Cargo - -
AMT_INSV_CUR Insurable Value Currency - -
AMT_INSV_VAL_2 Insurable Value - -
BASE_UOM_UNI Base Unit of Measure - -
BASE_UOM_VAL Base Quantity - -
CFIR_CAT Forwarding Settlement Document Categor
- -
CFIR_DBK Node ID - -
SAP Library
(C) SAP AG 108
CFIR_ID Forwarding Settlement Document
- -
CFIR_TYPE Forwarding Settlement Document Type
- -
CHANGED_BY Changed By - -
CHANGE_DATE Changed On - -
CHANGE_TSTMP Date/Time When the Item was Changed
- -
CM_REASON Credit Memo Reason Code - -
CNF_CONT_CNT_UNI Confirmed Number of TEU Unit of Measure
- -
CNF_CONT_CNT_VAL Confirmed Number of TEU - -
CNF_GRO_VOL_UNI Confirmed Gross Volume Unit of Measure
- -
CNF_GRO_VOL_VAL Confirmed Gross Volume - -
CNF_GRO_WEI_UNI Confirmed Gross Weight Unit of Measure
- -
CNF_GRO_WEI_VAL Confirmed Gross Weight - -
CNF_QUA_PCS_UNI Confirmed Pieces Unit of Measure
- -
CNF_QUA_PCS_VAL Confirmed Pieces - -
CONT_CNT_UNI Number of TEU Unit of Measure
- -
CONT_CNT_VAL Number of TEU - -
CREATED_BY Created By - -
CREATION_DATE Created On - -
CREATION_TSTMP Date/Time When the Item was Created
- -
FWSD_CLASS FWSD Classification - -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
GRO_WEI_VAL Gross Weight - -
INVOICE_DATE Invoice Date - -
LIFECYCLE Life Cycle Status of Forwarding Settlement Document
- -
SAP Library
(C) SAP AG 109
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
PKGUN_WEI_UNI Tare Weight Unit of Measure - -
PKGUN_WEI_VAL Tare Weight - -
QUA_PCS2_UNI Pieces 2 Unit of Measure - -
QUA_PCS2_VAL Pieces 2 - -
QUA_PCS_UNI Pieces Unit of Measure - -
QUA_PCS_VAL Pieces - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SALES_GRP_EXTID Sales Group External ID - -
SALES_OFF_EXTID Sales Office External ID - -
SALES_ORG_EXTID Sales Organization External ID - -
SAP Library
(C) SAP AG 110
1.1.1.2.3 Transactional Data of BO Freight Settlement Document
DataSource Transactional Data: 0SCM_TM_SFIR
This DataSource extracts transactional item data from the business object Freight Settlement Document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –-
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AMT_GDSVC_CUR Goods Value for Customs Currency
- -
AMT_GDSVC_VAL_2 Goods Value for Customs - -
AMT_GDSV_CUR Goods Value Currency - -
AMT_GDSV_VAL_2 Goods Value - -
AMT_HVAL_CAR_IND High-Value Cargo - -
AMT_INSV_CUR Insurable Value Currency - -
AMT_INSV_VAL_2 Insurable Value - -
BASE_UOM_UNI Base Unit of Measure - -
BASE_UOM_VAL Base Quantity - -
CHANGED_BY Changed By - -
CHANGE_DATE Changed On - -
SAP Library
(C) SAP AG 111
CHANGE_TSTMP Date/Time When the Item was Changed
- -
CNF_CONT_CNT_UNI Confirmed Number of TEU Unit of Measure
- -
CNF_CONT_CNT_VAL Confirmed Number of TEU - -
CNF_GRO_VOL_UNI Confirmed Gross Volume Unit of Measure
- -
CNF_GRO_VOL_VAL Confirmed Gross Volume - -
CNF_GRO_WEI_UNI Confirmed Gross Weight Unit of Measure
- -
CNF_GRO_WEI_VAL Confirmed Gross Weight - -
CNF_QUA_PCS_UNI Confirmed Pieces Unit of Measure
- -
CNF_QUA_PCS_VAL Confirmed Pieces - -
CONT_CNT_UNI Number of TEU Unit of Measure
- -
CONT_CNT_VAL Number of TEU - -
CREATED_BY Created By - -
CREATION_DATE Created On - -
CREATION_TSTMP Date/Time When the Item was Created
- -
CREATION_TYPE Creation Type of Freight Settlement Document
- -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
GRO_WEI_VAL Gross Weight - -
INVOICE_DATE Invoice Date - -
INV_AMOUNT_CURR Invoicing Currency - -
LIFECYCLE Life Cycle Status of Freight Settlement Document
- -
NET_INV_AMOUNT_2 Net Invoice Amount - -
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
PKGUN_WEI_UNI Tare Weight Unit of Measure - -
SAP Library
(C) SAP AG 112
PKGUN_WEI_VAL Tare Weight - -
PURCH_ORG_EXTID Purchase Organization External ID
- -
PURCH_GRP_EXTID Purchase Group External ID - -
QUA_PCS_VAL Pieces - -
QUA_PCS_UNI Pieces Unit of Measure - -
QUA_PCS2_VAL Pieces 2 - -
QUA_PCS2_UNI Pieces 2 Unit of Measure - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SFIR_CAT Freight Settlement Document Category
- -
SFIR_DBK Node ID - -
SFIR_ID Freight Settlement Document - -
SFIR_TYPE Freight Settlement Document Type
- -
SAP Library
(C) SAP AG 113
1.1.1.2.4 Transactional Data of BO FSD for Planned Transportation Charges
DataSource Transactional Data: 0SCM_TM_SFIR_PTC
This DataSource extracts transactional data from the business object Freight Settlement Document. The DataSource extracts data on the basis of planned transportation charges saved in the business object Freight Settlement Document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions 7.02 (TM 8.0); TM81 (TM 8.1); TM90 (TM 9.0)
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AMOUNT Amount - -
CALCULATION_DATE Calculation Date - -
CHANGE_DATE Changed On - -
CHRGCATCD021_I Charge Category - -
CREATION_DATE Created On - -
CURRCODE016 Currency - -
EXCH_RATE_DATE Exchange Rate Date for Document Currency Conversion
- -
EXCH_RATE_DATE_L Exchange Rate Date for Local Currency Conversion
- -
FAGRMNTID044 Agreement - -
FAGRMNTVSID045 Freight Agreement Version - -
SAP Library
(C) SAP AG 114
FAGRMNT_ITEM_NO Agreement Item Number - -
INVOICE_DATE Invoice Date - -
ITEM_DB_KEY Node ID - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
ROOT_LEVEL Calculation Level - -
SFIR_DBK Node ID - -
SFIR_ID Freight Settlement Document - -
SFIR_ITEM_ID Item - -
TARIFF_ID Transportation Charge Tariff - -
TCCALCRESINS040 Instruction Type - -
TCCLASS037 Charge Subcategory - -
TCET084 Charge Type - -
TCE_DBK Node ID - -
TOR_STAGE_KEY Node ID - -
SAP Library
(C) SAP AG 115
1.1.1.2.5 Transactional Data of BO FSD Item IV Information (Actual Costs)
DataSource Transactional Data: 0SCM_TM_SFIR_IV
This DataSource extracts transactional data from business object Freight Settlement Document. The DataSource extracts data on the basis of information coming from ERP invoice verification saved in business object Freight Settlement Document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BILL_FROM_PARTY Invoicing Party - -
CHANGE_DATE Changed On - -
CREATION_DATE Created On - -
DOCUMENT_DATE Document Date in Document - -
DOCUMENT_TYPE Document Type - -
INVOICE_DATE Invoice Date in Document - -
INVOICE_ID FSD Invoice Reference Document Number
- -
INVOICE_ITEM_ID FSD Invoicing Item in Invoice Document
- -
INV_FISCAL_YEAR Fiscal Year of ERP Invoice - -
INV_ITEM_AMOUNT Net Invoice Item Amount - -
SAP Library
(C) SAP AG 116
INV_ITEM_CURR Invoicing Currency - -
ITEM_DB_KEY Node ID - -
IV_DBK Node ID - -
POSTING_DATE Posting Date of ERP Document
- -
PUR_ORDER_ID Purchase Order Number - -
PUR_ORDER_ITM_ID Item Number of Purchase Order
- -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SES_ID Service Entry Sheet Number - -
SES_ITEM_ID Service Entry Sheet Item of a Reference Document
- -
SFIR_DBK Node ID - -
SFIR_ID Freight Settlement Document - -
SFIR_ITEM_ID Item - -
SAP Library
(C) SAP AG 117
1.1.1.2.6 Transactional Data of BO FWSD for Planned Transportation Charges
DataSource Transactional Data: 0SCM_TM_CFIR_PTC
The DataSource extracts transactional data on the basis of planned transportation charges saved in the business object Forwarding Settlement Document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions 7.02 (TM 8.0); TM81 (TM 8.1)
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images by Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AMOUNT Amount - -
CALCULATION_DATE Calculation Date - -
CFIR_DBK Node ID - -
CFIR_ID Forwarding Settlement Document
- -
CFIR_ITEM_ID Item - -
CHANGE_DATE Changed On - -
CHRGCATCD021_I Charge Category - -
CREATION_DATE Created On - -
CURRCODE016 Currency - -
EXCH_RATE_DATE Exchange Rate Date for Document Currency Conversion
- -
EXCH_RATE_DATE_L Exchange Rate Date for Local - -
SAP Library
(C) SAP AG 118
Currency Conversion
FAGRMNTID044 Agreement - -
FAGRMNTVSID045 Freight Agreement Version - -
FAGRMNT_ITEM_NO Agreement Item Number - -
INVOICE_DATE Invoice Date - -
ITEM_DB_KEY Node ID - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
ROOT_LEVEL Calculation Level - -
TARIFF_ID Transportation Charge Tariff - -
TCCALCRESINS040 Instruction Type - -
TCCLASS037 Charge Subcategory - -
TCET084 Charge Type - -
TCE_DBK Node ID - -
SAP Library
(C) SAP AG 119
1.1.1.2.7 Transactional Data of BO Transportation Allocation
DataSource Transactional Data: 0SCM_TM_TAL
This DataSource extracts transactional data from the business object Transportation Allocation.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81; TM90
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BASE_UOM_UNI Base Unit of Measure - -
BASE_UOM_UNICUR Base Unit of Measure - -
BASE_UOM_UNIMAX Base Unit of Measure - -
BASE_UOM_UNIMIN Base Unit of Measure - -
BASE_UOM_VAL Base Quantity - -
BASE_UOM_VALCUR Base Quantity - -
BASE_UOM_VALMAX Base Quantity - -
BASE_UOM_VALMIN Base Quantity - -
BUCKET_FROM Transportation Allocation: Start Time of Validity (UTC)
- -
BUCKET_FR_DATE Bucket From Date - -
BUCKET_TO Transportation Allocation: End Time of Validity (UTC)
- -
SAP Library
(C) SAP AG 120
BUCKET_TO_DATE Bucket To Date - -
BUCKET_TYPE Planning Period for Transportation Allocation
- -
CHANGED_BY Changed By - -
CHANGED_ON Changed On - -
CONT_CNT_UNI Number of TEU Unit of Measure - -
CONT_CNT_UNICUR Number of TEU Unit of Measure - -
CONT_CNT_UNIMAX Number of TEU Unit of Measure - -
CONT_CNT_UNIMIN Number of TEU Unit of Measure - -
CONT_CNT_VAL Number of TEU - -
CONT_CNT_VALCUR Number of TEU - -
CONT_CNT_VALMAX Number of TEU - -
CONT_CNT_VALMIN Number of TEU - -
CREATED_BY Created By - -
CREATION_DATE Created On - -
CREATION_TSTMP Created On - -
DB_KEY_BUCKET Node ID - -
DB_KEY_REFOBJ Node ID - -
DB_KEY_TAL Node ID - -
GEO_FR_LOC_ID Location - -
GEO_FR_TYPE Geography Type - -
GEO_FR_ZONE_ID Transportation Zone - -
GEO_TO_LOC_ID Location - -
GEO_TO_TYPE Geography Type - -
GEO_TO_ZONE_ID Transportation Zone - -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_UNICUR Gross Volume Unit of Measure - -
GRO_VOL_UNIMAX Gross Volume Unit of Measure - -
GRO_VOL_UNIMIN Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_VOL_VALCUR Gross Volume - -
GRO_VOL_VALMAX Gross Volume - -
SAP Library
(C) SAP AG 121
GRO_VOL_VALMIN Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
GRO_WEI_UNICUR Gross Weight Unit of Measure - -
GRO_WEI_UNIMAX Gross Weight Unit of Measure - -
GRO_WEI_UNIMIN Gross Weight Unit of Measure - -
GRO_WEI_VAL Gross Weight - -
GRO_WEI_VALCUR Gross Weight - -
GRO_WEI_VALMAX Gross Weight - -
GRO_WEI_VALMIN Gross Weight - -
LINE_TYPE Transportation Allocation Line Type
- -
LOAD_TYPE Allocation Load Type - -
MOT Transportation Mode Code - -
MTR Means of Transport - -
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_UNICUR Net Weight Unit of Measure - -
NET_WEI_UNIMAX Net Weight Unit of Measure - -
NET_WEI_UNIMIN Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
NET_WEI_VALCUR Net Weight - -
NET_WEI_VALMAX Net Weight - -
NET_WEI_VALMIN Net Weight - -
ORIENTATION Trade Lane Orientation for BW - -
PKGUN_WEI_UNI Tare Weight Unit of Measure - -
PKGUN_WEI_UNICUR Tare Weight Unit of Measure - -
PKGUN_WEI_UNIMAX Tare Weight Unit of Measure - -
PKGUN_WEI_UNIMIN Tare Weight Unit of Measure - -
PKGUN_WEI_VAL Tare Weight - -
PKGUN_WEI_VALCUR Tare Weight - -
PKGUN_WEI_VALMAX Tare Weight - -
PKGUN_WEI_VALMIN Tare Weight - -
ROCANCEL Deselect Data Record - -
SAP Library
(C) SAP AG 122
Checkbox for BW
TAL_CAT Transportation Allocation Category
- -
TAL_ID Transportation Allocation - -
TAL_TYPE Allocation Type - -
TDL_ID Trade Lane - -
TDL_UUID Node ID - -
TOR_KEY Node ID - -
TOR_START_UTC Date/Time (UTC) for Transportation Allocation
- -
TSP Business Partner Number - -
TZONE Time Zone - -
VALID_FROM_DATE Validity Start Date - -
VALID_FROM_TSTMP Transportation Allocation: Start Time of Validity (UTC)
- -
VALID_TO_DATE Validity End Date - -
VALID_TO_TSTMP Transportation Allocation: End Time of Validity (UTC)
- -
SAP Library
(C) SAP AG 123
1.1.1.2.8 Transactional Data of BO Transportation Order
DataSource Transactional Data: 0SCM_TM_TOR
This DataSource extracts transactional data from the business object Transportation Order.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions 7.02 (TM 8.0); TM81 (TM 8.1); TM90 (TM 9.0)
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
ARRIVAL_DATE Transportation Planning Date - -
BL_NUMBER House Bill of Lading - -
CHANGED_BY Changed By - -
CHANGE_DATE Changed On - -
CHANGE_TSTMP Date/Time When the Item was Changed
- -
COMPLETION_DATE Completion Date - -
COMPLETION_TSTMP Date/Time - -
CONSOL_TYPE Air Waybill Type - -
CONS_ALLOWED Consolidation Allowed - -
CONTRACT_BASIS Contract Basis - -
CREATED_BY Created By - -
CREATION_DATE Created On - -
SAP Library
(C) SAP AG 124
CREATION_TSTMP Date/Time When the Item was Created
- -
CREATION_TYPE Creation Type - -
DENSITY_FACTOR Density Factor - -
DROP_COUNT Number of Deliveries - -
DROP_COUNT_UNLOA Number of Transportation Stops with Unloading Activities
- -
FREIGHT_TERM Freight Term - -
GEN_SEC_STATUS Air Cargo Security Status - -
LIFECYCLE Life Cycle Status - -
MAX_UTIL Maximum Utilization - -
MAX_UTIL_MASS Maximum Utilization - -
MAX_UTIL_VOLUME Maximum Utilization - -
MLB_ISSUING_DATE Master Bill of Lading Issuing Date
- -
MOVEM_TYPE Movement Type - -
MULTIPICK_STOP_I Multi-Stop - -
NET_DRIV_DURATIO Total Duration - -
PARTNER_MBL_ID Carrier's Master Bill of Lading Number
- -
PICK_COUNT Potential Loading Stops - -
PICK_COUNT_LOAD Number of Stops with Loading Activities
- -
PLANNED_STAGES Number of Deliveries - -
PURCH_GRP_EXTID Purchasing Group External ID - -
PURCH_ORG_EXTID Purchasing Organization External ID
- -
QUA_PCS_TO_SPLIT Pieces to Be Split - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SHIPPING_TYPE Shipping Type - -
STOP_LOC_COUNT Number of Visits - -
TOR_CAT Business Document Category - -
TOR_DB_KEY Node ID - -
TOR_ID Document - -
SAP Library
(C) SAP AG 125
TOR_TYPE Business Document Type - -
TOT_DISTANCE_KM Total Distance - -
TOT_DURATION Total Duration - -
TRAFFIC_DIRECT Traffic Direction - -
TSP_AIRLCAWB Air Waybill Prefix - -
UNCONTROLLED Uncontrolled Transportation - -
SAP Library
(C) SAP AG 126
1.1.1.2.9 Transactional Data of BO Transportation Request
DataSource Transactional Data: 0SCM_TM_TRQ
This DataSource extracts transactional item data from business object Transportation Request.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions 7.02 (TM 8.0); TM81 (TM 8.1); TM90 (TM 9.0)
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIMD After-Images with Deletion Flag By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AIR_SECURITY Air Cargo Security Status - -
CHANGED_BY Changed By - -
CHANGE_DATE Changed On - -
CHANGE_TSTMP Date/Time When the Item was Changed
- -
CNCL_RSN_CODE Reason for Cancellation - -
COMPLETION_DATE Completion Date - -
COMPLETION_TSTMP Date/Time - -
CREATED_BY Created By - -
CREATION_DATE Created On - -
CREATION_TSTMP Date/Time When the Item was Created
- -
SAP Library
(C) SAP AG 127
DES_LOC_IATACODE Destination Location: IATA Code - -
DES_LOC_UNLOCODE Destination Location: United Nations Code
- -
GT_EXP_DECL_LSP Export Declaration by Logistics Service Provider
- -
INC_LOC_ID Incoterm Location - -
LIFECYCLE Life Cycle Status of FWO/FWQ or Trsp. Reqt
- -
MOVEM_TYPE Movement Type - -
PIC_EAR_ACC Earliest Pick-Up - -
PIC_LAT_ACC Latest Pick-Up - -
REGULATED_AGENT Regulated Agent Code - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SALES_GRP_EXTID Sales Group External ID - -
SALES_OFF_EXTID Sales Office External ID - -
SALES_ORG_EXTID Sales Organization External ID - -
SHIPPING_TYPE Shipping Type - -
SRC_LOC_IATACODE Source Location: IATA Code - -
SRC_LOC_UNLOCODE Source Location: United Nations Code
- -
TRACKING_NO Tracking Number - -
TRAFFIC_DIRECT Traffic Direction - -
TRQ_CAT Category (Forwarding Order/Quotation or Transportation Requirement)
- -
TRQ_DB_KEY Node ID - -
TRQ_ID ID of Forwarding Order/Quotation or Transportation Requirement
- -
TRQ_TYPE Type of FWO, FWQ, or Transportation Requirement
- -
TSP_AIRLCAWB Air Waybill Prefix - -
TSP_SCAC Standard Carrier Alpha Code - -
UNCONTROLLED Uncontrolled Transportation - -
UNLOAD_POINT Unloading Point Name - -
SAP Library
(C) SAP AG 128
1.1.1.2.10 Transactional Data of Charge Distribution of BO FSD
DataSource Transactional Data: 0SCM_TM_SFIR_TCD
This DataSource extracts transactional data concerning the charge distribution from the business object Freight Settlement Document (FSD).
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable Yes
Extraction from Archives
No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BTDITEM_ID Item - -
BTDITEM_TCO Business Transaction Document Item Type Code
- -
BTD_ID Business Transaction Document ID
- -
BTD_TCO Document Type for Business Transaction
- -
CALC_RES_BASE Calculation Resolution Base - -
CANCEL_FLAG Boolean Variable (X=True, -=False, Space=Unknown)
- -
CHARGE_EL_REFKEY NodeID - -
SAP Library
(C) SAP AG 129
CHARGE_TYPE Charge Type - -
CHRGCAT Charge Category - -
CHRGCAT2 Charge Category - -
CHRGSUBCAT Charge Subcategory - -
CURRCODE016 Currency - -
DISTRDATE Distribution Date - -
DISTR_LEVEL Distribution Level - -
DIST_ITEM_CAT Distribution Item Category - -
DOC_CURRENCY Document Currency - -
FSD_CHANGED_DATE Changed On - -
FSD_CREAT_DATE Created On - -
FSD_INVOICE_DATE Invoice Date - -
HOST_DBK Node ID - -
INSTRUCTION_TYPE Instruction Type - -
ITEM_PARENT_KEY NodeID - -
LINE_TYPE Transportation Charge Distribution Line Type
- -
NET_AMOUNT_DOC Net Amount in Document Currency
- -
ORIG_REF_ROOT NodeID - -
QTY_UNI Unit of Measure - -
REF_DESC Description - -
REF_KEY Node ID - -
REF_ROOT_KEY Node ID - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
TCD_ELM_DBK Node ID - -
TCD_EL_AMOUNT Amount - -
TCD_EL_DIS_RULE Distribution Rule - -
TCD_EL_QTY Quantity - -
TCD_ITEM_AMOUNT Amount - -
TCD_ITM_DBK Node ID - -
TCD_ITM_QTY Quantity - -
SAP Library
(C) SAP AG 130
TCD_ROOT_DBK Node ID - -
TCD_RO_DIS_RULE Distribution Rule - -
TCD_TOT_QTY_VAL Quantity - -
TRANS_DIS_LEVEL Distribution Level - -
SAP Library
(C) SAP AG 131
1.1.1.2.11 Transactional Data of Charge Distribution of BO TO
DataSource Transactional Data: 0SCM_TM_TOR_TCD
This DataSource extracts transactional data concerning the charge distribution from the business object Transportation Order (TO).
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable Yes
Extraction from Archives
No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BTDITEM_ID Item - -
BTDITEM_TCO Business Transaction Document Item Type Code
- -
BTD_ID Business Transaction Document ID
- -
BTD_TCO Document Type for Business Transaction
- -
CALC_RES_BASE Calculation Resolution Base - -
CANCEL_FLAG Boolean Variable (X=True, -=False, Space=Unknown)
- -
CHARGE_EL_REFKEY Node ID - -
SAP Library
(C) SAP AG 132
CHARGE_TYPE Charge Type - -
CHRGCAT Charge Category - -
CHRGCAT2 Charge Category - -
CHRGSUBCAT Charge Subcategory - -
CURRCODE016 Currency - -
DISTRDATE Distribution Date - -
DISTR_LEVEL Distribution Level - -
DIST_ITEM_CAT Distribution Item Category - -
DOC_CURRENCY Document Currency - -
HOST_DBK Node ID - -
INSTRUCTION_TYPE Instruction Type - -
ITEM_PARENT_KEY Node ID - -
LINE_TYPE Transportation Charge Distribution Line Type
- -
NET_AMOUNT_DOC Net Amount in Document Currency
- -
ORIG_REF_ROOT Node ID - -
QTY_UNI Unit of Measure - -
REF_DESC Description - -
REF_KEY Node ID - -
REF_ROOT_KEY Node ID - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
TCD_ELM_DBK Node ID - -
TCD_EL_AMOUNT Amount - -
TCD_EL_DIS_RULE Distribution Rule - -
TCD_EL_QTY Quantity - -
TCD_ITEM_AMOUNT Amount - -
TCD_ITM_DBK Node ID - -
TCD_ITM_QTY Quantity - -
TCD_ROOT_DBK Node ID - -
TCD_RO_DIS_RULE Distribution Rule - -
TCD_TOT_QTY_VAL Quantity - -
SAP Library
(C) SAP AG 133
TO_CHANGE_DATE Changed On - -
TO_COMPL_DATE Completion Date - -
TO_CREATION_DATE Created On - -
TRANS_DIS_LEVEL Distribution Level - -
SAP Library
(C) SAP AG 134
1.1.1.2.12 Transactional Data of Execution Information of BO TO
DataSource Transactional Data: 0SCM_TM_TOR_EXE
This DataSource extracts transactional data of execution information of the business object Transportation Order.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81; TM90
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
ACTUAL_DATE Actual Date/Time of Event - -
CHANGED_BY Changed By - -
CHANGED_ON Changed On - -
CHANGE_DATE Changed On - -
COMPLETION_DATE Completion Date - -
CREATED_BY Created By - -
CREATED_ON Created on - -
CREATION_DATE Created On - -
DISCREPANCY Discrepancy - -
DISCR_NO_BLOCK Discrepancy Type Leads to Block or Not
- -
DISCR_TYPE Discrepancy Type - -
SAP Library
(C) SAP AG 135
DURATION_INFO Duration Information for TO Root - -
DURATION_PLD_ACT Duration - -
DUR_DEPT_ARRIV Duration - -
DUR_LOAD_BEG_END Duration - -
DUR_POPU_POD Duration - -
DUR_UNLD_BEG_END Duration - -
ESTIMATED_DATE Date/Time - -
EVENT_CODE Event Occuring for a Transportation Activity
- -
EVENT_REASON Reason of Event Occuring for a Transportation Activity
- -
EVENT_REVOKED Event Has Been Recalled - -
EVENT_STATUS Event Status - -
EXECINFO_SOURCE Source of Execution Information - -
EXECUTION_ID Item - -
EXEC_ROLE_CAT Party Role - -
EXE_DBK Node ID - -
EXP_END_DATE Date/Time - -
EXT_LOC_ID Bus. Trans. Document ID - -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
GRO_WEI_VAL Gross Weight - -
NET_DURATION Duration - -
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
PDUR_DEPT_ARRIV Duration - -
PDUR_LOD_BEG_END Duration - -
PDUR_POPU_POD Duration - -
PDUR_UNL_BEG_END Duration - -
QUA_PCS_UNI Pieces Unit of Measure - -
QUA_PCS_VAL Pieces - -
SAP Library
(C) SAP AG 136
REF_EVENT_CODE Event Occuring for a Transportation Activity
- -
ROCANCEL Deselect Data Record Checkbox for BW
- -
TORITMUUID UUID of Transportation Order Item with Conversion Exit
- -
TORSTOPUUID UUID of Stop of Transportation Order with Conversion Exit
- -
TOR_DBK Node ID - -
TRANS_ACTIVITY Transportation Activity - -
UNEXP_EVENT Unexpected Event - -
SAP Library
(C) SAP AG 137
1.1.1.2.13 Transactional Data of Stage Information of BO TO
DataSource Transactional Data: 0SCM_TM_TOR_STG
This DataSource extracts transactional data of stage information of the business object Transportation Order.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable Yes
Extraction from Archives
No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AGREEMENT_PARTY Agreement Party Role - -
AIRCRAFT_CODE IATA Aircraft Type Code - -
BASE_UOM_UNI Base Unit of Measure - -
BASE_UOM_VAL Base Quantity - -
CHANGE_DATE Changed On - -
COMPLETION_DATE Completion Date - -
CONT_CNT_UNI Number of TEU Unit of Measure - -
CONT_CNT_VAL Number of TEU - -
CREATION_DATE Created On - -
SAP Library
(C) SAP AG 138
CUTOFF_CARGOMLS Cargo Cut-Off Date/Time - -
CUTOFF_CUST_DOC Customs Documentation Cut-Off Date/Time
- -
CUTOFF_DG_DOCMLS Dangerous Goods Documentation Cut-Off Date/Time
- -
CUTOFF_DOCMLS Document Cut-Off Date/Time - -
DEST_STOP_KEY NodeID - -
DES_ACC_END Acceptable End Date/Time at Stop
- -
DES_ACC_START Acceptable Start Date/Time at Stop
- -
DES_ASSGN_END Transportation Planning Date - -
DES_ASSGN_HRCO Capacity Consumption of Handling Resource
- -
DES_ASSGN_START Transportation Planning Date - -
DES_ASSG_CAT Stop Assignment Category - -
DES_CARR_C_END End of Pick-Up/Delivery Window Confirmed by carrier
- -
DES_CARR_C_STA Start of Pick-Up/Delivery Window Confirmed by Carrier
- -
DES_CUTOFF_CGO Cargo Cut-Off Date/Time - -
DES_CUTOFF_CUS Customs Documentation Cut-Off Date/Time
- -
DES_CUTOFF_DG Dangerous Goods Documentation Cut-Off Date/Time
- -
DES_CUTOFF_DOC Document Cut-Off Date/Time - -
DES_DATES_SETB Origin of Entry - -
DES_ENTRY_PORT Port of Entry - -
DES_EXIT_PORT Port of Exit - -
DES_HANDL_EXEC Handling Execution Status on Stop Level
- -
DES_LOG_LOC Destination Location - -
DES_LOG_LOCIATA International Air Transport Association: Location
- -
DES_LOG_LOCUN United Nations Code for Trade and Transport Locations
- -
SAP Library
(C) SAP AG 139
DES_NET_DUR Duration - -
DES_REQ_END Requested End Date/Time at Stop
- -
DES_REQ_START Requested Start Date/Time at Stop
- -
DES_STOP_CAT Stop Category - -
DES_STOP_ORIG Stop Origin - -
DES_STOP_ROLE Role of the Stop - -
DES_TRQ_ACC_EN Acceptable End Date/Time at Stop
- -
DES_TRQ_ACC_ST Acceptable Start Date/Time at Stop
- -
DES_TRQ_REQ_EN Requested End Date/Time at Stop
- -
DES_TRQ_REQ_ST Requested Start Date/Time at Stop
- -
DISTANCE_KM Decimal Value - -
DURATION_NET Duration - -
EXEC_GRP_ID Planning and Execution Group - -
EXEC_ORG_ID Planning and Execution Organization
- -
FLAG_COUNTRY Country Key - -
FLIGHT_CODE Airline Code and Flight Number - -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
GRO_WEI_VAL Gross Weight - -
GT_CUST_ACT_INB Customs Activity Inbound - -
IMO_ID IMO Ship Identification Number - -
I_CO2_EMISSION Carbon Dioxide Emissions - -
I_CO2_EMISSION_U Unit for Carbon Dioxide Emissions
- -
I_EMISS_WEIGHT Sustainability-Relevant Weight - -
I_EMISS_WEIGHT_U Sustainability-Relevant Weight Unit of Measure
- -
SAP Library
(C) SAP AG 140
I_FACTOR Sustainability Factor - -
I_FUEL_CONSUMP Fuel Consumption - -
I_FUEL_CONSUMP_U Unit for Fuel Consumption - -
I_RESULT_LEVEL Result Level of Distance Emissions
- -
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
PKGUN_WEI_UNI Tare Weight Unit of Measure - -
PKGUN_WEI_VAL Tare Weight - -
QUA_PCS2_UNI Pieces 2 Unit of Measure - -
QUA_PCS2_VAL Pieces 2 - -
QUA_PCS_UNI Pieces Unit of Measure - -
QUA_PCS_VAL Pieces - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SEQ_NUM Sequence Number - -
SOURCE_STOP_KEY NodeID - -
SRC_ACC_END Acceptable End Date/Time at Stop
- -
SRC_ACC_START Acceptable Start Date/Time at Stop
- -
SRC_ASSGN_END Transportation Planning Date - -
SRC_ASSGN_HRCO Capacity Consumption of Handling Resource
- -
SRC_ASSGN_START Transportation Planning Date - -
SRC_ASSG_CAT Stop Assignment Category - -
SRC_CARR_C_END End of Pick-Up/Delivery Window Confirmed by carrier
- -
SRC_CARR_C_STA Start of Pick-Up/Delivery Window Confirmed by Carrier
- -
SRC_CUTOFF_CGO Cargo Cut-Off Date/Time - -
SRC_CUTOFF_CUS Customs Documentation Cut-Off Date/Time
- -
SRC_CUTOFF_DG Dangerous Goods Documentation Cut-Off Date/Time
- -
SAP Library
(C) SAP AG 141
SRC_CUTOFF_DOC Document Cut-Off Date/Time - -
SRC_DATES_SETB Origin of Entry - -
SRC_ENTRY_PORT Port of Entry - -
SRC_EXIT_PORT Port of Exit - -
SRC_HANDL_EXEC Handling Execution Status on Stop Level
- -
SRC_LOG_LOC Source Location - -
SRC_LOG_LOCIATA International Air Transport Association: Location
- -
SRC_LOG_LOCUN United Nations Code for Trade and Transport Locations
- -
SRC_NET_DUR Duration - -
SRC_REQ_END Requested End Date/Time at Stop
- -
SRC_REQ_START Requested Start Date/Time at Stop
- -
SRC_STOP_CAT Stop Category - -
SRC_STOP_ORIG Stop Origin - -
SRC_STOP_ROLE Role of the Stop - -
SRC_TRQ_ACC_EN Acceptable End Date/Time at Stop
- -
SRC_TRQ_ACC_ST Acceptable Start Date/Time at Stop
- -
SRC_TRQ_REQ_EN Requested End Date/Time at Stop
- -
SRC_TRQ_REQ_ST Requested Start Date/Time at Stop
- -
STAGE_ID Transportation Stage ID - -
STAGE_TYPE Stage Type - -
STATISTICAL Not Relevant for Planning - -
TOR_DBK NodeID - -
TOR_ITM_DBK NodeID - -
TOR_STG_DBK NodeID - -
TRANSMEANSTYPECD Means of Transport - -
TRANSMODECODE Transportation Mode - -
SAP Library
(C) SAP AG 142
TRMODCAT Transportation Mode Category - -
TSP_AIRLC IATA Airline Code - -
TSP_ID Carrier - -
TSP_SCAC Standard Carrier Alpha Code - -
VESSEL_ID Vessel - -
VOYAGE_ID Departure/Journey ID - -
SAP Library
(C) SAP AG 143
1.1.1.2.14 Transactional Data of Stage Information of BO TR
DataSource Transactional Data: 0SCM_TM_TRQ_STG
This DataSource extracts transactional data of stage information of the business object Transportation Request.
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable Yes
Extraction from Archives
No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AGREEMENT_PARTY Agreement Party Role - -
CHANGE_DATE Changed On - -
COMPLETION_DATE Completion Date - -
CREATION_DATE Created On - -
DEL_EAR_ACC Earliest Delivery - -
DEL_EAR_REQ Delivery (From) - -
DEL_LAT_ACC Latest Delivery - -
DEL_LAT_REQ Delivery (To) - -
DES_LOG_LOCIATA Destination Location: IATA Code
- -
SAP Library
(C) SAP AG 144
DES_LOC_ID Destination Location - -
DES_LOC_UNLOCODE Destination Location: United Nations Code
- -
PIC_EAR_ACC Earliest Pick-Up - -
PIC_EAR_REQ Pick-Up (From) - -
PIC_LAT_ACC Latest Pick-Up - -
PIC_LAT_REQ Pick-Up (To) - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SRC_LOC_IATACODE Source Location: IATA Code - -
SRC_LOC_ID Source Location - -
SRC_LOC_UNLOCODE Source Location: United Nations Code
- -
STAGE_ID Transportation Stage ID - -
STAGE_SEQ_ID Sequence Number - -
STAGE_TYPE Stage Type - -
TRANSMEANSTYPECD Means of Transport - -
TRANSMODECODE Transportation Mode - -
TRMODCAT Transportation Mode Category - -
TRQ_DBK Node ID - -
TRQ_ITM_DBK Node ID - -
TRQ_STG_DBK Node ID - -
TSP_AIRLC IATA Airline Code - -
TSP_AIRLCAWB Air Waybill Prefix - -
TSP_ID Carrier - -
TSP_SCAC Standard Carrier Alpha Code - -
UNLOAD_POINT Unloading Point Name - -
SAP Library
(C) SAP AG 145
1.1.1.2.15 Transactional Data of Trade Lanes of BO Transportation Order
DataSource Transactional Data: 0SCM_TM_TOR_TDL
This DataSource extracts transactional data of trade lanes of the business object Transportation Order.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.1
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions TM81; TM90
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
LOCATION_ID Location - -
MOT Transportation Mode - -
MTR Means of Transport - -
ORIENTATION_BW Trade Lane Orientation for BW - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
TDL_DBK Node ID - -
TDL_ID Trade Lane - -
TDL_REL_TYPE Relation Type of TRL for BW - -
TOR_DBK Node ID - -
TOR_ITM_DBK Node ID - -
TOR_STG_DBK Node ID - -
TZONE_ID Transportation Zone - -
SAP Library
(C) SAP AG 146
1.1.1.2.16 Transactional Item Data of BO Forwarding Settlement Document
DataSource Transactional Data: 0SCM_TM_CFIR_ITM
This DataSource extracts transactional item data from business object Forwarding Settlement Document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BILL_TO_PARTY Bill-To Party - -
CFIR_DBK Node ID - -
CHANGE_DATE Changed On - -
CREATION_DATE Created On - -
INVOICE_DATE Invoice Date - -
ITEM_DB_KEY Node ID - -
ITEM_ID Item - -
ITEM_PARENT_KEY Node ID - -
ORDERER Ordering Party - -
PAYER Payer - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SAP Library
(C) SAP AG 148
1.1.1.2.17 Transactional Item Data of BO Freight Settlement Document
DataSource Transactional Data: 0SCM_TM_SFIR_ITM
This DataSource extracts transactional item data from business object Freight Settlement Document.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 5 SP02
Content Versions No content versions exist.
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
BILL_FROM_PARTY Invoicing Party - -
CHANGE_DATE Changed On - -
CONFIRMATION Freight Settlement Document Item Confirmation Status
- -
CONSIGNEE Consignee - -
CREATION_DATE Created On - -
INVOICE_DATE Invoice Date - -
ITEM_DB_KEY Node ID - -
ITEM_ID Item - -
ITEM_PARENT_KEY Node ID - -
PAYEE Payee - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SAP Library
(C) SAP AG 149
SFIR_DBK Node ID - -
SHIPPER Shipper - -
TOR_ITEM_KEY Node ID - -
TOR_ITEM_TR_KEY Node ID - -
TOR_ROOT_KEY Node ID - -
TRANSFER Freight Settlement Document Item Transfer Status
- -
SAP Library
(C) SAP AG 150
1.1.1.2.18 Transactional Item Data of BO Transportation Order
DataSource Transactional Data: 0SCM_TM_TOR_ITM
This DataSource extracts transactional item data from business object Transportation Order.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions 7.02 (TM 8.0); TM81 (TM 8.1); TM90 (TM 9.0)
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIM After-Images By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AMT_GDSVC_CUR Goods Value for Customs Currency
- -
AMT_GDSVC_VAL_2 Goods Value for Customs - -
AMT_GDSV_CUR Goods Value Currency - -
AMT_GDSV_VAL_2 Goods Value - -
AMT_HVAL_CAR_IND High-Value Cargo - -
AMT_INSV_CUR Insurable Value Currency - -
AMT_INSV_VAL_2 Insurable Value - -
BASE_UOM_UNI Base Unit of Measure - -
BASE_UOM_VAL Base Quantity - -
CAPACITY_REL Capacity Relevance Flag - -
CARGO_RECEIPT Cargo Receipt Status on Item Level
- -
SAP Library
(C) SAP AG 151
CHANGE_DATE Changed On - -
CNF_CONT_CNT_UNI Confirmed Number of TEU Unit of Measure
- -
CNF_CONT_CNT_VAL Confirmed Number of TEU - -
CNF_GRO_VOL_UNI Confirmed Gross Volume Unit of Measure
- -
CNF_GRO_VOL_VAL Confirmed Gross Volume - -
CNF_GRO_WEI_UNI Confirmed Gross Weight Unit of Measure
- -
CNF_GRO_WEI_VAL Confirmed Gross Weight - -
CNF_QUA_PCS_UNI Confirmed Pieces Unit of Measure
- -
CNF_QUA_PCS_VAL Confirmed Pieces - -
COMPLETION_DATE Completion Date - -
CONSIGNEE Consignee - -
CONT_CNT_UNI Number of TEU Unit of Measure - -
CONT_CNT_VAL Number of TEU - -
CREATION_DATE Created On - -
DGO_CHECK_ERROR Dangerous Goods Check Error - -
DGO_INDICATOR Dangerous Goods - -
DISCREPANCY Discrepancy - -
DISCR_NO_BLOCK Discrepancy Type Leads to Block or Not
- -
DT_PRIORITY_C Business Transaction Priority Code
- -
ERP_COMP_CODE Company Code - -
ERP_COMP_ORG_ID Company Organization - -
ERP_PLANT_ID Plant - -
FLIGHT_CODE Airline Code and Flight Number - -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
GRO_WEI_VAL Gross Weight - -
HANDLING_CARGO Cargo Execution Status on Item Level
- -
SAP Library
(C) SAP AG 152
HEIGHT Height - -
INC_CLASS_CODE Incoterm - -
INC_LOC_ID Incoterm Location - -
INC_TRANSF_LOC_N Incoterm Location (Free Text) - -
ITEM_CAT Item Category - -
ITEM_DB_KEY Node ID - -
ITEM_DESCR Item Description - -
ITEM_ID Item - -
ITEM_PARENT_KEY Node ID - -
LENGTH Length - -
LOC_FROM Source Location - -
LOC_FR_IATA International Air Transport Association: Location
- -
LOC_FR_UNLO United Nations Code for Trade and Transport Locations
- -
LOC_TO Destination Location - -
LOC_TO_IATA International Air Transport Association: Location
- -
LOC_TO_UNLO United Nations Code for Trade and Transport Locations
- -
MEASUOM Unit of measure for length, width and height
- -
MIXED_PALLET_IND Mixed ULD - -
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
NON_STACKABLE Non-Stackable Packages - -
ORIGIN_BO Short Name of Business Object - -
OVERDIM_CARGO Overdimensional Cargo - -
OVERDIM_ITEM_ID Item - -
PACKAGE_ID Package - -
PACKAGE_TCO Package Type - -
PIV_WEI_UNI Pivot Weight Unit of Measure - -
PIV_WEI_VAL Pivot Weight - -
PKGUN_WEI_UNI Tare Weight Unit of Measure - -
SAP Library
(C) SAP AG 153
PKGUN_WEI_VAL Tare Weight - -
PRD_DGPROFL Dangerous Goods Indicator Profile
- -
PRD_FRGHT_GRP Product Freight Group - -
PRD_KEY Product GUID - -
PRD_TRANSP_GRP Product Transportation Group Code
- -
PRODUCT_ID Product - -
QUA_PCS2_UNI Pieces 2 Unit of Measure - -
QUA_PCS2_VAL Pieces 2 - -
QUA_PCS_UNI Pieces Unit of Measure - -
QUA_PCS_VAL Pieces - -
RESP_EXP_ORG Business Partner Number - -
RESP_IMP_ORG Business Partner Number - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SHIPPER Shipper - -
SHIPPER_OWN Shipper-Owned Container - -
SPLIT_INDICATOR Item Split - -
TOPM_CARGO_ITEM Top Cargo Item - -
TOR_DB_KEY Node ID - -
TRANSMEANSTYPECD Means of Transport - -
TRANSMODECODE Transportation Mode - -
TRANSSRVLVL_CODE Transportation Service Level - -
TRMODCAT Transportation Mode Category - -
TSP Carrier - -
TSP_AIRLC IATA Airline Code - -
TSP_EXEC Executing Carrier - -
TSP_EXEC_SCAC Standard Carrier Alpha Code - -
TSP_SCAC Standard Carrier Alpha Code - -
TURES_CAT Equipment Group - -
TURES_TCO Equipment Type - -
ULD_RATE_CLASS Rate Class - -
SAP Library
(C) SAP AG 154
ULD_RATE_TYPE Rate Type for Unit Load Device - -
VOYAGE_ID Departure/Journey ID - -
WIDTH Width - -
SAP Library
(C) SAP AG 155
1.1.1.2.19 Transactional Item Data of BO Transportation Request
DataSource Transactional Data: 0SCM_TM_TRQ_ITM
This DataSource extracts transactional item data from the business object Transportation Request.
Technical Data
Application Component SAP Transportation Management (TM)
Available as of Release SAP Transportation Management 8.0
Shipment SAP NetWeaver 7.0 BI Content Add-On 6 SP03
Content Versions 7.02 (TM 8.0); TM81 (TM 8.1); TM90 (TM 9.0)
RemoteCube-Capable No
Delta-Capable Yes
Extraction from Archives No
Verifiable –
Data Modeling
Delta Update
A delta update is supported. Delta process: AIMD After-Images with Deletion Flag By Delta Queue.
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AMT_GDSVC_CUR Goods Value for Customs Currency - -
AMT_GDSVC_VAL_2 Goods Value for Customs - -
AMT_GDSV_CUR Goods Value Currency - -
AMT_GDSV_VAL_2 Goods Value - -
AMT_HVAL_CAR_IND High-Value Cargo - -
AMT_INSV_CUR Insurable Value Currency - -
AMT_INSV_VAL_2 Insurable Value - -
BASE_BTD_ID Base Business Transaction Document
- -
BASE_UOM_UNI Base Unit of Measure - -
BASE_UOM_VAL Base Quantity - -
SAP Library
(C) SAP AG 156
BILL_TO_PARTY Bill-To Party - -
CHANGE_DATE Changed On - -
CNF_CONT_CNT_UNI Confirmed Number of TEU Unit of Measure
- -
CNF_CONT_CNT_VAL Confirmed Number of TEU - -
CNF_GRO_VOL_UNI Confirmed Gross Volume Unit of Measure
- -
CNF_GRO_VOL_VAL Confirmed Gross Volume - -
CNF_GRO_WEI_UNI Confirmed Gross Weight Unit of Measure
- -
CNF_GRO_WEI_VAL Confirmed Gross Weight - -
CNF_QTY_UNI Confirmed Quantity Unit - -
CNF_QTY_VAL Confirmed Quantity - -
CNF_QUA_PCS_UNI Confirmed Pieces Unit of Measure - -
CNF_QUA_PCS_VAL Confirmed Pieces - -
COLLECT_AGREEM Collect Agreement Party - -
COLLECT_BILL_TO Collect Bill-To Party - -
COLLECT_PAYER Collect Payer Party - -
COMPLETION_DATE Completion Date - -
CONSIGNEE Consignee - -
CONT_CNT_UNI Number of TEU Unit of Measure - -
CONT_CNT_VAL Number of TEU - -
CREATION_DATE Created On - -
DGO_CHECK_ERROR Dangerous Goods Check Error - -
DGO_INDICATOR Dangerous Goods - -
DT_PRIORITY_C Business Transaction Priority Code - -
ERP_COMP_CODE Company Code - -
ERP_COMP_ORG_ID Company Organization - -
ERP_PLANT_ID Plant - -
GOODS_BUYER Goods Buyer Party - -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
SAP Library
(C) SAP AG 157
GRO_WEI_VAL Gross Weight - -
HEIGHT Height - -
INC_CLASS_CODE Incoterm - -
INC_LOC_ID Incoterm Location - -
INC_TRANSF_LOC_N Incoterm Location (Free Text) - -
ITEM_CAT Item Category - -
ITEM_DB_KEY Node ID - -
ITEM_DESCR Item Description - -
ITEM_ID Item - -
ITEM_PARENT_KEY Node ID - -
ITEM_TYPE Item Type for Items in FWOs, FWQs, and Transportation Requirements
- -
LENGTH Length - -
LOC_FROM Source Location - -
LOC_FR_IATA Source Location: IATA Code - -
LOC_FR_UNLO Source Location: United Nations Code
- -
LOC_TO Destination Location - -
LOC_TO_IATA Destination Location: IATA Code - -
LOC_TO_UNLO Destination Location: United Nations Code
- -
MAIN_CARGO_ITEM Main Cargo Item - -
MEASUOM Unit of measure for length, width and height
- -
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
NON_STACKABLE Non-Stackable Packages - -
OPEN_QTY_UNI Open Quantity Delivery Unit - -
OPEN_QTY_VAL Open Quantity - -
ORDERER Ordering Party - -
PACKAGE_ID Package - -
PACKAGE_TCO Package Type - -
PAYER Payer - -
SAP Library
(C) SAP AG 158
PKGUN_WEI_UNI Tare Weight Unit of Measure - -
PKGUN_WEI_VAL Tare Weight - -
PRD_DGPROFL Dangerous Goods Indicator Profile - -
PRD_FRGHT_GRP Product Freight Group - -
PRD_KEY Product GUID - -
PRD_TRANSP_GRP Product Transportation Group Code
- -
PREPAID_AGREEM Prepaid Agreement Party - -
PREPAID_BILL_TO Prepaid Bill-To Party - -
PREPAID_PAYER Prepaid Payer Party - -
PRODUCT_ID Product - -
QUA_DLV_UNI Delivery Quantity Unit of Measure - -
QUA_DLV_VAL Delivery Quantity - -
QUA_PCS2_UNI Pieces 2 Unit of Measure - -
QUA_PCS2_VAL Pieces 2 - -
QUA_PCS_UNI Pieces Unit of Measure - -
QUA_PCS_VAL Pieces - -
REQ_QTY_UNI Requested Quantity Unit - -
REQ_QTY_VAL Requested Quantity - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SHIPPER Shipper - -
SHIPPER_OWN Shipper-Owned Container - -
SRC_LOC_CSS Security Status of Cargo Handover Party
- -
TRANSMODECODE Transportation Mode - -
TRANSSRVLVL_CODE Transportation Service Level - -
TRMODCAT Transportation Mode Category - -
TRQ_DB_KEY Node ID - -
TSP Carrier - -
TSP_SCAC Standard Carrier Alpha Code - -
TURES_CAT Equipment Group - -
TURES_TCO Equipment Type - -
SAP Library
(C) SAP AG 160
1.1.1.3 DataSources for Operational Data Provisioning
In this section you find the DataSources that are used for Operational Data Provisioning (ODP).
More Information
For more information about ODP, see Operational Reporting in SAP TM [Page 167].
SAP Library
(C) SAP AG 161
1.1.1.3.1 Operational Data Provider for Stage Information of BO TO
DataSource Transactional Data: 0SCM_TM_TOR_STG_ODP
This DataSource extracts stage and sustainability information of the business object Transportation Order. It is used for Operational Data Provisioning [Extern] (ODP). For more information about ODP, see Operational Reporting in SAP TM [Page 167].
Technical Data
Application Component
SAP Transportation Management (TM)
Available as of Release
SAP Transportation Management 9.0 SP 01
Shipment SAP NetWeaver 7.31 BI Content 7.47 SP 02; SAP NetWeaver 7.3 BI Content 7.37 SP 02
Content Versions TM90
RemoteCube-Capable
No
Delta-Capable No
Extraction from Archives
No
Verifiable –
Data Modeling
Fields of Origin for the Extract Structure
Fields in the Extract Structure
Description of the Field in the Extract Structure
Table of Origin
Field in the Table of Origin
AGREEMENT_PARTY Agreement Party Role - -
AIRCRAFT_CODE IATA Aircraft Type Code - -
BASE_UOM_UNI Base Unit of Measure - -
BASE_UOM_VAL Base Quantity - -
CHANGE_DATE Changed On - -
COMPLETION_DATE Completion Date - -
CONT_CNT_UNI Number of TEU Unit of Measure - -
CONT_CNT_VAL Number of TEU - -
CREATION_DATE Created On - -
CUTOFF_CARGOMLS Cargo Cut-Off Date/Time - -
SAP Library
(C) SAP AG 162
CUTOFF_CUST_DOC Customs Documentation Cut-Off Date/Time
- -
CUTOFF_DG_DOCMLS Dangerous Goods Documentation Cut-Off Date/Time
- -
CUTOFF_DOCMLS Document Cut-Off Date/Time - -
DEST_STOP_KEY NodeID - -
DES_ACC_END Acceptable End Date/Time at Stop
- -
DES_ACC_START Acceptable Start Date/Time at Stop
- -
DES_ASSGN_END Transportation Planning Date - -
DES_ASSGN_HRCO Capacity Consumption of Handling Resource
- -
DES_ASSGN_START Transportation Planning Date - -
DES_ASSG_CAT Stop Assignment Category - -
DES_CARR_C_END End of Pick-Up/Delivery Window Confirmed by Carrier
- -
DES_CARR_C_STA Start of Pick-Up/Delivery Window Confirmed by Carrier
- -
DES_CUTOFF_CGO Cargo Cut-Off Date/Time - -
DES_CUTOFF_CUS Customs Documentation Cut-Off Date/Time
- -
DES_CUTOFF_DG Dangerous Goods Documentation Cut-Off Date/Time
- -
DES_CUTOFF_DOC Document Cut-Off Date/Time - -
DES_DATES_SETB Origin of Entry - -
DES_ENTRY_PORT Port of Entry - -
DES_EXIT_PORT Port of Exit - -
DES_HANDL_EXEC Handling Execution Status on Stop Level
- -
DES_LOG_LOC Destination Location - -
DES_LOG_LOCIATA International Air Transport Association: Location
- -
DES_LOG_LOCUN United Nations Code for Trade and Transport Locations
- -
DES_NET_DUR Duration - -
SAP Library
(C) SAP AG 163
DES_REQ_END Requested End Date/Time at Stop
- -
DES_REQ_START Requested Start Date/Time at Stop
- -
DES_STOP_CAT Stop Category - -
DES_STOP_ORIG Stop Origin - -
DES_STOP_ROLE Role of the Stop - -
DES_TRQ_ACC_EN Acceptable End Date/Time at Stop
- -
DES_TRQ_ACC_ST Acceptable Start Date/Time at Stop
- -
DES_TRQ_REQ_EN Requested End Date/Time at Stop
- -
DES_TRQ_REQ_ST Requested Start Date/Time at Stop
- -
DISTANCE_KM Decimal Value - -
DURATION_NET Duration - -
EXEC_GRP_ID Planning and Execution Group - -
EXEC_ORG_ID Planning and Execution Organization
- -
FLAG_COUNTRY Country Key - -
FLIGHT_CODE Airline Code and Flight Number - -
GRO_VOL_UNI Gross Volume Unit of Measure - -
GRO_VOL_VAL Gross Volume - -
GRO_WEI_UNI Gross Weight Unit of Measure - -
GRO_WEI_VAL Gross Weight - -
GT_CUST_ACT_INB Customs Activity Inbound - -
IMO_ID IMO Ship Identification Number - -
I_CO2_EMISSION Carbon Dioxide Emissions - -
I_CO2_EMISSION_U Unit for Carbon Dioxide Emissions
- -
I_EMISS_WEIGHT Sustainability-Relevant Weight - -
I_EMISS_WEIGHT_U Sustainability-Relevant Weight Unit of Measure
- -
I_FACTOR Sustainability Factor - -
SAP Library
(C) SAP AG 164
I_FUEL_CONSUMP Fuel Consumption - -
I_FUEL_CONSUMP_U Unit for Fuel Consumption - -
I_RESULT_LEVEL Result Level of Distance Emissions
- -
NET_WEI_UNI Net Weight Unit of Measure - -
NET_WEI_VAL Net Weight - -
PKGUN_WEI_UNI Tare Weight Unit of Measure - -
PKGUN_WEI_VAL Tare Weight - -
QUA_PCS2_UNI Pieces 2 Unit of Measure - -
QUA_PCS2_VAL Pieces 2 - -
QUA_PCS_UNI Pieces Unit of Measure - -
QUA_PCS_VAL Pieces - -
ROCANCEL Deselect Data Record Checkbox for BW
- -
SEQ_NUM Sequence Number - -
SOURCE_STOP_KEY NodeID - -
SRC_ACC_END Acceptable End Date/Time at Stop
- -
SRC_ACC_START Acceptable Start Date/Time at Stop
- -
SRC_ASSGN_END Transportation Planning Date - -
SRC_ASSGN_HRCO Capacity Consumption of Handling Resource
- -
SRC_ASSGN_START Transportation Planning Date - -
SRC_ASSG_CAT Stop Assignment Category - -
SRC_CARR_C_END End of Pick-Up/Delivery Window Confirmed by carrier
- -
SRC_CARR_C_STA Start of Pick-Up/Delivery Window Confirmed by Carrier
- -
SRC_CUTOFF_CGO Cargo Cut-Off Date/Time - -
SRC_CUTOFF_CUS Customs Documentation Cut-Off Date/Time
- -
SRC_CUTOFF_DG Dangerous Goods Documentation Cut-Off Date/Time
- -
SRC_CUTOFF_DOC Document Cut-Off Date/Time - -
SAP Library
(C) SAP AG 165
SRC_DATES_SETB Origin of Entry - -
SRC_ENTRY_PORT Port of Entry - -
SRC_EXIT_PORT Port of Exit - -
SRC_HANDL_EXEC Handling Execution Status on Stop Level
- -
SRC_LOG_LOC Source Location - -
SRC_LOG_LOCIATA International Air Transport Association: Location
- -
SRC_LOG_LOCUN United Nations Code for Trade and Transport Locations
- -
SRC_NET_DUR Duration - -
SRC_REQ_END Requested End Date/Time at Stop
- -
SRC_REQ_START Requested Start Date/Time at Stop
- -
SRC_STOP_CAT Stop Category - -
SRC_STOP_ORIG Stop Origin - -
SRC_STOP_ROLE Role of the Stop - -
SRC_TRQ_ACC_EN Acceptable End Date/Time at Stop
- -
SRC_TRQ_ACC_ST Acceptable Start Date/Time at Stop
- -
SRC_TRQ_REQ_EN Requested End Date/Time at Stop
- -
SRC_TRQ_REQ_ST Requested Start Date/Time at Stop
- -
STAGE_ID Transportation Stage ID - -
STAGE_TYPE Stage Type - -
STATISTICAL Not Relevant for Planning - -
TOR_DBK NodeID - -
TOR_ITM_DBK NodeID - -
TOR_STG_DBK NodeID - -
TRANSMEANSTYPECD Means of Transport - -
TRANSMODECODE Transportation Mode - -
TRMODCAT Transportation Mode Category - -
SAP Library
(C) SAP AG 166
TSP_AIRLC IATA Airline Code - -
TSP_ID Carrier - -
TSP_SCAC Standard Carrier Alpha Code - -
VESSEL_ID Vessel - -
VOYAGE_ID Departure/Journey ID - -
SAP Library
(C) SAP AG 167
1.2 Operational Reporting in SAP TM (Operational Data Provisioning)
In this folder you find documents describing the operational reporting capabilities of SAP Transportation Management (SAP TM) based on Operational Data Provisioning (ODP) [Extern].
Operational Data Provisioning is a metadata concept in SAP NetWeaver, which gives an analytic query access to operative data in a backend system. It also supports replication scenarios.
Operational Data Provisioning and the analytics search use a common modeling environment. In the modeling of the search and analytics model [Extern], an operational data provider (ODP) [Extern] is defined on the basis of DataSources.
You can change the search and analytics models, or create your own models.
You can use operational reporting for real-time data analyses. You can access the data instantly in your live system. No additional replication mechanisms like a separate SAP NetWeaver Business Warehouse are required. This way, you always use current data for your evaluations and can react promptly and adequately.
New queries [Page 168] are available for Operational Data Provisioning. The queries are based on TransientProviders [Page 174] which in turn are based on a search and analytics model [Page 171].
SAP Library
(C) SAP AG 168
1.2.1 Queries
This section contains the available queries that are based on Operational Data Provisioning.
SAP Library
(C) SAP AG 169
1.2.1.1 Sustainability and Emissions Analysis
Query: 0SCM_TM_TOST_Q0001
This query returns data for sustainability and emissions analyses. The query is built using the operational data provisioning (ODP) technology.
Structure
Free Characteristics
Object Type Name Technical Name
Characteristic Created On 2O0SCM_TM_TOST-
CREATION_DAT
Characteristic Completion Date 2O0SCM_TM_TOST-
COMPLETION_D
Characteristic Changed On 2O0SCM_TM_TOST-
CHANGE_DATE
Characteristic Transportation Mode Category 2O0SCM_TM_TOST-TRMODCAT
Characteristic Means of Transport 2O0SCM_TM_TOST-
TRANSMEANSTY
Characteristic Stage Type 2O0SCM_TM_STG
Characteristic Carrier on Stage 2O0SCM_TM_TOST-TSP_ID
Characteristic Voyage 2O0SCM_TM_TOST-VOYAGE_ID
Characteristic Airline Code and Flight Number 2O0SCM_TM_TOST-
FLIGHT_CODE
Characteristic Sustainability-Relevant Weight Unit of Measure
2O-I_EMISS_W095
Characteristic Unit for Carbon Dioxide Emissions 2O-I_CO2_EMI097
Characteristic Unit for Fuel Consumption 2O-I_FUEL_CO099
Variables
Object Type Name Technical Name
Variable Created On 2O0SCM_TM_TOST-CREATION_DAT
Variable Changed On 2O0SCM_TM_TOST-CHANGE_DATE
Variable Completion Date 2O0SCM_TM_TOST-COMPLETION_D
Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Transportation Mode Category
2O0SCM_TM_TMCO —
SAP Library
(C) SAP AG 170
Characteristic Transportation Stage ID
2O0SCM_TM_TOST-
STAGE_ID —
Characteristic Source Location 2O0SCM_TM_TOST-
SRC_LOC —
Characteristic Destination Location 2O0SCM_TM_TOST-
DES_LOC —
Columns
Object Type
Name Technical Name Value Restriction / Calculation
Key Figure
Carbon Dioxide Emissions
2O-I_CO2_EMI096-
I_CO2_EMI097 —
Key Figure
Distance 2O-DISTANCE_KM-DEC —
Key Figure
Fuel Consumption 2O-I_FUEL_CO098-
I_FUEL_CO099 —
Key Figure
Carbon Dioxide Emissions
2O-I_CO2_EMI096-
I_CO2_EMI097 —
Key Figure
Gross Weight 2O-GRO_WEI_VAL-QUAN —
Key Figure
Gross Volume 2O-GRO_VOL_VAL-QUAN —
Key Figure
Duration 2O-DURATION_NET-DEC —
SAP Library
(C) SAP AG 171
1.2.2 Search and Analytics Model
The following section contains the search and analytics model that is required for operational reporting based on ODP.
A search and analytics model is based on new or adjusted DataSources.
More Information
For information about DataSources, see DataSources [Page 11].
SAP Library
(C) SAP AG 172
1.2.2.1 Transportation Order Stage
: Search and Analytics Model 0SCM_TM_TOR_STG_ODP
This search and analytics model is used to retrieve the data of the business object transportation order stages.
Technical Data
Model Usage Application Model
Software Component for Search and Analytics SAPTM TM-BW
Root Node: Stage Information of Business Object Transportation Order
Technical Name
0SCM_TM_TOR_STG_ODP
Data Source 0SCM_TM_TOR_STG_ODP
The search an analytics model uses all the fields belonging to the DataSource.
Operational Data Provider: Business Object Transportation Order Stage
Technical Name 0SCM_TM_TOR_STG_ODP
Direct Access Enabled Yes
Node Relationship: Transportation Mode Code
Node 0SCM_TM_TMODECD.0SCM_TM_TMODECD
Association 0SCM_TM_TOR_STG_ODP20SCM_TM_TMCO
Cardinality Arbitrary
Reverse Cardinality Exactly One
Sub-query No
Foreign Key
Attribute of Parent Node Value Attribute of Child Node Value Join-Operator
TRANSMODECODE n.a. TRMOCODE n.a. Equal
Node Relationship: Stage Type
Node 0SCM_TM_STAGETYPE.0SCM_TM_STAGETYPE
Association 0SCM_TM_STAGETYPE20SCM_TM_TOR_ST
Cardinality Arbitrary
Reverse Cardinality Exactly One
Sub-query No
SAP Library
(C) SAP AG 173
Foreign Key
Attribute of Parent Node Value Attribute of Child Node Value Join-Operator
STAGE_TYPE n.a. STAGE_TYPE n.a. Equal
SAP Library
(C) SAP AG 174
1.2.3 TransientProvider
This section contains the TransientProvider that is relevant for the queries of this component.
SAP Library
(C) SAP AG 175
1.2.3.1 Operational Data Provider for BO TO Stage
: Transient Provider 2O0SCM_TM_TOST
This TransientProvider provides the stage and sustainability data for the business object transportation order.
Integration
This TransientProvides provides the data for the query Sustainability and Emissions Analysis [Page 169] (0SCM_TM_TOST_Q0001).
Structure
Operational Data Provider
DataSource
0SCM_TM_TOR_STG_ODP 0SCM_TM_TOR_STG_ODP
For more information, see the DataSource Operational Data Provider for Stage Information of Business Object TO [Page 161].
Key Figures Used
For more information, see Key Figures [Page 182].
Characteristics Used
Name Technical Name
Stage Type 2O9SCM_TM_STG
Transportation Mode Code 2O0SCM_TM_TMCO
Agreement Party Role 2O0SCM_TM_TOST-
AGREEMENT_PA
IATA Aircraft Type Code 2O0SCM_TM_TOST-
AIRCRAFT_COD
Changed On 2O0SCM_TM_TOST-CHANGE_DATE
Completion Date 2O0SCM_TM_TOST-
COMPLETION_D
Created On 2O0SCM_TM_TOST-
CREATION_DAT
Destination Stop 2O0SCM_TM_TOST-
DEST_STOP_KE
Stop Assignment Category 2O0SCM_TM_TOST-
DES_ASSG_CAT
Origin of Entry 2O0SCM_TM_TOST-
DES_DATES_SE
Port of Entry 2O0SCM_TM_TOST-
DES_ENTRY_PO
SAP Library
(C) SAP AG 176
Port of Exit 2O0SCM_TM_TOST-
DES_EXIT_POR
Handling Execution Status on Stop Level 2O0SCM_TM_TOST-
DES_HANDL_EX
Destination Location 2O0SCM_TM_TOST-DES_LOG_LOC
International Air Transport Association: Location 2O0SCM_TM_TOST-
DES_LOG_LOCI
United Nations Code for Trade and Transport Locations
2O0SCM_TM_TOST-
DES_LOG_LOCU
Stop Category 2O0SCM_TM_TOST-
DES_STOP_CAT
Stop Origin 2O0SCM_TM_TOST-
DES_STOP_ORI
Role of the Stop 2O0SCM_TM_TOST-
DES_STOP_ROL
Planning and Execution Group 2O0SCM_TM_TOST-EXEC_GRP_ID
Planning and Execution Organization 2O0SCM_TM_TOST-EXEC_ORG_ID
Country Key 2O0SCM_TM_TOST-
FLAG_COUNTRY
Airline Code and Flight Number 2O0SCM_TM_TOST-FLIGHT_CODE
Customs Activity Inbound 2O0SCM_TM_TOST-
GT_CUST_ACT_
IMO Ship Identification Number 2O0SCM_TM_TOST-IMO_ID
Sustainability Factor 2O0SCM_TM_TOST-I_FACTOR
Result Level of Distance Emissions 2O0SCM_TM_TOST-
I_RESULT_LEV
Deselect Data Record Checkbox for BW 2O0SCM_TM_TOST-ROCANCEL
Sequence Number 2O0SCM_TM_TOST-SEQ_NUM
Source Stop 2O0SCM_TM_TOST-
SOURCE_STOP_
Stop Assignment Category 2O0SCM_TM_TOST-
SRC_ASSG_CAT
Origin of Entry 2O0SCM_TM_TOST-
SRC_DATES_SE
Port of Entry 2O0SCM_TM_TOST-
SRC_ENTRY_PO
Port of Exit 2O0SCM_TM_TOST-
SRC_EXIT_POR
Handling Execution Status on Stop Level 2O0SCM_TM_TOST-
SAP Library
(C) SAP AG 177
SRC_HANDL_EX
Source Location 2O0SCM_TM_TOST-SRC_LOG_LOC
International Air Transport Association: Location 2O0SCM_TM_TOST-
SRC_LOG_LOCI
United Nations Code for Trade and Transport Locations
2O0SCM_TM_TOST-
SRC_LOG_LOCU
Stop Category 2O0SCM_TM_TOST-
SRC_STOP_CAT
Stop Origin 2O0SCM_TM_TOST-
SRC_STOP_ORI
Role of the Stop 2O0SCM_TM_TOST-
SRC_STOP_ROL
Transportation Stage ID 2O0SCM_TM_TOST-STAGE_ID
Not Relevant for Planning 2O0SCM_TM_TOST-STATISTICAL
Means of Transport 2O0SCM_TM_TOST-
TRANSMEANSTY
Transportation Mode Category 2O0SCM_TM_TOST-TRMODCAT
IATA Airline Code 2O0SCM_TM_TOST-TSP_AIRLC
Carrier 2O0SCM_TM_TOST-TSP_ID
Standard Carrier Alpha Code 2O0SCM_TM_TOST-TSP_SCAC
Vessel 2O0SCM_TM_TOST-VESSEL_ID
Departure/Journey ID 2O0SCM_TM_TOST-VOYAGE_ID
SAP Library
(C) SAP AG 179
1.2.4.1 Changed On
Variable: 0SCMTMCHANGEDON
This variable is a selection option and puts a restriction on the Changed On
(2O0SCM_TM_TOST-CHANGE_DATE) InfoObject.
SAP Library
(C) SAP AG 180
1.2.4.2 Completion Date
Variable: 0SCMTMCOMPLDATE
This variable is a selection option and puts a restriction on the Completion Date
(2O0SCM_TM_TOST-COMPLETION_D) InfoObject.
SAP Library
(C) SAP AG 181
1.2.4.3 Created On
Variable: 0SCMTMCREATEDON
This variable is mandatory. The user must provide a date on which the transportation order stages were created. The variable is a selection option and puts a restriction on the Created
On (2O0SCM_TM_TOST-CREATION_DAT) InfoObject.
SAP Library
(C) SAP AG 183
1.2.5.1 Acceptable End Date/Time at Stop (Destination)
Key Figure: 2O-DES_ACC_END-DEC
This key figure contains the acceptable end date and time at the stop of the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 184
1.2.5.2 Acceptable End Date/Time at Stop (Destination, from TR)
Key Figure: 2O-DES_TRQ_A067-DEC
This key figure contains the acceptable end date and time at the stop of the destination location. The end date/time is retrieved from the transportation request.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 185
1.2.5.3 Acceptable End Date/Time at Stop (Source)
Key Figure: 2O-SRC_ACC_END-DEC
This key figure contains the acceptable end date and time at the stop for the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 186
1.2.5.4 Acceptable End Date/Time at Stop (Source, from TR)
Key Figure: 2O-SRC_TRQ_A038-DEC
This key figure contains the acceptable end date and time at the stop of the source location. The end date/time is retrieved from the transportation request (TR).
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 187
1.2.5.5 Acceptable Start Date/Time at Stop (Destination)
Key Figure: 2O-DES_ACC_STAR-DEC
This key figure contains the acceptable start date and time at the stop for the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 188
1.2.5.6 Acceptable Start Date/Time at Stop (Destination, from TR)
Key Figure: 2O-DES_TRQ_A064-DEC
This key figure contains the acceptable start date and time at the stop for the destination location. The start date/time is retrieved from the transportation request.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 189
1.2.5.7 Acceptable Start Date/Time at Stop (Source)
Key Figure: 2O-SRC_ACC_STAR-DEC
This key figure contains the acceptable start date and time at the stop for the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 190
1.2.5.8 Acceptable Start Date/Time at Stop (Source, from TR)
Key Figure: 2O-SRC_TRQ_A035-DEC
This key figure contains the acceptable start date and time at the stop of the source location. The start date/time is retrieved from the transport request.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 191
1.2.5.9 Base Quantity
Key Figure: 2O-BASE_UOM_VAL-QUAN
This key figure contains the base quantity.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 192
1.2.5.10 Capacity Consumption of Handling Resource (Destination)
Key Figure: 2O-DES_ASSGN_HR-DEC
This key figure contains the capacity consumption of the handling resources at the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 193
1.2.5.11 Capacity Consumption of Handling Resource (Source)
Key Figure: 2O-SRC_ASSGN_HR-DEC
This key figure contains the capacity consumption of the handling resources at the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 194
1.2.5.12 Carbon Dioxide Emissions
Key Figure: 2O-I_CO2_EMI096-I_CO2_EMI097
This key figure contains the carbon dioxide emissions.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 195
1.2.5.13 Cargo Cut-Off Date/Time
Key Figure: 20-CUTOFF_CARGO-DEC
This key figure contains the general cargo cut-off date and time.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 196
C 1.2.5.14 argo Cut-Off Date/Time (Destination)
Key Figure: 2O-DES_CUTOF053-DEC
This key figure contains the cargo cut-off date and time for the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 197
1.2.5.15 Cargo Cut-Off Date/Time (Source)
Key Figure: 2O-SRC_CUTOF024-DEC
This key figure contains the cargo cut-off date and time for the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 198
1.2.5.16 Customs Documentation Cut-Off Date/Time
Key Figure: 2O-CUTOFF_CUST_-DEC
This key figure contains the general customs documentation cut-off date and time.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 199
1.2.5.17 Customs Documentation Cut-Off Date/Time (Destination)
Key Figure: 2O-DES_CUTOF055-DEC
This key figure contains the general customs documentation cut-off date and time for the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 200
1.2.5.18 Customs Documentation Cut-Off Date/Time (Source)
Key Figure: 2O-SRC_CUTOF026-DEC
This key figure contains the general customs documentation cut-off date and time for the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 201
1.2.5.19 Dangerous Goods Documentation Cut-Off Date/Time
Key Figure: 2O-CUTOFF_DG_DO-DEC
This key figure contains the general cut-off date and time of the dangerous goods documentation.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 202
1.2.5.20 Dangerous Goods Documentation Cut-Off Date/Time (Destination)
Key Figure: 2O-DES_CUTOF056-DEC
This key figure contains the cut-off date and time of the dangerous goods documentation for the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 203
1.2.5.21 Dangerous Goods Documentation Cut-Off Date/Time (Source)
Key Figure: 2O-SRC_CUTOF027-DEC
This key figure contains the cut-off date and time of the dangerous goods documentatio for the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 204
1.2.5.22 Decimal Value
Key Figure: 2O-DISTANCE_KM-DEC
This key figure contains the decimal value for the distance (in kilometers).
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 205
1.2.5.23 Document Cut-Off Date/Time
Key Figure: 2O-CUTOFF_DOCML-DEC
This key figure contains the general document cut-off date and time.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 206
1.2.5.24 Document Cut-Off Date/Time (Destination)
Key Figure: 2O-DES_CUTOF054-DEC
This key figure contains the document cut-off date and time for the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 207
1.2.5.25 Document Cut-Off Date/Time (Source)
Key Figure: 2O-SRC_CUTOF025-DEC
This key figure contains the document cut-off date and time for the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 208
1.2.5.26 Duration
Key Figure: 2O-DURATION_NET-DEC
This key figure contains the general net duration.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 209
1.2.5.27 Duration (Destination)
Key Figure: 2O-DES_NET_DUR-DEC
This key figure contains the net duration at the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 210
1.2.5.28 Duration (Source)
Key Figure: 2O-SRC_NET_DUR-DEC
This key figure contains the net duration at the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 211
1.2.5.29 End of Pick-Up/Delivery Window Confirmed by Carrier (Destin.)
Key Figure: 2O-DES_CARR_C_E-DEC
This key figure contains the end of the pick-up or delivery window at the destination location that was confirmed by the carrier.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 212
1.2.5.30 End of Pick-Up/Delivery Window Confirmed by Carrier (Source)
Key Figure: 2O-SRC_CARR_C_E-DEC
This key figure contains the end of the pick-up or delivery window at the source location that was confirmed by the carrier.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 213
1.2.5.31 Fuel Consumption
Key Figure: 2O-I_FUEL_CO098-I_FUEL_CO099
This key figure contains the fuel consumption.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 214
1.2.5.32 Gross Volume
Key Figure: 2O-GRO_VOL_VAL-QUAN
This key figure contains the gross volume.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 215
1.2.5.33 Gross Weight
Key Figure: 2O-GRO_WEI_VAL-QUAN
This key figure contains the gross weight.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 216
1.2.5.34 Net Weight
Key Figure: 2O-NET_WEI_VAL-QUAN
This key figure contains the net weight.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 217
1.2.5.35 Number of TEU
Key Figure: 2O-CONT_CNT_VAL-QUAN
This key figure contains the number of twenty-foot equivalent units (TEU).
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 218
1.2.5.36 Pieces
Key Figure: 2O-QUA_PCS_VAL-QUAN
This key figure contains information on pieces.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 219
1.2.5.37 Pieces 2
Key Figure: 2O-QUA_PCS2_VAL-QUAN
This key figure contains information on pieces.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 220
1.2.5.38 Requested End Date/Time at Stop (Destination)
Key Figure: 2O-DES_REQ_END-DEC
This key figure contains the requested end date and time at the stop of the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 221
1.2.5.39 Requested End Date/Time at Stop (Destination, from TR)
Key Figure: 2O-DES_TRQ_R066-DEC
This key figure contains the requested end date and time at the stop of the destination location. The end date/time is retrieved from the transportation request.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 222
1.2.5.40 Requested End Date/Time at Stop (Source)
Key Figure: 2O-SRC_REQ_END-DEC
This key figure contains the requested end date and time at the stop of the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 223
1.2.5.41 Requested End Date/Time at Stop (Source, from TR)
Key Figure: 2O-SRC_TRQ_R037-DEC
This key figure contains the requested end date and time at the stop of the source location. The end date/time is retrieved from the transportation request (TR).
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 224
1.2.5.42 Requested Start Date/Time at Stop (Destination)
Key Figure: 2O-DES_REQ_STAR-DEC
This key figure contains the requested start date and time at the stop of the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 225
1.2.5.43 Requested Start Date/Time at Stop (Destination, from TR)
Key Figure: 2O_DES_TRQ_R065_DEC
This key figure contains the requested start date and time at the stop of the destination location. The start date/time is retrieved from the transportation request (TR).
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 226
1.2.5.44 Requested Start Date/Time at Stop (Source)
Key Figure: 2O-SRC_REQ_STAR-DEC
This key figure contains the requested start date and time at the stop of the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 227
1.2.5.45 Requested Start Date/Time at Stop (Source, from TR)
Key Figure: 2O-SRC_TRQ_R036-DEC
This key figure contains the requested start date and time at the stop of the source location. The start date/time is retrieved from the transportation request.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 228
1.2.5.46 Start of Pick-Up/Delivery Window Confirmed by Carrier (Destin.)
Key Figure: 2O-DES_CARR_C_S-DEC
This key figure contains the start of the pick-up or delivery window at the destination location that was confirmed by the carrier.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 229
1.2.5.47 Start of Pick-Up/Delivery Window Confirmed by Carrier (Source)
Key Figure: 2O-SRC_CARR_C_S-DEC
This key figure contains the start of the pick-up or delivery window at the source location that was confirmed by the carrier.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 230
1.2.5.48 Sustainability-Relevant Weight
Key Figure: 2O-I_EMISS_W094-I_EMISS_W095
This key figure contains the sustainability-relevant weight.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 231
1.2.5.49 Tare Weight
Key Figure: 2O-PKGUN_WEI_VA-QUAN
This key figure contains the tare weight.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 232
1.2.5.50 Transportation Planning Date (End, Destination)
Key Figure: 2O-DES_ASSGN_EN-DEC
This key figure contains transportation planning end date for the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 233
1.2.5.51 Transportation Planning Date (End, Source)
Key Figure: 2O-SRC_ASSGN_EN-DEC
This key figure contains the transportation planning end date for the source destination.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 234
1.2.5.52 Transportation Planning Date (Start, Destination)
Key Figure: 2O-DES_ASSGN_ST-DEC
This key figure contains the transportation planning start date for the destination location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 235
1.2.5.53 Transportation Planning Date (Start, Source)
Key Figure: 2O-SRC_ASSGN_ST-DEC
This key figure contains the transportation planning start date from the source location.
Technical Data
Available as of Release SAP Transportation Management 9.0 SP 01
Aggregation No
Exception Aggregation No
Calculation No
Restriction No
SAP Library
(C) SAP AG 236
1.3 Business Context Viewer in SAP TM
You use this function to display SAP Transportation Management (SAP TM) content in the Business Context Viewer (BCV).
Prerequisites
You have installed and configured the Internet Graphics Service (IGS) for SAP TM.
For more information about IGS, see SAP Library for SAP NetWeaver 7.0 Including
Enhancement Package 1 on SAP Help Portal at http://help.sap.com SAP
NetWeaver SAP NetWeaver 7.0 Including Enhancement Package 1 . In SAP
Library, choose SAP NetWeaver SAP NetWeaver by Key Capability Application
Platform by Key Capability ABAP Technology UI Technology SAP Graphics
Internet Graphics Service .
In SAP TM, you have activated business function FND, Business Context Viewer
Main Application (/BC/MAIN).
In SAP TM, you have activated BCV for business documents and their categories.
For more information, see Customizing for Transportation Management under
Basic Functions User Interface Define Settings for Business Context Viewer .
Features
SAP delivers the following BCV queries:
/SCMTMS/CL_BCV_SC_REJ_CODES (Search Connector Rejection Code
Determination)
/SCMTMS/CL_BCV_SC_REJ_DET (Search Connector Rejection Determination)
/SCMTMS/CL_BCV_SC_TSP_RANKING (Search Connector Carrier Ranking)
For more information about BCV and BCV queries, see Business Context Viewer (BCV) [Extern].
Activities
To display the BCV queries delivered by SAP or to create new BCV queries, access the Class
Builder (transaction SE24).