SAP ABAP Table JRTROUTE (IS-M/SD: Truck Route Master Data)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JRTROUTE	Table Relationship Diagram
Short Description	IS-M/SD: Truck Route Master Data

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	ROUTE	☑	ISPROUTE	ISPROUTE	CHAR	6	0	Truck Route - Media
3	ROUTENTYP	☐	ROUTENTYP	ROUTENTYP	CHAR	1	0	IS-M: Truck route category
4	.INCLUDE	☐				0	0	IS-M: Short and Long Texts
5	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
6	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
7	.INCLUDE	☐				0	0	IS-M/SD: Truck Route Mast.Data - Daily Truck Route (Part 1)
8	ROUTART	☐	ROUTART	ROUTART	CHAR	2	0	Truck route type	TJR01
9	PLSTARTZ	☐	PLSTARTZT	DAUERSTD4	TIMS	6	0	Planned starting time of truck route
10	BELADEST	☐	BELADST	BEABLST	CHAR	10	0	IS-M: Loading Point at Plant	JRTBEABST
11	BEZRUNDE	☐	JRUNDE_R	BEZRUNDE	CHAR	10	0	IS-M: Delivery round covered by truck route	JVTRUNDE
12	XPLSTARTVT	☐	XPLSTARTVT	XFELD	CHAR	1	0	Planned start time on day before shipping date
13	XPLSTARTAT	☐	XPLSTARTAT	XFELD	CHAR	1	0	Planned start on planning date
14	XPLSTARTFT	☐	XPLSTARTFT	XFELD	CHAR	1	0	Planned start on day after planning
15	PLFAHRTDA	☐	PLFAHRTDA	DAUERSTD99	CHAR	4	0	Planned duration of truck route
16	PLLASTEINH	☐	PLLASTEINH	MEINS	UNIT	3	0	Unit of measure for planned loaded running distance	T006
17	PLLASTENTF	☐	PLLASTENTF	ISPMNG13	QUAN	13	3	Planned loaded running distance for truck route
18	PLLEEREINH	☐	PLLEEREINH	MEINS	UNIT	3	0	Unit of measure for planned empty running distance	T006
19	PLLEERENTF	☐	PLLEERENTF	ISPMNG13	QUAN	13	3	Planned empty running distance
20	PLANKUNFTZ	☐	PLANKUNFTZ	DAUERSTD4	TIMS	6	0	Planned arrival time for truck route (first loading/unl.pt)
21	XPLANK1VT	☐	XPLANK1VT	XFELD	CHAR	1	0	Planned arrival (1st position) on day before circ.planning
22	XPLANK1AT	☐	XPLANK1AT	XFELD	CHAR	1	0	Planned arrival (1st position) on date of circ.planning
23	XPLANK1FT	☐	XPLANK1FT	XFELD	CHAR	1	0	Planned arrival (1st position) on day after circ.planning
24	PLANKUNFLT	☐	PLANKUNFLT	DAUERSTD4	TIMS	6	0	Planned arrival time for truck route (last loading/unl.pt)
25	XPLANKLAVT	☐	XPLANKLAVT	XFELD	CHAR	1	0	Planned arrival (last position) on day before circ.planning
26	XPLANKLAAT	☐	XPLANKLAAT	XFELD	CHAR	1	0	Planned arrival (last position) on date of circ.planning
27	XPLANKLAFT	☐	XPLANKLAFT	XFELD	CHAR	1	0	Planned arrival (last position) on day after circ.planning
28	PLRKZEIT	☐	PLRKZEIT	DAUERSTD4	TIMS	6	0	Planned return time of truck route (loading point)
29	XPLRKZVT	☐	XPLRKZVT	XFELD	CHAR	1	0	Planned return on day before planning
30	XPLRKZAT	☐	XPLRKZAT	XFELD	CHAR	1	0	Planned return on planning day
31	XPLRKZFT	☐	XPLRKZFT	XFELD	CHAR	1	0	Planned return on day after planning
32	PLBEREITZT	☐	PLBEREITZT	DAUERSTD4	TIMS	6	0	Planned Standby Time for Truck Route
33	XPLBERZVT	☐	XPLBERZVT	XFELD	CHAR	1	0	Time specified refers to day before planning
34	XPLBERZAT	☐	XPLBERZAT	XFELD	CHAR	1	0	Time specified refers to circulation planning date
35	XPLBERZFT	☐	XPLBERZFT	XFELD	CHAR	1	0	Time specified refers to day after planning
36	PLBELADEDA	☐	PLBELADEDA	DAUERSTD99	CHAR	4	0	Planned loading time for truck route
37	RSUCHFELD	☐	RSUCHFELD	CHAR20	CHAR	20	0	IS-M: Search field for truck route
38	HAUPTROUTE	☐	HAUPTROUTE	ISPROUTE	CHAR	6	0	IS-M: (Caution: do not use this field)	JRTROUTE
39	BELA_UTOUR	☐	BELA_UTOUR	BEABLST	CHAR	10	0	IS-M: Caution - do not use this field	JRTBEABST
40	XRABLFOLGE	☐	XRABLFOLGE	XFELD	CHAR	1	0	IS-M: Serve unloading point sequence in opposite direction
41	.INCLUDE	☐				0	0	IS-M/SD: Truck Route Mast.Data - Daily Truck Route (Part 2)
42	GEWICHTKL	☐	GEWICHTKL	GEWICHTKL	CHAR	2	0	Weight Class	TJR31
43	ENTFERNKAT	☐	ENTFERNKAT	ENTFERNKAT	CHAR	2	0	Distance Category (for Settlement)	TJR33
44	SCHLKAT	☐	SCHLKAT	SCHLKAT	CHAR	2	0	Key category (for settlement)	TJR35
45	ROUKATE1	☐	ROUKATE1	ROUKATE1	CHAR	2	0	IS-M: Truck route settlement category type 1	TJR21
46	ROUKATE2	☐	ROUKATE2	ROUKATE2	CHAR	2	0	IS-M: Truck route settlement category 2	TJR23
47	ROUKATE3	☐	ROUKATE3	ROUKATE3	CHAR	2	0	IS-M: Truck route settlement category type 3	TJR25
48	ROUKATE4	☐	ROUKATE4	ROUKATE4	CHAR	2	0	IS-M: Truck route settlement category type 4	TJR27
49	ROUKATE5	☐	ROUKATE5	ROUKATE5	CHAR	2	0	IS-M: Truck route category type 5	TJR29
50	PREIS	☐	ROUTPREIS	ISPWV112	CURR	13	2	Truck route price (for statistical purposes)
51	WAEHRUNG	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
52	.INCLUDE	☐				0	0	IS-M/SD: Truck Route Master Data - Daily Truck Route Part 3
53	XKONDUEB	☐	XKONDUEB	XFELD	CHAR	1	0	Copy conditions for split route
54	XPAPIERDRK	☐	XPAPIERDRK	XFELD	CHAR	1	0	Print shipping documents for truck route split
55	LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
56	LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
57	FKALENDID	☐	FKALENDIDR	WFCID	CHAR	2	0	Factory Calendar for Truck Route Generation	TFACD
58	PERREGEL	☐	PERREGEL	PERREGEL	CHAR	5	0	Frequency rule	TJD03
59	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
60	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
61	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
62	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
63	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
64	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
65	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
66	.INCLUDE	☐				0	0	IS-PSD: INCLUDE Structure - Printer Parameters for Gen.SDoc.
67	VSPSOFORTD	☐	J_VSPIMMED	XFELD	CHAR	1	0	Print out Shipping Documents Immediately
68	VSPLOESCHN	☐	J_VSPDELET	XFELD	CHAR	1	0	Delete Shipping Documents After Printing
69	VSPVERWDAU	☐	J_VSPLIFET	SYNUM01	NUMC	1	0	Shipping Document Retention Period in Spool
70	VSPSAPDECK	☐	J_VSPPRSAP	SYCHAR01	CHAR	1	0	Print: SAP cover sheet
71	VSPDECKTXT	☐	J_VSPPRTXT	SYCHAR68K	CHAR	68	0	Print: Text for cover sheet
72	VSPDECKEMP	☐	J_VSPPRREC	SYCHAR12	CHAR	12	0	Print: Recipient
73	VSPDECKABT	☐	J_VSPPRABT	SYCHAR12K	CHAR	12	0	Print: Department on cover sheet
74	VSPDECKBER	☐	J_VSPPRBER	SYCHAR12	CHAR	12	0	Print: Authorization
75	VSPARCHMOD	☐	J_VSPARMOD	SYARMOD	CHAR	1	0	Print: Archiving mode
76	.INCLUDE	☐				0	0	IS-M/SD: Planned Truck Route Date for Truck Route Times
77	PBEREITD	☐	PBEREITD	DATUM	DATS	8	0	IS-M: Planned truck route availability date
78	PSTARTD	☐	PSTARTD	DATUM	DATS	8	0	IS-M: Planned start date for truck route
79	PANKUNFTD	☐	PANKUNFTD	DATUM	DATS	8	0	IS-M: Planned arrival date of truck route
80	PANKBEABD	☐	PANKBEABD	DATUM	DATS	8	0	IS-M: Planned arr.date of truck route at last loading/unl.pt
81	PRUECKD	☐	PRUECKD	DATUM	DATS	8	0	IS-M: Planned return date for truck route
82	.INCLUDE	☐				0	0	IS-M/SD: Actual Truck Route Date for Truck Route Times
83	IBEREITD	☐	IBEREITD	DATUM	DATS	8	0	IS-M: Actual Standby Date for Truck Route
84	ISTARTD	☐	ISTARTD	DATUM	DATS	8	0	IS-M: Actual Truck Route Starting Date
85	IANKUNFTD	☐	IANKUNFTD	DATUM	DATS	8	0	IS-M: Actual Arrival Date for Truck Route
86	IANKBEABD	☐	IANKBEABD	DATUM	DATS	8	0	IS-M: Actual Arrival Date at Last Loading/Unloading Point
87	IRUECKD	☐	IRUECKD	DATUM	DATS	8	0	IS-M: Actual Return Date of Truck Route
88	PREISAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
89	VERKMITART	☐	VKMITARTVB	VERKMITART	CHAR	3	0	Vehicle	TJR39

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JRTROUTE	BELADEST	JRTBEABST	BEABLST	KEY	1	CN
2	JRTROUTE	BELA_UTOUR	JRTBEABST	BEABLST
3	JRTROUTE	BEZRUNDE	JVTRUNDE	RUNDE		1	CN
4	JRTROUTE	ENTFERNKAT	TJR33	ENTFERNKAT	REF	C	CN
5	JRTROUTE	FKALENDID	TFACD	IDENT	REF	1	CN
6	JRTROUTE	GEWICHTKL	TJR31	GEWICHTKL	REF	C	CN
7	JRTROUTE	HAUPTROUTE	JRTROUTE	ROUTE
8	JRTROUTE	MANDT	T000	MANDT	KEY	1	CN
9	JRTROUTE	PERREGEL	TJD03	PERREGEL	REF	1	CN
10	JRTROUTE	PLLASTEINH	T006	MSEHI	REF	C	CN
11	JRTROUTE	PLLEEREINH	T006	MSEHI	REF	C	CN
12	JRTROUTE	ROUKATE1	TJR21	ROUKATE1	REF	C	CN
13	JRTROUTE	ROUKATE2	TJR23	ROUKATE2	REF	C	CN
14	JRTROUTE	ROUKATE3	TJR25	ROUKATE3	REF	C	CN
15	JRTROUTE	ROUKATE4	TJR27	ROUKATE4	REF	C	CN
16	JRTROUTE	ROUKATE5	TJR29	ROUKATE5	REF	C	CN
17	JRTROUTE	ROUTART	TJR01	ROUTART	REF	1	CN
18	JRTROUTE	SCHLKAT	TJR35	SCHLKAT	REF	C	CN
19	JRTROUTE	VERKMITART	TJR39	VERKMITART	KEY	1	CN
20	JRTROUTE	WAEHRUNG	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in