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
⤷ 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 |