SAP ABAP Table VTTS (Stage of Shipment)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTTS	Table Relationship Diagram
Short Description	Stage 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	TKNUM	☑	TKNUM	TKNUM	CHAR	10	0	Shipment Number	VTTK
3	TSNUM	☑	TSNUM	TSNUM	NUMC	4	0	Stage of transport number
4	TSTYP	☐	TSTYP	TSTYP	CHAR	1	0	Stage category
5	TSRFO	☐	TSRFO	TSRFO	NUMC	4	0	Stage of transport sequence
6	ELUPD	☐	ELUPD	ELUPD	CHAR	1	0	Change Indicator
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
13	ROUTE	☐	ROUTES	ROUTE	CHAR	6	0	Route for shipment stage	TVRO
14	VSART	☐	VERSARTS	VERSART	CHAR	2	0	Shipping type for shipment stage	T173
15	INCO1	☐	INCO1VTTS	INCO1	CHAR	3	0	Incoterms for printout	TINC
16	LAUFK	☐	LAUFS	LAUFK	CHAR	1	0	Leg indicator for shipment stage
17	ADRNA	☐	ADRNA	ADRNR	CHAR	10	0	Departure point: Address	*
18	KNOTA	☐	KNOTA	KNOTN	CHAR	10	0	Departure Point	TVKN
19	VSTEL	☐	VSTELA	VSTEL	CHAR	4	0	Shipping point at point of departure	TVST
20	LSTEL	☐	LSTELA	LSTEL	CHAR	2	0	Point of departure: Loading point at shipping point	TVLA
21	WERKA	☐	WERKSA	WERKS	CHAR	4	0	Plant at point of departure	T001W
22	LGORTA	☐	LGORTA	LGORT	CHAR	4	0	Departure point: Storage location in plant	T001L
23	KUNNA	☐	KUNNA	KUNNR	CHAR	10	0	Departure point: Customer	KNA1
24	LIFNA	☐	LIFNA	LIFNR	CHAR	10	0	Vendor number of departure point	LFA1
25	BELAD	☐	BELAD	TEXT25	CHAR	25	0	Point of departure: Additional info (e.g. loading point)
26	ADRNZ	☐	ADRNZ	ADRNR	CHAR	10	0	Destination address	*
27	KNOTZ	☐	KNOTZ	KNOTN	CHAR	10	0	Destination point	TVKN
28	VSTEZ	☐	VSTELZ	VSTEL	CHAR	4	0	Shipping point at destination	TVST
29	LSTEZ	☐	LSTELZ	LSTEL	CHAR	2	0	Destination: Loading point at shipping point	TVLA
30	WERKZ	☐	WERKSZ	WERKS	CHAR	4	0	Plant at destination point	T001W
31	LGORTZ	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	T001L
32	KUNNZ	☐	KUNNZ	KUNNR	CHAR	10	0	Customer number for destination point	KNA1
33	LIFNZ	☐	LIFNZ	LIFNR	CHAR	10	0	Vendor number of destination point	LFA1
34	ABLAD	☐	ABLADZ	TEXT25	CHAR	25	0	Destination: Additional information (e.g. unloading point)
35	DPTBG	☐	DPTBGS	DATUM	DATS	8	0	Stage: Planned date for start of shipment
36	UPTBG	☐	UPTBGS	UZEIT	TIMS	6	0	Stage: Planned shipment start time
37	DATBG	☐	DATBGS	DATUM	DATS	8	0	Stage: Current date for start of shipment
38	UATBG	☐	UATBGS	UZEIT	TIMS	6	0	Stage: Current shipment start time
39	DPTEN	☐	DPTENS	DATUM	DATS	8	0	Stage: Planned date for end of shipment
40	UPTEN	☐	UPTENS	UZEIT	TIMS	6	0	Stage: Planned shipemnt end time
41	DATEN	☐	DATENDS	DATUM	DATS	8	0	Stage: Actual Date for End of Shipment
42	UATEN	☐	UATENDS	UZEIT	TIMS	6	0	Stage: Actual shipment end time
43	TDLNR	☐	TDLNRS	LIFNR	CHAR	10	0	Number of forwarding agent in the shipment stage	LFA1
44	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
45	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
46	FAHZT	☐	FAHZT	FAHZT	QUAN	5	2	Travelling time only between two locations
47	GESZT	☐	GESZT	FAHZT	QUAN	5	2	Total travelling time between two locations incl. breaks
48	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	*
49	LGNUMA	☐	LGNUMA	LGNUM	CHAR	3	0	Point of departure: Warehouse number	T300
50	TORA	☐	LGTORA	LGTOR	CHAR	3	0	Point of departure: Gate for warehouse number	T30B
51	ADRKNZA	☐	ADRKNZA	ADRKNZ	CHAR	1	0	Point of departure: Origin indicator of address
52	KUNABLA	☐	KUNABLA	TEXT25	CHAR	25	0	Point of departure: Customer's unloading point	KNVA
53	LGNUMZ	☐	LGNUMZ	LGNUM	CHAR	3	0	Destination: Warehouse number	T300
54	TORZ	☐	LGTORZ	LGTOR	CHAR	3	0	Destination. Gate for warehouse number	T30B
55	ADRKNZZ	☐	ADRKNZZ	ADRKNZ	CHAR	1	0	Destination: Origin indicator of address
56	KUNABLZ	☐	KUNABLZ	TEXT25	CHAR	25	0	Destination: Customer's unloading point	KNVA
57	GESZTD	☐	AB_GESZTDP	TSTRDURAG	DEC	11	0	Planned total time at stage level (in days)
58	FAHZTD	☐	AB_EFFZTDP	TSTRDURAN	DEC	11	0	Plan: Actual duration at stage level (in hours:minutes)
59	GESZTDA	☐	AB_GESZTDA	TSTRDURAG	DEC	11	0	Actual total time at stage of shipment (in days)
60	FAHZTDA	☐	AB_EFFZTDA	TSTRDURAN	DEC	11	0	Actual duration of shipment stage (in hours:minutes)
61	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
62	FRKRL	☐	FRKRL	FRKRL	CHAR	1	0	Shipment costs relevance
63	SKALSM	☐	KALSM_TRAB	KALSM	CHAR	6	0	Pricing procedure in stage of shipment	T683
64	FBSTA	☐	FBSTA	FBSTA	CHAR	1	0	Status of shipment costs calculation
65	ARSTA	☐	ARSTA	ARSTA	CHAR	1	0	Status of shipment costs settlement
66	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
67	CONT_DG	☐	ADGE_SCDG	X	CHAR	1	0	Indicator: Section contains dangerous goods
68	WARZTD	☐	AB_WARZTDP	TSTRDURAN	DEC	11	0	Planned waiting time in shipment stage (in hrs:min)
69	WARZTDA	☐	AB_WARZTDA	TSTRDURAN	DEC	11	0	Current waiting time in shipment stage (in hrs:min)
70	ABLAND1	☐	ABLAND1	LAND1	CHAR	3	0	Country of departure	T005
71	ABPSTLZ	☐	ABPSTLZ	PSTLZ	CHAR	10	0	Departure postal code
72	ABORT01	☐	ABORT01	ORT01	CHAR	35	0	Point of departure
73	EDLAND1	☐	EDLAND1	LAND1	CHAR	3	0	Destination Country	T005
74	EDPSTLZ	☐	EDPSTLZ	PSTLZ	CHAR	10	0	Destination Postal Code
75	EDORT01	☐	EDORT01	ORT01	CHAR	35	0	Destination

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in