/SCMTMS/D_TORITE

TO Item Table | #transactional | Component: Freight Order
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Goods Value Currency (AMT_GDSV_CUR):
AMT_GDSV_VAL Goods Value
💲 Insurable Value Currency (AMT_INSV_CUR):
AMT_INSV_VAL Insurable Value
💲 Goods Value for Customs Currency (AMT_GDSVC_CUR):
AMT_GDSVC_VAL Goods Value for Customs
Column Name Description
📏 Gross Weight Unit of Measure (GRO_WEI_UNI):
GRO_WEI_VAL Gross Weight
📏 Gross Volume Unit of Measure (GRO_VOL_UNI):
GRO_VOL_VAL Gross Volume
📏 Net Weight Unit of Measure (NET_WEI_UNI):
NET_WEI_VAL Net Weight
📏 Quantity Unit of Measure (QUA_PCS_UNI):
QUA_PCS_VAL Quantity
📏 Alternative Quantity 2 Unit of Measure (QUA_PCS2_UNI):
QUA_PCS2_VAL Alternative Quantity
📏 Base Unit of Measure (BASE_UOM_UNI):
BASE_UOM_VAL Base Quantity
📏 Tare Weight Unit of Measure (PKGUN_WEI_UNI):
PKGUN_WEI_VAL Tare Weight
📏 Number of TEU Unit of Measure (CONT_CNT_UNI):
CONT_CNT_VAL Number of Twenty-Foot Equivalent Units
📏 Unit of Measure for ADR 1.1.3.6 DG Exemption Points (DG_ADR_PTS_UNI):
DG_ADR_PTS_VAL ADR 1.1.3.6 DG Exemption Points
📏 Confirmed Gross Weight Unit of Measure (CNF_GRO_WEI_UNI):
CNF_GRO_WEI_VAL Confirmed Gross Weight
📏 Confirmed Gross Volume Unit of Measure (CNF_GRO_VOL_UNI):
CNF_GRO_VOL_VAL Confirmed Gross Volume
📏 Confirmed Quantity Unit of Measure (CNF_QUA_PCS_UNI):
CNF_QUA_PCS_VAL Confirmed Quantity
📏 Confirmed Alternative Quantity Unit of Measure (CNF_QUA_PCS2_UNI):
CNF_QUA_PCS2_VAL Confirmed Alternative Quantity
📏 Confirmed Number of TEU Unit of Measure (CNF_CONT_CNT_UNI):
CNF_CONT_CNT_VAL Confirmed Number of TEU
📏 Unit of measure for length, width and height (MEASUOM):
LENGTH Length
WIDTH Width
HEIGHT Height
📏 Unit of Measure of Temperature (TEMP_UOM):
TEMP_CTRL_MIN Minimum Temperature
TEMP_CTRL_MAX Maximum Temperature
📏 Unit of Measurement of Load Consumption Quantity (LOADCONSUOM):
LOADCONSVAL Load Consumption Quantity
📏 Unit of Measure of Normalized Load Consumption Quantity (NORMLOADCONSUOM):
NORMLOADCONSVAL Normalized Load Consumption Quantity
📏 Unit of Measure of Sales Unit (SALES_QTY_UNI):
SALES_QTY_VAL Quantity of Sales Unit
📏 Unit of Measure of Original Sales Quantity (ORIG_SALES_QTY_UNI):
ORIG_SALES_QTY_VAL Original Sales Quantity
📏 Unit of measure for length, width and height (MEASUOM_VRES):
LENGTH_VRES Length
📏 Tare Weight Unit of Measure (TARE_WEI_UNI_VRES):
TARE_WEI_VAL_VRES Tare Weight
📏 Payload Weight Unit of Measure (PAYL_WEI_UNI_VRES):
PAYL_WEI_VAL_VRES Maximum Payload Weight
📏 Payload Volume Unit of Measure (PAYL_VOL_UNI_VRES):
PAYL_VOL_VAL_VRES Maximum Payload Volume
📏 Gross Weight Unit of Measure (GRO_WEI_UNICAP):
GRO_WEI_VALCAP Gross Weight
📏 Gross Volume Unit of Measure (GRO_VOL_UNICAP):
GRO_VOL_VALCAP Gross Volume
📏 Net Weight Unit of Measure (NET_WEI_UNICAP):
NET_WEI_VALCAP Net Weight
📏 Quantity Unit of Measure (QUA_PCS_UNICAP):
QUA_PCS_VALCAP Quantity
📏 Alternative Quantity 2 Unit of Measure (QUA_PCS2_UNICAP):
QUA_PCS2_VALCAP Alternative Quantity
📏 Base Unit of Measure (BASE_UOM_UNICAP):
BASE_UOM_VALCAP Base Quantity
📏 Tare Weight Unit of Measure (PKGUN_WEI_UNICAP):
PKGUN_WEI_VALCAP Tare Weight
📏 Number of TEU Unit of Measure (CONT_CNT_UNICAP):
CONT_CNT_VALCAP Number of Twenty-Foot Equivalent Units
📏 Unit of Measure for ADR 1.1.3.6 DG Exemption Points (DG_ADR_PTS_UNICAP):
DG_ADR_PTS_VALCAP ADR 1.1.3.6 DG Exemption Points
📏 Unit of measure for length, width and height (MEASUOMCAM):
LENGTHCAM Length
WIDTHCAM Width
HEIGHTCAM Height
📏 Unit of Measure of Normalized Load Consumption Quantity (NORMLOADCONSUNICAP):
NORMLOADCONSVALCAP Normalized Load Consumption Quantity
📏 Container Air Exchange Rate Unit (AIR_EXCH_UOM):
AIR_EXCH_RATE Container Air Exchange Rate
📏 Pivot Weight Unit of Measure (PIV_WEI_UNI):
PIV_WEI_VAL Pivot Weight
📏 Maximum Top Load Unit of Measure (MAX_TOP_LOAD_UOM):
MAX_TOP_LOAD Maximum Top Load
📏 Tare Volume Unit of Measure (PKGUN_VOL_UNI):
PKGUN_VOL_VAL Tare Volume
📏 Outer Volume Unit of Measure (OUT_VOL_UNI):
OUT_VOL_VAL Outer Volume
Column Name Description
BASE_BTD_DATE Base Business Transaction Document Date
BUYORIG_BTD_DATE Buyer Origin Business Transaction Doc Date (Ordering Date)
_DATAAGING Data Filter Value for Data Aging
Column Name Description
MULTI_ITEM Multi-Item Show values
NODE_HAS_ERROR Error on Node Instance Show values
ITEM_CAT Item Category Show values
MAIN_CARGO_ITEM Main Cargo Item Show values
REP_QUANTITY_EXISTS Recorded Quantities Show values
OVERDIM_CARGO Overdimensional Cargo Show values
AMT_HVAL_CAR_IND High-Value Cargo Show values
DGO_INDICATOR Dangerous Goods Show values
DGO_CHECK_ERROR Dangerous Goods Check Error Show values
DGO_DOC_BASED Document-Based Dangerous Goods Data Show values
DG_ADR_NO_EXEMPTION Prohibited for ADR 1.1.3.6 DG Exemption Show values
NON_STACKABLE Non-Stackable Packages Show values
PACKAGE_ID_SRC Origin of Package ID Show values
PACK_MAT_CAT Packaging Material Category Show values
DLV_PRIO Business Transaction Priority Code Show values
MOT_CAT Transportation Mode Category Show values
DLV_GOODS_MVMNT Delivery Goods Movement Status Show values
DLV_GOODS_MVMNT_PROC_IND Goods Movement Processing Show values
DAMAGED Damaged Item Show values
COST_DIST_RELEVANCE Relevant for cost distribution Show values
WH_PROCESSING_STATUS Warehouse Processing Status Show values
DG_STATUS Dangerous Goods Status Show values
LGLC_LIC_IND Legal Control License Indicator Show values
PB_ENGINE Unified Package Building Engine Show values
DEL_PUDL_SPECIFICATIONTRQ Pick-Up/Delivery Window Specification Show values
COST_CHARGE_EXISTTRQ Cost Pull Charge Exists Show values
HANDLING_EXEC Handling Execution Status on Item Level Show values
HANDLING_CARGO Cargo Execution Status on Item Level Show values
CARGO_RECEIPT Cargo Receipt Status on Item Level Show values
WH_TRANSM_STATUS Transmission-to-EWM Status on Item Level Show values
WH_TRANSM_STATUS_INBOUND Transmission-to-EWM Status on Item Level Show values
LOAD_PLAN_STATUS Load Plan Status on Item Level Show values
UNLOAD_PLAN_STATUS Unload Plan Status on Item Level Show values
LOAD_PLAN_ITEM_STATUS Load Plan Item Status on Item Level Show values
UNLOAD_PLAN_ITEM_STATUS Unload Plan Item Status on Item Level Show values
LP_ITEM_STATUS_SET_BY Origin of Entry Show values
LP_STATUS_SET_BY Origin of Entry Show values
QTY_DISCREPANCY Occurrence of Quantity Discrepancy Show values
DISCREPANCY Discrepancy Show values
DISCR_NO_BLOCK Discrepancy Type Leads to Block or Not Show values
LOCAL_ITEM Item Is Local Within BO Transportation Order Show values
ITEM_CAPA_DEF Capacity Item Definition for Referenced Item Show values
LOCAL_CCODE Deviating Commodity Codes Show values
LOCAL_NOG Nature of Goods Defined Locally Show values
TRQ_CAT Category (Forwarding Order/Quotation or Trsp. Reqt) Show values
ORIG_REF_ITEM_CAT Item Category Show values
FU_QTY_FIXED Freight Unit Quantity Fixed Show values
INT_ACTUAL_QTY Integration Based on Actual Quantity Show values
ITEM_HIER_TCO BTD Item Hierarchy Relationship Type Code Show values
HBL_NUMBER_STATUS Status of Waybill Number Show values
TRACK_EXEC_REL Execution Tracking Relevance Show values
RES_TIME_CHECK_REL Relevance for Resource Time Check Show values
MULTI_RESOURCE Multiresource Show values
CONF_STATUS Booking Confirmation Status Show values
SHIPPER_OWN Shipper-Owned Container Show values
PROVISION_REQ Empty Provisioning Show values
EMPTY_RETURN_REQ Empty Return Show values
ORGANIZED_BY_ORDPARTY Empty Provisioning or Return Organized by Sold-to Party Show values
CONS_CONT Consolidation Container Show values
ULD_RATE_CLASS Rate Class Show values
ULD_LOAD_INSTR ULD Loading Instructions Show values
SPLIT_INDICATOR Item Split Show values
MIXED_PALLET_IND Mixed ULD Show values
UPD_PROP_INDICATOR Update Propagation Control on Item Level Show values
WM_WH_CAT Warehouse Category Show values
WM_WH_CATSEC Warehouse Category Show values
RES_ADHOC Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
RESOURCE_ORIGIN Origin of Resource Show values
FIX_CAPA_ASSGN_REQ_TOR Fixing Status of Requirement Assignment Show values
CLOSED_PM Closed Packaging Material Show values
Column Name Description Domain name
PARENT_KEY NodeID /BOBF/CONF_KEY
ITEM_ID Item /SCMTMS/ITEM_ID
ITEM_TYPE Transportation Order Item Type /SCMTMS/TOR_ITEM_TYPE
ITEM_PARENT_KEY Key of Transportation Order Item
SRC_STOP_KEY Key of a Stop of a Transportation Order
DES_STOP_KEY Key of a Stop of a Transportation Order
ITEM_SORT_ID Sorting ID of Business Document Item /SCMTMS/TOR_ITEM_SORT_ID
ITEM_DESCR Item Description /SCMTMS/ITEM_DESCRIPTION
SP_ADDRESS_ID Unique Identifier for Address (APC_V_ADDRESS_ID)
SHIPPER_ID Shipper BU_PARTNER
SHIPPER_KEY Shipper Business Partner GUID /SCMTMS/BUPAUUID
CP_ADDRESS_ID Unique Identifier for Address (APC_V_ADDRESS_ID)
CONSIGNEE_ID Ship-to Party BU_PARTNER
CONSIGNEE_KEY Ship-to Party Business Partner GUID /SCMTMS/BUPAUUID
PACKAGE_ID Package ID
PACKCODE Packaging Code CBUND_PACOD
PACKAGE_ID_EXT External Package ID
PRODUCT_ID Product MATNR
PRD_KEY Product GUID
PRD_DGPROFL Dangerous Goods Indicator Profile ADGD_PROFL
TRANSSRVREQ_CODE Service Type /SCMTMS/TRANSPSERV_REQ_CODE
FAG_KEY Freight Agreement Key /BOBF/CONF_KEY
FAG_ITEM_KEY Freight Agreement Item Key /BOBF/CONF_KEY
FAG_SERVICE_KEY Freight Agreement Service Key /BOBF/CONF_KEY
MOT Transportation Mode VKTRA
ERP_PLANT_ID Plant WERKS
ERP_COMP_ORG_ID Company Organization NUM08
ERP_COMP_CODE Company Code BUKRS
LOADING_POINT_ID Loading/Unloading Point
LGORT Storage location LGORT
HU_KEY Handling Unit Key (Handle)
SLAC_VAL Shipper's Load and Count (SLAC)
AIR_HUMIDITY Container Air Humidity in Percent
LEADING_ITEM_KEY Leading Item Key /BOBF/CONF_KEY
PB_PROFILE_ID Unified Package Building Profile /SCMB/DO_PB_PROFILE_ID
PB_RULE Unified Package Building Rule
SRC_LOC_IDTRQ Source Location
SRC_LOC_KEYTRQ Location GUID (004) with Conversion Exit /SCMTMS/LOCUUID
SRC_LOC_IATACODETRQ IATA Code (Source Location) /SCMTMS/LOC_IATACODE
SRC_LOC_UNLOCODETRQ Source Location: United Nations Code /SCMTMS/LOC_UNLOCODE
PIC_EAR_REQTRQ Pick-Up (From) /SCMTMS/TIMESTAMP
PIC_LAT_REQTRQ Pick-Up (To) /SCMTMS/TIMESTAMP
PIC_EAR_ACCTRQ Earliest Pick-Up /SCMTMS/TIMESTAMP
PIC_LAT_ACCTRQ Latest Pick-Up /SCMTMS/TIMESTAMP
DES_LOC_IDTRQ Destination Location
DES_LOC_KEYTRQ Location GUID (004) with Conversion Exit /SCMTMS/LOCUUID
DES_LOC_IATACODETRQ IATA Code (Destination Location) /SCMTMS/LOC_IATACODE
DES_LOC_UNLOCODETRQ Destination Location: United Nations Code /SCMTMS/LOC_UNLOCODE
UNLOAD_POINTTRQ Unloading Point Name CHAR25
DEL_EAR_REQTRQ Delivery (From) /SCMTMS/TIMESTAMP
DEL_LAT_REQTRQ Delivery (To) /SCMTMS/TIMESTAMP
DEL_EAR_ACCTRQ Earliest Delivery /SCMTMS/TIMESTAMP
DEL_LAT_ACCTRQ Latest Delivery /SCMTMS/TIMESTAMP
INC_TRANSF_LOC_N Incoterm Location (Free Text)
INC_LOC_KEY Incoterm Location /SCMTMS/LOCUUID
INC_LOC_ID Incoterm Location
REF_INCOTERM_KEY Key of an Incoterm
REF_ITEM_KEY NodeID /BOBF/CONF_KEY
REF_ROOT_KEY NodeID /BOBF/CONF_KEY
REF_BO Short Name of Business Object
SRC_STOP_KEY_A Key of a Stop of a Transportation Order
DES_STOP_KEY_A Key of a Stop of a Transportation Order
ORIG_REF_ITEM NodeID /BOBF/CONF_KEY
ORIG_REF_ROOT NodeID /BOBF/CONF_KEY
ORIG_REF_BO Short Name of Business Object
ORIG_REF_PARENT_ITEM NodeID /BOBF/CONF_KEY
FU_ROOT_KEY Key of Transportation Order
TRQ_ID ID of Forwarding Order/Quotation or Trsp. Reqt /SCMTMS/TRQ_ID
TRQ_ITEM_ID Item /SCMTMS/ITEM_ID
SPLIT_ORIG_REF_ITEM NodeID /BOBF/CONF_KEY
REF_TRQ_ITEM_KEY NodeID /BOBF/CONF_KEY
REF_TRQ_ROOT_KEY NodeID /BOBF/CONF_KEY
BASE_BTD_ID Base Business Transaction Document /SCMTMS/BTD_ID
BASE_BTD_VERSION Base Business Transaction Document Version /SCMTMS/BTD_VERSION
BASE_BTD_KEY Base Business Transaction Document Key
BASE_BTD_LOGSYS Logical System (Sending System) LOGSYS
BASE_BTDITEM_KEY Base Business Transaction Document Item Key
BASE_BTDITEM_TCO Base Document Item Type Code for Business Transaction /SCMTMS/BTD_ITEM_TYPECODE
BASE_BTDITEM_ID Base Document Item for Business Transaction /SCMTMS/BTD_ITEM_ID
BASE_BTD_PROCTCO Business Transaction Document Processing Type Code /SCMTMS/BTD_PROC_TYPE_CODE
BASE_BTD_PARITEM_ID Base Document Item for Business Transaction /SCMTMS/BTD_ITEM_ID
BASE_BTD_PARITEM_TCO Base Document Item Type Code for Business Transaction /SCMTMS/BTD_ITEM_TYPECODE
ORIGREGION_CODE Region Code
BUYORIG_BTD_ID Buyer Origin Document for Business Transaction /SCMTMS/BTD_ID
BUYORIG_BTD_ITEM_ID Buyer Origin Document Item for Business Transaction /SCMTMS/BTD_ITEM_ID
ORIG_BTD_ID Origin Business Transaction Document /SCMTMS/BTD_ID
ORIG_BTDITEM_TCO Origin Business Transaction Document Item Type Code /SCMTMS/BTD_ITEM_TYPECODE
ORIG_BTDITEM_ID Origin Business Transaction Document Item /SCMTMS/BTD_ITEM_ID
HBL_NUMBER House Bill of Lading /SCMTMS/HOUSESHIP_ID
SHP_ITEM_REF Reference to Shipment Item
TRACKING_NO Tracking Number /SCMTMS/TRACKING_NUMBER_LONG
PLATENUMBER Registration Number
COUNTRY_VEHIC_ID TM Localization - Ctry/Reg.-Specific Vehicle Identification /SCMTMS/COUNTRY_VEHIC_ID
MTR Means of Transport /SAPAPO/TR_TRATY
COUNTRY Country/Region Key LAND1
SCHED_KEY Schedule GUID (029) with Conversion Exit /SCMTMS/SCHEDUUID
SCHED_DEP Date/Time /SCMTMS/TIMESTAMP
VOYAGE_ID Voyage / Train Number /SCMTMS/VOYAGE_ID
FLIGHT_CODE Airline Code and Flight Number /SCMTMS/FLIGHT_CODE
VESSEL_ID Vessel /SCMTMS/VESSEL_ID
IMO_ID IMO Ship Identification Number /SCMTMS/IMO_ID
FLIGHT_NUMBER Flight Number (Numerical) /SCMTMS/FLIGHT_NUMBER
CAPREF_KEY Reference to Booking Capacity Requirement Item /SCMTMS/BO_NODE_KEY_WITH_NAME
CT_SEQ Sequence Number NUMC2
CT_TYPE Compartment Type /SAPAPO/CPTYPE
ULD_RATE_TYPE Rate Type for Unit Load Device /SCMTMS/ULD_RATE_TYPE
RES_CLASS Resource Class /SCMB/RES_CLASS
RES_OWNER_ORG Org. Unit That Owns the Resource HROBJID
ASSGN_START Transportation Planning Date /SCMTMS/TIMESTAMP
ASSGN_END Transportation Planning Date /SCMTMS/TIMESTAMP
UNASSGN_START Transportation Planning Date /SCMTMS/TIMESTAMP
UNASSGN_END Transportation Planning Date /SCMTMS/TIMESTAMP
OP_UUID001 Internal Universally Unique Identifier
ERP_DLV_ID ERP Delivery Document Assigned to ERP Shipment /SCMTMS/BTD_ID
ERP_DLV_ITEM_ID ERP Delivery Item Assigned to ERP Shipment /SCMTMS/BTD_ITEM_ID
INCL_PIECE_COUNT Included Packages
CARRIER_PROD_ID Service Product /SCMTMS/SERVICE_PRODUCT_ID
EEW_TOR_ITM_TR Dummy function in length 1 DUMMY
DENSITY_FACTOR Density Factor
ORIENTATION Orientation
POS_X Position X
POS_Y Position Y
POS_Z Position Z
POS_ROW Row
POS_STACK Stack
POS_LEVEL Level
POS_SPLIT_DECK Split Deck
LOAD_SEQ Loading Sequence
WM_LOGSYS Logical System (SAP EWM Target System) LOGSYS
WM_WH_NUMBER Warehouse Number /SCMTMS/WAREHOUSE_NUMBER
WM_WH_DOOR Warehouse Door /SCMTMS/WAREHOUSE_DOOR
WM_LOGSYSSEC Logical System (SAP EWM Target System) LOGSYS
WM_WH_NUMBERSEC Warehouse Number /SCMTMS/WAREHOUSE_NUMBER
WM_WH_DOORSEC Warehouse Door /SCMTMS/WAREHOUSE_DOOR
LOADING_POINT_IDSEC Loading/Unloading Point
RES_KEY Internal Universally Unique Identifier
RES_ID Resource
RES_SEQ Sequence Number for Resources
Master Data Relations Join Conditions
Goods Value for Customs Currency
  • /SCMTMS/D_TORITE.MANDT == TCURC.MANDT
  • /SCMTMS/D_TORITE.AMT_GDSVC_CUR == TCURC.WAERS
Goods Value Currency
  • /SCMTMS/D_TORITE.MANDT == TCURC.MANDT
  • /SCMTMS/D_TORITE.AMT_GDSV_CUR == TCURC.WAERS
Insurable Value Currency
  • /SCMTMS/D_TORITE.MANDT == TCURC.MANDT
  • /SCMTMS/D_TORITE.AMT_INSV_CUR == TCURC.WAERS
Base Document Type for Business Transaction
Incoterm
  • Incoterm
  • Client
  • /SCMTMS/D_TORITE.INC_CLASS_CODE == TINC.INCO1
  • /SCMTMS/D_TORITE.MANDT == TINC.MANDT
Country/Region
  • Country/Region
  • Client
  • /SCMTMS/D_TORITE.ORIGCOUNTRY_CODE == T005.LAND1
  • /SCMTMS/D_TORITE.MANDT == T005.MANDT
Origin Business Transaction Document Type Code
Packaging Material Type
  • /SCMTMS/D_TORITE.MANDT == TVTY.MANDT
  • /SCMTMS/D_TORITE.PACKAGE_TCO == TVTY.TRATY
Material freight group
  • Material freight group
  • Client
  • /SCMTMS/D_TORITE.PRD_FRGHT_GRP == TMFG.MFRGR
  • /SCMTMS/D_TORITE.MANDT == TMFG.MANDT
Transportation Group
  • /SCMTMS/D_TORITE.MANDT == TTGR.MANDT
  • /SCMTMS/D_TORITE.PRD_TRANSP_GRP == TTGR.TRAGR
Sales Group
  • ?
  • ?
  • Client
  • Sales Group
  • /SCMTMS/D_TORITE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_TORITE.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_TORITE.MANDT == PLOGI.MANDT
  • /SCMTMS/D_TORITE.SALES_GROUP_ID == PLOGI.OBJID
Sales Office
  • ?
  • ?
  • Client
  • Sales Office
  • /SCMTMS/D_TORITE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_TORITE.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_TORITE.MANDT == PLOGI.MANDT
  • /SCMTMS/D_TORITE.SALES_OFF_ID == PLOGI.OBJID
Sales Organization
  • ?
  • ?
  • Client
  • Sales Organization
  • /SCMTMS/D_TORITE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_TORITE.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_TORITE.MANDT == PLOGI.MANDT
  • /SCMTMS/D_TORITE.SALES_ORG_ID == PLOGI.OBJID
Ventilation Setting Code for Container