/SCMTMS/D_TRQROT - Transportation Request Root
Transportation Request Root information is stored in SAP table /SCMTMS/D_TRQROT.
It is part of development package /SCMTMS/TRQ in software component TM-FWM-FWO. This development package consists of objects that can be grouped under "BO Transportation Request".
It is part of development package /SCMTMS/TRQ in software component TM-FWM-FWO. This development package consists of objects that can be grouped under "BO Transportation Request".
Fields for table /SCMTMS/D_TRQROT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DB_KEY | NodeID | X | /BOBF/CONF_KEY | RAW | 16 | |
| .INCLUDE | ROOT | /SCMTMS/S_TRQ_ROOT | 0 | |||
| TRQ_ID | ID of Forwarding Order/Quotation or Trsp. Reqt | /SCMTMS/TRQ_ID | CHAR | 40 | ||
| TRQ_TYPE | Type of FWO, FWQ, or Transportation Requirement | /SCMTMS/TRQ_TYPE | CHAR | 8 | /SCMTMS/C_TRQTY | |
| TRQ_CAT | Category (Forwarding Order/Quotation or Trsp. Reqt) | /SCMTMS/TRQ_CATEGORY | CHAR | 4 | ||
| LABELTXT | Label | /SCMTMS/TOR_LABEL | CHAR | 80 | ||
| ORDER_DATE | Order Date of FWO, FWQ, or Transportation Requirement | /SCMTMS/TRQ_ORDER_DATE | DATS | 16 | ||
| TRQ_CNF_CR_TYPE | Confirmation Creation Type | /SCMTMS/TRQ_CNF_CREATION_TYPE | CHAR | 2 | ||
| TRQ_CNF_SUB_IND | FWO Confirmed / FWQ Submitted | /SCMTMS/TRQ_CNF_SUBMIT_IND | CHAR | 2 | ||
| TRQ_TEMPLATE_IND | Template Indicator | /SCMTMS/TRQ_TEMPLATE_IND | CHAR | 2 | ||
| LOGSYS | Logical System (Sending System) | /SCMTMS/LOGSYS_SENDING | CHAR | 20 | * | |
| .INCLUDE | /SCMTMS/S_PTY_SENDER_PARTY | 0 | ||||
| SENDER_PARTY_ID | Sender Party | /SCMTMS/PTY_SENDER_PARTY | CHAR | 20 | ||
| .INCLUDE | /SCMTMS/S_PTY_SHIPPER | 0 | ||||
| SP_ADDRESS_ID | Unique Identifier for Address (APC_V_ADDRESS_ID) | /BOFU/ADDRESS_ID | CHAR | 80 | ||
| SHIPPER_ID | Shipper | /SCMTMS/PTY_SHIPPER | CHAR | 20 | ||
| SHIPPER_KEY | Shipper Business Partner GUID | /SCMTMS/SHIPPER_KEY | RAW | 16 | ||
| .INCLUDE | /SCMTMS/S_PTY_CONSIGNEE | 0 | ||||
| CP_ADDRESS_ID | Unique Identifier for Address (APC_V_ADDRESS_ID) | /BOFU/ADDRESS_ID | CHAR | 80 | ||
| CONSIGNEE_ID | Ship-to Party | /SCMTMS/PTY_CONSIGNEE | CHAR | 20 | ||
| CONSIGNEE_KEY | Ship-to Party Business Partner GUID | /SCMTMS/CONSIGNEE_KEY | RAW | 16 | ||
| .INCLUDE | /SCMTMS/S_PTY_ORDERING_PARTY | 0 | ||||
| OP_ADDRESS_ID | Unique Identifier for Address (APC_V_ADDRESS_ID) | /BOFU/ADDRESS_ID | CHAR | 80 | ||
| ORDER_PARTY_ID | Sold-to Party | /SCMTMS/PTY_ORDERING_PARTY | CHAR | 20 | ||
| ORDER_PARTY_KEY | Sold-to Party Business Partner GUID | /SCMTMS/ORDER_PARTY_KEY | RAW | 16 | ||
| OP_AMT_CLC_VAL | Credit Limit Check Amount | /SCMTMS/CLC_AMT | CURR | 15 | ||
| OP_AMT_CLC_CUR | Credit Limit Check Currency | /SCMTMS/CLC_CURRENCY | CUKY | 10 | * | |
| OP_PAYTERM | Terms of payment key | DZTERM | CHAR | 8 | ||
| PAYMENT_STATUS | Payment Status | /SCMTMS/TRQ_PAYMENT_STATUS | CHAR | 4 | ||
| OP_PAYMENT_RECVD | Payment Received | /SCMTMS/TRQ_PAYMENT_RECVD | CHAR | 2 | ||
| OP_PREPAY_REQD | Prepayment Required | /SCMTMS/TRQ_PREPAY_REQD | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_PTY_TSP | 0 | ||||
| TSP_ADDRESS_ID | Unique Identifier for Address (APC_V_ADDRESS_ID) | /BOFU/ADDRESS_ID | CHAR | 80 | ||
| TSP_ID | Carrier | /SCMTMS/PTY_TRANS_SRV_PROVIDER | CHAR | 20 | * | |
| TSP_KEY | Carrier Business Partner GUID | /SCMTMS/CARRIER_PARTY_KEY | RAW | 16 | ||
| TSP_SCAC | Standard Carrier Alpha Code | /SCMTMS/SCACD | CHAR | 8 | ||
| TSP_AIRLC | IATA Airline Code | /SCMTMS/AIRLC | CHAR | 6 | * | |
| TSP_AIRLCAWB | Air Waybill Prefix | /SCMTMS/AIRLCAWB | CHAR | 6 | ||
| .INCLUDE | SRC_LOC_DATA | /SCMTMS/S_SRC_LOC_WITH_PU_DATE | 0 | |||
| .INCLUDE | SRC_LOC_W_CODES | /SCMTMS/S_SRC_LOC_W_CODES | 0 | |||
| .INCLUDE | SRC_LOC | /SCMTMS/S_SRC_LOC | 0 | |||
| SRC_LOC_ID | Source Location | /SCMTMS/SOURCE_LOCATION | CHAR | 40 | ||
| SRC_LOC_KEY | Location GUID (004) with Conversion Exit | /SCMTMS/LOCUUID | RAW | 16 | ||
| SRC_LOC_IATACODE | IATA Code (Source Location) | /SCMTMS/SOURCE_IATACODE | CHAR | 6 | ||
| SRC_LOC_UNLOCODE | Source Location: United Nations Code | /SCMTMS/SOURCE_UNLOCODE | CHAR | 10 | * | |
| .INCLUDE | PICKUP_DATE | /SCMTMS/S_DTMPS_PICKUP | 0 | |||
| PIC_EAR_REQ | Pick-Up (From) | /SCMTMS/PIC_EAR_REQ_DATETIME | DEC | 8 | ||
| PIC_LAT_REQ | Pick-Up (To) | /SCMTMS/PIC_LAT_REQ_DATETIME | DEC | 8 | ||
| PIC_EAR_ACC | Earliest Pick-Up | /SCMTMS/PIC_EAR_ACC_DATETIME | DEC | 8 | ||
| PIC_LAT_ACC | Latest Pick-Up | /SCMTMS/PIC_LAT_ACC_DATETIME | DEC | 8 | ||
| PIC_SEL_TIME | Timestamp for Stop Selection | /SCMTMS/STOP_SELECTION_DATA | DEC | 8 | ||
| .INCLUDE | CNF_PICKUP_DATE | /SCMTMS/S_DTMPS_PICKUP_CNF | 0 | |||
| PIC_EAR_CNF | Confirmed Pick-Up (From) | /SCMTMS/PIC_EAR_CNF_DATETIME | DEC | 8 | ||
| PIC_LAT_CNF | Confirmed Pick-Up (To) | /SCMTMS/PIC_LAT_CNF_DATETIME | DEC | 8 | ||
| SRC_STAGE_KEY | Source Stage Key | /SCMTMS/TRQ_SRC_STAGE_KEY | RAW | 16 | ||
| .INCLUDE | DES_LOC_DATA | /SCMTMS/S_DES_LOC_WITH_DELDATE | 0 | |||
| .INCLUDE | DES_LOC_W_CODES | /SCMTMS/S_DES_LOC_W_CODES | 0 | |||
| .INCLUDE | DES_LOC | /SCMTMS/S_DES_LOC | 0 | |||
| DES_LOC_ID | Destination Location | /SCMTMS/DESTINATION_LOCATION | CHAR | 40 | ||
| DES_LOC_KEY | Location GUID (004) with Conversion Exit | /SCMTMS/LOCUUID | RAW | 16 | ||
| DES_LOC_IATACODE | IATA Code (Destination Location) | /SCMTMS/DESTINATION_IATACODE | CHAR | 6 | ||
| DES_LOC_UNLOCODE | Destination Location: United Nations Code | /SCMTMS/DESTINATION_UNLOCODE | CHAR | 10 | * | |
| UNLOAD_POINT | Unloading Point Name | /SCMTMS/UNLOADING_POINT_NAME | CHAR | 50 | ||
| .INCLUDE | DELIVERY_DATE | /SCMTMS/S_DTMPS_DELIVERY | 0 | |||
| DEL_EAR_REQ | Delivery (From) | /SCMTMS/DEL_EAR_REQ_DATETIME | DEC | 8 | ||
| DEL_LAT_REQ | Delivery (To) | /SCMTMS/DEL_LAT_REQ_DATETIME | DEC | 8 | ||
| DEL_EAR_ACC | Earliest Delivery | /SCMTMS/DEL_EAR_ACC_DATETIME | DEC | 8 | ||
| DEL_LAT_ACC | Latest Delivery | /SCMTMS/DEL_LAT_ACC_DATETIME | DEC | 8 | ||
| DEL_PUDL_SPECIFICATION | Pick-Up/Delivery Window Specification | /SCMTMS/TRQ_PUDL_SPECIFICATION | CHAR | 2 | ||
| DEL_SEL_TIME | Timestamp for Stop Selection | /SCMTMS/STOP_SELECTION_DATA | DEC | 8 | ||
| .INCLUDE | CNF_DELIVERY_DATE | /SCMTMS/S_DTMPS_DELIVERY_CNF | 0 | |||
| DEL_EAR_CNF | Confirmed Delivery (From) | /SCMTMS/DEL_EAR_CNF_DATETIME | DEC | 8 | ||
| DEL_LAT_CNF | Confirmed Delivery (To) | /SCMTMS/DEL_LAT_CNF_DATETIME | DEC | 8 | ||
| DES_STAGE_KEY | Destination Stage Key | /SCMTMS/TRQ_DES_STAGE_KEY | RAW | 16 | ||
| .INCLUDE | QUANTITIES | /SCMTMS/S_QUANTITIES | 0 | |||
| GRO_WEI_VAL | Gross Weight | /SCMTMS/QUA_GRO_WEI_VAL | QUAN | 16 | ||
| GRO_WEI_UNI | Gross Weight Unit of Measure | /SCMTMS/QUA_GRO_WEI_UNI | UNIT | 6 | * | |
| GRO_VOL_VAL | Gross Volume | /SCMTMS/QUA_GRO_VOL_VAL | QUAN | 16 | ||
| GRO_VOL_UNI | Gross Volume Unit of Measure | /SCMTMS/QUA_GRO_VOL_UNI | UNIT | 6 | * | |
| NET_WEI_VAL | Net Weight | /SCMTMS/QUA_NET_WEI_VAL | QUAN | 16 | ||
| NET_WEI_UNI | Net Weight Unit of Measure | /SCMTMS/QUA_NET_WEI_UNI | UNIT | 6 | * | |
| QUA_PCS_VAL | Quantity | /SCMTMS/QUA_PCS_VAL | QUAN | 16 | ||
| QUA_PCS_UNI | Quantity Unit of Measure | /SCMTMS/QUA_PCS_UNI | UNIT | 6 | * | |
| QUA_PCS2_VAL | Alternative Quantity | /SCMTMS/QUA_PCS2_VAL | QUAN | 16 | ||
| QUA_PCS2_UNI | Alternative Quantity 2 Unit of Measure | /SCMTMS/QUA_PCS2_UNI | UNIT | 6 | * | |
| BASE_UOM_VAL | Base Quantity | /SCMTMS/QUA_BASE_UOM_VAL | QUAN | 16 | ||
| BASE_UOM_UNI | Base Unit of Measure | /SCMTMS/QUA_BASE_UOM_UNI | UNIT | 6 | * | |
| PKGUN_WEI_VAL | Tare Weight | /SCMTMS/QUA_PACK_UNL_WEI_VAL | QUAN | 16 | ||
| PKGUN_WEI_UNI | Tare Weight Unit of Measure | /SCMTMS/QUA_PACK_UNL_WEI_UNI | UNIT | 6 | * | |
| CONT_CNT_VAL | Number of Twenty-Foot Equivalent Units | /SCMTMS/CONT_COUNT_VAL | QUAN | 16 | ||
| CONT_CNT_UNI | Number of TEU Unit of Measure | /SCMTMS/CONT_COUNT_UNI | UNIT | 6 | * | |
| DG_ADR_PTS_VAL | ADR 1.1.3.6 DG Exemption Points | /SCMTMS/DG_ADR_POINTS_VAL | QUAN | 16 | ||
| DG_ADR_PTS_UNI | Unit of Measure for ADR 1.1.3.6 DG Exemption Points | /SCMTMS/DG_ADR_POINTS_UNI | UNIT | 6 | * | |
| .INCLUDE | CNF_QUANTITIES | /SCMTMS/S_QUANTITIES_CONF | 0 | |||
| CNF_GRO_WEI_VAL | Confirmed Gross Weight | /SCMTMS/CNF_QUA_GRO_WEI_VAL | QUAN | 16 | ||
| CNF_GRO_WEI_UNI | Confirmed Gross Weight Unit of Measure | /SCMTMS/CNF_QUA_GRO_WEI_UNI | UNIT | 6 | * | |
| CNF_GRO_VOL_VAL | Confirmed Gross Volume | /SCMTMS/CNF_QUA_GRO_VOL_VAL | QUAN | 16 | ||
| CNF_GRO_VOL_UNI | Confirmed Gross Volume Unit of Measure | /SCMTMS/CNF_QUA_GRO_VOL_UNI | UNIT | 6 | * | |
| CNF_QUA_PCS_VAL | Confirmed Quantity | /SCMTMS/CNF_QUA_PCS_VAL | QUAN | 16 | ||
| CNF_QUA_PCS_UNI | Confirmed Quantity Unit of Measure | /SCMTMS/CNF_QUA_PCS_UNI | UNIT | 6 | * | |
| CNF_QUA_PCS2_VAL | Confirmed Alternative Quantity | /SCMTMS/CNF_QUA_PCS2_VAL | QUAN | 16 | ||
| CNF_QUA_PCS2_UNI | Confirmed Alternative Quantity Unit of Measure | /SCMTMS/CNF_QUA_PCS2_UNI | UNIT | 6 | * | |
| CNF_CONT_CNT_VAL | Confirmed Number of TEU | /SCMTMS/CNF_CONT_COUNT_VAL | QUAN | 16 | ||
| CNF_CONT_CNT_UNI | Confirmed Number of TEU Unit of Measure | /SCMTMS/CNF_CONT_COUNT_UNI | UNIT | 6 | * | |
| .INCLUDE | AMOUNTS | /SCMTMS/S_AMOUNTS | 0 | |||
| AMT_GDSV_VAL | Goods Value | /SCMTMS/AMT_GOODSVALUE_VAL | CURR | 15 | ||
| AMT_GDSV_CUR | Goods Value Currency | /SCMTMS/AMT_GOODSVALUE_CURR | CUKY | 10 | TCURC | |
| AMT_INSV_VAL | Insurable Value | /SCMTMS/AMT_INSURVALUE_VAL | CURR | 15 | ||
| AMT_INSV_CUR | Insurable Value Currency | /SCMTMS/AMT_INSURVALUE_CURR | CUKY | 10 | TCURC | |
| AMT_GDSVC_VAL | Goods Value for Customs | /SCMTMS/AMT_GOODSVALUECUS_VAL | CURR | 15 | ||
| AMT_GDSVC_CUR | Goods Value for Customs Currency | /SCMTMS/AMT_GOODSVALUECUS_CURR | CUKY | 10 | TCURC | |
| AMT_HVAL_CAR_IND | High-Value Cargo | /SCMTMS/HIGH_VALUE_CARGO_IND | CHAR | 2 | ||
| INS_BY_LSP_IND | Insurance by LSP | /SCMTMS/INS_BY_LSP | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_TRQ_DLV_TERMS_ROOT | 0 | ||||
| .INCLUDE | /SCMTMS/S_INCOTERMS_INCL | 0 | ||||
| INC_CLASS_CODE | Incoterm | /SCMTMS/INC_CLASS_CODE | CHAR | 6 | TINC | |
| INC_TRANSF_LOC_N | Incoterm Location (Free Text) | /SCMTMS/INC_TRANSF_LOC_NAME | CHAR | 56 | ||
| INC_LOC_KEY | Incoterm Location | /SCMTMS/INC_LOC_KEY | RAW | 16 | ||
| INC_LOC_ID | Incoterm Location | /SCMTMS/INC_LOCINTID | CHAR | 40 | ||
| .INCLUDE | ROOTINCODAT | /SCMTMS/S_DTMPS_INCOTERM_LOC | 0 | |||
| INC_LOC_EAR_REQ | Requested Incoterm Location Date | /SCMTMS/INCLC_EAR_REQ_DATETIME | DEC | 8 | ||
| INC_LOC_LAT_REQ | Requested Incoterm Location Date | /SCMTMS/INCLC_LAT_REQ_DATETIME | DEC | 8 | ||
| INC_LOC_EAR_ACC | Earliest Incoterm Location Date | /SCMTMS/INCLC_EAR_ACC_DATETIME | DEC | 8 | ||
| INC_LOC_LAT_ACC | Latest Incoterm Location Date | /SCMTMS/INCLC_LAT_ACC_DATETIME | DEC | 8 | ||
| DT_PRIORITY_C | Business Transaction Priority Code | /SCMTMS/BT_PRIO_CODE | CHAR | 2 | ||
| DT_ORD_COMB_IND | Order Combination Allowed | /SCMTMS/ORDERCOMBIALLOWED | CHAR | 2 | ||
| PD_CTRL_CODE | Partial Delivery Control Code | /SCMTMS/PART_DLV_CTRL_CODE | CHAR | 4 | ||
| FREIGHT_TERM | Freight Term | /SCMTMS/FREIGHT_TERM | CHAR | 4 | /SCMTMS/C_FRTERM | |
| .INCLUDE | /SCMTMS/S_TRQ_QUOTATION | 0 | ||||
| QUOT_TRQ_KEY | Quotation TRQ Key | /SCMTMS/TRQ_QUOT_TRQ_KEY | RAW | 16 | ||
| QUOT_MODE | Quotation Mode | /SCMTMS/QUOTATION_MODE | CHAR | 2 | ||
| QUOT_VALID_FROM | Quotation Valid From | /SCMTMS/TRQ_QUOT_VALID_FROM | DEC | 8 | ||
| QUOT_VALID_TO | Quotation Valid To | /SCMTMS/TRQ_QUOT_VALID_TO | DEC | 8 | ||
| QUOT_CREATE_TRQ | Restrict Number of FWOs Created from Quotations | /SCMTMS/TRQ_QUOT_CREATE_TRQ | INT4 | 4 | ||
| QUOT_PRLIMIT_VAL | Quotation Price Limit | /SCMTMS/QUOT_PRICELIMIT_VAL | CURR | 15 | ||
| QUOT_PRLIMIT_CUR | Quotation Price Limit Currency | /SCMTMS/QUOT_PRICELIMIT_CURR | CUKY | 10 | TCURC | |
| RFQ_RESP_CODE | Response Code | /SCMTMS/RESPONSE_CODE | CHAR | 4 | ||
| RFQ_REJ_R_CODE | Tendering Response Rejection Reason | /SCMTMS/REJ_REASON_CODE | CHAR | 20 | ||
| RFQ_RESPDUEDTIME | Request for Quotation Latest Response Due Date and Time | /SCMTMS/RFQ_RESP_DUE_DATETIME | DEC | 8 | ||
| .INCLUDE | /SCMTMS/S_BASE_DOCUMENT | 0 | ||||
| BASE_BTD_TCO | Base Document Type for Business Transaction | /SCMTMS/BASE_BTD_TCO | CHAR | 10 | /SCMTMS/C_BTDTY | |
| BASE_BTD_ID | Base Business Transaction Document | /SCMTMS/BASE_BTD_ID | CHAR | 70 | ||
| BASE_BTD_VERSION | Base Business Transaction Document Version | /SCMTMS/BASE_BTD_VERSION | CHAR | 64 | ||
| BASE_BTD_KEY | Base Business Transaction Document Key | /SCMTMS/BASE_BTD_KEY | RAW | 16 | ||
| BASE_BTD_DATE | Base Business Transaction Document Date | /SCMTMS/BASE_BTD_DATE | DATS | 16 | ||
| BASE_BTD_PROCTCO | Business Transaction Document Processing Type Code | /SCMTMS/BTD_PROC_TYPE_CODE | CHAR | 8 | ||
| .INCLUDE | /SCMTMS/S_BUYER_ORIG_DOCUMENT | 0 | ||||
| BUYORIG_BTD_ID | Buyer Origin Document for Business Transaction | /SCMTMS/BUYER_ORIGIN_BTD_ID | CHAR | 70 | ||
| BUYORIG_BTD_DATE | Buyer Origin Business Transaction Doc Date (Ordering Date) | /SCMTMS/BUYER_ORIGIN_BTD_DATE | DATS | 16 | ||
| BUYORIG_BTD_ITEM_ID | Buyer Origin Document Item for Business Transaction | /SCMTMS/BUYER_ORIGIN_BTD_ITMID | CHAR | 20 | ||
| ERP_PLANT_ID | Plant | /SCMTMS/PLANT_ID | CHAR | 8 | * | |
| ERP_COMP_ORG_ID | Company Organization | /SCMTMS/COMPANY_ORG | NUMC | 16 | ||
| ERP_COMP_CODE | Company Code | /SCMTMS/COMPANY_CODE | CHAR | 8 | * | |
| .INCLUDE | /SCMTMS/S_DELIVERY | 0 | ||||
| .INCLUDE | /SCMTMS/S_DLV_STATUS | 0 | ||||
| DLV_PICKING | Picking/Putaway Status of Delivery | /SCMTMS/DLV_PICKING_STATUS | CHAR | 2 | ||
| DLV_PACKING | Packing Status of Delivery | /SCMTMS/DLV_PACKING_STATUS | CHAR | 2 | ||
| DLV_GOODS_MVMNT | Delivery Goods Movement Status | /SCMTMS/DLV_GOODS_MOVEM_STATUS | CHAR | 2 | ||
| DLV_DISTRIBUTION | Delivery Distribution Status | /SCMTMS/DLV_DISTRIBUT_STATUS | CHAR | 2 | ||
| DLV_BILLING | ERP Delivery Billing Status | /SCMTMS/DLV_BILLING_STATUS | CHAR | 2 | ||
| DLV_PLANNING | Delivery Planning Status | /SCMTMS/DLV_PLANNING_STATUS | CHAR | 2 | ||
| DLV_BLOCKED | Delivery Blocked | /SCMTMS/DLV_BLOCKED | CHAR | 2 | ||
| DLV_BLOCK_REASON | Default Delivery Block | LIFSP | CHAR | 4 | * | |
| DLV_FU_BTD_TCO | Delivery Follow Up Business Transaction Document Type Code | /SCMTMS/DLV_FOLLOWUP_BTD_TCO | CHAR | 10 | * | |
| DLV_CR_BY_TM | Delivery Creation Triggered by TM | /SCMTMS/DLV_CREATION_BY_TM | CHAR | 2 | ||
| DLV_SPLTUPD_STATUS | Delivery Split or Update Processing Status | /SCMTMS/DLV_SPLTUPD_STATUS | CHAR | 2 | ||
| DLV_SPLTUPD_TIME | Delivery Split or Update Processing Time | /SCMTMS/DLV_SPLTUPD_TIME | DEC | 8 | ||
| SHPPLN_BLOCKED | Shipment Planning Blocked | /SCMTMS/SHPPLN_BLOCKED | CHAR | 2 | ||
| SHPPLN_BLOCK_REASON | Shipment Blocking Reason | TRSPG | CHAR | 4 | * | |
| .INCLUDE | WM_INFO | /SCMTMS/S_WAREHOUSE_INFO | 0 | |||
| WM_LOGSYS | Logical System (SAP EWM Target System) | /SCMTMS/LOGSYS_EWM_TARGET_SYS | CHAR | 20 | * | |
| WM_WH_NUMBER | Warehouse Number | /SCMTMS/WAREHOUSE_NUMBER | CHAR | 8 | ||
| WM_WH_CAT | Warehouse Category | /SCMTMS/WAREHOUSE_CAT | CHAR | 2 | ||
| WM_WH_DOOR | Warehouse Door | /SCMTMS/WAREHOUSE_DOOR | CHAR | 8 | ||
| CONSUMPTION | Consumption Status of Transportation Requirement | /SCMTMS/TRQ_CONSUMPTION_STATUS | CHAR | 4 | ||
| CNCL_RSN_CODE | Reason for Cancellation | /SCMTMS/CNCL_REASON_CODE | CHAR | 8 | * | |
| .INCLUDE | /SCMTMS/S_ORGUNIT_SALES | 0 | ||||
| SALES_ORG_ID | Sales Organization | /SCMTMS/SALES_ORG_ID | NUMC | 16 | PLOGI | |
| SALES_OFF_ID | Sales Office | /SCMTMS/SALES_OFF_ID | NUMC | 16 | PLOGI | |
| SALES_GROUP_ID | Sales Group | /SCMTMS/SALES_GRP_ID | NUMC | 16 | PLOGI | |
| REGULATED_AGENT | Regulated Agent Code | /SCMTMS/REGULATED_AGENT | CHAR | 50 | ||
| .INCLUDE | /SCMTMS/S_WORKFLOW_DETAIL | 0 | ||||
| WF_COUNT | Count Number of Workflows for PPF Action | /SCMTMS/WF_COUNT | INT4 | 4 | ||
| TRACKING_NO | Tracking Number | /SCMTMS/TRACKING_NUMBER | CHAR | 70 | ||
| .INCLUDE | /BOFU/S_ADMIN_DATA | 0 | ||||
| CREATED_BY | Created By | /BOFU/USER_ID_CREATED_BY | CHAR | 24 | ||
| CREATED_ON | Created on | /BOFU/TSTMP_CREATION_TIME | DEC | 8 | ||
| CHANGED_BY | Changed By | /BOFU/USER_ID_CHANGED_BY | CHAR | 24 | ||
| CHANGED_ON | Changed On | /BOFU/TSTMP_CHANGED_TIME | DEC | 8 | ||
| .INCLUDE | /SCMTMS/S_TRQ_BLOCKING_PROCESS | 0 | ||||
| BLKG_EDI | Blocked by EDI Update | /SCMTMS/TRQ_BLOCKING_EDI_UPD | CHAR | 2 | ||
| .INCLUDE | BLOCKED_PROCESS | /SCMTMS/S_TRQ_BLOCKED_PROCESS | 0 | |||
| BLK_PLAN | Planning Block | /SCMTMS/BLOCK_PLANNING | CHAR | 2 | ||
| BLK_EXEC | Execution Block | /SCMTMS/BLOCK_EXECUTION | CHAR | 2 | ||
| BLK_CONF | Block for Confirmation of Forwarding Order | /SCMTMS/TRQ_BLOCK_CONFIRMATION | CHAR | 2 | ||
| BLK_CFIR | Block for Creation of Forwarding Settlement Document | /SCMTMS/TRQ_BLOCK_INVOICING | CHAR | 2 | ||
| BLK_QUOT | Forwarding Quotation Block | /SCMTMS/TRQ_BLOCK_QUOTATION | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_DG_COMMON_INFO | 0 | ||||
| DGO_INDICATOR | Dangerous Goods | /SCMTMS/DANG_GOODS_IND | CHAR | 2 | ||
| DGO_CHECK_ERROR | Dangerous Goods Check Error | /SCMTMS/DANG_GOODS_CHECK_ERROR | CHAR | 2 | ||
| DGO_DOC_BASED | Document-Based Dangerous Goods Data | /SCMTMS/DG_DOC_BASED | CHAR | 2 | ||
| DG_ADR_NO_EXEMPTION | Prohibited for ADR 1.1.3.6 DG Exemption | /SCMTMS/DG_ADR_NO_EXEMPTION | CHAR | 2 | ||
| TRANSSRVLVL_CODE | Transportation Service Level - Sales | /SCMTMS/TRANSP_SLC_SALES | CHAR | 4 | * | |
| .INCLUDE | /SCMTMS/S_MOT_INCL | 0 | ||||
| MOT | Transportation Mode | /SCMTMS/TRMODCODE | CHAR | 4 | ||
| MOT_CAT | Transportation Mode Category | /SCMTMS/TRMODCAT | CHAR | 2 | ||
| SHIPPING_TYPE | Shipping Type | /SCMTMS/SHIPPING_TYPE | CHAR | 6 | /SCMTMS/C_MODSH | |
| TRAFFIC_DIRECT | Traffic Direction | /SCMTMS/TRAFFIC_DIRECTION | CHAR | 6 | ||
| MOVEM_TYPE | Movement Type | /SCMTMS/MOVEMENT_TYPE | CHAR | 6 | /SCMTMS/C_MVMTY | |
| CONSOL_TYPE | Air Waybill Type | /SCMTMS/AIR_CONS_TYPE | CHAR | 4 | /SCMTMS/I_AFCON | |
| .INCLUDE | /SCMTMS/S_STAGE_PROFILE | 0 | ||||
| STAGE_PROFILE | Stage Profile | /SCMTMS/STAGE_PROFILE | CHAR | 8 | * | |
| STAGE_DET_STRAT | Stage Determination Strategy | /SCMTMS/STAGE_DET_STRATEGY | CHAR | 2 | ||
| CRTRADE_FWO_KEY | Cross-Trade Forwarding Order Key | /SCMTMS/CROSSTRADE_FWO_KEY | RAW | 16 | ||
| UNCONTROLLED | Uncontrolled Transportation | /SCMTMS/UNCONTROLLED_SHPMENT | CHAR | 2 | ||
| GT_EXP_DECL_LSP | Export Declaration by Logistics Service Provider | /SCMTMS/GT_EXP_DECL_BY_LSP | CHAR | 2 | ||
| GT_IMP_DECL_LSP | Import Declaration by Logistics Service Provider | /SCMTMS/GT_IMP_DECL_BY_LSP | CHAR | 2 | ||
| EDI_INDICATOR | EDI Indicator | /SCMTMS/EDI_INDICATOR | CHAR | 2 | ||
| PLAN_DATA_INCOMP | Planning Data Incomplete | /SCMTMS/PLAN_DATA_INCOMPLETE | CHAR | 2 | ||
| AGEABLE | Business document is or was ready for data aging | /BOFU/AGEABLE | CHAR | 2 | ||
| ARCHIVING_TIME | Archiving Date | /SCMTMS/ARCH_DATETIME | DEC | 8 | ||
| AGREEMENT_PARTY | Agreement Partner Function | /SCMTMS/AGREEMENT_PARTY | CHAR | 4 | ||
| .INCLUDE | /SCMTMS/S_FAG_INFO | 0 | ||||
| FAG_KEY | Freight Agreement Key | /SCMTMS/FAG_KEY | RAW | 16 | ||
| FAG_ITEM_KEY | Freight Agreement Item Key | /SCMTMS/FAG_ITEM_KEY | RAW | 16 | ||
| SERVICE_PRODUCT_ID | Service Product | /SCMTMS/SERVICE_PRODUCT_ID | CHAR | 80 | ||
| ADD_FAG_KEY | Freight Agreement Key | /SCMTMS/FAG_KEY | RAW | 16 | ||
| ADD_FAG_ITEM_KEY | Freight Agreement Item Key | /SCMTMS/FAG_ITEM_KEY | RAW | 16 | ||
| ADD_SERVICE_PRODUCT_ID | Service Product | /SCMTMS/SERVICE_PRODUCT_ID | CHAR | 80 | ||
| .INCLUDE | /SCMTMS/S_TRQ_ROOT_CUST | 0 | ||||
| APPROVAL_ACTIVE | Enable Approval Workflow | /SCMTMS/APPROVAL_WF_ACTIVE | CHAR | 2 | ||
| EM_ACTIVE | Enable EM Integration | /SCMTMS/EM_ACTIVE | CHAR | 2 | ||
| DIRECT_EWM_ACTIVE | Enable Direct EWM Integration | /SCMTMS/DIRECT_EWM_ACTIVE | CHAR | 2 | ||
| INVOICING_ENABLE | Enable Settlement for Forwarding Order Management | /SCMTMS/TRQ_INVOICING_ENABLED | CHAR | 2 | ||
| INVC_INT_ENABLE | Enable Internal Settlement for Forwarding Order Management | /SCMTMS/TRQ_INTINVOICE_ENABLED | CHAR | 2 | ||
| TCC_ENABLE | Enable Charge Calculation | /SCMTMS/TRQ_TCC_ENABLED | CHAR | 2 | ||
| TCC_INT_ENABLE | Enable Internal Charge Calculation | /SCMTMS/TRQ_TCC_INT_ENABLED | CHAR | 2 | ||
| ONE_ITEM_ALLOWED | One Item Per Business Document Allowed | /SCMTMS/TRQ_ONE_ITEM_ALLOWED | CHAR | 2 | ||
| SHIPMENT_LIKE | Same Locations and Business Partners for All FWO/FWQ Items | /SCMTMS/TRQ_SHIPMENT_LIKE | CHAR | 2 | ||
| FOLLOWUP_TRQ_EXP | Follow-Up Document for Business Documents Expected | /SCMTMS/TRQ_FOLLOW_UP_TRQ_EXP | CHAR | 2 | ||
| PLN_REQ_CNF_QTY | Plan on Requested or Confirmed Quantities | /SCMTMS/PLN_REQ_CNF_QTY | CHAR | 4 | ||
| CUSTOMS_HANDLG | Forwarding Order Customs Handling | /SCMTMS/TRQ_FWO_CUSTOMS_HANDLG | CHAR | 2 | ||
| CMPLC_CHK_ENABLE | Enable Compliance Check | /SCMTMS/GT_COMPLIANCE_CHECK | CHAR | 2 | ||
| PARTNER_SCHEMA | Partner Determination Profile | /SCMTMS/PARTNER_SCHEMA | CHAR | 8 | ||
| ACS_CHECK_ENABLE | Enable Air Cargo Security Check | /SCMTMS/AIR_CARGO_SECUR_CHECK | CHAR | 2 | ||
| ACS_COPY_LOCDATA | Copy Air Cargo Security Data to Document | /SCMTMS/ACS_LOCATION_DATA | CHAR | 2 | ||
| INS_ENABLE | Enable Instructions | /SCMTMS/INS_ENABLED | CHAR | 2 | ||
| LOGISTICAL_RELEVANCE | Restrict Follow-On Processing | /SCMTMS/TRQ_LOG_REL | CHAR | 2 | ||
| INC_LOC_STAGE_RULE | Incoterm Location Stage Building | /SCMTMS/INC_LOC_STAGE_RULE | CHAR | 4 | ||
| TCC_EVENT_PROFILE | Event Profile | /SCMTMS/EVENT_PROFILE | CHAR | 20 | ||
| PAYMENT_TERMS | Settlement Terms | /SCMTMS/TRQ_TYPE_PAYMENT_TERMS | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_TRQ_STATUS_ROOT | 0 | ||||
| LIFECYCLE | Life Cycle Status of FWO/FWQ or Trsp. Reqt | /SCMTMS/TRQ_LIFECYCLE_STATUS | CHAR | 4 | ||
| ARCHIVING | Archiving Status | /SCMTMS/ARCHIVING_STATUS_CODE | CHAR | 4 | ||
| APPROVAL | Approval Status | /SCMTMS/APPROVAL_STATUS | CHAR | 4 | ||
| CONFIRMATION | Confirmation Status of FWO/FWQ or Trsp. Reqt | /SCMTMS/TRQ_CONF_STATUS | CHAR | 4 | ||
| PLANNING | Planning Status of Forwarding Order or Trsp. Reqt | /SCMTMS/TRQ_PLANNING_STATUS | CHAR | 4 | ||
| EXECUTION | Execution Status of Forwarding Order or Trsp. Reqt | /SCMTMS/TRQ_EXECUTION_STATUS | CHAR | 4 | ||
| COMPLETENESS | Completeness Status | /SCMTMS/COMPLETENESS_STATUS | CHAR | 4 | ||
| CREDITLIMIT | Credit Limit Check Status | /SCMTMS/TRQ_CLC_STATUS | CHAR | 4 | ||
| COMPLIANCE | Compliance Status | /SCMTMS/GT_COMPLIANCE_STATUS | CHAR | 4 | ||
| QUOT_ASSIGNMENT | Forwarding Quotation Assignment Status of Forwarding Order | /SCMTMS/TRQ_QUOT_ASSGNM_STATUS | CHAR | 4 | ||
| .INCLUDE | /SCMTMS/S_TRQ_STATUS_AGGR_ROOT | 0 | ||||
| DELIVERY | Delivery Status | /SCMTMS/DELIVERY_STATUS | CHAR | 4 | ||
| AIR_SECURITY | Air Cargo Security Status for Freight | /SCMB/ACS_GEN_SECURITY_STATUS | CHAR | 6 | ||
| AGGR_ORG_INTERACTION | Aggregated Organization Interaction Status | /SCMTMS/AGGR_ORG_INT_STATUS | CHAR | 4 | ||
| DATETIME_CHLC | Date/Time | /SCMTMS/DATETIME | DEC | 8 | ||
| DATETIME_CHCNF | Date/Time | /SCMTMS/DATETIME | DEC | 8 | ||
| DATETIME_CHCMPLC | Date/Time | /SCMTMS/DATETIME | DEC | 8 | ||
| SCI_CODE | Special Customs Information | /SCMTMS/SCI_CODE | CHAR | 4 | ||
| .INCLUDE | EEW_ROOT | /SCMTMS/INCL_EEW_TRQ_ROOT | 0 | |||
| EEW_TRQ_ROOT | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
| DEF_ROUTE_KEY | Default Root Key | /SCMTMS/TRQ_DEF_ROUTE_KEY | RAW | 16 | ||
| MULTI_INV_PTY | Multiple Invoicing Parties | /SCMTMS/MULTI_INV_PTY | CHAR | 2 | ||
| RESP_PERSON | Person Responsible | /SCMTMS/RESP_PERSON | CHAR | 24 | ||
| CUTOFF_CUST_VGM | VGM Cut-Off Date/Time Given to Shipper | /SCMTMS/CUTOFF_TIME_CUST_VGM | DEC | 8 | ||
| ADV_SHP_RECV_RLV | Advanced Shipping and Receiving Relevance | /SCMTMS/ADV_SHP_RECV_RLV | CHAR | 2 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |