SAP table S053 (Shipment: shipping data)
SAP table S053 has 10 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,TPLST,LFART,VSTEL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SSOUR | Statistic(s) origin | CHAR | 4 | 0 | SSOUR | ||
| VRSIO | Version number in the information structure | CHAR | 3 | 0 | * | VRSIO | |
| SPMON | Period to analyze - month | NUMC | 6 | 0 | SPMON | ||
| SPTAG | Period to analyze - current date | DATS | 8 | 0 | SPTAG | ||
| SPWOC | Period to analyze - week | NUMC | 6 | 0 | SPWOC | ||
| SPBUP | Period to analyze - posting period | NUMC | 6 | 0 | SPBUP | ||
| TPLST | Transportation planning point | CHAR | 4 | 0 | TTDS | TPLST | |
| LFART | Delivery Type | CHAR | 4 | 0 | TVLK | LFART | |
| VSTEL | Shipping Point / Receiving Point | CHAR | 4 | 0 | TVST | VSTEL | |
| PERIV | Fiscal Year Variant | CHAR | 2 | 0 | * | PERIV | |
| VWDAT | Pointer to administrative data | NUMC | 10 | 0 | VWDAT | ||
| STAGEW | Weight unit for statistics update | UNIT | 3 | 0 | T006 | STAGEW | |
| STAVOL | Volume unit for statistics update | UNIT | 3 | 0 | T006 | STAVOL | |
| BRGEWK | TIS: Sum of the delivery gross weights in shipment | QUAN | 15 | 3 | MC_TPBRGEW | ||
| NTGEWK | TIS: sum of the delivery net weights in the shipment | QUAN | 15 | 3 | MC_TPNTGEW | ||
| VOLUMK | TIS: sum of the delivery volumes in a shipment | QUAN | 15 | 3 | MC_TPVOLUM | ||
| ANZTPLF | TIS: Number of deliveries in the shipment | DEC | 9 | 0 | MC_ANZTPLF | ||
| ANZPKK | TIS: Number of packages | DEC | 9 | 0 | MC_ANZPK |
S053 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 S053 | LFART | TVLK | Delivery Types | MANDT |
| 0 S053 | LFART | TVLK | Delivery Types | LFART |
| 1 S053 | STAGEW | T006 | Units of Measurement | MANDT |
| 1 S053 | STAGEW | T006 | Units of Measurement | MSEHI |
| 0 S053 | STAVOL | T006 | Units of Measurement | MANDT |
| 0 S053 | STAVOL | T006 | Units of Measurement | MSEHI |
| 1 S053 | TPLST | TTDS | Organizational Unit: Transportation Scheduling Point | TPLST |
| 0 S053 | VSTEL | TVST | Organizational Unit: Shipping Points | MANDT |
| 0 S053 | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |