SAP ABAP Table S052 (Means of transportation)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | S052 |
Table Relationship Diagram 
|
| Short Description | Means of transportation |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | SSOUR |
SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
| 3 | VRSIO |
VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
| 4 | SPMON |
SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
| 5 | SPTAG |
SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
| 6 | SPWOC |
SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
| 7 | SPBUP |
SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
| 8 | TPLST |
TPLST | TPLST | CHAR | 4 | 0 | Transportation planning point | TTDS | |
| 9 | SHTYP |
SHTYP | SHTYP | CHAR | 4 | 0 | Shipment type | TVTK | |
| 10 | VHILM_VE |
VHILM_VET | MATNR | CHAR | 18 | 0 | LIS: Highest shipping element in transport | MARA | |
| 11 | ROUTE |
ROUTR | ROUTE | CHAR | 6 | 0 | Shipment route | TVRO | |
| 12 | PERIV |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
| 13 | VWDAT |
VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
| 14 | STAGEW |
STAGEW | MEINS | UNIT | 3 | 0 | Weight unit for statistics update | T006 | |
| 15 | STAVOL |
STAVOL | MEINS | UNIT | 3 | 0 | Volume unit for statistics update | T006 | |
| 16 | STADIS |
STADIS | MEINS | UNIT | 3 | 0 | Distance unit for statistics update | T006 | |
| 17 | ANZHV |
MC_ANZHV | MCZAEHLER | DEC | 9 | 0 | TIS: Number of main shipping units in the shipment | ||
| 18 | ANZTP |
MC_ANZTP | MCZAEHLER | DEC | 9 | 0 | TIS: No. of shipments | ||
| 19 | ANZTPLF |
MC_ANZTPLF | MCZAEHLER | DEC | 9 | 0 | TIS: Number of deliveries in the shipment | ||
| 20 | BRGEW_VE |
BRGEW_VET | MENG15 | QUAN | 15 | 3 | LIS: Gross weight of all main shipping units in shipment | ||
| 21 | NTGEW_VE |
NTGEW_VET | MENG15 | QUAN | 15 | 3 | LIS: Net weight of all main shipping units in shipment | ||
| 22 | TARAG_VE |
TARAG_VET | MENG15 | QUAN | 15 | 3 | LIS: Tare weight of all main shipping units in shipment | ||
| 23 | MAGEW_VE |
MAGEW_VET | MENG15 | QUAN | 15 | 3 | LIS: Max. freight weight of all main shipping units in shpmt | ||
| 24 | BRVOL_VE |
BRVOL_VET | MENG15 | QUAN | 15 | 3 | LIS: Gross volume of all main shipping units in shipment | ||
| 25 | NTVOL_VE |
NTVOL_VET | MENG15 | QUAN | 15 | 3 | LIS: Net volume of all main shipping units in shipment | ||
| 26 | TAVOL_VE |
TAVOL_VET | MENG15 | QUAN | 15 | 3 | LIS: Tare volume of all main shipping units in shipment | ||
| 27 | MAVOL_VE |
MAVOL_VET | MENG15 | QUAN | 15 | 3 | LIS: Max. freight volume of all main shipping units in shpmt | ||
| 28 | PRGEW_TOT |
PRGEW_TOT | DEC_10 | DEC | 10 | 0 | Total weight utilization as a percentage | ||
| 29 | PRVOL_TOT |
PRVOL_TOT | DEC_10 | DEC | 10 | 0 | Utilization percentage: volume | ||
| 30 | BRGEWK |
MC_TPBRGEW | MENGV15_3 | QUAN | 15 | 3 | TIS: Sum of the delivery gross weights in shipment | ||
| 31 | VOLUMK |
MC_TPVOLUM | MENGV15_3 | QUAN | 15 | 3 | TIS: sum of the delivery volumes in a shipment | ||
| 32 | NTGEWK |
MC_TPNTGEW | MENGV15_3 | QUAN | 15 | 3 | TIS: sum of the delivery net weights in the shipment | ||
| 33 | DISTZK |
MC_TPDISTZ | MENGV15_3 | QUAN | 15 | 3 | TIS: Sum of distances in the shipment | ||
| 34 | DURLP |
MC_TPDURLDP | TDURAMIN | DEC | 11 | 0 | TIS: planned shipment loading time | ||
| 35 | DURLA |
MC_TPDURLDA | TDURAMIN | DEC | 11 | 0 | TIS: actual shipment loading time | ||
| 36 | LATEL |
MC_TPDURLDU | TDURAMIN | DEC | 11 | 0 | TIS: Amount of time the planned loading time was exceeded | ||
| 37 | DURTP |
MC_TPDURTPP | TDURAMIN | DEC | 11 | 0 | TIS: planned shipment duration | ||
| 38 | DURTA |
MC_TPDURTPA | TDURAMIN | DEC | 11 | 0 | TIS: actual shipment duration | ||
| 39 | LATET |
MC_TPDURTPU | TDURAMIN | DEC | 11 | 0 | TIS: Amount of time the planned shipment time was exceeded | ||
| 40 | TPAVGLDA |
MC_TPAVGLDA | TDURAMIN | DEC | 11 | 0 | Average actual loading time for a shipment | ||
| 41 | TPAVGLDP |
MC_TPAVGLDP | TDURAMIN | DEC | 11 | 0 | Average planned loading time for a shipment | ||
| 42 | TPAVGLDU |
MC_TPAVGLDU | TDURAMIN | DEC | 11 | 0 | Average time the planned shipment loading time was exceeded | ||
| 43 | TPAVGTPA |
MC_TPAVGTPA | TDURAMIN | DEC | 11 | 0 | Average actual shipment duration | ||
| 44 | TPAVGTPP |
MC_TPAVGTPP | TDURAMIN | DEC | 11 | 0 | Average planned shipment duration | ||
| 45 | TPAVGTPU |
MC_TPAVGTPU | TDURAMIN | DEC | 11 | 0 | Average time the planned shipment time was exceeded | ||
| 46 | AUSLG_VE |
PRGEW_CAPD | DEC3 | DEC | 3 | 0 | Utilization percentage: Weight | ||
| 47 | AUSLV_VE |
PRVOL_CAPD | DEC3 | DEC | 3 | 0 | Utilization percentage: volume |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | S052 | MANDT |  T000 |
MANDT |
KEY | ||
| 2 | S052 | ROUTE | TVRO |
ROUTE |
KEY | C | CN |
| 3 | S052 | SHTYP | TVTK |
SHTYP |
KEY | 1 | CN |
| 4 | S052 | STADIS | T006 |
MSEHI |
|||
| 5 | S052 | STAGEW | T006 |
MSEHI |
|||
| 6 | S052 | STAVOL | T006 |
MSEHI |
|||
| 7 | S052 | TPLST | TTDS |
TPLST |
KEY | 1 | CN |
| 8 | S052 | VHILM_VE | MARA |
MATNR |
KEY |
History
| Last changed by/on | SAP | 20050411 |
| SAP Release Created in |
