Need Table name that stores Scheduled transport requests.

[Former Member]

Hello All,

I need the table name which stores the scheduled transport requests. I know the table TMSBUFREQ but it does not have date field. I need a table which stores the schedules TRs, with date field.

Please help me out!

Regards,

Viswa...

[Former Member]

Hi,

TAble taht may help you is .... E070.

try to look into table E07* too.

Regards,

Jeet

[Clemenss]

Hi,

table /SCMTMS/D_TRQITM has fields

.INCLUDE	/SCMTMS/S_DTMPS_PICKUP	Include Structure for Pick-up Date/Time
PIC_EAR_REQ	/SCMTMS/PIC_EAR_REQ_DATETIME	Pick-Up (From)
PIC_LAT_REQ	/SCMTMS/PIC_LAT_REQ_DATETIME	Pick-Up (To)
PIC_EAR_ACC	/SCMTMS/PIC_EAR_ACC_DATETIME	Earliest Pick-Up
PIC_LAT_ACC	/SCMTMS/PIC_LAT_ACC_DATETIME	Latest Pick-Up
PIC_SEL_TIME	/SCMTMS/STOP_SELECTION_DATA	Timestamp for Stop Selection
.INCLUDE	/SCMTMS/S_DTMPS_PICKUP_CNF	Include Structure for Confirmed Pick-up Date/Time
PIC_EAR_CNF	/SCMTMS/PIC_EAR_CNF_DATETIME	Confirmed Pick-Up (From)
PIC_LAT_CNF	/SCMTMS/PIC_LAT_CNF_DATETIME	Confirmed Pick-Up (To)
.INCLUDE	/SCMTMS/S_DTMPS_DELIVERY	Include Structure for Delivery Date/Time
DEL_EAR_REQ	/SCMTMS/DEL_EAR_REQ_DATETIME	Delivery (From)
DEL_LAT_REQ	/SCMTMS/DEL_LAT_REQ_DATETIME	Delivery (To)
DEL_EAR_ACC	/SCMTMS/DEL_EAR_ACC_DATETIME	Earliest Delivery
DEL_LAT_ACC	/SCMTMS/DEL_LAT_ACC_DATETIME	Latest Delivery
DEL_SEL_TIME	/SCMTMS/STOP_SELECTION_DATA	Timestamp for Stop Selection
.INCLUDE	/SCMTMS/S_DTMPS_DELIVERY_CNF	Include Structure for Confirmed Delivery Date/Time
DEL_EAR_CNF	/SCMTMS/DEL_EAR_CNF_DATETIME	Confirmed Delivery (From)
DEL_LAT_CNF	/SCMTMS/DEL_LAT_CNF_DATETIME	Confirmed Delivery (To)

Note that all those are UTC time stamps to be converted by CONVERT TIMESTAMP

Regards

Clemens

[tomas_black]

Hello Viswa,

such information is not stored in a table, simply because the import time is controlled by jobs in SM37 (run program RDDIMPDP to schedule the jobs and inform the import ime). You can see all jobs scheculed to be run in SM37 as well.

Indeed table TMSBUFREQ contains the requests that are already on the queue to be imported, but the import time is not applicable here.

Regards,

Tomas Black