/MRSS/D_TRAVEL SAP table for – Travel Times

Here we would like to draw your attention to /MRSS/D_TRAVEL table in SAP. As we know it is being mainly used with the SAP PM-WOC (Maintenance Processing in PM) component which is coming under PM module (Plant Maintenance). /MRSS/D_TRAVEL is a SAP standard transparent table used for storing Travel Times related data in SAP. It comes under the package /MRSS/SGE.

SAP /MRSS/D_TRAVEL table

Table /MRSS/D_TRAVEL technical data

Table/MRSS/D_TRAVEL
Data storingTravel Times
ModulePM
ComponentPM-WOC
SAP Package/MRSS/SGE
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /MRSS/D_TRAVEL Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /MRSS/D_TRAVEL table.

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • TRV_TO_DIS_UNIT
    Its data type is C (Character String) with field length 6
  • TRV_TO_MANU_SET
    Its data type is C (Character String) with field length 2
  • TRV_TO_PROFILE
    Its data type is C (Character String) with field length 20
  • TRV_FRM_BEGIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TRV_FRM_END
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TRV_FRM_DURATION
    Its data type is X (Byte string) with field length 4
  • TRV_FRM_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • TRV_FRM_DISTANCE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TRV_FRM_DIS_UNIT
    Its data type is C (Character String) with field length 6
  • TRV_FRM_MANU_SET
    Its data type is C (Character String) with field length 2
  • TRAVEL_TIME_KEY
    Its a key field. Its data type is X (Byte string) with field length 16
  • TRV_FRM_PROFILE
    Its data type is C (Character String) with field length 20
  • RESOURCE_KEY
    Its data type is X (Byte string) with field length 16
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /MRSS/T_TRAVEL_TIME
  • TRV_TO_BEGIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TRV_TO_END
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TRV_TO_DURATION
    Its data type is X (Byte string) with field length 4
  • TRV_TO_DUR_UNIT
    Its data type is C (Character String) with field length 6
  • TRV_TO_DISTANCE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8