SAP ABAP Table VTPRL (Transportation Planning System Route Limitations)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ VTRI (Package) Interfaces to external transport systems

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTPRL	Table Relationship Diagram
Short Description	Transportation Planning System Route Limitations

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	*
2	TPLST	☑	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
3	ROUTE	☑	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
4	PRLSMA	☐	PRLSMA	PRLSM	CHAR	2	0	Substitution procedure for route limitation at route start	VTPRS
5	KNTPSA	☐	KNTPSA	KNOTN	CHAR	10	0	Point as planning start in transportation planning system	TVKN
6	PRLSME	☐	PRLSME	PRLSM	CHAR	2	0	Substitution procedure for route limitation at route end	VTPRS
7	KNTPSE	☐	KNTPSE	KNOTN	CHAR	10	0	Point at planning end in transportation planning system	TVKN
8	FZTVL	☐	FZTVL	DIFZT	DEC	5	2	Total travelling time for the preliminary leg in days
9	FZTHL	☐	FZTHL	DIFZT	DEC	5	2	Total travelling time for the main leg in days
10	FZTNL	☐	FZTNL	DIFZT	DEC	5	2	Total travelling time for the subsequent leg in days

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTPRL	KNTPSA	TVKN	KNOTE
2	VTPRL	KNTPSE	TVKN	KNOTE
3	VTPRL	PRLSMA	VTPRS	PRLSM	KEY	C	CN
4	VTPRL	PRLSME	VTPRS	PRLSM	KEY	C	CN
5	VTPRL	ROUTE	TVRO	ROUTE
6	VTPRL	TPLST	TTDS	TPLST	KEY	1	CN

History

Last changed by/on	SAP	20010122
SAP Release Created in