SAP /SCMTMS/EXTR_STR_TRQ table - Extraction Structure for BO Transportation Request details in SAP

SAP /SCMTMS/EXTR_STR_TRQ table summary

Object Name: /SCMTMS/EXTR_STR_TRQ
Dictionary Type: Structure
Description: Extraction Structure for BO Transportation Request

Field list for /SCMTMS/EXTR_STR_TRQ table on an S/4 SAP system

Details

/SCMTMS/EXTR_STR_TRQ-TRQ_ID table field - ID of Forwarding Order/Quotation or Trsp. Reqt ▼

Description: ID of Forwarding Order/Quotation or Trsp. Reqt
Field Name: TRQ_ID
Data Element: /SCMTMS/TRQ_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: /SCMTMS/TRQ_ID
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_TRQ_ID
SHLP Field: TRQ_ID
ConvExit: ALPHA

See all SAP tables containing field TRQ_ID

/SCMTMS/EXTR_STR_TRQ-TRQ_DB_KEY table field - NodeID ▼

Description: NodeID
Field Name: TRQ_DB_KEY
Data Element: /BOBF/CONF_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRQ_DB_KEY

/SCMTMS/EXTR_STR_TRQ-TRQ_TYPE table field - Type of FWO, FWQ, or Transportation Requirement ▼

Description: Type of FWO, FWQ, or Transportation Requirement
Field Name: TRQ_TYPE
Data Element: /SCMTMS/TRQ_TYPE
Data Type: CHAR
length (Dec): 4(0)
Check table: /SCMTMS/C_TRQTY
Conversion Routine:
Domain Name: /SCMTMS/TRQ_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRQ_TYPE

/SCMTMS/EXTR_STR_TRQ-TRQ_CAT table field - Category (Forwarding Order/Quotation or Trsp. Reqt) ▼

Description: Category (Forwarding Order/Quotation or Trsp. Reqt)
Field Name: TRQ_CAT
Data Element: /SCMTMS/TRQ_CATEGORY
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TRQ_CATEGORY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRQ_CAT

/SCMTMS/EXTR_STR_TRQ-TSP_SCAC table field - Standard Carrier Alpha Code ▼

Description: Standard Carrier Alpha Code
Field Name: TSP_SCAC
Data Element: /SCMTMS/SCACD
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/SCACD
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_SCAC
SHLP Field: SCAC
ConvExit:

See all SAP tables containing field TSP_SCAC

/SCMTMS/EXTR_STR_TRQ-SRC_LOC_IATACODE table field - IATA Code (Source Location) ▼

Description: IATA Code (Source Location)
Field Name: SRC_LOC_IATACODE
Data Element: /SCMTMS/SOURCE_IATACODE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/LOC_IATACODE
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_LOC_IATACODE
SHLP Field: IATAC
ConvExit:

See all SAP tables containing field SRC_LOC_IATACODE

/SCMTMS/EXTR_STR_TRQ-SRC_LOC_UNLOCODE table field - Source Location: United Nations Code ▼

Description: Source Location: United Nations Code
Field Name: SRC_LOC_UNLOCODE
Data Element: /SCMTMS/SOURCE_UNLOCODE
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/LOC_UNLOCODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SRC_LOC_UNLOCODE

/SCMTMS/EXTR_STR_TRQ-DES_LOC_IATACODE table field - IATA Code (Destination Location) ▼

Description: IATA Code (Destination Location)
Field Name: DES_LOC_IATACODE
Data Element: /SCMTMS/DESTINATION_IATACODE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/LOC_IATACODE
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_LOC_IATACODE
SHLP Field: IATAC
ConvExit:

See all SAP tables containing field DES_LOC_IATACODE

/SCMTMS/EXTR_STR_TRQ-DES_LOC_UNLOCODE table field - Destination Location: United Nations Code ▼

Description: Destination Location: United Nations Code
Field Name: DES_LOC_UNLOCODE
Data Element: /SCMTMS/DESTINATION_UNLOCODE
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/LOC_UNLOCODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DES_LOC_UNLOCODE

/SCMTMS/EXTR_STR_TRQ-SHIPPING_TYPE table field - Shipping Type ▼

Description: Shipping Type
Field Name: SHIPPING_TYPE
Data Element: /SCMTMS/SHIPPING_TYPE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/SHIPPING_TYPE
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_SHTYPE
SHLP Field: SHIPPING_TYPE
ConvExit:

See all SAP tables containing field SHIPPING_TYPE

/SCMTMS/EXTR_STR_TRQ-TRAFFIC_DIRECT table field - Traffic Direction ▼

Description: Traffic Direction
Field Name: TRAFFIC_DIRECT
Data Element: /SCMTMS/TRAFFIC_DIRECTION
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TRAFFIC_DIRECTION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRAFFIC_DIRECT

/SCMTMS/EXTR_STR_TRQ-MOVEM_TYPE table field - Movement Type ▼

Description: Movement Type
Field Name: MOVEM_TYPE
Data Element: /SCMTMS/MOVEMENT_TYPE
Data Type: CHAR
length (Dec): 3(0)
Check table: /SCMTMS/C_MVMTY
Conversion Routine:
Domain Name: /SCMTMS/MOVEMENT_TYPE
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_MOVEM_TYPE
SHLP Field: MOVEM_TYPE
ConvExit:

See all SAP tables containing field MOVEM_TYPE

/SCMTMS/EXTR_STR_TRQ-TSP_AIRLCAWB table field - Air Waybill Prefix ▼

Description: Air Waybill Prefix
Field Name: TSP_AIRLCAWB
Data Element: /SCMTMS/AIRLCAWB
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSP_AIRLCAWB

/SCMTMS/EXTR_STR_TRQ-UNCONTROLLED table field - Uncontrolled Transportation ▼

Description: Uncontrolled Transportation
Field Name: UNCONTROLLED
Data Element: /SCMTMS/UNCONTROLLED_SHPMENT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/INDICATOR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNCONTROLLED

/SCMTMS/EXTR_STR_TRQ-SALES_ORG_EXTID table field - Transportation Sales Organization ▼

Description: Transportation Sales Organization
Field Name: SALES_ORG_EXTID
Data Element: /SCMB/SALES_ORG_EXT_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/ORG_EXT_ID
MemoryID:
AppClass:
SHLP: /SCMB/SH_ORGUNIT_SLSORG
SHLP Field: EXTERNAL_ID
ConvExit:

See all SAP tables containing field SALES_ORG_EXTID

/SCMTMS/EXTR_STR_TRQ-SALES_OFF_EXTID table field - Transportation Sales Office ▼

Description: Transportation Sales Office
Field Name: SALES_OFF_EXTID
Data Element: /SCMB/BUR_ORG_EXT_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/ORG_EXT_ID
MemoryID:
AppClass:
SHLP: /SCMB/SH_ORGUNIT_SLSBUR
SHLP Field: EXTERNAL_ID
ConvExit:

See all SAP tables containing field SALES_OFF_EXTID

/SCMTMS/EXTR_STR_TRQ-SALES_GRP_EXTID table field - Transportation Sales Group ▼

Description: Transportation Sales Group
Field Name: SALES_GRP_EXTID
Data Element: /SCMB/SGRP_ORG_EXT_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/ORG_EXT_ID
MemoryID:
AppClass:
SHLP: /SCMB/SH_ORGUNIT_SLSGRP
SHLP Field: EXTERNAL_ID
ConvExit:

See all SAP tables containing field SALES_GRP_EXTID

/SCMTMS/EXTR_STR_TRQ-TRACKING_NO table field - Tracking Number ▼

Description: Tracking Number
Field Name: TRACKING_NO
Data Element: /SCMTMS/TRACKING_NUMBER
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TRACKING_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRACKING_NO

/SCMTMS/EXTR_STR_TRQ-GT_EXP_DECL_LSP table field - Export Declaration by Logistics Service Provider ▼

Description: Export Declaration by Logistics Service Provider
Field Name: GT_EXP_DECL_LSP
Data Element: /SCMTMS/GT_EXP_DECL_BY_LSP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/INDICATOR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GT_EXP_DECL_LSP

/SCMTMS/EXTR_STR_TRQ-REGULATED_AGENT table field - Regulated Agent Code ▼

Description: Regulated Agent Code
Field Name: REGULATED_AGENT
Data Element: /SCMTMS/REGULATED_AGENT
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGULATED_AGENT

/SCMTMS/EXTR_STR_TRQ-UNLOAD_POINT table field - Unloading Point Name ▼

Description: Unloading Point Name
Field Name: UNLOAD_POINT
Data Element: /SCMTMS/UNLOADING_POINT_NAME
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNLOAD_POINT

/SCMTMS/EXTR_STR_TRQ-INC_LOC_ID table field - Incoterm Location ▼

Description: Incoterm Location
Field Name: INC_LOC_ID
Data Element: /SCMTMS/INC_LOCINTID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP: /SCMTMS/LOC
SHLP Field: LOCNO
ConvExit:

See all SAP tables containing field INC_LOC_ID

/SCMTMS/EXTR_STR_TRQ-PIC_EAR_ACC table field - Earliest Pick-Up ▼

Description: Earliest Pick-Up
Field Name: PIC_EAR_ACC
Data Element: /SCMTMS/PIC_EAR_ACC_DATETIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TIMESTAMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PIC_EAR_ACC

/SCMTMS/EXTR_STR_TRQ-PIC_LAT_ACC table field - Latest Pick-Up ▼

Description: Latest Pick-Up
Field Name: PIC_LAT_ACC
Data Element: /SCMTMS/PIC_LAT_ACC_DATETIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TIMESTAMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PIC_LAT_ACC

/SCMTMS/EXTR_STR_TRQ-CREATION_TSTMP table field - Date/Time When the Item was Created ▼

Description: Date/Time When the Item was Created
Field Name: CREATION_TSTMP
Data Element: /SCMTMS/DATETIME_CR
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TIMESTAMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATION_TSTMP

/SCMTMS/EXTR_STR_TRQ-CREATION_DATE table field - Created On ▼

Description: Created On
Field Name: CREATION_DATE
Data Element: /SCMTMS/DATE_CR
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATION_DATE

/SCMTMS/EXTR_STR_TRQ-CREATED_BY table field - Created By ▼

Description: Created By
Field Name: CREATED_BY
Data Element: /BOFU/USER_ID_CREATED_BY
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: XUBNAME
MemoryID:
AppClass: SUSR
SHLP: USER_COMP
SHLP Field: BNAME
ConvExit:

See all SAP tables containing field CREATED_BY

/SCMTMS/EXTR_STR_TRQ-CHANGE_TSTMP table field - Date/Time When the Item was Changed ▼

Description: Date/Time When the Item was Changed
Field Name: CHANGE_TSTMP
Data Element: /SCMTMS/DATETIME_CH
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TIMESTAMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGE_TSTMP

/SCMTMS/EXTR_STR_TRQ-CHANGE_DATE table field - Changed On ▼

Description: Changed On
Field Name: CHANGE_DATE
Data Element: /SCMTMS/DATE_CH
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHANGE_DATE

/SCMTMS/EXTR_STR_TRQ-CHANGED_BY table field - Changed By ▼

Description: Changed By
Field Name: CHANGED_BY
Data Element: /BOFU/USER_ID_CHANGED_BY
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: XUBNAME
MemoryID:
AppClass: SUSR
SHLP: USER_COMP
SHLP Field: BNAME
ConvExit:

See all SAP tables containing field CHANGED_BY

/SCMTMS/EXTR_STR_TRQ-COMPLETION_TSTMP table field - Date/Time ▼

Description: Date/Time
Field Name: COMPLETION_TSTMP
Data Element: /SCMTMS/DATETIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TIMESTAMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPLETION_TSTMP

/SCMTMS/EXTR_STR_TRQ-COMPLETION_DATE table field - Completion Date ▼

Description: Completion Date
Field Name: COMPLETION_DATE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPLETION_DATE

/SCMTMS/EXTR_STR_TRQ-AIR_SECURITY table field - Air Cargo Security Status for Freight ▼

Description: Air Cargo Security Status for Freight
Field Name: AIR_SECURITY
Data Element: /SCMB/ACS_GEN_SECURITY_STATUS
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SCMB/ACS_GEN_SECURITY_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AIR_SECURITY

/SCMTMS/EXTR_STR_TRQ-TRANSSRVLVL_CODE table field - Transportation Service Level - Sales ▼

Description: Transportation Service Level - Sales
Field Name: TRANSSRVLVL_CODE
Data Element: /SCMTMS/TRANSP_SLC_SALES
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: VSBED
MemoryID:
AppClass: VV
SHLP: /SCMTMS/SH_SLA
SHLP Field: VSBED
ConvExit:

See all SAP tables containing field TRANSSRVLVL_CODE

/SCMTMS/EXTR_STR_TRQ-FAG_ID_MAN table field - Agreement ▼

Description: Agreement
Field Name: FAG_ID_MAN
Data Element: /SCMTMS/FAG_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: /SCMTMS/FAG_ID
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_FAG_UI_ID
SHLP Field: FAGRMNTID044
ConvExit: ALPHA

See all SAP tables containing field FAG_ID_MAN

/SCMTMS/EXTR_STR_TRQ-FAG_ID_CALC table field - Agreement ▼

Description: Agreement
Field Name: FAG_ID_CALC
Data Element: /SCMTMS/FAG_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: /SCMTMS/FAG_ID
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_FAG_UI_ID
SHLP Field: FAGRMNTID044
ConvExit: ALPHA

See all SAP tables containing field FAG_ID_CALC

/SCMTMS/EXTR_STR_TRQ-LIFECYCLE table field - Life Cycle Status of FWO/FWQ or Trsp. Reqt ▼

Description: Life Cycle Status of FWO/FWQ or Trsp. Reqt
Field Name: LIFECYCLE
Data Element: /SCMTMS/TRQ_LIFECYCLE_STATUS
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/TRQ_LIFECYCLE_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIFECYCLE

/SCMTMS/EXTR_STR_TRQ-CNCL_RSN_CODE table field - Reason for Cancellation ▼

Description: Reason for Cancellation
Field Name: CNCL_RSN_CODE
Data Element: /SCMTMS/CNCL_REASON_CODE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/CNCL_REASON_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CNCL_RSN_CODE

/SCMTMS/EXTR_STR_TRQ-ROCANCEL table field - Deselect Data Record Checkbox for BW ▼

Description: Deselect Data Record Checkbox for BW
Field Name: ROCANCEL
Data Element: /SCMTMS/ROCANCEL
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: RODMUPDMOD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROCANCEL

View list of all SAP tables(S4H/ECC)

Select data from SAP table