S054 SAP (Stages of shipment) Table details

Dictionary Type: Table
Description: Stages of shipment




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




Table field list including key, data, relationships and ABAP select examples

S054 is a standard SAP Table which is used to store Stages of shipment data and is available within R/3 SAP systems depending on the version and release level.

The S054 table consists of various fields, each holding specific information or linking keys about Stages of 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 S054 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 in the shipment stage TDLNRSCHAR10LFA1ALPHALIFNRF4_CARRIERS
LAND1ACountry key for point of departure LAND1ACHAR3T005LAND1LND
LZONEATransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
LAND1ZCountry key LAND1ZCHAR3T005LAND1LND
LZONEZTransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
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
ANZTSTIS: Number of shipment stages MC_ANZTSDEC9MCZAEHLER
ANZTPLFTIS: Number of deliveries in the shipment MC_ANZTPLFDEC9MCZAEHLER
ANZPKKTIS: Number of packages MC_ANZPKDEC9MCZAEHLER
DURTPTIS: planned shipment duration MC_TPDURTPPDEC11TDURMTDURAMIN
DURTATIS: actual shipment duration MC_TPDURTPADEC11TDURMTDURAMIN
LATETTIS: Amount of time the planned shipment time was exceeded MC_TPDURTPUDEC11TDURMTDURAMIN
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
TPAVGTPPAverage planned shipment duration MC_TPAVGTPPDEC11TDURMTDURAMIN
TPAVGTPAAverage actual shipment duration MC_TPAVGTPADEC11TDURMTDURAMIN
TPAVGTPUAverage time the planned shipment time was exceeded MC_TPAVGTPUDEC11TDURMTDURAMIN
TPAVGTPVAverage time shipment begin was delayed (planned - actual) MC_TPAVGTPVDEC11TDURMTDURAMIN
TPAVGTPZAverage delay of the shipment end (planned - actual) MC_TPAVGTPZDEC11TDURMTDURAMIN
TPAVGFAHPAverage planned travel time (in minutes) MC_TPAVGFAHPDEC11TDURMTDURAMIN
TPAVGFAHAverage transit time in real travel time (minutes) MC_TPAVGFAHDEC11TDURMTDURAMIN
TPAVGGESPAverage planned total duration in minutes MC_TPAVGGESPDEC11TDURMTDURAMIN
TPAVGGESAverage total duration in minutes MC_TPAVGGESDEC11TDURMTDURAMIN

Key field Non-key field



How do I retrieve data from SAP table S054 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S054 to SELECT all data from the table
DATA: WA_S054 TYPE S054.

SELECT SINGLE *
FROM S054
INTO CORRESPONDING FIELDS OF WA_S054
WHERE...

How to access SAP table S054

Within an ECC or HANA version of SAP you can also view further information about S054 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!