S050 SAP (Shipment) Table details
Dictionary Type: Table
Description: Shipment
Description: Shipment
Table field list including key, data, relationships and ABAP select examples
S050 is a standard SAP Table which is used to store Shipment data and is available within R/3 SAP systems depending on the version and release level.
The S050 table consists of various fields, each holding specific information or linking keys about Shipment data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP S050 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
TPLST | Transportation planning point | TPLST | CHAR | 4 | TTDS | TPLST | TDP | ||
SHTYP | Shipment type | SHTYP | CHAR | 4 | TVTK | SHTYP | TSH | ||
TDLNR | Number of forwarding agent | TDLNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | F4_CARRIERS |
ALAND | Country: shipment start | ALAND_TBG | CHAR | 3 | T005 | LAND1 | VAL | ||
AZONE | Zone: shipment start | AZONE_TBG | CHAR | 10 | TZONE | ZONE | |||
LLAND | Country: shipment end | LLAND_TEN | CHAR | 3 | T005 | LAND1 | VLL | ||
LZONE | Zone: shipment end | LZONE_TEN | CHAR | 10 | TZONE | ZONE | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
STADIS | Distance unit for statistics update | STADIS | UNIT | 3 | T006 | CUNIT | MEINS | ||
STAGEW | Weight unit for statistics update | STAGEW | UNIT | 3 | T006 | CUNIT | MEINS | ||
STAVOL | Volume unit for statistics update | STAVOL | UNIT | 3 | T006 | CUNIT | MEINS | ||
DISTZK | TIS: Sum of distances in the shipment | MC_TPDISTZ | QUAN | 15(3) | MENGV15_3 | ||||
BRGEWK | TIS: Sum of the delivery gross weights in shipment | MC_TPBRGEW | QUAN | 15(3) | MENGV15_3 | ||||
NTGEWK | TIS: sum of the delivery net weights in the shipment | MC_TPNTGEW | QUAN | 15(3) | MENGV15_3 | ||||
VOLUMK | TIS: sum of the delivery volumes in a shipment | MC_TPVOLUM | QUAN | 15(3) | MENGV15_3 | ||||
ANZTP | TIS: No. of shipments | MC_ANZTP | DEC | 9 | MCZAEHLER | ||||
ANZTS | TIS: Number of shipment stages | MC_ANZTS | DEC | 9 | MCZAEHLER | ||||
ANZHV | TIS: Number of main shipping units in the shipment | MC_ANZHV | DEC | 9 | MCZAEHLER | ||||
BRGEW_VE | LIS: Gross weight of all main shipping units in shipment | BRGEW_VET | QUAN | 15(3) | MENG15 | ||||
NTGEW_VE | LIS: Net weight of all main shipping units in shipment | NTGEW_VET | QUAN | 15(3) | MENG15 | ||||
NTVOL_VE | LIS: Net volume of all main shipping units in shipment | NTVOL_VET | QUAN | 15(3) | MENG15 | ||||
MAGEW_VE | LIS: Max. freight weight of all main shipping units in shpmt | MAGEW_VET | QUAN | 15(3) | MENG15 | ||||
MAVOL_VE | LIS: Max. freight volume of all main shipping units in shpmt | MAVOL_VET | QUAN | 15(3) | MENG15 | ||||
ANZTPLF | TIS: Number of deliveries in the shipment | MC_ANZTPLF | DEC | 9 | MCZAEHLER | ||||
ANZPKK | TIS: Number of packages | MC_ANZPK | DEC | 9 | MCZAEHLER | ||||
PRVOL_TOT | Utilization percentage: volume | PRVOL_TOT | DEC | 10 | DEC_10 | ||||
PRGEW_TOT | Total weight utilization as a percentage | PRGEW_TOT | DEC | 10 | DEC_10 | ||||
DURLP | TIS: planned shipment loading time | MC_TPDURLDP | DEC | 11 | TDURM | TDURAMIN | |||
DURLA | TIS: actual shipment loading time | MC_TPDURLDA | DEC | 11 | TDURM | TDURAMIN | |||
LATEL | TIS: Amount of time the planned loading time was exceeded | MC_TPDURLDU | DEC | 11 | TDURM | TDURAMIN | |||
DURTP | TIS: planned shipment duration | MC_TPDURTPP | DEC | 11 | TDURM | TDURAMIN | |||
DURTA | TIS: actual shipment duration | MC_TPDURTPA | DEC | 11 | TDURM | TDURAMIN | |||
LATET | TIS: Amount of time the planned shipment time was exceeded | MC_TPDURTPU | DEC | 11 | TDURM | TDURAMIN | |||
LATER | TIS: Check-in delay (planned - actual) | MC_TPDURRGV | DEC | 11 | TDURM | TDURAMIN | |||
LATEB | TIS: Loading start delay (planned - actual) | MC_TPDURLDV | DEC | 11 | TDURM | TDURAMIN | |||
LATES | TIS: amount of time shipment start was delayed (planned-act) | MC_TPDURTPV | DEC | 11 | TDURM | TDURAMIN | |||
LATEE | TIS: delay of the actual shipment end (planned - actual) | MC_TPDURTPZ | DEC | 11 | TDURM | TDURAMIN | |||
DURFAHP | Planned travel time in minutes | MC_TPDURFAHP | DEC | 11 | TDURM | TDURAMIN | |||
DURFAH | Travel duration in real travel time (minutes) | MC_TPDURFAH | DEC | 11 | TDURM | TDURAMIN | |||
DURGESP | Planned total duration in minutes | MC_TPDURGESP | DEC | 11 | TDURM | TDURAMIN | |||
DURGES | Total duration in minutes | MC_TPDURGES | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGLDV | Average delay of loading begin (planning - actual) | MC_TPAVGLDV | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGLDA | Average actual loading time for a shipment | MC_TPAVGLDA | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGLDP | Average planned loading time for a shipment | MC_TPAVGLDP | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGLDU | Average time the planned shipment loading time was exceeded | MC_TPAVGLDU | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGRGV | Average delay of check-in (planning - actual) | MC_TPAVGRGV | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGTPV | Average time shipment begin was delayed (planned - actual) | MC_TPAVGTPV | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGTPZ | Average delay of the shipment end (planned - actual) | MC_TPAVGTPZ | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGTPA | Average actual shipment duration | MC_TPAVGTPA | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGTPP | Average planned shipment duration | MC_TPAVGTPP | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGTPU | Average time the planned shipment time was exceeded | MC_TPAVGTPU | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGGESP | Average planned total duration in minutes | MC_TPAVGGESP | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGGES | Average total duration in minutes | MC_TPAVGGES | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGFAHP | Average planned travel time (in minutes) | MC_TPAVGFAHP | DEC | 11 | TDURM | TDURAMIN | |||
TPAVGFAH | Average transit time in real travel time (minutes) | MC_TPAVGFAH | DEC | 11 | TDURM | TDURAMIN | |||
AUSLG_VE | Utilization percentage: Weight | PRGEW_CAPD | DEC | 3 | DEC3 | ||||
AUSLV_VE | Utilization percentage: volume | PRVOL_CAPD | DEC | 3 | DEC3 |
Key field | Non-key field |
How do I retrieve data from SAP table S050 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S050 to SELECT all data from the tableDATA: WA_S050 TYPE S050.
SELECT SINGLE *
FROM S050
INTO CORRESPONDING FIELDS OF WA_S050
WHERE...
How to access SAP table S050
Within an ECC or HANA version of SAP you can also view further information about S050 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects