SAP ABAP Table MCVTTSB (Reference Structure for MCVTTS)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LE-TRA (Application Component) Transportation
     ⤷ MCT (Package) Application Development R/3 Transportation Inform. System

Basic Data

Table Category	INTTAB	Structure
Structure	MCVTTSB	Table Relationship Diagram
Short Description	Reference Structure for MCVTTS

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Update Indicator for Statistics Updating
2	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
3	.INCLUDE	☐				0	0	LIS: Stages of Shipment Data
4	.INCLUDE	☐				0	0	Stage of Shipment
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	TKNUM	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	VTTK
7	TSNUM	☐	TSNUM	TSNUM	NUMC	4	0	Stage of transport number	*
8	TSTYP	☐	TSTYP	TSTYP	CHAR	1	0	Stage category
9	TSRFO	☐	TSRFO	TSRFO	NUMC	4	0	Stage of transport sequence
10	ELUPD	☐	ELUPD	ELUPD	CHAR	1	0	Change Indicator
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
17	ROUTE	☐	ROUTES	ROUTE	CHAR	6	0	Route for shipment stage	TVRO
18	VSART	☐	VERSARTS	VERSART	CHAR	2	0	Shipping type for shipment stage	T173
19	INCO1	☐	INCO1VTTS	INCO1	CHAR	3	0	Incoterms for printout	TINC
20	LAUFK	☐	LAUFS	LAUFK	CHAR	1	0	Leg indicator for shipment stage
21	ADRNA	☐	ADRNA	ADRNR	CHAR	10	0	Departure point: Address	*
22	KNOTA	☐	KNOTA	KNOTN	CHAR	10	0	Departure Point	TVKN
23	VSTEL	☐	VSTELA	VSTEL	CHAR	4	0	Shipping point at point of departure	TVST
24	LSTEL	☐	LSTELA	LSTEL	CHAR	2	0	Point of departure: Loading point at shipping point	TVLA
25	WERKA	☐	WERKSA	WERKS	CHAR	4	0	Plant at point of departure	T001W
26	LGORTA	☐	LGORTA	LGORT	CHAR	4	0	Departure point: Storage location in plant	T001L
27	KUNNA	☐	KUNNA	KUNNR	CHAR	10	0	Departure point: Customer	KNA1
28	LIFNA	☐	LIFNA	LIFNR	CHAR	10	0	Vendor number of departure point	LFA1
29	BELAD	☐	BELAD	TEXT25	CHAR	25	0	Point of departure: Additional info (e.g. loading point)
30	ADRNZ	☐	ADRNZ	ADRNR	CHAR	10	0	Destination address	*
31	KNOTZ	☐	KNOTZ	KNOTN	CHAR	10	0	Destination point	TVKN
32	VSTEZ	☐	VSTELZ	VSTEL	CHAR	4	0	Shipping point at destination	TVST
33	LSTEZ	☐	LSTELZ	LSTEL	CHAR	2	0	Destination: Loading point at shipping point	TVLA
34	WERKZ	☐	WERKSZ	WERKS	CHAR	4	0	Plant at destination point	T001W
35	LGORTZ	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	T001L
36	KUNNZ	☐	KUNNZ	KUNNR	CHAR	10	0	Customer number for destination point	KNA1
37	LIFNZ	☐	LIFNZ	LIFNR	CHAR	10	0	Vendor number of destination point	LFA1
38	ABLAD	☐	ABLADZ	TEXT25	CHAR	25	0	Destination: Additional information (e.g. unloading point)
39	DPTBG	☐	DPTBGS	DATUM	DATS	8	0	Stage: Planned date for start of shipment
40	UPTBG	☐	UPTBGS	UZEIT	TIMS	6	0	Stage: Planned shipment start time
41	DATBG	☐	DATBGS	DATUM	DATS	8	0	Stage: Current date for start of shipment
42	UATBG	☐	UATBGS	UZEIT	TIMS	6	0	Stage: Current shipment start time
43	DPTEN	☐	DPTENS	DATUM	DATS	8	0	Stage: Planned date for end of shipment
44	UPTEN	☐	UPTENS	UZEIT	TIMS	6	0	Stage: Planned shipemnt end time
45	DATEN	☐	DATENDS	DATUM	DATS	8	0	Stage: Actual Date for End of Shipment
46	UATEN	☐	UATENDS	UZEIT	TIMS	6	0	Stage: Actual shipment end time
47	TDLNR	☐	TDLNRS	LIFNR	CHAR	10	0	Number of forwarding agent in the shipment stage	LFA1
48	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
49	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
50	FAHZT	☐	FAHZT	FAHZT	QUAN	5	2	Travelling time only between two locations
51	GESZT	☐	GESZT	FAHZT	QUAN	5	2	Total travelling time between two locations incl. breaks
52	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	*
53	LGNUMA	☐	LGNUMA	LGNUM	CHAR	3	0	Point of departure: Warehouse number	T300
54	TORA	☐	LGTORA	LGTOR	CHAR	3	0	Point of departure: Gate for warehouse number	T30B
55	ADRKNZA	☐	ADRKNZA	ADRKNZ	CHAR	1	0	Point of departure: Origin indicator of address
56	KUNABLA	☐	KUNABLA	TEXT25	CHAR	25	0	Point of departure: Customer's unloading point	KNVA
57	LGNUMZ	☐	LGNUMZ	LGNUM	CHAR	3	0	Destination: Warehouse number	T300
58	TORZ	☐	LGTORZ	LGTOR	CHAR	3	0	Destination. Gate for warehouse number	T30B
59	ADRKNZZ	☐	ADRKNZZ	ADRKNZ	CHAR	1	0	Destination: Origin indicator of address
60	KUNABLZ	☐	KUNABLZ	TEXT25	CHAR	25	0	Destination: Customer's unloading point	KNVA
61	GESZTD	☐	AB_GESZTDP	TSTRDURAG	DEC	11	0	Planned total time at stage level (in days)
62	FAHZTD	☐	AB_EFFZTDP	TSTRDURAN	DEC	11	0	Plan: Actual duration at stage level (in hours:minutes)
63	GESZTDA	☐	AB_GESZTDA	TSTRDURAG	DEC	11	0	Actual total time at stage of shipment (in days)
64	FAHZTDA	☐	AB_EFFZTDA	TSTRDURAN	DEC	11	0	Actual duration of shipment stage (in hours:minutes)
65	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
66	FRKRL	☐	FRKRL	FRKRL	CHAR	1	0	Shipment costs relevance
67	SKALSM	☐	KALSM_TRAB	KALSM	CHAR	6	0	Pricing procedure in stage of shipment	T683
68	FBSTA	☐	FBSTA	FBSTA	CHAR	1	0	Status of shipment costs calculation
69	ARSTA	☐	ARSTA	ARSTA	CHAR	1	0	Status of shipment costs settlement
70	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
71	CONT_DG	☐	ADGE_SCDG	X	CHAR	1	0	Indicator: Section contains dangerous goods
72	WARZTD	☐	AB_WARZTDP	TSTRDURAN	DEC	11	0	Planned waiting time in shipment stage (in hrs:min)
73	WARZTDA	☐	AB_WARZTDA	TSTRDURAN	DEC	11	0	Current waiting time in shipment stage (in hrs:min)
74	ABLAND1	☐	ABLAND1	LAND1	CHAR	3	0	Country of departure	T005
75	ABPSTLZ	☐	ABPSTLZ	PSTLZ	CHAR	10	0	Departure postal code
76	ABORT01	☐	ABORT01	ORT01	CHAR	35	0	Point of departure
77	EDLAND1	☐	EDLAND1	LAND1	CHAR	3	0	Destination Country	T005
78	EDPSTLZ	☐	EDPSTLZ	PSTLZ	CHAR	10	0	Destination Postal Code
79	EDORT01	☐	EDORT01	ORT01	CHAR	35	0	Destination
80	.INCLUDE	☐				0	0	Additional Fields: Stages of Shipment for LIS Updating
81	TKNOTA	☐	BEZKNOTA	TEXT30	CHAR	30	0	Description of departure point
82	TORT2A	☐	BEZKNOTA	TEXT30	CHAR	30	0	Description of departure point
83	PSTLZA	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
84	LAND1A	☐	LAND1A	LAND1	CHAR	3	0	Country key for point of departure	*
85	LZONEA	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
86	REGIOA	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
87	TKNOTZ	☐	BEZKNOTZ	TEXT30	CHAR	30	0	Description of destination point
88	TORT2Z	☐	BEZKNOTZ	TEXT30	CHAR	30	0	Description of destination point
89	PSTLZZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
90	LAND1Z	☐	LAND1Z	LAND1	CHAR	3	0	Country key	*
91	LZONEZ	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
92	REGIOZ	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
93	DLNAMT	☐	DLNRNAME	NAME	CHAR	35	0	Name of the Service Agent
94	BEZKOMPRA	☐	BEZKOMPR	CHAR60	CHAR	60	0	Abbreviated location name
95	BEZKOMPRZ	☐	BEZKOMPR	CHAR60	CHAR	60	0	Abbreviated location name
96	DURTP	☐	MC_TPDURTPP	TDURAMIN	DEC	11	0	TIS: planned shipment duration
97	DURTA	☐	MC_TPDURTPA	TDURAMIN	DEC	11	0	TIS: actual shipment duration
98	LATET	☐	MC_TPDURTPU	TDURAMIN	DEC	11	0	TIS: Amount of time the planned shipment time was exceeded
99	LATES	☐	MC_TPDURTPV	TDURAMIN	DEC	11	0	TIS: amount of time shipment start was delayed (planned-act)
100	LATEE	☐	MC_TPDURTPZ	TDURAMIN	DEC	11	0	TIS: delay of the actual shipment end (planned - actual)
101	DURGES	☐	MC_TPDURGES	TDURAMIN	DEC	11	0	Total duration in minutes
102	DURFAH	☐	MC_TPDURFAH	TDURAMIN	DEC	11	0	Travel duration in real travel time (minutes)
103	DURFAHP	☐	MC_TPDURFAHP	TDURAMIN	DEC	11	0	Planned travel time in minutes
104	DURGESP	☐	MC_TPDURGESP	TDURAMIN	DEC	11	0	Planned total duration in minutes
105	.INCLUDE	☐				0	0	Partner Structures for Transport from VBPA
106	PKUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
107	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
108	PKUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
109	PKUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
110	PTDLNR	☐	TDLNR	LIFNR	CHAR	10	0	Number of forwarding agent	*
111	PTFRNR	☐	TFRNR	LIFNR	CHAR	10	0	Name of carrier in transportation	*
112	PTRFNR	☐	TRFNR	LIFNR	CHAR	10	0	Number of cleaning company in the shipment	*
113	PTVENR	☐	TVENR	LIFNR	CHAR	10	0	Number of transportation insurance in the shipment	*
114	PLAAG	☐	PLAAG	LAND1	CHAR	3	0	Country of the sold-to party	*
115	PLAWE	☐	PLAWE	LAND1	CHAR	3	0	Country of ship-to party	*
116	PLARE	☐	PLARE	LAND1	CHAR	3	0	Country of the bill-to party	*
117	PLARG	☐	PLARG	LAND1	CHAR	3	0	Country of the payer	*
118	PLASP	☐	PLASP	LAND1	CHAR	3	0	Country of the carrier	*
119	PLAFF	☐	PLAFF	LAND1	CHAR	3	0	Country of carrier	*
120	PLARF	☐	PLARF	LAND1	CHAR	3	0	Country of cleaning company	*
121	PLATV	☐	PLATV	LAND1	CHAR	3	0	Country of transportation insurer	*
122	PABLA	☐	PABLA	TEXT25	CHAR	25	0	Unloading point of the ship-to party
123	PZONE	☐	PZONE	ZONE	CHAR	10	0	Transportation zone of the ship-to party	*
124	.INCLUDE	☐				0	0	User Section: Additional Partner(s) from VBPA
125	PDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
126	.INCLUDE	☐				0	0	User Structure: Stages of Shipment for LIS Updating
127	UDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCVTTSB	ABLAND1	T005	LAND1
2	MCVTTSB	EDLAND1	T005	LAND1
3	MCVTTSB	INCO1	TINC	INCO1	REF	C	CN
4	MCVTTSB	KNOTA	TVKN	KNOTE	REF	C	CN
5	MCVTTSB	KNOTZ	TVKN	KNOTE	REF	C	CN
6	MCVTTSB	KUNABLA	KNVA	ABLAD
7	MCVTTSB	KUNABLZ	KNVA	ABLAD
8	MCVTTSB	KUNNA	KNA1	KUNNR	REF	C	CN
9	MCVTTSB	KUNNZ	KNA1	KUNNR	REF	C	CN
10	MCVTTSB	LGNUMA	T300	LGNUM
11	MCVTTSB	LGNUMZ	T300	LGNUM
12	MCVTTSB	LGORTA	T001L	LGORT
13	MCVTTSB	LGORTZ	T001L	LGORT
14	MCVTTSB	LIFNA	LFA1	LIFNR	REF	C	CN
15	MCVTTSB	LIFNZ	LFA1	LIFNR	REF	C	CN
16	MCVTTSB	LSTEL	TVLA	LSTEL	REF	C	CN
17	MCVTTSB	LSTEZ	TVLA	LSTEL	REF	C	CN
18	MCVTTSB	MANDT	T000	MANDT	KEY	1	CN
19	MCVTTSB	ROUTE	TVRO	ROUTE	REF	C	CN
20	MCVTTSB	SDABW	TVSAK	SDABW
21	MCVTTSB	SKALSM	T683	KALSM
22	MCVTTSB	TDLNR	LFA1	LIFNR	REF	1	CN
23	MCVTTSB	TKNUM	VTTK	TKNUM	KEY	1	CN
24	MCVTTSB	TORA	T30B	LGTOR
25	MCVTTSB	TORZ	T30B	LGTOR
26	MCVTTSB	VSART	T173	VSART	REF	C	CN
27	MCVTTSB	VSTEL	TVST	VSTEL	REF	C	CN
28	MCVTTSB	VSTEZ	TVST	VSTEL	REF	C	CN
29	MCVTTSB	WERKA	T001W	WERKS
30	MCVTTSB	WERKZ	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in