SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | JRTTROUTE
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JRTTROUTE1173IS-M/SD: Daily Truck RoutesPeriodical Sales and Distribution
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, ROUTE, DISPODAT, KURZTEXT, LANGTEXT, ROUTART, PLSTARTZ, BELADEST, BEZRUNDE, XPLSTARTVT, XPLSTARTAT, XPLSTARTFT, PLFAHRTDA, PLLASTEINH, PLLASTENTF, PLLEEREINH, PLLEERENTF, PLANKUNFTZ, XPLANK1VT, XPLANK1AT, XPLANK1FT, PLANKUNFLT, XPLANKLAVT, XPLANKLAAT, XPLANKLAFT, PLRKZEIT, XPLRKZVT, XPLRKZAT, XPLRKZFT, PLBEREITZT, XPLBERZVT, XPLBERZAT, XPLBERZFT, PLBELADEDA, RSUCHFELD, HAUPTROUTE, BELA_UTOUR, XRABLFOLGE, ISTARTZ, XISTARTVT, XISTARTAT, XISTARTFT, IFAHRTDA, ILASTEINH, ILASTENTF, ILEEREINH, ILEERENTF, IANKUNFTZ, XIANK1VT, XIANK1AT, XIANK1FT, IANKUNFLT, XIANKLAVT, XIANKLAAT, XIANKLAFT, IRKZEIT, XIRKZVT, XIRKZAT, XIRKZFT, IBEREITZT, XIBERZVT, XIBERZAT, XIBERZFT, IBELADEDA, GEWICHTKL, ENTFERNKAT, SCHLKAT, ROUKATE1, ROUKATE2, ROUKATE3, ROUKATE4, ROUKATE5, PREIS, WAEHRUNG, XKONDUEB, XPAPIERDRK, LOEVM, LOEKZ, FKALENDID, PERREGEL, GRUND, IVKMITART, WARTEDAUER, LADHILFDA, XGENMASCH, XISTERF, ERFUSER, ERFDATE, ERFTIME, ERFPROG, AENUSER, AENDATE, AENTIME, AENPROG, EPERDATUM, VSPSOFORTD, VSPLOESCHN, VSPVERWDAU, VSPSAPDECK, VSPDECKTXT, VSPDECKEMP, VSPDECKABT, VSPDECKBER, VSPARCHMOD, ROUTENTYP, SPLITT_JA, PBEREITD, PSTARTD, PANKUNFTD, PANKBEABD, PRUECKD, IBEREITD, ISTARTD, IANKUNFTD, IANKBEABD, IRUECKD, BASISROUTE FROM JRTTROUTE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ROUTETruck Route - Medianvarchar60CHAR(N' ')NoJRTROUTEISPROUTE Allow NULL? 
3DISPODATIS-M: Shipping Datenvarchar80DATS(N'00000000')NoVRSNDDATUM Allow NULL? 
4KURZTEXTIS-M: Short Textnvarchar150CHAR(N' ')YesBEZEICHN15 Allow NULL? 
5LANGTEXTIS-M: Long Textnvarchar500CHAR(N' ')YesBEZEICHN50 Allow NULL? 
6ROUTARTTruck route typenvarchar20CHAR(N' ')YesTJR01ROUTART Allow NULL? 
7PLSTARTZPlanned starting time of truck routenvarchar60TIMS(N'000000')YesPLSTARTZT Allow NULL? 
8BELADESTIS-M: Loading Point at Plantnvarchar100CHAR(N' ')YesJRTBEABSTBELADST Allow NULL? 
9BEZRUNDEIS-M: Delivery round covered by truck routenvarchar100CHAR(N' ')YesJVTRUNDEJRUNDE_R Allow NULL? 
10XPLSTARTVTPlanned start time on day before shipping datechar10CHAR(N' ')YesXPLSTARTVT Allow NULL? 
11XPLSTARTATPlanned start on planning datechar10CHAR(N' ')YesXPLSTARTAT Allow NULL? 
12XPLSTARTFTPlanned start on day after planningchar10CHAR(N' ')YesXPLSTARTFT Allow NULL? 
13PLFAHRTDAPlanned duration of truck routenvarchar40CHAR(N' ')YesPLFAHRTDA Allow NULL? 
14PLLASTEINHUnit of measure for planned loaded running distancenvarchar30UNIT(N' ')YesT006PLLASTEINH Allow NULL? 
15PLLASTENTFPlanned loaded running distance for truck routedecimal133QUAN((0))YesPLLASTENTF
16PLLEEREINHUnit of measure for planned empty running distancenvarchar30UNIT(N' ')YesT006PLLEEREINH Allow NULL? 
17PLLEERENTFPlanned empty running distancedecimal133QUAN((0))YesPLLEERENTF
18PLANKUNFTZPlanned arrival time for truck route (first loading/unl.pt)nvarchar60TIMS(N'000000')YesPLANKUNFTZ Allow NULL? 
19XPLANK1VTPlanned arrival (1st position) on day before circ.planningchar10CHAR(N' ')YesXPLANK1VT Allow NULL? 
20XPLANK1ATPlanned arrival (1st position) on date of circ.planningchar10CHAR(N' ')YesXPLANK1AT Allow NULL? 
21XPLANK1FTPlanned arrival (1st position) on day after circ.planningchar10CHAR(N' ')YesXPLANK1FT Allow NULL? 
22PLANKUNFLTPlanned arrival time for truck route (last loading/unl.pt)nvarchar60TIMS(N'000000')YesPLANKUNFLT Allow NULL? 
23XPLANKLAVTPlanned arrival (last position) on day before circ.planningchar10CHAR(N' ')YesXPLANKLAVT Allow NULL? 
24XPLANKLAATPlanned arrival (last position) on date of circ.planningchar10CHAR(N' ')YesXPLANKLAAT Allow NULL? 
25XPLANKLAFTPlanned arrival (last position) on day after circ.planningchar10CHAR(N' ')YesXPLANKLAFT Allow NULL? 
26PLRKZEITPlanned return time of truck route (loading point)nvarchar60TIMS(N'000000')YesPLRKZEIT Allow NULL? 
27XPLRKZVTPlanned return on day before planningchar10CHAR(N' ')YesXPLRKZVT Allow NULL? 
28XPLRKZATPlanned return on planning daychar10CHAR(N' ')YesXPLRKZAT Allow NULL? 
29XPLRKZFTPlanned return on day after planningchar10CHAR(N' ')YesXPLRKZFT Allow NULL? 
30PLBEREITZTPlanned Standby Time for Truck Routenvarchar60TIMS(N'000000')YesPLBEREITZT Allow NULL? 
31XPLBERZVTTime specified refers to day before planningchar10CHAR(N' ')YesXPLBERZVT Allow NULL? 
32XPLBERZATTime specified refers to circulation planning datechar10CHAR(N' ')YesXPLBERZAT Allow NULL? 
33XPLBERZFTTime specified refers to day after planningchar10CHAR(N' ')YesXPLBERZFT Allow NULL? 
34PLBELADEDAPlanned loading time for truck routenvarchar40CHAR(N' ')YesPLBELADEDA Allow NULL? 
35RSUCHFELDIS-M: Search field for truck routenvarchar200CHAR(N' ')YesRSUCHFELD Allow NULL? 
36HAUPTROUTEIS-M: (Caution: do not use this field)nvarchar60CHAR(N' ')YesJRTROUTEHAUPTROUTE Allow NULL? 
37BELA_UTOURIS-M: Caution - do not use this fieldnvarchar100CHAR(N' ')YesJRTBEABSTBELA_UTOUR Allow NULL? 
38XRABLFOLGEIS-M: Serve unloading point sequence in opposite directionchar10CHAR(N' ')YesXRABLFOLGE Allow NULL? 
39ISTARTZActual Truck Route Starting Timenvarchar60TIMS(N'000000')YesISTARTZT Allow NULL? 
40XISTARTVTActual starting time on day before planningchar10CHAR(N' ')YesXISTARTVT Allow NULL? 
41XISTARTATActual starting time on planning datechar10CHAR(N' ')YesXISTARTAT Allow NULL? 
42XISTARTFTActual starting time on day after planningchar10CHAR(N' ')YesXISTARTFT Allow NULL? 
43IFAHRTDAActual Run Time for Truck Routenvarchar40CHAR(N' ')YesIFAHRTDA Allow NULL? 
44ILASTEINHUnit of Measure for Actual Loaded Running Distancenvarchar30UNIT(N' ')YesT006ILASTEINH Allow NULL? 
45ILASTENTFActual Loaded Running Distance for Truck Routedecimal133QUAN((0))YesILASTENTF
46ILEEREINHUnit of Measure for Actual Empty Running Distancenvarchar30UNIT(N' ')YesT006ILEEREINH Allow NULL? 
47ILEERENTFActual Empty Running Distance for Truck Routedecimal133QUAN((0))YesILEERENTF
48IANKUNFTZActual Arrival Time for Truck Route (at First Load./Unl.Pt)nvarchar60TIMS(N'000000')YesIANKUNFTZ Allow NULL? 
49XIANK1VTActual arrival (at first point) on day before planningchar10CHAR(N' ')YesXIANK1VT Allow NULL? 
50XIANK1ATActual arrival (at first point) on planning datechar10CHAR(N' ')YesXIANK1AT Allow NULL? 
51XIANK1FTActual arrival (at first point) on day after planningchar10CHAR(N' ')YesXIANK1FT Allow NULL? 
52IANKUNFLTActual Arrival Time for Truck Route (at Last Loading/Unl.Pt)nvarchar60TIMS(N'000000')YesIANKUNFLT Allow NULL? 
53XIANKLAVTActual arrival (at last point) on day before planningchar10CHAR(N' ')YesXIANKLAVT Allow NULL? 
54XIANKLAATActual arrival (at last point) on planning datechar10CHAR(N' ')YesXIANKLAAT Allow NULL? 
55XIANKLAFTActual arrival (at last point) on day after planningchar10CHAR(N' ')YesXIANKLAFT Allow NULL? 
56IRKZEITActual Return Time of Truck Route (to Loading Point)nvarchar60TIMS(N'000000')YesIRKZEIT Allow NULL? 
57XIRKZVTActual return time on day before planningchar10CHAR(N' ')YesXIRKZVT Allow NULL? 
58XIRKZATActual return time on planning datechar10CHAR(N' ')YesXIRKZAT Allow NULL? 
59XIRKZFTActual return on day after planningchar10CHAR(N' ')YesXIRKZFT Allow NULL? 
60IBEREITZTActual Standby Time for Truck Routenvarchar60TIMS(N'000000')YesIBEREITZT Allow NULL? 
61XIBERZVTTime specified refers to day before planningchar10CHAR(N' ')YesXPLBERZVT Allow NULL? 
62XIBERZATTime specified refers to circulation planning datechar10CHAR(N' ')YesXPLBERZAT Allow NULL? 
63XIBERZFTTime specified refers to day after planningchar10CHAR(N' ')YesXPLBERZFT Allow NULL? 
64IBELADEDAActual Loading Time for Truck Routenvarchar40CHAR(N' ')YesIBELADEDA Allow NULL? 
65GEWICHTKLWeight Classnvarchar20CHAR(N' ')YesTJR31GEWICHTKL Allow NULL? 
66ENTFERNKATDistance Category (for Settlement)nvarchar20CHAR(N' ')YesTJR33ENTFERNKAT Allow NULL? 
67SCHLKATKey category (for settlement)nvarchar20CHAR(N' ')YesTJR35SCHLKAT Allow NULL? 
68ROUKATE1IS-M: Truck route settlement category type 1nvarchar20CHAR(N' ')YesTJR21ROUKATE1 Allow NULL? 
69ROUKATE2IS-M: Truck route settlement category 2nvarchar20CHAR(N' ')YesTJR23ROUKATE2 Allow NULL? 
70ROUKATE3IS-M: Truck route settlement category type 3nvarchar20CHAR(N' ')YesTJR25ROUKATE3 Allow NULL? 
71ROUKATE4IS-M: Truck route settlement category type 4nvarchar20CHAR(N' ')YesTJR27ROUKATE4 Allow NULL? 
72ROUKATE5IS-M: Truck route category type 5nvarchar20CHAR(N' ')YesTJR29ROUKATE5 Allow NULL? 
73PREISTruck route price (for statistical purposes)decimal132CURR((0))YesROUTPREIS
74WAEHRUNGCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
75XKONDUEBCopy conditions for split routechar10CHAR(N' ')YesXKONDUEB Allow NULL? 
76XPAPIERDRKPrint shipping documents for truck route splitchar10CHAR(N' ')YesXPAPIERDRK Allow NULL? 
77LOEVMDeletion Flag for Master Data in Media Sales & Distributionchar10CHAR(N' ')YesLOEVM_ISP Allow NULL? 
78LOEKZDeletion Indicator for Master Data in Media Sales & Dist.char10CHAR(N' ')YesLOEKZ_ISP Allow NULL? 
79FKALENDIDFactory Calendar for Truck Route Generationnvarchar20CHAR(N' ')YesTFACDFKALENDIDR Allow NULL? 
80PERREGELFrequency rulenvarchar50CHAR(N' ')YesTJD03PERREGEL Allow NULL? 
81GRUNDIS-M: Reason for Alternative Vehiclenvarchar20CHAR(N' ')YesTJR41KFZAWGRUND Allow NULL? 
82IVKMITARTActual Vehiclenvarchar30CHAR(N' ')YesTJR39IVRKMITART Allow NULL? 
83WARTEDAUERActual Waiting Timenvarchar40CHAR(N' ')YesIWARTEDAUR Allow NULL? 
84LADHILFDAActual Time for Loading Assistantnvarchar40CHAR(N' ')YesILADHILFDA Allow NULL? 
85XGENMASCHIndicator: Object generated automaticallychar10CHAR(N' ')YesXGENMASCH Allow NULL? 
86XISTERFActual data recorded for truck routechar10CHAR(N' ')YesXISTERF Allow NULL? 
87ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
88ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
89ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
90ERFPROGProgram Used to Create Objectnvarchar400CHAR(N' ')Yes*ERFPROG Allow NULL? 
91AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
92AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
93AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
94AENPROGProgram that Made Last Changenvarchar400CHAR(N' ')Yes*AENPROG Allow NULL? 
95EPERDATUMIS-M: Starting Date of Individual Periodnvarchar80DATS(N'00000000')YesEPERDATUM Allow NULL? 
96VSPSOFORTDPrint out Shipping Documents Immediatelychar10CHAR(N' ')YesJ_VSPIMMED Allow NULL? 
97VSPLOESCHNDelete Shipping Documents After Printingchar10CHAR(N' ')YesJ_VSPDELET Allow NULL? 
98VSPVERWDAUShipping Document Retention Period in Spoolchar10NUMC(N'0')YesJ_VSPLIFET Allow NULL? 
99VSPSAPDECKPrint: SAP cover sheetchar10CHAR(N' ')YesJ_VSPPRSAP Allow NULL? 
100VSPDECKTXTPrint: Text for cover sheetnvarchar680CHAR(N' ')YesJ_VSPPRTXT Allow NULL? 
101VSPDECKEMPPrint: Recipientnvarchar120CHAR(N' ')YesJ_VSPPRREC Allow NULL? 
102VSPDECKABTPrint: Department on cover sheetnvarchar120CHAR(N' ')YesJ_VSPPRABT Allow NULL? 
103VSPDECKBERPrint: Authorizationnvarchar120CHAR(N' ')YesJ_VSPPRBER Allow NULL? 
104VSPARCHMODPrint: Archiving modechar10CHAR(N' ')YesJ_VSPARMOD Allow NULL? 
105ROUTENTYPIS-M: Truck route categorychar10CHAR(N' ')YesROUTENTYP Allow NULL? 
106SPLITT_JAIS-M: Split indicator for truck route splitchar10CHAR(N' ')YesSPLITT_JA Allow NULL? 
107PBEREITDIS-M: Planned truck route availability datenvarchar80DATS(N'00000000')YesPBEREITD Allow NULL? 
108PSTARTDIS-M: Planned start date for truck routenvarchar80DATS(N'00000000')YesPSTARTD Allow NULL? 
109PANKUNFTDIS-M: Planned arrival date of truck routenvarchar80DATS(N'00000000')YesPANKUNFTD Allow NULL? 
110PANKBEABDIS-M: Planned arr.date of truck route at last loading/unl.ptnvarchar80DATS(N'00000000')YesPANKBEABD Allow NULL? 
111PRUECKDIS-M: Planned return date for truck routenvarchar80DATS(N'00000000')YesPRUECKD Allow NULL? 
112IBEREITDIS-M: Actual Standby Date for Truck Routenvarchar80DATS(N'00000000')YesIBEREITD Allow NULL? 
113ISTARTDIS-M: Actual Truck Route Starting Datenvarchar80DATS(N'00000000')YesISTARTD Allow NULL? 
114IANKUNFTDIS-M: Actual Arrival Date for Truck Routenvarchar80DATS(N'00000000')YesIANKUNFTD Allow NULL? 
115IANKBEABDIS-M: Actual Arrival Date at Last Loading/Unloading Pointnvarchar80DATS(N'00000000')YesIANKBEABD Allow NULL? 
116IRUECKDIS-M: Actual Return Date of Truck Routenvarchar80DATS(N'00000000')YesIRUECKD Allow NULL? 
117BASISROUTETruck Route - Medianvarchar60CHAR(N' ')Yes*ISPROUTE Allow NULL? 
NamePrimaryUniqueTypeColumns
JRTTROUTE~0YesYesCLUSTEREDDISPODAT, ROUTE, MANDT
JRTTROUTE~1NoNoNONCLUSTEREDHAUPTROUTE
JRTTROUTE~2NoNoNONCLUSTEREDDISPODAT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy