/SCMTMS/D_TRQROT

Transportation Request Root | #transactional | Component: Forwarding Order
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Credit Limit Check Currency (OP_AMT_CLC_CUR):
OP_AMT_CLC_VAL Credit Limit Check Amount
💲 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
💲 Quotation Price Limit Currency (QUOT_PRLIMIT_CUR):
QUOT_PRLIMIT_VAL Quotation Price Limit
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
Column Name Description
ORDER_DATE Order Date of FWO, FWQ, or Transportation Requirement
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
TRQ_CAT Category (Forwarding Order/Quotation or Trsp. Reqt) Show values
TRQ_CNF_CR_TYPE Confirmation Creation Type Show values
TRQ_CNF_SUB_IND FWO Confirmed / FWQ Submitted Show values
TRQ_TEMPLATE_IND Template Indicator Show values
PAYMENT_STATUS Payment Status Show values
OP_PAYMENT_RECVD Payment Received Show values
OP_PREPAY_REQD Prepayment Required Show values
DEL_PUDL_SPECIFICATION Pick-Up/Delivery Window Specification Show values
AMT_HVAL_CAR_IND High-Value Cargo Show values
INS_BY_LSP_IND Insurance by LSP 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
QUOT_MODE Quotation Mode Show values
RFQ_RESP_CODE Response Code Show values
DLV_PICKING Picking/Putaway Status of Delivery Show values
DLV_PACKING Packing Status of Delivery Show values
DLV_GOODS_MVMNT Delivery Goods Movement Status Show values
DLV_DISTRIBUTION Delivery Distribution Status Show values
DLV_BILLING ERP Delivery Billing Status Show values
DLV_PLANNING Delivery Planning Status Show values
DLV_BLOCKED Delivery Blocked Show values
DLV_CR_BY_TM Delivery Creation Triggered by TM Show values
DLV_SPLTUPD_STATUS Delivery Split or Update Processing Status Show values
SHPPLN_BLOCKED Shipment Planning Blocked Show values
WM_WH_CAT Warehouse Category Show values
CONSUMPTION Consumption Status of Transportation Requirement Show values
BLKG_EDI Blocked by EDI Update Show values
BLK_PLAN Planning Block Show values
BLK_EXEC Execution Block Show values
BLK_CONF Block for Confirmation of Forwarding Order Show values
BLK_CFIR Block for Creation of Forwarding Settlement Document Show values
BLK_QUOT Forwarding Quotation Block 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
MOT_CAT Transportation Mode Category Show values
TRAFFIC_DIRECT Traffic Direction Show values
STAGE_DET_STRAT Stage Determination Strategy Show values
UNCONTROLLED Uncontrolled Transportation Show values
GT_EXP_DECL_LSP Export Declaration by Logistics Service Provider Show values
GT_IMP_DECL_LSP Import Declaration by Logistics Service Provider Show values
EDI_INDICATOR EDI Indicator Show values
PLAN_DATA_INCOMP Planning Data Incomplete Show values
AGEABLE Business document is or was ready for data aging Show values
AGREEMENT_PARTY Agreement Partner Function Show values
APPROVAL_ACTIVE Enable Approval Workflow Show values
EM_ACTIVE Enable EM Integration Show values
DIRECT_EWM_ACTIVE Enable Direct EWM Integration Show values
INVOICING_ENABLE Enable Settlement for Forwarding Order Management Show values
INVC_INT_ENABLE Enable Internal Settlement for Forwarding Order Management Show values
TCC_ENABLE Enable Charge Calculation Show values
TCC_INT_ENABLE Enable Internal Charge Calculation Show values
ONE_ITEM_ALLOWED One Item Per Business Document Allowed Show values
SHIPMENT_LIKE Same Locations and Business Partners for All FWO/FWQ Items Show values
FOLLOWUP_TRQ_EXP Follow-Up Document for Business Documents Expected Show values
PLN_REQ_CNF_QTY Plan on Requested or Confirmed Quantities Show values
CUSTOMS_HANDLG Forwarding Order Customs Handling Show values
CMPLC_CHK_ENABLE Enable Compliance Check Show values
ACS_CHECK_ENABLE Enable Air Cargo Security Check Show values
ACS_COPY_LOCDATA Copy Air Cargo Security Data to Document Show values
INS_ENABLE Enable Instructions Show values
LOGISTICAL_RELEVANCE Restrict Follow-On Processing Show values
INC_LOC_STAGE_RULE Incoterm Location Stage Building Show values
PAYMENT_TERMS Settlement Terms Show values
LIFECYCLE Life Cycle Status of FWO/FWQ or Trsp. Reqt Show values
ARCHIVING Archiving Status Show values
APPROVAL Approval Status Show values
CONFIRMATION Confirmation Status of FWO/FWQ or Trsp. Reqt Show values
PLANNING Planning Status of Forwarding Order or Trsp. Reqt Show values
EXECUTION Execution Status of Forwarding Order or Trsp. Reqt Show values
COMPLETENESS Completeness Status Show values
CREDITLIMIT Credit Limit Check Status Show values
COMPLIANCE Compliance Status Show values
QUOT_ASSIGNMENT Forwarding Quotation Assignment Status of Forwarding Order Show values
DELIVERY Delivery Status Show values
AIR_SECURITY Air Cargo Security Status for Freight Show values
AGGR_ORG_INTERACTION Aggregated Organization Interaction Status Show values
MULTI_INV_PTY Multiple Invoicing Parties Show values
ADV_SHP_RECV_RLV Advanced Shipping and Receiving Relevance Show values
Column Name Description Domain name
TRQ_ID ID of Forwarding Order/Quotation or Trsp. Reqt /SCMTMS/TRQ_ID
LABELTXT Label /SCMTMS/DESCRIPTION_S
LOGSYS Logical System (Sending System) LOGSYS
SENDER_PARTY_ID Sender Party BU_PARTNER
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
OP_ADDRESS_ID Unique Identifier for Address (APC_V_ADDRESS_ID)
ORDER_PARTY_ID Sold-to Party BU_PARTNER
ORDER_PARTY_KEY Sold-to Party Business Partner GUID /SCMTMS/BUPAUUID
OP_PAYTERM Terms of payment key ZTERM
TSP_ADDRESS_ID Unique Identifier for Address (APC_V_ADDRESS_ID)
TSP_ID Carrier BU_PARTNER
TSP_KEY Carrier Business Partner GUID /SCMTMS/BUPAUUID
TSP_SCAC Standard Carrier Alpha Code /SCMTMS/SCACD
TSP_AIRLCAWB Air Waybill Prefix CHAR3
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
INC_TRANSF_LOC_N Incoterm Location (Free Text)
INC_LOC_KEY Incoterm Location /SCMTMS/LOCUUID
INC_LOC_ID Incoterm Location
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
QUOT_TRQ_KEY Quotation TRQ Key /BOBF/CONF_KEY
QUOT_VALID_FROM Quotation Valid From /SCMTMS/TIMESTAMP
QUOT_VALID_TO Quotation Valid To /SCMTMS/TIMESTAMP
QUOT_CREATE_TRQ Restrict Number of FWOs Created from Quotations
RFQ_REJ_R_CODE Tendering Response Rejection Reason /SCMTMS/REJ_REASON_CODE
RFQ_RESPDUEDTIME Request for Quotation Latest Response Due Date and Time TZNTSTMPS
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_PROCTCO Business Transaction Document Processing Type Code /SCMTMS/BTD_PROC_TYPE_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
ERP_PLANT_ID Plant WERKS
ERP_COMP_ORG_ID Company Organization NUM08
ERP_COMP_CODE Company Code BUKRS
DLV_BLOCK_REASON Default Delivery Block LIFSP
DLV_FU_BTD_TCO Delivery Follow Up Business Transaction Document Type Code /SCMTMS/BTD_TYPE_CODE
DLV_SPLTUPD_TIME Delivery Split or Update Processing Time /SCMTMS/TIMESTAMP
SHPPLN_BLOCK_REASON Shipment Blocking Reason TRSPG
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
CNCL_RSN_CODE Reason for Cancellation /SCMTMS/CNCL_REASON_CODE
REGULATED_AGENT Regulated Agent Code CHAR25
WF_COUNT Count Number of Workflows for PPF Action
TRACKING_NO Tracking Number /SCMTMS/TRACKING_NUMBER
CREATED_BY Created By XUBNAME
CREATED_ON Created on /BOFU/TSTMP
CHANGED_BY Changed By XUBNAME
CHANGED_ON Changed On /BOFU/TSTMP
MOT Transportation Mode VKTRA
STAGE_PROFILE Stage Profile /SCMTMS/STAGE_PROFILE
CRTRADE_FWO_KEY Cross-Trade Forwarding Order Key /BOBF/CONF_KEY
ARCHIVING_TIME Archiving Date /SCMTMS/TIMESTAMP
FAG_KEY Freight Agreement Key /BOBF/CONF_KEY
FAG_ITEM_KEY Freight Agreement Item Key /BOBF/CONF_KEY
SERVICE_PRODUCT_ID Service Product /SCMTMS/SERVICE_PRODUCT_ID
ADD_FAG_KEY Freight Agreement Key /BOBF/CONF_KEY
ADD_FAG_ITEM_KEY Freight Agreement Item Key /BOBF/CONF_KEY
ADD_SERVICE_PRODUCT_ID Service Product /SCMTMS/SERVICE_PRODUCT_ID
PARTNER_SCHEMA Partner Determination Profile /SCMTMS/PARTNER_SCHEMA
TCC_EVENT_PROFILE Event Profile /SCMTMS/EVENT_PROFILE
DATETIME_CHLC Date/Time /SCMTMS/TIMESTAMP
DATETIME_CHCNF Date/Time /SCMTMS/TIMESTAMP
DATETIME_CHCMPLC Date/Time /SCMTMS/TIMESTAMP
SCI_CODE Special Customs Information /SCMTMS/SCI_CODE
EEW_TRQ_ROOT Dummy function in length 1 DUMMY
DEF_ROUTE_KEY Default Root Key /BOBF/CONF_KEY
RESP_PERSON Person Responsible UNAME
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_TRQROT.MANDT == TCURC.MANDT
  • /SCMTMS/D_TRQROT.AMT_GDSVC_CUR == TCURC.WAERS
Goods Value Currency
  • /SCMTMS/D_TRQROT.MANDT == TCURC.MANDT
  • /SCMTMS/D_TRQROT.AMT_GDSV_CUR == TCURC.WAERS
Insurable Value Currency
  • /SCMTMS/D_TRQROT.MANDT == TCURC.MANDT
  • /SCMTMS/D_TRQROT.AMT_INSV_CUR == TCURC.WAERS
Base Document Type for Business Transaction
Air Waybill Type
  • Air Waybill Type
  • Client
Freight Term
  • Freight Term
  • Client
  • Transportation Mode Category
Incoterm
  • Incoterm
  • Client
  • /SCMTMS/D_TRQROT.INC_CLASS_CODE == TINC.INCO1
  • /SCMTMS/D_TRQROT.MANDT == TINC.MANDT
Movement Type
Quotation Price Limit Currency
  • /SCMTMS/D_TRQROT.MANDT == TCURC.MANDT
  • /SCMTMS/D_TRQROT.QUOT_PRLIMIT_CUR == TCURC.WAERS
Sales Group
  • ?
  • ?
  • Client
  • Sales Group
  • /SCMTMS/D_TRQROT.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_TRQROT.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_TRQROT.MANDT == PLOGI.MANDT
  • /SCMTMS/D_TRQROT.SALES_GROUP_ID == PLOGI.OBJID
Sales Office
  • ?
  • ?
  • Client
  • Sales Office
  • /SCMTMS/D_TRQROT.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_TRQROT.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_TRQROT.MANDT == PLOGI.MANDT
  • /SCMTMS/D_TRQROT.SALES_OFF_ID == PLOGI.OBJID
Sales Organization
  • ?
  • ?
  • Client
  • Sales Organization
  • /SCMTMS/D_TRQROT.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_TRQROT.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_TRQROT.MANDT == PLOGI.MANDT
  • /SCMTMS/D_TRQROT.SALES_ORG_ID == PLOGI.OBJID
Type of FWO, FWQ, or Transportation Requirement
  • Type of FWO, FWQ, or Transportation Requirement
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Shipping Type
  • Shipping Type
  • Transportation Mode