SAP ABAP Table S054 (Stages of 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	S054	Table Relationship Diagram
Short Description	Stages of 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	☑	TDLNRS	LIFNR	CHAR	10	0	Number of forwarding agent in the shipment stage	LFA1
11	LAND1A	☑	LAND1A	LAND1	CHAR	3	0	Country key for point of departure	T005
12	LZONEA	☑	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
13	LAND1Z	☑	LAND1Z	LAND1	CHAR	3	0	Country key	T005
14	LZONEZ	☑	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	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	ANZTS	☐	MC_ANZTS	MCZAEHLER	DEC	9	0	TIS: Number of shipment stages
25	ANZTPLF	☐	MC_ANZTPLF	MCZAEHLER	DEC	9	0	TIS: Number of deliveries in the shipment
26	ANZPKK	☐	MC_ANZPK	MCZAEHLER	DEC	9	0	TIS: Number of packages
27	DURTP	☐	MC_TPDURTPP	TDURAMIN	DEC	11	0	TIS: planned shipment duration
28	DURTA	☐	MC_TPDURTPA	TDURAMIN	DEC	11	0	TIS: actual shipment duration
29	LATET	☐	MC_TPDURTPU	TDURAMIN	DEC	11	0	TIS: Amount of time the planned shipment time was exceeded
30	LATES	☐	MC_TPDURTPV	TDURAMIN	DEC	11	0	TIS: amount of time shipment start was delayed (planned-act)
31	LATEE	☐	MC_TPDURTPZ	TDURAMIN	DEC	11	0	TIS: delay of the actual shipment end (planned - actual)
32	DURFAHP	☐	MC_TPDURFAHP	TDURAMIN	DEC	11	0	Planned travel time in minutes
33	DURFAH	☐	MC_TPDURFAH	TDURAMIN	DEC	11	0	Travel duration in real travel time (minutes)
34	DURGESP	☐	MC_TPDURGESP	TDURAMIN	DEC	11	0	Planned total duration in minutes
35	DURGES	☐	MC_TPDURGES	TDURAMIN	DEC	11	0	Total duration in minutes
36	TPAVGTPP	☐	MC_TPAVGTPP	TDURAMIN	DEC	11	0	Average planned shipment duration
37	TPAVGTPA	☐	MC_TPAVGTPA	TDURAMIN	DEC	11	0	Average actual shipment duration
38	TPAVGTPU	☐	MC_TPAVGTPU	TDURAMIN	DEC	11	0	Average time the planned shipment time was exceeded
39	TPAVGTPV	☐	MC_TPAVGTPV	TDURAMIN	DEC	11	0	Average time shipment begin was delayed (planned - actual)
40	TPAVGTPZ	☐	MC_TPAVGTPZ	TDURAMIN	DEC	11	0	Average delay of the shipment end (planned - actual)
41	TPAVGFAHP	☐	MC_TPAVGFAHP	TDURAMIN	DEC	11	0	Average planned travel time (in minutes)
42	TPAVGFAH	☐	MC_TPAVGFAH	TDURAMIN	DEC	11	0	Average transit time in real travel time (minutes)
43	TPAVGGESP	☐	MC_TPAVGGESP	TDURAMIN	DEC	11	0	Average planned total duration in minutes
44	TPAVGGES	☐	MC_TPAVGGES	TDURAMIN	DEC	11	0	Average total duration in minutes

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S054	LAND1A	T005	LAND1	KEY
2	S054	LAND1Z	T005	LAND1	KEY
3	S054	LZONEA	TZONE	ZONE1	KEY
4	S054	LZONEZ	TZONE	ZONE1	KEY
5	S054	MANDT	T000	MANDT	KEY
6	S054	SHTYP	TVTK	SHTYP	KEY	1	CN
7	S054	STADIS	T006	MSEHI
8	S054	STAGEW	T006	MSEHI
9	S054	STAVOL	T006	MSEHI
10	S054	TDLNR	LFA1	LIFNR	KEY	1	CN
11	S054	TPLST	TTDS	TPLST	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in