SAP ABAP Table JRTTROUTE (IS-M/SD: Daily Truck Routes)

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	JRTTROUTE	Table Relationship Diagram
Short Description	IS-M/SD: Daily Truck Routes

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	JRTROUTE
3	DISPODAT	☑	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
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: Combination of Actual Data on Daily Truck Route
42	ISTARTZ	☐	ISTARTZT	DAUERSTD4	TIMS	6	0	Actual Truck Route Starting Time
43	XISTARTVT	☐	XISTARTVT	XFELD	CHAR	1	0	Actual starting time on day before planning
44	XISTARTAT	☐	XISTARTAT	XFELD	CHAR	1	0	Actual starting time on planning date
45	XISTARTFT	☐	XISTARTFT	XFELD	CHAR	1	0	Actual starting time on day after planning
46	IFAHRTDA	☐	IFAHRTDA	DAUERSTD99	CHAR	4	0	Actual Run Time for Truck Route
47	ILASTEINH	☐	ILASTEINH	MEINS	UNIT	3	0	Unit of Measure for Actual Loaded Running Distance	T006
48	ILASTENTF	☐	ILASTENTF	ISPMNG13	QUAN	13	3	Actual Loaded Running Distance for Truck Route
49	ILEEREINH	☐	ILEEREINH	MEINS	UNIT	3	0	Unit of Measure for Actual Empty Running Distance	T006
50	ILEERENTF	☐	ILEERENTF	ISPMNG13	QUAN	13	3	Actual Empty Running Distance for Truck Route
51	IANKUNFTZ	☐	IANKUNFTZ	DAUERSTD4	TIMS	6	0	Actual Arrival Time for Truck Route (at First Load./Unl.Pt)
52	XIANK1VT	☐	XIANK1VT	XFELD	CHAR	1	0	Actual arrival (at first point) on day before planning
53	XIANK1AT	☐	XIANK1AT	XFELD	CHAR	1	0	Actual arrival (at first point) on planning date
54	XIANK1FT	☐	XIANK1FT	XFELD	CHAR	1	0	Actual arrival (at first point) on day after planning
55	IANKUNFLT	☐	IANKUNFLT	DAUERSTD4	TIMS	6	0	Actual Arrival Time for Truck Route (at Last Loading/Unl.Pt)
56	XIANKLAVT	☐	XIANKLAVT	XFELD	CHAR	1	0	Actual arrival (at last point) on day before planning
57	XIANKLAAT	☐	XIANKLAAT	XFELD	CHAR	1	0	Actual arrival (at last point) on planning date
58	XIANKLAFT	☐	XIANKLAFT	XFELD	CHAR	1	0	Actual arrival (at last point) on day after planning
59	IRKZEIT	☐	IRKZEIT	DAUERSTD4	TIMS	6	0	Actual Return Time of Truck Route (to Loading Point)
60	XIRKZVT	☐	XIRKZVT	XFELD	CHAR	1	0	Actual return time on day before planning
61	XIRKZAT	☐	XIRKZAT	XFELD	CHAR	1	0	Actual return time on planning date
62	XIRKZFT	☐	XIRKZFT	XFELD	CHAR	1	0	Actual return on day after planning
63	IBEREITZT	☐	IBEREITZT	DAUERSTD4	TIMS	6	0	Actual Standby Time for Truck Route
64	XIBERZVT	☐	XPLBERZVT	XFELD	CHAR	1	0	Time specified refers to day before planning
65	XIBERZAT	☐	XPLBERZAT	XFELD	CHAR	1	0	Time specified refers to circulation planning date
66	XIBERZFT	☐	XPLBERZFT	XFELD	CHAR	1	0	Time specified refers to day after planning
67	IBELADEDA	☐	IBELADEDA	DAUERSTD99	CHAR	4	0	Actual Loading Time for Truck Route
68	.INCLUDE	☐				0	0	IS-M/SD: Truck Route Mast.Data - Daily Truck Route (Part 2)
69	GEWICHTKL	☐	GEWICHTKL	GEWICHTKL	CHAR	2	0	Weight Class	TJR31
70	ENTFERNKAT	☐	ENTFERNKAT	ENTFERNKAT	CHAR	2	0	Distance Category (for Settlement)	TJR33
71	SCHLKAT	☐	SCHLKAT	SCHLKAT	CHAR	2	0	Key category (for settlement)	TJR35
72	ROUKATE1	☐	ROUKATE1	ROUKATE1	CHAR	2	0	IS-M: Truck route settlement category type 1	TJR21
73	ROUKATE2	☐	ROUKATE2	ROUKATE2	CHAR	2	0	IS-M: Truck route settlement category 2	TJR23
74	ROUKATE3	☐	ROUKATE3	ROUKATE3	CHAR	2	0	IS-M: Truck route settlement category type 3	TJR25
75	ROUKATE4	☐	ROUKATE4	ROUKATE4	CHAR	2	0	IS-M: Truck route settlement category type 4	TJR27
76	ROUKATE5	☐	ROUKATE5	ROUKATE5	CHAR	2	0	IS-M: Truck route category type 5	TJR29
77	PREIS	☐	ROUTPREIS	ISPWV112	CURR	13	2	Truck route price (for statistical purposes)
78	WAEHRUNG	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
79	.INCLUDE	☐				0	0	IS-M/SD: Truck Route Master Data - Daily Truck Route Part 3
80	XKONDUEB	☐	XKONDUEB	XFELD	CHAR	1	0	Copy conditions for split route
81	XPAPIERDRK	☐	XPAPIERDRK	XFELD	CHAR	1	0	Print shipping documents for truck route split
82	LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
83	LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
84	FKALENDID	☐	FKALENDIDR	WFCID	CHAR	2	0	Factory Calendar for Truck Route Generation	TFACD
85	PERREGEL	☐	PERREGEL	PERREGEL	CHAR	5	0	Frequency rule	TJD03
86	GRUND	☐	KFZAWGRUND	KFZAWGRUND	CHAR	2	0	IS-M: Reason for Alternative Vehicle	TJR41
87	IVKMITART	☐	IVRKMITART	VERKMITART	CHAR	3	0	Actual Vehicle	TJR39
88	WARTEDAUER	☐	IWARTEDAUR	DAUERSTD99	CHAR	4	0	Actual Waiting Time
89	LADHILFDA	☐	ILADHILFDA	DAUERSTD99	CHAR	4	0	Actual Time for Loading Assistant
90	XGENMASCH	☐	XGENMASCH	XFELD	CHAR	1	0	Indicator: Object generated automatically
91	XISTERF	☐	XISTERF	XFELD	CHAR	1	0	Actual data recorded for truck route
92	.INCLUDE	☐				0	0	Created-by data (maximum version)
93	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
94	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
95	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
96	ERFPROG	☐	ERFPROG	PROGRAMM	CHAR	40	0	Program Used to Create Object	*
97	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
98	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
99	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
100	AENPROG	☐	AENPROG	PROGRAMM	CHAR	40	0	Program that Made Last Change	*
101	EPERDATUM	☐	EPERDATUM	DATUM	DATS	8	0	IS-M: Starting Date of Individual Period
102	.INCLUDE	☐				0	0	IS-PSD: INCLUDE Structure - Printer Parameters for Gen.SDoc.
103	VSPSOFORTD	☐	J_VSPIMMED	XFELD	CHAR	1	0	Print out Shipping Documents Immediately
104	VSPLOESCHN	☐	J_VSPDELET	XFELD	CHAR	1	0	Delete Shipping Documents After Printing
105	VSPVERWDAU	☐	J_VSPLIFET	SYNUM01	NUMC	1	0	Shipping Document Retention Period in Spool
106	VSPSAPDECK	☐	J_VSPPRSAP	SYCHAR01	CHAR	1	0	Print: SAP cover sheet
107	VSPDECKTXT	☐	J_VSPPRTXT	SYCHAR68K	CHAR	68	0	Print: Text for cover sheet
108	VSPDECKEMP	☐	J_VSPPRREC	SYCHAR12	CHAR	12	0	Print: Recipient
109	VSPDECKABT	☐	J_VSPPRABT	SYCHAR12K	CHAR	12	0	Print: Department on cover sheet
110	VSPDECKBER	☐	J_VSPPRBER	SYCHAR12	CHAR	12	0	Print: Authorization
111	VSPARCHMOD	☐	J_VSPARMOD	SYARMOD	CHAR	1	0	Print: Archiving mode
112	ROUTENTYP	☐	ROUTENTYP	ROUTENTYP	CHAR	1	0	IS-M: Truck route category
113	SPLITT_JA	☐	SPLITT_JA	SPLITT_JA	CHAR	1	0	IS-M: Split indicator for truck route split
114	.INCLUDE	☐				0	0	IS-M/SD: Planned Truck Route Date for Truck Route Times
115	PBEREITD	☐	PBEREITD	DATUM	DATS	8	0	IS-M: Planned truck route availability date
116	PSTARTD	☐	PSTARTD	DATUM	DATS	8	0	IS-M: Planned start date for truck route
117	PANKUNFTD	☐	PANKUNFTD	DATUM	DATS	8	0	IS-M: Planned arrival date of truck route
118	PANKBEABD	☐	PANKBEABD	DATUM	DATS	8	0	IS-M: Planned arr.date of truck route at last loading/unl.pt
119	PRUECKD	☐	PRUECKD	DATUM	DATS	8	0	IS-M: Planned return date for truck route
120	.INCLUDE	☐				0	0	IS-M/SD: Actual Truck Route Date for Truck Route Times
121	IBEREITD	☐	IBEREITD	DATUM	DATS	8	0	IS-M: Actual Standby Date for Truck Route
122	ISTARTD	☐	ISTARTD	DATUM	DATS	8	0	IS-M: Actual Truck Route Starting Date
123	IANKUNFTD	☐	IANKUNFTD	DATUM	DATS	8	0	IS-M: Actual Arrival Date for Truck Route
124	IANKBEABD	☐	IANKBEABD	DATUM	DATS	8	0	IS-M: Actual Arrival Date at Last Loading/Unloading Point
125	IRUECKD	☐	IRUECKD	DATUM	DATS	8	0	IS-M: Actual Return Date of Truck Route
126	BASISROUTE	☐	ISPROUTE	ISPROUTE	CHAR	6	0	Truck Route - Media	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in