SAP ABAP Table S050 (Shipment)

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S050	Table Relationship Diagram
Short Description	Shipment

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	TDLNR	☑	TDLNR	LIFNR	CHAR	10	0	Number of forwarding agent	LFA1
11	ALAND	☑	ALAND_TBG	LAND1	CHAR	3	0	Country: shipment start	T005
12	AZONE	☑	AZONE_TBG	ZONE	CHAR	10	0	Zone: shipment start	TZONE
13	LLAND	☑	LLAND_TEN	LAND1	CHAR	3	0	Country: shipment end	T005
14	LZONE	☑	LZONE_TEN	ZONE	CHAR	10	0	Zone: shipment end	TZONE
15	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
16	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
17	STADIS	☐	STADIS	MEINS	UNIT	3	0	Distance unit for statistics update	T006
18	STAGEW	☐	STAGEW	MEINS	UNIT	3	0	Weight unit for statistics update	T006
19	STAVOL	☐	STAVOL	MEINS	UNIT	3	0	Volume unit for statistics update	T006
20	DISTZK	☐	MC_TPDISTZ	MENGV15_3	QUAN	15	3	TIS: Sum of distances in the shipment
21	BRGEWK	☐	MC_TPBRGEW	MENGV15_3	QUAN	15	3	TIS: Sum of the delivery gross weights in shipment
22	NTGEWK	☐	MC_TPNTGEW	MENGV15_3	QUAN	15	3	TIS: sum of the delivery net weights in the shipment
23	VOLUMK	☐	MC_TPVOLUM	MENGV15_3	QUAN	15	3	TIS: sum of the delivery volumes in a shipment
24	ANZTP	☐	MC_ANZTP	MCZAEHLER	DEC	9	0	TIS: No. of shipments
25	ANZTS	☐	MC_ANZTS	MCZAEHLER	DEC	9	0	TIS: Number of shipment stages
26	ANZHV	☐	MC_ANZHV	MCZAEHLER	DEC	9	0	TIS: Number of main shipping units in the shipment
27	BRGEW_VE	☐	BRGEW_VET	MENG15	QUAN	15	3	LIS: Gross weight of all main shipping units in shipment
28	NTGEW_VE	☐	NTGEW_VET	MENG15	QUAN	15	3	LIS: Net weight of all main shipping units in shipment
29	NTVOL_VE	☐	NTVOL_VET	MENG15	QUAN	15	3	LIS: Net volume of all main shipping units in shipment
30	MAGEW_VE	☐	MAGEW_VET	MENG15	QUAN	15	3	LIS: Max. freight weight of all main shipping units in shpmt
31	MAVOL_VE	☐	MAVOL_VET	MENG15	QUAN	15	3	LIS: Max. freight volume of all main shipping units in shpmt
32	ANZTPLF	☐	MC_ANZTPLF	MCZAEHLER	DEC	9	0	TIS: Number of deliveries in the shipment
33	ANZPKK	☐	MC_ANZPK	MCZAEHLER	DEC	9	0	TIS: Number of packages
34	PRVOL_TOT	☐	PRVOL_TOT	DEC_10	DEC	10	0	Utilization percentage: volume
35	PRGEW_TOT	☐	PRGEW_TOT	DEC_10	DEC	10	0	Total weight utilization as a percentage
36	DURLP	☐	MC_TPDURLDP	TDURAMIN	DEC	11	0	TIS: planned shipment loading time
37	DURLA	☐	MC_TPDURLDA	TDURAMIN	DEC	11	0	TIS: actual shipment loading time
38	LATEL	☐	MC_TPDURLDU	TDURAMIN	DEC	11	0	TIS: Amount of time the planned loading time was exceeded
39	DURTP	☐	MC_TPDURTPP	TDURAMIN	DEC	11	0	TIS: planned shipment duration
40	DURTA	☐	MC_TPDURTPA	TDURAMIN	DEC	11	0	TIS: actual shipment duration
41	LATET	☐	MC_TPDURTPU	TDURAMIN	DEC	11	0	TIS: Amount of time the planned shipment time was exceeded
42	LATER	☐	MC_TPDURRGV	TDURAMIN	DEC	11	0	TIS: Check-in delay (planned - actual)
43	LATEB	☐	MC_TPDURLDV	TDURAMIN	DEC	11	0	TIS: Loading start delay (planned - actual)
44	LATES	☐	MC_TPDURTPV	TDURAMIN	DEC	11	0	TIS: amount of time shipment start was delayed (planned-act)
45	LATEE	☐	MC_TPDURTPZ	TDURAMIN	DEC	11	0	TIS: delay of the actual shipment end (planned - actual)
46	DURFAHP	☐	MC_TPDURFAHP	TDURAMIN	DEC	11	0	Planned travel time in minutes
47	DURFAH	☐	MC_TPDURFAH	TDURAMIN	DEC	11	0	Travel duration in real travel time (minutes)
48	DURGESP	☐	MC_TPDURGESP	TDURAMIN	DEC	11	0	Planned total duration in minutes
49	DURGES	☐	MC_TPDURGES	TDURAMIN	DEC	11	0	Total duration in minutes
50	TPAVGLDV	☐	MC_TPAVGLDV	TDURAMIN	DEC	11	0	Average delay of loading begin (planning - actual)
51	TPAVGLDA	☐	MC_TPAVGLDA	TDURAMIN	DEC	11	0	Average actual loading time for a shipment
52	TPAVGLDP	☐	MC_TPAVGLDP	TDURAMIN	DEC	11	0	Average planned loading time for a shipment
53	TPAVGLDU	☐	MC_TPAVGLDU	TDURAMIN	DEC	11	0	Average time the planned shipment loading time was exceeded
54	TPAVGRGV	☐	MC_TPAVGRGV	TDURAMIN	DEC	11	0	Average delay of check-in (planning - actual)
55	TPAVGTPV	☐	MC_TPAVGTPV	TDURAMIN	DEC	11	0	Average time shipment begin was delayed (planned - actual)
56	TPAVGTPZ	☐	MC_TPAVGTPZ	TDURAMIN	DEC	11	0	Average delay of the shipment end (planned - actual)
57	TPAVGTPA	☐	MC_TPAVGTPA	TDURAMIN	DEC	11	0	Average actual shipment duration
58	TPAVGTPP	☐	MC_TPAVGTPP	TDURAMIN	DEC	11	0	Average planned shipment duration
59	TPAVGTPU	☐	MC_TPAVGTPU	TDURAMIN	DEC	11	0	Average time the planned shipment time was exceeded
60	TPAVGGESP	☐	MC_TPAVGGESP	TDURAMIN	DEC	11	0	Average planned total duration in minutes
61	TPAVGGES	☐	MC_TPAVGGES	TDURAMIN	DEC	11	0	Average total duration in minutes
62	TPAVGFAHP	☐	MC_TPAVGFAHP	TDURAMIN	DEC	11	0	Average planned travel time (in minutes)
63	TPAVGFAH	☐	MC_TPAVGFAH	TDURAMIN	DEC	11	0	Average transit time in real travel time (minutes)
64	AUSLG_VE	☐	PRGEW_CAPD	DEC3	DEC	3	0	Utilization percentage: Weight
65	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	S050	ALAND	T005	LAND1	KEY
2	S050	AZONE	TZONE	ZONE1	KEY
3	S050	LLAND	T005	LAND1	KEY
4	S050	LZONE	TZONE	ZONE1	KEY
5	S050	MANDT	T000	MANDT	KEY
6	S050	SHTYP	TVTK	SHTYP	KEY	1	CN
7	S050	STADIS	T006	MSEHI
8	S050	STAGEW	T006	MSEHI
9	S050	STAVOL	T006	MSEHI
10	S050	TDLNR	LFA1	LIFNR	KEY	1	CN
11	S050	TPLST	TTDS	TPLST	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in