S051 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S051 in SAP.
- Table description : Shipment routes
- Module : CRM
- Parent Module : CRM
- Package : MCS
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S051 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| TPLST | Transportation planning point | TPLST | TPLST |
| SHTYP | Shipment type | SHTYP | SHTYP |
| ROUTE | Shipment route | ROUTR | ROUTE |
| LAUFK | Leg Indicator | LAUFK | LAUFK |
| TDLNR | Number of forwarding agent | TDLNR | LIFNR |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| STADIS | Distance unit for statistics update | STADIS | MEINS |
| STAGEW | Weight unit for statistics update | STAGEW | MEINS |
| STAVOL | Volume unit for statistics update | STAVOL | MEINS |
| DISTZK | TIS: Sum of distances in the shipment | MC_TPDISTZ | MENGV15_3 |
| BRGEWK | TIS: Sum of the delivery gross weights in shipment | MC_TPBRGEW | MENGV15_3 |
| NTGEWK | TIS: sum of the delivery net weights in the shipment | MC_TPNTGEW | MENGV15_3 |
| VOLUMK | TIS: sum of the delivery volumes in a shipment | MC_TPVOLUM | MENGV15_3 |
| ANZTP | TIS: No. of shipments | MC_ANZTP | MCZAEHLER |
| ANZTS | TIS: Number of shipment stages | MC_ANZTS | MCZAEHLER |
| ANZHV | TIS: Number of main shipping units in the shipment | MC_ANZHV | MCZAEHLER |
| BRGEW_VE | LIS: Gross weight of all main shipping units in shipment | BRGEW_VET | MENG15 |
| NTGEW_VE | LIS: Net weight of all main shipping units in shipment | NTGEW_VET | MENG15 |
| NTVOL_VE | LIS: Net volume of all main shipping units in shipment | NTVOL_VET | MENG15 |
| MAGEW_VE | LIS: Max. freight weight of all main shipping units in shpmt | MAGEW_VET | MENG15 |
| MAVOL_VE | LIS: Max. freight volume of all main shipping units in shpmt | MAVOL_VET | MENG15 |
| ANZTPLF | TIS: Number of deliveries in the shipment | MC_ANZTPLF | MCZAEHLER |
| ANZPKK | TIS: Number of packages | MC_ANZPK | MCZAEHLER |
| PRVOL_TOT | Utilization percentage: volume | PRVOL_TOT | DEC_10 |
| PRGEW_TOT | Total weight utilization as a percentage | PRGEW_TOT | DEC_10 |
| DURLP | TIS: planned shipment loading time | MC_TPDURLDP | TDURAMIN |
| DURLA | TIS: actual shipment loading time | MC_TPDURLDA | TDURAMIN |
| LATEL | TIS: Amount of time the planned loading time was exceeded | MC_TPDURLDU | TDURAMIN |
| DURTP | TIS: planned shipment duration | MC_TPDURTPP | TDURAMIN |
| DURTA | TIS: actual shipment duration | MC_TPDURTPA | TDURAMIN |
| LATET | TIS: Amount of time the planned shipment time was exceeded | MC_TPDURTPU | TDURAMIN |
| LATER | TIS: Check-in delay (planned - actual) | MC_TPDURRGV | TDURAMIN |
| LATEB | TIS: Loading start delay (planned - actual) | MC_TPDURLDV | TDURAMIN |
| LATES | TIS: amount of time shipment start was delayed (planned-act) | MC_TPDURTPV | TDURAMIN |
| LATEE | TIS: delay of the actual shipment end (planned - actual) | MC_TPDURTPZ | TDURAMIN |
| DURFAHP | Planned travel time in minutes | MC_TPDURFAHP | TDURAMIN |
| DURFAH | Travel duration in real travel time (minutes) | MC_TPDURFAH | TDURAMIN |
| DURGESP | Planned total duration in minutes | MC_TPDURGESP | TDURAMIN |
| DURGES | Total duration in minutes | MC_TPDURGES | TDURAMIN |
| TPAVGLDV | Average delay of loading begin (planning - actual) | MC_TPAVGLDV | TDURAMIN |
| TPAVGLDA | Average actual loading time for a shipment | MC_TPAVGLDA | TDURAMIN |
| TPAVGLDP | Average planned loading time for a shipment | MC_TPAVGLDP | TDURAMIN |
| TPAVGLDU | Average time the planned shipment loading time was exceeded | MC_TPAVGLDU | TDURAMIN |
| TPAVGRGV | Average delay of check-in (planning - actual) | MC_TPAVGRGV | TDURAMIN |
| TPAVGTPV | Average time shipment begin was delayed (planned - actual) | MC_TPAVGTPV | TDURAMIN |
| TPAVGTPZ | Average delay of the shipment end (planned - actual) | MC_TPAVGTPZ | TDURAMIN |
| TPAVGTPA | Average actual shipment duration | MC_TPAVGTPA | TDURAMIN |
| TPAVGTPP | Average planned shipment duration | MC_TPAVGTPP | TDURAMIN |
| TPAVGTPU | Average time the planned shipment time was exceeded | MC_TPAVGTPU | TDURAMIN |
| TPAVGGESP | Average planned total duration in minutes | MC_TPAVGGESP | TDURAMIN |
| TPAVGGES | Average total duration in minutes | MC_TPAVGGES | TDURAMIN |
| TPAVGFAHP | Average planned travel time (in minutes) | MC_TPAVGFAHP | TDURAMIN |
| TPAVGFAH | Average transit time in real travel time (minutes) | MC_TPAVGFAH | TDURAMIN |
| AUSLG_VE | Utilization percentage: Weight | PRGEW_CAPD | DEC3 |
| AUSLV_VE | Utilization percentage: volume | PRVOL_CAPD | DEC3 |
S051 related tables
| Table | Note |
|---|---|
| TROAL | Routes: Allowed Actual Routes for Delivery |
| OIO_SR_ROUTE | Shipment receipt - allowed routes |
| S051 | Shipment routes |
| VTSGT | Shipment: Statistic Groups, Shipment Types |
| VTSGTT | Shipment: Statistics Groups, Shipment Types: Texts |
| EADRCITYROUTE | Routes for City |
| EEWA_CAPAB_ROUTE | IS-U Waste: Capacity Planning - Routes |
| ELWEG_LOG | Log Numbers for Street Routes |
| JRTABLRGLA | IS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes) |
| JRTROURUN | IS-M/SD: Truck Routes Delivery Rounds |
| JRTTROUTE | IS-M/SD: Daily Truck Routes |
| JSTGEOBEZ | IS-M/SD: Assignment of Carrier Routes to Geographical Units |
| LMNRT | Mandatory routes |
| SMOTLGRT | Routes: Loading Groups: Texts |
| T173 | Routes: Mode of Transport for Each Shipping Type |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP