S050 SAP (Shipment) Table details

Dictionary Type: Table
Description: Shipment




ABAP Code to SELECT data from S050
Related tables to S050
Access table S050




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
MANDTClient MANDTCLNT3T000MANDT
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
SHTYPShipment type SHTYPCHAR4TVTKSHTYPTSH
TDLNRNumber of forwarding agent TDLNRCHAR10LFA1ALPHALIFNRLIFF4_CARRIERS
ALANDCountry: shipment start ALAND_TBGCHAR3T005LAND1VAL
AZONEZone: shipment start AZONE_TBGCHAR10TZONEZONE
LLANDCountry: shipment end LLAND_TENCHAR3T005LAND1VLL
LZONEZone: shipment end LZONE_TENCHAR10TZONEZONE
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
STADISDistance unit for statistics update STADISUNIT3T006CUNITMEINS
STAGEWWeight unit for statistics update STAGEWUNIT3T006CUNITMEINS
STAVOLVolume unit for statistics update STAVOLUNIT3T006CUNITMEINS
DISTZKTIS: Sum of distances in the shipment MC_TPDISTZQUAN15(3) MENGV15_3
BRGEWKTIS: Sum of the delivery gross weights in shipment MC_TPBRGEWQUAN15(3) MENGV15_3
NTGEWKTIS: sum of the delivery net weights in the shipment MC_TPNTGEWQUAN15(3) MENGV15_3
VOLUMKTIS: sum of the delivery volumes in a shipment MC_TPVOLUMQUAN15(3) MENGV15_3
ANZTPTIS: No. of shipments MC_ANZTPDEC9MCZAEHLER
ANZTSTIS: Number of shipment stages MC_ANZTSDEC9MCZAEHLER
ANZHVTIS: Number of main shipping units in the shipment MC_ANZHVDEC9MCZAEHLER
BRGEW_VELIS: Gross weight of all main shipping units in shipment BRGEW_VETQUAN15(3) MENG15
NTGEW_VELIS: Net weight of all main shipping units in shipment NTGEW_VETQUAN15(3) MENG15
NTVOL_VELIS: Net volume of all main shipping units in shipment NTVOL_VETQUAN15(3) MENG15
MAGEW_VELIS: Max. freight weight of all main shipping units in shpmt MAGEW_VETQUAN15(3) MENG15
MAVOL_VELIS: Max. freight volume of all main shipping units in shpmt MAVOL_VETQUAN15(3) MENG15
ANZTPLFTIS: Number of deliveries in the shipment MC_ANZTPLFDEC9MCZAEHLER
ANZPKKTIS: Number of packages MC_ANZPKDEC9MCZAEHLER
PRVOL_TOTUtilization percentage: volume PRVOL_TOTDEC10DEC_10
PRGEW_TOTTotal weight utilization as a percentage PRGEW_TOTDEC10DEC_10
DURLPTIS: planned shipment loading time MC_TPDURLDPDEC11TDURMTDURAMIN
DURLATIS: actual shipment loading time MC_TPDURLDADEC11TDURMTDURAMIN
LATELTIS: Amount of time the planned loading time was exceeded MC_TPDURLDUDEC11TDURMTDURAMIN
DURTPTIS: planned shipment duration MC_TPDURTPPDEC11TDURMTDURAMIN
DURTATIS: actual shipment duration MC_TPDURTPADEC11TDURMTDURAMIN
LATETTIS: Amount of time the planned shipment time was exceeded MC_TPDURTPUDEC11TDURMTDURAMIN
LATERTIS: Check-in delay (planned - actual) MC_TPDURRGVDEC11TDURMTDURAMIN
LATEBTIS: Loading start delay (planned - actual) MC_TPDURLDVDEC11TDURMTDURAMIN
LATESTIS: amount of time shipment start was delayed (planned-act) MC_TPDURTPVDEC11TDURMTDURAMIN
LATEETIS: delay of the actual shipment end (planned - actual) MC_TPDURTPZDEC11TDURMTDURAMIN
DURFAHPPlanned travel time in minutes MC_TPDURFAHPDEC11TDURMTDURAMIN
DURFAHTravel duration in real travel time (minutes) MC_TPDURFAHDEC11TDURMTDURAMIN
DURGESPPlanned total duration in minutes MC_TPDURGESPDEC11TDURMTDURAMIN
DURGESTotal duration in minutes MC_TPDURGESDEC11TDURMTDURAMIN
TPAVGLDVAverage delay of loading begin (planning - actual) MC_TPAVGLDVDEC11TDURMTDURAMIN
TPAVGLDAAverage actual loading time for a shipment MC_TPAVGLDADEC11TDURMTDURAMIN
TPAVGLDPAverage planned loading time for a shipment MC_TPAVGLDPDEC11TDURMTDURAMIN
TPAVGLDUAverage time the planned shipment loading time was exceeded MC_TPAVGLDUDEC11TDURMTDURAMIN
TPAVGRGVAverage delay of check-in (planning - actual) MC_TPAVGRGVDEC11TDURMTDURAMIN
TPAVGTPVAverage time shipment begin was delayed (planned - actual) MC_TPAVGTPVDEC11TDURMTDURAMIN
TPAVGTPZAverage delay of the shipment end (planned - actual) MC_TPAVGTPZDEC11TDURMTDURAMIN
TPAVGTPAAverage actual shipment duration MC_TPAVGTPADEC11TDURMTDURAMIN
TPAVGTPPAverage planned shipment duration MC_TPAVGTPPDEC11TDURMTDURAMIN
TPAVGTPUAverage time the planned shipment time was exceeded MC_TPAVGTPUDEC11TDURMTDURAMIN
TPAVGGESPAverage planned total duration in minutes MC_TPAVGGESPDEC11TDURMTDURAMIN
TPAVGGESAverage total duration in minutes MC_TPAVGGESDEC11TDURMTDURAMIN
TPAVGFAHPAverage planned travel time (in minutes) MC_TPAVGFAHPDEC11TDURMTDURAMIN
TPAVGFAHAverage transit time in real travel time (minutes) MC_TPAVGFAHDEC11TDURMTDURAMIN
AUSLG_VEUtilization percentage: Weight PRGEW_CAPDDEC3DEC3
AUSLV_VEUtilization percentage: volume PRVOL_CAPDDEC3DEC3

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!