/SCMTMS/D_TRQSTG - Transportation Request Stage
Transportation Request Stage information is stored in SAP table /SCMTMS/D_TRQSTG.
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_TRQSTG
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 | |
PARENT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
.INCLUDE | STAGE | /SCMTMS/S_TRQ_STAGE | 0 | |||
STAGE_ID | Transportation Stage ID | /SCMTMS/TRANSPORTATIONSTAGEID | CHAR | 20 | ||
STAGE_TYPE | Stage Type | /SCMTMS/STAGE_TYPE | CHAR | 6 | /SCMTMS/C_STGTY | |
.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 | ||
.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 | ||
.INCLUDE | /SCMTMS/S_MOT_INCL | 0 | ||||
MOT | Transportation Mode | /SCMTMS/TRMODCODE | CHAR | 4 | ||
MOT_CAT | Transportation Mode Category | /SCMTMS/TRMODCAT | CHAR | 2 | ||
MTR_TCO | Means of Transport | /SCMTMS/TRANSMEANSTYPECODE | CHAR | 20 | ||
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 | ||
AGREEMENT_PARTY | Agreement Partner Function | /SCMTMS/AGREEMENT_PARTY | CHAR | 4 | ||
.INCLUDE | /SCMTMS/S_PTY_TSP_PYMT | 0 | ||||
TSP_PYMT_ID | Invoicing Carrier | /SCMTMS/PTY_PYMT_CARRIER | CHAR | 20 | ||
TSP_PYMT_KEY | Invoicing Carrier Business Partner GUID | /SCMTMS/PYMT_CARRIER_PARTY_KEY | RAW | 16 | ||
TSP_PYMT_SCAC | Standard Carrier Alpha Code | /SCMTMS/SCACD | CHAR | 8 | ||
.INCLUDE | EXTERNAL_FA | /SCMTMS/S_EXTERNAL_FA | 0 | |||
EXTERNAL_FA_ID | External Freight Agreement | /SCMTMS/EXTERNAL_FA_ID | CHAR | 70 | ||
EXTERNAL_FA_VERSION | External Freight Agreement Version | /SCMTMS/EXTERNAL_FA_VERSION | CHAR | 64 | ||
EXTERNAL_FA_ITEM_ID | External Freight Agreement Item | /SCMTMS/EXTERNAL_FA_ITEM_ID | CHAR | 20 | ||
SUCC_STAGE_KEY | Stage Successor Key | /SCMTMS/TRQ_SUCC_STAGE_KEY | RAW | 16 | ||
PRED_STAGE_KEY | Stage Predecessor Key | /SCMTMS/TRQ_PRED_STAGE_KEY | RAW | 16 | ||
.INCLUDE | EEW_STAGE | /SCMTMS/INCL_EEW_TRQ_STAGE | 0 | |||
EEW_TRQ_STAGE | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |