SAP ABAP Table V_TVRAB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TVRAB	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	TVRO
3	ABNUM	☑	RABNUM	NUM4	NUMC	4	0	Stage Number
4	ANFRF	☐	ANFRF	ANFRF	NUMC	3	0	Itinerary for regular route
5	ABCAT	☐	ABCAT	ABCAT	NUMC	1	0	Route stage category
6	KNANF	☐	KNOTA	KNOTN	CHAR	10	0	Departure Point	TVKN
7	KNEND	☐	KNOTZ	KNOTN	CHAR	10	0	Destination point	TVKN
8	KNUZL	☐	KNOTU	KNOTN	CHAR	10	0	Destination of a load transfer point	TVKN
9	GESZTD	☐	GESZTD	TSTRDURAG	DEC	11	0	Total duration in calendar days
10	FAHZTD	☐	FAHZTD	TSTRDURAN	DEC	11	0	Travel duration as actual time (hours/minutes)
11	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
12	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	T006
13	TDLNR	☐	TDLNR	LIFNR	CHAR	10	0	Number of forwarding agent	LFA1
14	LAUFK	☐	LAUFK	LAUFK	CHAR	1	0	Leg Indicator
15	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
16	TSTYP	☐	TSTYP	TSTYP	CHAR	1	0	Stage category
17	SPFBK	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
18	SPZST	☐	TSTRIDSD	TSTRID	CHAR	10	0	Working time from sales view	TTSTRSD
19	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	T173
20	FRKRL	☐	FRKRL	FRKRL	CHAR	1	0	Shipment costs relevance
21	SKALSM	☐	KALSM_TRAB	KALSM	CHAR	6	0	Pricing procedure in stage of shipment	T683
22	BEZEI	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
23	OIJ_TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TVRAB	KNANF	TVKN	KNOTE	REF	C	CN
2	V_TVRAB	KNEND	TVKN	KNOTE	REF	C	CN
3	V_TVRAB	KNUZL	TVKN	KNOTE
4	V_TVRAB	MANDT	T000	MANDT	KEY	1	CN
5	V_TVRAB	MEDST	T006	MSEHI	REF	C	CN
6	V_TVRAB	OIJ_TSYST	OIJTS	TSYST
7	V_TVRAB	ROUTE	TVRO	ROUTE	KEY	1	CN
8	V_TVRAB	SDABW	TVSAK	SDABW	REF	C	CN
9	V_TVRAB	SKALSM	T683	KALSM
10	V_TVRAB	SPFBK	TFACD	IDENT	REF	C	CN
11	V_TVRAB	SPZST	TTSTRSD	TSTREAMID
12	V_TVRAB	TDLNR	LFA1	LIFNR	REF	C	CN
13	V_TVRAB	VSART	T173	VSART	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in