SAP ABAP Table VTTS_ALL (Leg Data and Descriptions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VTR (Package) SD R/3 transport processing

Basic Data

Table Category	INTTAB	Structure
Structure	VTTS_ALL	Table Relationship Diagram
Short Description	Leg Data and Descriptions

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	Stage of Shipment
2	.INCLUDE	☐				0	0	Stage of Shipment
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	TKNUM	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	VTTK
5	TSNUM	☐	TSNUM	TSNUM	NUMC	4	0	Stage of transport number	*
6	TSTYP	☐	TSTYP	TSTYP	CHAR	1	0	Stage category
7	TSRFO	☐	TSRFO	TSRFO	NUMC	4	0	Stage of transport sequence
8	ELUPD	☐	ELUPD	ELUPD	CHAR	1	0	Change Indicator
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
12	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
15	ROUTE	☐	ROUTES	ROUTE	CHAR	6	0	Route for shipment stage	TVRO
16	VSART	☐	VERSARTS	VERSART	CHAR	2	0	Shipping type for shipment stage	T173
17	INCO1	☐	INCO1VTTS	INCO1	CHAR	3	0	Incoterms for printout	TINC
18	LAUFK	☐	LAUFS	LAUFK	CHAR	1	0	Leg indicator for shipment stage
19	ADRNA	☐	ADRNA	ADRNR	CHAR	10	0	Departure point: Address	*
20	KNOTA	☐	KNOTA	KNOTN	CHAR	10	0	Departure Point	TVKN
21	VSTEL	☐	VSTELA	VSTEL	CHAR	4	0	Shipping point at point of departure	TVST
22	LSTEL	☐	LSTELA	LSTEL	CHAR	2	0	Point of departure: Loading point at shipping point	TVLA
23	WERKA	☐	WERKSA	WERKS	CHAR	4	0	Plant at point of departure	T001W
24	LGORTA	☐	LGORTA	LGORT	CHAR	4	0	Departure point: Storage location in plant	T001L
25	KUNNA	☐	KUNNA	KUNNR	CHAR	10	0	Departure point: Customer	KNA1
26	LIFNA	☐	LIFNA	LIFNR	CHAR	10	0	Vendor number of departure point	LFA1
27	BELAD	☐	BELAD	TEXT25	CHAR	25	0	Point of departure: Additional info (e.g. loading point)
28	ADRNZ	☐	ADRNZ	ADRNR	CHAR	10	0	Destination address	*
29	KNOTZ	☐	KNOTZ	KNOTN	CHAR	10	0	Destination point	TVKN
30	VSTEZ	☐	VSTELZ	VSTEL	CHAR	4	0	Shipping point at destination	TVST
31	LSTEZ	☐	LSTELZ	LSTEL	CHAR	2	0	Destination: Loading point at shipping point	TVLA
32	WERKZ	☐	WERKSZ	WERKS	CHAR	4	0	Plant at destination point	T001W
33	LGORTZ	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	T001L
34	KUNNZ	☐	KUNNZ	KUNNR	CHAR	10	0	Customer number for destination point	KNA1
35	LIFNZ	☐	LIFNZ	LIFNR	CHAR	10	0	Vendor number of destination point	LFA1
36	ABLAD	☐	ABLADZ	TEXT25	CHAR	25	0	Destination: Additional information (e.g. unloading point)
37	DPTBG	☐	DPTBGS	DATUM	DATS	8	0	Stage: Planned date for start of shipment
38	UPTBG	☐	UPTBGS	UZEIT	TIMS	6	0	Stage: Planned shipment start time
39	DATBG	☐	DATBGS	DATUM	DATS	8	0	Stage: Current date for start of shipment
40	UATBG	☐	UATBGS	UZEIT	TIMS	6	0	Stage: Current shipment start time
41	DPTEN	☐	DPTENS	DATUM	DATS	8	0	Stage: Planned date for end of shipment
42	UPTEN	☐	UPTENS	UZEIT	TIMS	6	0	Stage: Planned shipemnt end time
43	DATEN	☐	DATENDS	DATUM	DATS	8	0	Stage: Actual Date for End of Shipment
44	UATEN	☐	UATENDS	UZEIT	TIMS	6	0	Stage: Actual shipment end time
45	TDLNR	☐	TDLNRS	LIFNR	CHAR	10	0	Number of forwarding agent in the shipment stage	LFA1
46	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
47	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
48	FAHZT	☐	FAHZT	FAHZT	QUAN	5	2	Travelling time only between two locations
49	GESZT	☐	GESZT	FAHZT	QUAN	5	2	Total travelling time between two locations incl. breaks
50	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	*
51	LGNUMA	☐	LGNUMA	LGNUM	CHAR	3	0	Point of departure: Warehouse number	T300
52	TORA	☐	LGTORA	LGTOR	CHAR	3	0	Point of departure: Gate for warehouse number	T30B
53	ADRKNZA	☐	ADRKNZA	ADRKNZ	CHAR	1	0	Point of departure: Origin indicator of address
54	KUNABLA	☐	KUNABLA	TEXT25	CHAR	25	0	Point of departure: Customer's unloading point	KNVA
55	LGNUMZ	☐	LGNUMZ	LGNUM	CHAR	3	0	Destination: Warehouse number	T300
56	TORZ	☐	LGTORZ	LGTOR	CHAR	3	0	Destination. Gate for warehouse number	T30B
57	ADRKNZZ	☐	ADRKNZZ	ADRKNZ	CHAR	1	0	Destination: Origin indicator of address
58	KUNABLZ	☐	KUNABLZ	TEXT25	CHAR	25	0	Destination: Customer's unloading point	KNVA
59	GESZTD	☐	AB_GESZTDP	TSTRDURAG	DEC	11	0	Planned total time at stage level (in days)
60	FAHZTD	☐	AB_EFFZTDP	TSTRDURAN	DEC	11	0	Plan: Actual duration at stage level (in hours:minutes)
61	GESZTDA	☐	AB_GESZTDA	TSTRDURAG	DEC	11	0	Actual total time at stage of shipment (in days)
62	FAHZTDA	☐	AB_EFFZTDA	TSTRDURAN	DEC	11	0	Actual duration of shipment stage (in hours:minutes)
63	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
64	FRKRL	☐	FRKRL	FRKRL	CHAR	1	0	Shipment costs relevance
65	SKALSM	☐	KALSM_TRAB	KALSM	CHAR	6	0	Pricing procedure in stage of shipment	T683
66	FBSTA	☐	FBSTA	FBSTA	CHAR	1	0	Status of shipment costs calculation
67	ARSTA	☐	ARSTA	ARSTA	CHAR	1	0	Status of shipment costs settlement
68	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
69	CONT_DG	☐	ADGE_SCDG	X	CHAR	1	0	Indicator: Section contains dangerous goods
70	WARZTD	☐	AB_WARZTDP	TSTRDURAN	DEC	11	0	Planned waiting time in shipment stage (in hrs:min)
71	WARZTDA	☐	AB_WARZTDA	TSTRDURAN	DEC	11	0	Current waiting time in shipment stage (in hrs:min)
72	ABLAND1	☐	ABLAND1	LAND1	CHAR	3	0	Country of departure	T005
73	ABPSTLZ	☐	ABPSTLZ	PSTLZ	CHAR	10	0	Departure postal code
74	ABORT01	☐	ABORT01	ORT01	CHAR	35	0	Point of departure
75	EDLAND1	☐	EDLAND1	LAND1	CHAR	3	0	Destination Country	T005
76	EDPSTLZ	☐	EDPSTLZ	PSTLZ	CHAR	10	0	Destination Postal Code
77	EDORT01	☐	EDORT01	ORT01	CHAR	35	0	Destination
78	.INCLUDE	☐				0	0	Stage of Transport: Dynamic Part
79	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
80	DLNAMT	☐	DLNRNAME	NAME	CHAR	35	0	Name of the Service Agent
81	VSBEDT	☐	VSBED_BEZ	TEXT20	CHAR	20	0	Description of the shipping conditions
82	ADRNAD	☐	ADRNA	ADRNR	CHAR	10	0	Departure point: Address	*
83	ADRHNDA	☐	ADRHNDA	TEXT10	CHAR	10	0	Point of departure: Handle of an address
84	UPDADA	☐	UPDKZA	UPDKZ	CHAR	1	0	Point of departure: Update indicator of address
85	TKNOTA	☐	BEZKNOTA	TEXT30	CHAR	30	0	Description of departure point
86	TORT2A	☐	BEZKNOTA2	TEXT30	CHAR	30	0	Description of departure point - Part 2
87	PSTLZA	☐	PSTLZ_A	PSTLZ	CHAR	10	0	Departure point: Postal code
88	LAND1A	☐	LAND1_A	LAND1	CHAR	3	0	Point of departure: Country key	*
89	LZONEA	☐	LZONE_A	ZONE	CHAR	10	0	Point of departure: Transportation zone	*
90	REGIOA	☐	REGIO_A	REGIO	CHAR	3	0	Dep.point: Region (state, Federal county, province etc.)	*
91	BEZKOMPRA	☐	BEZKOMPRA	CHAR60	CHAR	60	0	Departure point: Description of location (compressed)
92	ADRNZD	☐	ADRNZ	ADRNR	CHAR	10	0	Destination address	*
93	ADRHNDZ	☐	ADRHNDZ	TEXT10	CHAR	10	0	Destination: Handle of an address
94	UPDADZ	☐	UPDKZZ	UPDKZ	CHAR	1	0	Destination: Update indicator of address
95	TKNOTZ	☐	BEZKNOTZ	TEXT30	CHAR	30	0	Description of destination point
96	TORT2Z	☐	BEZKNOTZ2	TEXT30	CHAR	30	0	Description of destination - Part 2
97	PSTLZZ	☐	PSTLZ_Z	PSTLZ	CHAR	10	0	Destination: Postal code
98	LAND1Z	☐	LAND1_Z	LAND1	CHAR	3	0	Destination: Country key	*
99	LZONEZ	☐	LZONE_Z	ZONE	CHAR	10	0	Destination: Transportation zone	*
100	REGIOZ	☐	REGIO_Z	REGIO	CHAR	3	0	Destination: Region (state, Federal county, province)	*
101	BEZKOMPRZ	☐	BEZKOMPRZ	CHAR60	CHAR	60	0	Destination: Description of Location (Compressed)
102	ADRNRDL	☐	ADRNR_SP	ADRNR	CHAR	10	0	Address no. of forwarding agent	*
103	ADRDADL	☐	ADRDA	ADRDA	CHAR	1	0	Address indicator
104	.INCLUDE	☐				0	0	Descriptions for leg
105	TSTYP_TXT	☐	TSTYP_TXT	TEXT15	CHAR	15	0	Description of stage category
106	TSTYP_ICON	☐	TSTYP_ICON	TEXT15	CHAR	15	0	Stage category, represented with an icon
107	ELUPD_TXT	☐	ELUPD_TXT	TEXT20	CHAR	20	0	Description of change indicator
108	ROUTE_TXT	☐	ROUTE_TXT	TEXT30	CHAR	30	0	Name of shipment route
109	VSART_TXT	☐	VSART_TXT	TEXT15	CHAR	15	0	Description of shipping type
110	INCO1_TXT	☐	INCO1_TXT	TEXT15	CHAR	15	0	Incoterms description for printing
111	LAUFK_TXT	☐	LAUFK_TXT	CHAR15	CHAR	15	0	Leg indicator description
112	TDLNR_TXT	☐	TDLNR_TXT	NAME	CHAR	35	0	Forwarding agent name
113	SDABW_TXT	☐	SDABW_TXT	TEXT35	CHAR	35	0	Description of special processing indicator
114	FRKRL_TXT	☐	FRKRL_TXT	TEXT40	CHAR	40	0	Description of freight costs relevance
115	SKALSM_TXT	☐	SKALSM_TXT	TEXT30	CHAR	30	0	Name of procedure for shipment stage
116	FBSTA_TXT	☐	FBSTA_TXT	TEXT30	CHAR	30	0	Status of shipment costs calculation
117	ARSTA_TXT	☐	ARSTA_TXT	TEXT30	CHAR	30	0	Status of shipment cost settlement (description)
118	BAHNRA	☐	BAHNR	BAHNR	CHAR	10	0	TrainStnNumber
119	STBNHA	☐	STBNH	XFELD	CHAR	1	0	Indicator: General cargo train station
120	EXBNHA	☐	EXBNH	XFELD	CHAR	1	0	Express train station
121	PABNHA	☐	PABNH	XFELD	CHAR	1	0	Train station used for freight transport
122	LABNHA	☐	LABNH	XFELD	CHAR	1	0	Loading train station
123	BAHNGA	☐	BAHNG	LIFNR	CHAR	10	0	Rail carrier	*
124	STREKLA	☐	STREKL	CHAR7	CHAR	7	0	Leg class for rail
125	BAHNRZ	☐	BAHNR	BAHNR	CHAR	10	0	TrainStnNumber
126	STBNHZ	☐	STBNH	XFELD	CHAR	1	0	Indicator: General cargo train station
127	EXBNHZ	☐	EXBNH	XFELD	CHAR	1	0	Express train station
128	PABNHZ	☐	PABNH	XFELD	CHAR	1	0	Train station used for freight transport
129	LABNHZ	☐	LABNH	XFELD	CHAR	1	0	Loading train station
130	BAHNGZ	☐	BAHNG	LIFNR	CHAR	10	0	Rail carrier	*
131	STREKLZ	☐	STREKL	CHAR7	CHAR	7	0	Leg class for rail
132	BAHNGA_TXT	☐	BAHNG_TXT	NAME	CHAR	35	0	Name of rail carrier
133	BAHNGZ_TXT	☐	BAHNG_TXT	NAME	CHAR	35	0	Name of rail carrier
134	LOCA_TXT	☐	BEZKOMPRA	CHAR60	CHAR	60	0	Departure point: Description of location (compressed)
135	LOCZ_TXT	☐	BEZKOMPRZ	CHAR60	CHAR	60	0	Destination: Description of Location (Compressed)
136	.INCLUDE	☐				0	0	Departure Point: Descriptions and Additonal Data
137	KNOTA_TXT	☐	KNOTE_TXT	TEXT30	CHAR	30	0	Point description
138	VSTEL_TXT	☐	VSTEL_TXT	TEXT30	CHAR	30	0	Description of shipping point
139	LSTEL_TXT	☐	LSTEL_TXT	TEXT20	CHAR	20	0	Description of loading point
140	KUNNA_TXT	☐	KUNNR_TXT	NAME	CHAR	35	0	Customer description
141	LIFNA_TXT	☐	LIFNR_TXT	NAME	CHAR	35	0	Vendor description
142	WERKA_TXT	☐	WERKS_TXT	TEXT30	CHAR	30	0	Plant description
143	LGORTA_TXT	☐	LGORT_TXT	TEXT16	CHAR	16	0	Description of storage location
144	LGNUMA_TXT	☐	LGNUM_TXT	TEXT25	CHAR	25	0	Warehouse number description
145	LGTORA_TXT	☐	LGTOR_TXT	TEXT25	CHAR	25	0	Door description
146	ADRNA_TXT	☐	ADRNR_TXT	BEZEI80	CHAR	80	0	Full details of address
147	VSLSA_TXT	☐	VSTLST_TXT	TEXT50	CHAR	50	0	Combined description of shipping point/loading point
148	WKLGA_TXT	☐	WRKLGO_TXT	TEXT50	CHAR	50	0	Combined description plant / storage location
149	LGTRA_TXT	☐	LGNTOR_TXT	TEXT50	CHAR	50	0	Concatenated description for warehouse number / gate
150	ADKNZA_TXT	☐	ADRKNZ_TXT	CHAR50	CHAR	50	0	Origin of the address
151	.INCLUDE	☐				0	0	Destination City: Descriptions and Additional Data
152	KNOTZ_TXT	☐	KNOTE_TXT	TEXT30	CHAR	30	0	Point description
153	VSTEZ_TXT	☐	VSTEL_TXT	TEXT30	CHAR	30	0	Description of shipping point
154	LSTEZ_TXT	☐	LSTEL_TXT	TEXT20	CHAR	20	0	Description of loading point
155	KUNNZ_TXT	☐	KUNNR_TXT	NAME	CHAR	35	0	Customer description
156	LIFNZ_TXT	☐	LIFNR_TXT	NAME	CHAR	35	0	Vendor description
157	WERKZ_TXT	☐	WERKS_TXT	TEXT30	CHAR	30	0	Plant description
158	LGORTZ_TXT	☐	LGORT_TXT	TEXT16	CHAR	16	0	Description of storage location
159	LGNUMZ_TXT	☐	LGNUM_TXT	TEXT25	CHAR	25	0	Warehouse number description
160	LGTORZ_TXT	☐	LGTOR_TXT	TEXT25	CHAR	25	0	Door description
161	ADRNZ_TXT	☐	ADRNR_TXT	BEZEI80	CHAR	80	0	Full details of address
162	VSLSZ_TXT	☐	VSTLST_TXT	TEXT50	CHAR	50	0	Combined description of shipping point/loading point
163	WKLGZ_TXT	☐	WRKLGO_TXT	TEXT50	CHAR	50	0	Combined description plant / storage location
164	LGTRZ_TXT	☐	LGNTOR_TXT	TEXT50	CHAR	50	0	Concatenated description for warehouse number / gate
165	ADKNZZ_TXT	☐	ADRKNZ_TXT	CHAR50	CHAR	50	0	Origin of the address
166	MARK	☐	MARKFIELD	XFIELD	CHAR	1	0	Selection indicator
167	TXT_INFO	☐	BEZEI80	BEZEI80	CHAR	80	0	Description with lenght of 80
168	SEP1	☐	SEPARATOR	XFELD	CHAR	1	0	Optical division of columns in table control
169	SEP2	☐	SEPARATOR	XFELD	CHAR	1	0	Optical division of columns in table control
170	SEP3	☐	SEPARATOR	XFELD	CHAR	1	0	Optical division of columns in table control

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in