SAP ABAP Table V_TVRO_COM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TVRO_COM	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	ROUTE	☑	ROUTE	ROUTE	CHAR	6	0	Route
3	BEZEI	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
4	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	T173
5	VSAVL	☐	VERSARTVL	VERSART	CHAR	2	0	Shipping type of preliminary leg	T173
6	VSANL	☐	VERSARTNL	VERSART	CHAR	2	0	Shipping type of subsequent leg	T173
7	TDLNR	☐	TDLNR	LIFNR	CHAR	10	0	Number of forwarding agent	LFA1
8	TRAZT	☐	TRAZT	DIFZT	DEC	5	2	Outdated: Transit Time from GI to Ship-to Party (in Days)
9	TRAZTD	☐	TRAZTD	TSTRDURAG	DEC	11	0	Transit duration in calendar days
10	TDVZT	☐	TDVZT	DIFZT	DEC	5	2	Outdated: Transportation-Planning Lead Time (in Days)
11	TDVZTD	☐	TDVZTD	TSTRDURAG	DEC	11	0	Transportation lead time in calendar days
12	SPFBK	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
13	ZSTID	☐	TSTRIDSD	TSTRID	CHAR	10	0	Working time from sales view	TTSTRSD
14	FAHZTD	☐	FAHZTD	TSTRDURAN	DEC	11	0	Travel duration as actual time (hours/minutes)
15	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
16	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance
17	EXPVZ	☐	EXPVZ	EXPVZ	CHAR	1	0	Mode of Transport for Foreign Trade	T618
18	TDIIX	☐	TDIIX	XFELD	CHAR	1	0	Relevance for transportation ID
19	ROUTID	☐	ROUTID	CHAR100	CHAR	100	0	Route identification
20	TDVZND	☐	TDVZND	TSTRDURAN	DEC	11	0	Transportation lead time in hours/minutes work time
21	TCTAB	☐	ADGE_TCTAB	X	CHAR	1	0	Take Table for Transit Countries into Account
22	ALLOWED_TWGT	☐	ALLOWED_TWGT	MENG12_0	QUAN	8	0	Allowed total weight of shipment
23	ALLOWED_UOM	☐	ALLOWED_UOM	MEINS	UNIT	3	0	Unit of Measurement for Allowed Total Weight of Shipment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TVRO_COM	EXPVZ	T618	EXPVZ	REF	C	CN
2	V_TVRO_COM	MANDT	T000	MANDT	KEY	1	CN
3	V_TVRO_COM	SPFBK	TFACD	IDENT	REF	C	CN
4	V_TVRO_COM	TDLNR	LFA1	LIFNR	REF	C	CN
5	V_TVRO_COM	VSANL	T173	VSART	REF	C	CN
6	V_TVRO_COM	VSART	T173	VSART	REF	C	CN
7	V_TVRO_COM	VSAVL	T173	VSART	REF	C	CN
8	V_TVRO_COM	ZSTID	TTSTRSD	TSTREAMID

History

Last changed by/on	SAP	20130529
SAP Release Created in