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

Dictionary Type: Table
Description: IS-M/SD: Truck Route Master Data




ABAP Code to SELECT data from JRTROUTE
Related tables to JRTROUTE
Access table JRTROUTE




Table field list including key, data, relationships and ABAP select examples

JRTROUTE is a standard SAP Table which is used to store IS-M/SD: Truck Route Master Data data and is available within R/3 SAP systems depending on the version and release level.

The JRTROUTE table consists of various fields, each holding specific information or linking keys about IS-M/SD: Truck Route Master Data data available in SAP. These include ROUTE (Truck Route - Media), ROUTENTYP (IS-M: Truck route category), KURZTEXT (IS-M: Short Text), LANGTEXT (IS-M: Long Text).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP JRTROUTE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ROUTETruck Route - Media ISPROUTECHAR6ALPHAISPROUTEROU
ROUTENTYPIS-M: Truck route category ROUTENTYPCHAR1ROUTENTYP
KURZTEXTIS-M: Short Text BEZEICHN15CHAR15TEXT15
LANGTEXTIS-M: Long Text BEZEICHN50CHAR50TEXT50
ROUTARTTruck route type ROUTARTCHAR2TJR01ROUTART
PLSTARTZPlanned starting time of truck route PLSTARTZTTIMS6DAUERSTD4
BELADESTIS-M: Loading Point at Plant BELADSTCHAR10JRTBEABSTALPHABEABLST
BEZRUNDEIS-M: Delivery round covered by truck route JRUNDE_RCHAR10JVTRUNDEALPHABEZRUNDE
XPLSTARTVTPlanned start time on day before shipping date XPLSTARTVTCHAR1XFELD
XPLSTARTATPlanned start on planning date XPLSTARTATCHAR1XFELD
XPLSTARTFTPlanned start on day after planning XPLSTARTFTCHAR1XFELD
PLFAHRTDAPlanned duration of truck route PLFAHRTDACHAR4DAUERSTD99
PLLASTEINHUnit of measure for planned loaded running distance PLLASTEINHUNIT3T006CUNITMEINS
PLLASTENTFPlanned loaded running distance for truck route PLLASTENTFQUAN13(3) ISPMNG13
PLLEEREINHUnit of measure for planned empty running distance PLLEEREINHUNIT3T006CUNITMEINS
PLLEERENTFPlanned empty running distance PLLEERENTFQUAN13(3) ISPMNG13
PLANKUNFTZPlanned arrival time for truck route (first loading/unl.pt) PLANKUNFTZTIMS6DAUERSTD4
XPLANK1VTPlanned arrival (1st position) on day before circ.planning XPLANK1VTCHAR1XFELD
XPLANK1ATPlanned arrival (1st position) on date of circ.planning XPLANK1ATCHAR1XFELD
XPLANK1FTPlanned arrival (1st position) on day after circ.planning XPLANK1FTCHAR1XFELD
PLANKUNFLTPlanned arrival time for truck route (last loading/unl.pt) PLANKUNFLTTIMS6DAUERSTD4
XPLANKLAVTPlanned arrival (last position) on day before circ.planning XPLANKLAVTCHAR1XFELD
XPLANKLAATPlanned arrival (last position) on date of circ.planning XPLANKLAATCHAR1XFELD
XPLANKLAFTPlanned arrival (last position) on day after circ.planning XPLANKLAFTCHAR1XFELD
PLRKZEITPlanned return time of truck route (loading point) PLRKZEITTIMS6DAUERSTD4
XPLRKZVTPlanned return on day before planning XPLRKZVTCHAR1XFELD
XPLRKZATPlanned return on planning day XPLRKZATCHAR1XFELD
XPLRKZFTPlanned return on day after planning XPLRKZFTCHAR1XFELD
PLBEREITZTPlanned Standby Time for Truck Route PLBEREITZTTIMS6DAUERSTD4
XPLBERZVTTime specified refers to day before planning XPLBERZVTCHAR1XFELD
XPLBERZATTime specified refers to circulation planning date XPLBERZATCHAR1XFELD
XPLBERZFTTime specified refers to day after planning XPLBERZFTCHAR1XFELD
PLBELADEDAPlanned loading time for truck route PLBELADEDACHAR4DAUERSTD99
RSUCHFELDIS-M: Search field for truck route RSUCHFELDCHAR20CHAR20
HAUPTROUTEIS-M: (Caution: do not use this field) HAUPTROUTECHAR6JRTROUTEALPHAISPROUTE
BELA_UTOURIS-M: Caution - do not use this field BELA_UTOURCHAR10JRTBEABSTALPHABEABLST
XRABLFOLGEIS-M: Serve unloading point sequence in opposite direction XRABLFOLGECHAR1XFELD
GEWICHTKLWeight Class GEWICHTKLCHAR2TJR31GEWICHTKL
ENTFERNKATDistance Category (for Settlement) ENTFERNKATCHAR2TJR33ENTFERNKAT
SCHLKATKey category (for settlement) SCHLKATCHAR2TJR35SCHLKAT
ROUKATE1IS-M: Truck route settlement category type 1 ROUKATE1CHAR2TJR21ROUKATE1
ROUKATE2IS-M: Truck route settlement category 2 ROUKATE2CHAR2TJR23ROUKATE2
ROUKATE3IS-M: Truck route settlement category type 3 ROUKATE3CHAR2TJR25ROUKATE3
ROUKATE4IS-M: Truck route settlement category type 4 ROUKATE4CHAR2TJR27ROUKATE4
ROUKATE5IS-M: Truck route category type 5 ROUKATE5CHAR2TJR29ROUKATE5
PREISTruck route price (for statistical purposes) ROUTPREISCURR13(2) ISPWV112
WAEHRUNGCurrency Key WAERSCUKY5TCURCWAERSFWS
XKONDUEBCopy conditions for split route XKONDUEBCHAR1XFELD
XPAPIERDRKPrint shipping documents for truck route split XPAPIERDRKCHAR1XFELD
LOEVMDeletion Flag for Master Data in Media Sales & Distribution LOEVM_ISPCHAR1XFELD
LOEKZDeletion Indicator for Master Data in Media Sales & Dist. LOEKZ_ISPCHAR1XFELD
FKALENDIDFactory Calendar for Truck Route Generation FKALENDIDRCHAR2TFACDWFCID
PERREGELFrequency rule PERREGELCHAR5TJD03ALPHAPERREGEL
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
VSPSOFORTDPrint out Shipping Documents Immediately J_VSPIMMEDCHAR1XFELD
VSPLOESCHNDelete Shipping Documents After Printing J_VSPDELETCHAR1XFELD
VSPVERWDAUShipping Document Retention Period in Spool J_VSPLIFETNUMC1SYNUM01
VSPSAPDECKPrint: SAP cover sheet J_VSPPRSAPCHAR1SYCHAR01
VSPDECKTXTPrint: Text for cover sheet J_VSPPRTXTCHAR68SYCHAR68K
VSPDECKEMPPrint: Recipient J_VSPPRRECCHAR12SYCHAR12
VSPDECKABTPrint: Department on cover sheet J_VSPPRABTCHAR12SYCHAR12K
VSPDECKBERPrint: Authorization J_VSPPRBERCHAR12SYCHAR12
VSPARCHMODPrint: Archiving mode J_VSPARMODCHAR1SYARMOD
PBEREITDIS-M: Planned truck route availability date PBEREITDDATS8DATUM
PSTARTDIS-M: Planned start date for truck route PSTARTDDATS8DATUM
PANKUNFTDIS-M: Planned arrival date of truck route PANKUNFTDDATS8DATUM
PANKBEABDIS-M: Planned arr.date of truck route at last loading/unl.pt PANKBEABDDATS8DATUM
PRUECKDIS-M: Planned return date for truck route PRUECKDDATS8DATUM
IBEREITDIS-M: Actual Standby Date for Truck Route IBEREITDDATS8DATUM
ISTARTDIS-M: Actual Truck Route Starting Date ISTARTDDATS8DATUM
IANKUNFTDIS-M: Actual Arrival Date for Truck Route IANKUNFTDDATS8DATUM
IANKBEABDIS-M: Actual Arrival Date at Last Loading/Unloading Point IANKBEABDDATS8DATUM
IRUECKDIS-M: Actual Return Date of Truck Route IRUECKDDATS8DATUM
PREISABValid-From Date GUELTIGVONDATS8DATUMJSA
VERKMITARTVehicle VKMITARTVBCHAR3TJR39VERKMITART

Key field Non-key field



How do I retrieve data from SAP table JRTROUTE using ABAP code

The following ABAP code Example will allow you to do a basic selection on JRTROUTE to SELECT all data from the table
DATA: WA_JRTROUTE TYPE JRTROUTE.

SELECT SINGLE *
FROM JRTROUTE
INTO CORRESPONDING FIELDS OF WA_JRTROUTE
WHERE...

How to access SAP table JRTROUTE

Within an ECC or HANA version of SAP you can also view further information about JRTROUTE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!