/SCMTMS/D_TRQITM

Transportation Request Item | #transactional | Component: Forwarding 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
📏 Container Air Exchange Rate Unit (AIR_EXCH_UOM):
AIR_EXCH_RATE Container Air Exchange Rate
📏 Delivery Quantity Unit of Measure (QUA_DLV_UNI):
QUA_DLV_VAL Delivery Quantity
📏 Partial Delivery Minimum Quantity Unit of Measure (PAR_DLV_MIN_UNI):
PAR_DLV_MIN_VAL Partial Delivery Minimum Quantity
📏 Partial Delivery Rounding Factor Quantity Unit of Measure (PAR_DLV_RDF_UNI):
PAR_DLV_RDF_VAL Partial Delivery Rounding Factor Quantity
📏 Component Based Quantity Unit of Measure (QUA_COMP_BSD_UNI):
QUA_COMP_BSD_VAL Component Based Quantity
📏 Requested Quantity Unit (REQ_QTY_UNI):
REQ_QTY_VAL Requested Quantity
📏 Confirmed Quantity Unit (CNF_QTY_UNI):
CNF_QTY_VAL Confirmed Quantity
📏 Received Quantity Unit (RCVD_QTY_UNI):
RCVD_QTY_VAL Received Quantity
📏 Open Quantity Delivery Unit (OPEN_QTY_UNI):
OPEN_QTY_VAL Open Quantity
📏 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
BUYORIG_BTD_DATE Buyer Origin Business Transaction Doc Date (Ordering Date)
GT_ATB_EDATE Customs Document Date
_DATAAGING Data Filter Value for Data Aging
Column Name Description
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
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
DEL_PUDL_SPECIFICATION Pick-Up/Delivery Window Specification Show values
DT_PRIORITY_C Business Transaction Priority Code Show values
DT_ORD_COMB_IND Order Combination Allowed Show values
PD_CTRL_CODE Partial Delivery Control Code Show values
QT_OVER_PERC_IND Unlimited Percentage Above Ordered Quantity Show values
BASE_BTD_DLVPROC Delivery Processing Status Show values
ORIG_BTD_DLVPROC Delivery Processing Status Show values
ITEM_COMPLETED Item Completed Indicator Show values
ORD_ITM_REJECTED Order Item Rejected Indicator Show values
ORD_ITM_CANCELED Order Item Cancelled Indicator Show values
GM_RELEVANCE Goods Movement Relevance Indicator Show values
TRANSP_RELEVANCE Transportation Relevance Show values
QTY_DTM_FIXED Quantity, Date, and Time Fixed Show values
DLV_SCHED_RELTYPE Release Type of Delivery Schedule Show values
INT_ACTUAL_QTY Integration Based on Actual Quantity Show values
DLV_RELEVANCE Delivery Relevance Show values
DLV_COMPLETED Delivery Completed Show values
DLV_BLOCKED Delivery Blocked Show values
DLV_RETURN Returns Indicator Show values
ITEM_HIER_TCO BTD Item Hierarchy Relationship Type Code Show values
BOM_INDICATOR Item is a Bill of Material Show values
BLK_PLAN Planning Block Show values
BLK_EXEC Execution Block Show values
GT_BOND_CARGO Bonded Goods Show values
GT_CUST_ACT_IB Customs Activity Inbound Show values
WM_WH_CAT Warehouse Category Show values
PROCESSING_STATUS Processing Status of Item Show values
Column Name Description Domain name
PARENT_KEY NodeID /BOBF/CONF_KEY
ITEM_ID Item /SCMTMS/ITEM_ID
ITEM_PARENT_KEY Item Parent Key /BOBF/CONF_KEY
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
PLATENUMBER Registration Number
COUNTRY Country/Region Key LAND1
RES_KEY Internal Universally Unique Identifier
RES_ID Resource
EXEC_START_DATETIME Service Execution Start Date and Time /SCMTMS/TIMESTAMP
EXEC_END_DATETIME Service Execution End Date and Time /SCMTMS/TIMESTAMP
SRC_LOC_ID Source Location
SRC_LOC_KEY Location GUID (004) with Conversion Exit /SCMTMS/LOCUUID
SRC_LOC_IATACODE IATA Code (Source Location) /SCMTMS/LOC_IATACODE
SRC_LOC_UNLOCODE Source Location: United Nations Code /SCMTMS/LOC_UNLOCODE
PIC_EAR_REQ Pick-Up (From) /SCMTMS/TIMESTAMP
PIC_LAT_REQ Pick-Up (To) /SCMTMS/TIMESTAMP
PIC_EAR_ACC Earliest Pick-Up /SCMTMS/TIMESTAMP
PIC_LAT_ACC Latest Pick-Up /SCMTMS/TIMESTAMP
PIC_SEL_TIME Timestamp for Stop Selection /SCMTMS/TIMESTAMP
PIC_EAR_CNF Confirmed Pick-Up (From) /SCMTMS/TIMESTAMP
PIC_LAT_CNF Confirmed Pick-Up (To) /SCMTMS/TIMESTAMP
SRC_STAGE_KEY Source Stage Key /BOBF/CONF_KEY
DES_LOC_ID Destination Location
DES_LOC_KEY Location GUID (004) with Conversion Exit /SCMTMS/LOCUUID
DES_LOC_IATACODE IATA Code (Destination Location) /SCMTMS/LOC_IATACODE
DES_LOC_UNLOCODE Destination Location: United Nations Code /SCMTMS/LOC_UNLOCODE
UNLOAD_POINT Unloading Point Name CHAR25
DEL_EAR_REQ Delivery (From) /SCMTMS/TIMESTAMP
DEL_LAT_REQ Delivery (To) /SCMTMS/TIMESTAMP
DEL_EAR_ACC Earliest Delivery /SCMTMS/TIMESTAMP
DEL_LAT_ACC Latest Delivery /SCMTMS/TIMESTAMP
DEL_SEL_TIME Timestamp for Stop Selection /SCMTMS/TIMESTAMP
DEL_EAR_CNF Confirmed Delivery (From) /SCMTMS/TIMESTAMP
DEL_LAT_CNF Confirmed Delivery (To) /SCMTMS/TIMESTAMP
DES_STAGE_KEY Destination Stage Key /BOBF/CONF_KEY
TRQ_OTR_ITEM_KEY TRQ OTR Item Key /BOBF/CONF_KEY
TRANP_PL_DATE Transportation Planning Date TZNTSTMPS
MAT_AVAIL_DATE Material Availability Date /SCMTMS/TIMESTAMP
GOODS_ISSUE_DATE Goods Issue Date TZNTSTMPS
DT_ITEM_GRP_ID Business Transaction Document Item Group ID
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
INC_LOC_EAR_REQ Requested Incoterm Location Date TZNTSTMPS
INC_LOC_LAT_REQ Requested Incoterm Location Date TZNTSTMPS
INC_LOC_EAR_ACC Earliest Incoterm Location Date TZNTSTMPS
INC_LOC_LAT_ACC Latest Incoterm Location Date TZNTSTMPS
PD_MAX_NUMBER Maximum Number for Partial Delivery
QT_OVER_PERCENT Tolerated Percentage Above Ordered Quantity
QT_UNDER_PERCENT Tolerated Percentage Below Ordered Quantity
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_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_BTDITEM_KEY Base Business Transaction Document Item Key
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
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
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
ORD_REJ_REASON Order Rejection Reason Code /SCMTMS/ORDER_REJECTION_REASON
ORIG_PU_DATE Original Pick-Up Date TZNTSTMPS
ORIG_DLV_DATE Original Delivery Date TZNTSTMPS
ORIG_INCLOC_DATE Original Incoterm Location Date TZNTSTMPS
CONV_RATE_VAL Quantity Conversion Rate
CNV_RATE_BAS_VAL Quantity Conversion Rate Base
TIMESTREAM_ID Time Stream ID /SCMTMS/TSTRID
PIC_PAC_ACTDUR Picking and Packing Activity Duration TSTRDURAN
DLV_SCHED_ID Delivery Schedule
DLV_BLOCK_REASON Default Delivery Block LIFSP
DLV_ADD_SPLITCRT Additional Delivery Split Criterion
ORIGREGION_CODE Region Code
EXPORT_BT_TYPE Customs Business Transaction Type /SAPSLL/CBSTT
CUST_COMM_CLASS Customs Commodity Code CHAR17
OUTB_CUSPR_AREA Customs ID for Outward Processing /SCMTMS/LOGISTICS_AREA_ID
INB_CUSPR_AREA Customs ID for Customs Procedures CWH, IP, PUCC /SCMTMS/LOGISTICS_AREA_ID
OUTB_CUSPR_STOCK Additional ID for Stock Separation in Outward Processing /SCMTMS/IDENTIFIED_STOCK_ID
INB_CUSPR_STOCK Additional ID for Stock Separation in CWH, IP, PUCC /SCMTMS/IDENTIFIED_STOCK_ID
GT_ATB Previous Document CHAR_35
GT_ATB_TYPE Type of Previous Document VORPA
GT_IMPORT_LOC Import Location CHAR_40
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
EEW_TRQ_ITEM Dummy function in length 1 DUMMY
CUTOFF_CUST_VGM VGM Cut-Off Date/Time Given to Shipper /SCMTMS/TIMESTAMP
Master Data Relations Join Conditions
Goods Value for Customs Currency
  • /SCMTMS/D_TRQITM.MANDT == TCURC.MANDT
  • /SCMTMS/D_TRQITM.AMT_GDSVC_CUR == TCURC.WAERS
Goods Value Currency
  • /SCMTMS/D_TRQITM.MANDT == TCURC.MANDT
  • /SCMTMS/D_TRQITM.AMT_GDSV_CUR == TCURC.WAERS
Insurable Value Currency
  • /SCMTMS/D_TRQITM.MANDT == TCURC.MANDT
  • /SCMTMS/D_TRQITM.AMT_INSV_CUR == TCURC.WAERS
Base Document Type for Business Transaction
Confirmed Quantity Unit
  • /SCMTMS/D_TRQITM.MANDT == T006.MANDT
  • /SCMTMS/D_TRQITM.CNF_QTY_UNI == T006.MSEHI
Incoterm
  • Incoterm
  • Client
  • /SCMTMS/D_TRQITM.INC_CLASS_CODE == TINC.INCO1
  • /SCMTMS/D_TRQITM.MANDT == TINC.MANDT
Item Type for Items in FWOs or FWQs
  • Item Type for Items in FWOs or FWQs
  • Client
Open Quantity Delivery Unit
  • /SCMTMS/D_TRQITM.MANDT == T006.MANDT
  • /SCMTMS/D_TRQITM.OPEN_QTY_UNI == T006.MSEHI
Country/Region
  • Country/Region
  • Client
  • /SCMTMS/D_TRQITM.ORIGCOUNTRY_CODE == T005.LAND1
  • /SCMTMS/D_TRQITM.MANDT == T005.MANDT
Origin Business Transaction Document Type Code
Packaging Material Type
  • /SCMTMS/D_TRQITM.MANDT == TVTY.MANDT
  • /SCMTMS/D_TRQITM.PACKAGE_TCO == TVTY.TRATY
Partial Delivery Minimum Quantity Unit of Measure
  • /SCMTMS/D_TRQITM.MANDT == T006.MANDT
  • /SCMTMS/D_TRQITM.PAR_DLV_MIN_UNI == T006.MSEHI
Partial Delivery Rounding Factor Quantity Unit of Measure
  • /SCMTMS/D_TRQITM.MANDT == T006.MANDT
  • /SCMTMS/D_TRQITM.PAR_DLV_RDF_UNI == T006.MSEHI
Material freight group
  • Material freight group
  • Client
  • /SCMTMS/D_TRQITM.PRD_FRGHT_GRP == TMFG.MFRGR
  • /SCMTMS/D_TRQITM.MANDT == TMFG.MANDT
Transportation Group
  • /SCMTMS/D_TRQITM.MANDT == TTGR.MANDT
  • /SCMTMS/D_TRQITM.PRD_TRANSP_GRP == TTGR.TRAGR
Component Based Quantity Unit of Measure
  • /SCMTMS/D_TRQITM.MANDT == T006.MANDT
  • /SCMTMS/D_TRQITM.QUA_COMP_BSD_UNI == T006.MSEHI
Delivery Quantity Unit of Measure
  • /SCMTMS/D_TRQITM.MANDT == T006.MANDT
  • /SCMTMS/D_TRQITM.QUA_DLV_UNI == T006.MSEHI
Requested Quantity Unit
  • /SCMTMS/D_TRQITM.MANDT == T006.MANDT
  • /SCMTMS/D_TRQITM.REQ_QTY_UNI == T006.MSEHI
Vehicle Resource Class
Ventilation Setting Code for Container