S051 - Shipment routes
Shipment routes information is stored in SAP table S051.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S051
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 4 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 3 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 6 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 8 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 6 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
| TPLST | Transportation planning point | X | TPLST | CHAR | 4 | TTDS |
| SHTYP | Shipment type | X | SHTYP | CHAR | 4 | TVTK |
| ROUTE | Shipment route | X | ROUTR | CHAR | 6 | TVRO |
| LAUFK | Leg Indicator | X | LAUFK | CHAR | 1 | |
| TDLNR | Number of forwarding agent | X | TDLNR | CHAR | 10 | LFA1 |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| STADIS | Distance unit for statistics update | STADIS | UNIT | 3 | T006 | |
| STAGEW | Weight unit for statistics update | STAGEW | UNIT | 3 | T006 | |
| STAVOL | Volume unit for statistics update | STAVOL | UNIT | 3 | T006 | |
| DISTZK | TIS: Sum of distances in the shipment | MC_TPDISTZ | QUAN | 8 | ||
| BRGEWK | TIS: Sum of the delivery gross weights in shipment | MC_TPBRGEW | QUAN | 8 | ||
| NTGEWK | TIS: sum of the delivery net weights in the shipment | MC_TPNTGEW | QUAN | 8 | ||
| VOLUMK | TIS: sum of the delivery volumes in a shipment | MC_TPVOLUM | QUAN | 8 | ||
| ANZTP | TIS: No. of shipments | MC_ANZTP | DEC | 5 | ||
| ANZTS | TIS: Number of shipment stages | MC_ANZTS | DEC | 5 | ||
| ANZHV | TIS: Number of main shipping units in the shipment | MC_ANZHV | DEC | 5 | ||
| BRGEW_VE | LIS: Gross weight of all main shipping units in shipment | BRGEW_VET | QUAN | 8 | ||
| NTGEW_VE | LIS: Net weight of all main shipping units in shipment | NTGEW_VET | QUAN | 8 | ||
| NTVOL_VE | LIS: Net volume of all main shipping units in shipment | NTVOL_VET | QUAN | 8 | ||
| MAGEW_VE | LIS: Max. freight weight of all main shipping units in shpmt | MAGEW_VET | QUAN | 8 | ||
| MAVOL_VE | LIS: Max. freight volume of all main shipping units in shpmt | MAVOL_VET | QUAN | 8 | ||
| ANZTPLF | TIS: Number of deliveries in the shipment | MC_ANZTPLF | DEC | 5 | ||
| ANZPKK | TIS: Number of packages | MC_ANZPK | DEC | 5 | ||
| PRVOL_TOT | Utilization percentage: volume | PRVOL_TOT | DEC | 6 | ||
| PRGEW_TOT | Total weight utilization as a percentage | PRGEW_TOT | DEC | 6 | ||
| DURLP | TIS: planned shipment loading time | MC_TPDURLDP | DEC | 6 | ||
| DURLA | TIS: actual shipment loading time | MC_TPDURLDA | DEC | 6 | ||
| LATEL | TIS: Amount of time the planned loading time was exceeded | MC_TPDURLDU | DEC | 6 | ||
| DURTP | TIS: planned shipment duration | MC_TPDURTPP | DEC | 6 | ||
| DURTA | TIS: actual shipment duration | MC_TPDURTPA | DEC | 6 | ||
| LATET | TIS: Amount of time the planned shipment time was exceeded | MC_TPDURTPU | DEC | 6 | ||
| LATER | TIS: Check-in delay (planned - actual) | MC_TPDURRGV | DEC | 6 | ||
| LATEB | TIS: Loading start delay (planned - actual) | MC_TPDURLDV | DEC | 6 | ||
| LATES | TIS: amount of time shipment start was delayed (planned-act) | MC_TPDURTPV | DEC | 6 | ||
| LATEE | TIS: delay of the actual shipment end (planned - actual) | MC_TPDURTPZ | DEC | 6 | ||
| DURFAHP | Planned travel time in minutes | MC_TPDURFAHP | DEC | 6 | ||
| DURFAH | Travel duration in real travel time (minutes) | MC_TPDURFAH | DEC | 6 | ||
| DURGESP | Planned total duration in minutes | MC_TPDURGESP | DEC | 6 | ||
| DURGES | Total duration in minutes | MC_TPDURGES | DEC | 6 | ||
| TPAVGLDV | Average delay of loading begin (planning - actual) | MC_TPAVGLDV | DEC | 6 | ||
| TPAVGLDA | Average actual loading time for a shipment | MC_TPAVGLDA | DEC | 6 | ||
| TPAVGLDP | Average planned loading time for a shipment | MC_TPAVGLDP | DEC | 6 | ||
| TPAVGLDU | Average time the planned shipment loading time was exceeded | MC_TPAVGLDU | DEC | 6 | ||
| TPAVGRGV | Average delay of check-in (planning - actual) | MC_TPAVGRGV | DEC | 6 | ||
| TPAVGTPV | Average time shipment begin was delayed (planned - actual) | MC_TPAVGTPV | DEC | 6 | ||
| TPAVGTPZ | Average delay of the shipment end (planned - actual) | MC_TPAVGTPZ | DEC | 6 | ||
| TPAVGTPA | Average actual shipment duration | MC_TPAVGTPA | DEC | 6 | ||
| TPAVGTPP | Average planned shipment duration | MC_TPAVGTPP | DEC | 6 | ||
| TPAVGTPU | Average time the planned shipment time was exceeded | MC_TPAVGTPU | DEC | 6 | ||
| TPAVGGESP | Average planned total duration in minutes | MC_TPAVGGESP | DEC | 6 | ||
| TPAVGGES | Average total duration in minutes | MC_TPAVGGES | DEC | 6 | ||
| TPAVGFAHP | Average planned travel time (in minutes) | MC_TPAVGFAHP | DEC | 6 | ||
| TPAVGFAH | Average transit time in real travel time (minutes) | MC_TPAVGFAH | DEC | 6 | ||
| AUSLG_VE | Utilization percentage: Weight | PRGEW_CAPD | DEC | 2 | ||
| AUSLV_VE | Utilization percentage: volume | PRVOL_CAPD | DEC | 2 |