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  | JRTROUTE
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

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

SELECT MANDT, ROUTE, ROUTENTYP, 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, GEWICHTKL, ENTFERNKAT, SCHLKAT, ROUKATE1, ROUKATE2, ROUKATE3, ROUKATE4, ROUKATE5, PREIS, WAEHRUNG, XKONDUEB, XPAPIERDRK, LOEVM, LOEKZ, FKALENDID, PERREGEL, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, VSPSOFORTD, VSPLOESCHN, VSPVERWDAU, VSPSAPDECK, VSPDECKTXT, VSPDECKEMP, VSPDECKABT, VSPDECKBER, VSPARCHMOD, PBEREITD, PSTARTD, PANKUNFTD, PANKBEABD, PRUECKD, IBEREITD, ISTARTD, IANKUNFTD, IANKBEABD, IRUECKD, PREISAB, VERKMITART FROM JRTROUTE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ROUTETruck Route - Medianvarchar60CHAR(N' ')NoISPROUTE Allow NULL? 
3ROUTENTYPIS-M: Truck route categorychar10CHAR(N' ')YesROUTENTYP 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? 
39GEWICHTKLWeight Classnvarchar20CHAR(N' ')YesTJR31GEWICHTKL Allow NULL? 
40ENTFERNKATDistance Category (for Settlement)nvarchar20CHAR(N' ')YesTJR33ENTFERNKAT Allow NULL? 
41SCHLKATKey category (for settlement)nvarchar20CHAR(N' ')YesTJR35SCHLKAT Allow NULL? 
42ROUKATE1IS-M: Truck route settlement category type 1nvarchar20CHAR(N' ')YesTJR21ROUKATE1 Allow NULL? 
43ROUKATE2IS-M: Truck route settlement category 2nvarchar20CHAR(N' ')YesTJR23ROUKATE2 Allow NULL? 
44ROUKATE3IS-M: Truck route settlement category type 3nvarchar20CHAR(N' ')YesTJR25ROUKATE3 Allow NULL? 
45ROUKATE4IS-M: Truck route settlement category type 4nvarchar20CHAR(N' ')YesTJR27ROUKATE4 Allow NULL? 
46ROUKATE5IS-M: Truck route category type 5nvarchar20CHAR(N' ')YesTJR29ROUKATE5 Allow NULL? 
47PREISTruck route price (for statistical purposes)decimal132CURR((0))YesROUTPREIS
48WAEHRUNGCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
49XKONDUEBCopy conditions for split routechar10CHAR(N' ')YesXKONDUEB Allow NULL? 
50XPAPIERDRKPrint shipping documents for truck route splitchar10CHAR(N' ')YesXPAPIERDRK Allow NULL? 
51LOEVMDeletion Flag for Master Data in Media Sales & Distributionchar10CHAR(N' ')YesLOEVM_ISP Allow NULL? 
52LOEKZDeletion Indicator for Master Data in Media Sales & Dist.char10CHAR(N' ')YesLOEKZ_ISP Allow NULL? 
53FKALENDIDFactory Calendar for Truck Route Generationnvarchar20CHAR(N' ')YesTFACDFKALENDIDR Allow NULL? 
54PERREGELFrequency rulenvarchar50CHAR(N' ')YesTJD03PERREGEL Allow NULL? 
55ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
56ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
57ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
58AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
59AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
60AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
61VSPSOFORTDPrint out Shipping Documents Immediatelychar10CHAR(N' ')YesJ_VSPIMMED Allow NULL? 
62VSPLOESCHNDelete Shipping Documents After Printingchar10CHAR(N' ')YesJ_VSPDELET Allow NULL? 
63VSPVERWDAUShipping Document Retention Period in Spoolchar10NUMC(N'0')YesJ_VSPLIFET Allow NULL? 
64VSPSAPDECKPrint: SAP cover sheetchar10CHAR(N' ')YesJ_VSPPRSAP Allow NULL? 
65VSPDECKTXTPrint: Text for cover sheetnvarchar680CHAR(N' ')YesJ_VSPPRTXT Allow NULL? 
66VSPDECKEMPPrint: Recipientnvarchar120CHAR(N' ')YesJ_VSPPRREC Allow NULL? 
67VSPDECKABTPrint: Department on cover sheetnvarchar120CHAR(N' ')YesJ_VSPPRABT Allow NULL? 
68VSPDECKBERPrint: Authorizationnvarchar120CHAR(N' ')YesJ_VSPPRBER Allow NULL? 
69VSPARCHMODPrint: Archiving modechar10CHAR(N' ')YesJ_VSPARMOD Allow NULL? 
70PBEREITDIS-M: Planned truck route availability datenvarchar80DATS(N'00000000')YesPBEREITD Allow NULL? 
71PSTARTDIS-M: Planned start date for truck routenvarchar80DATS(N'00000000')YesPSTARTD Allow NULL? 
72PANKUNFTDIS-M: Planned arrival date of truck routenvarchar80DATS(N'00000000')YesPANKUNFTD Allow NULL? 
73PANKBEABDIS-M: Planned arr.date of truck route at last loading/unl.ptnvarchar80DATS(N'00000000')YesPANKBEABD Allow NULL? 
74PRUECKDIS-M: Planned return date for truck routenvarchar80DATS(N'00000000')YesPRUECKD Allow NULL? 
75IBEREITDIS-M: Actual Standby Date for Truck Routenvarchar80DATS(N'00000000')YesIBEREITD Allow NULL? 
76ISTARTDIS-M: Actual Truck Route Starting Datenvarchar80DATS(N'00000000')YesISTARTD Allow NULL? 
77IANKUNFTDIS-M: Actual Arrival Date for Truck Routenvarchar80DATS(N'00000000')YesIANKUNFTD Allow NULL? 
78IANKBEABDIS-M: Actual Arrival Date at Last Loading/Unloading Pointnvarchar80DATS(N'00000000')YesIANKBEABD Allow NULL? 
79IRUECKDIS-M: Actual Return Date of Truck Routenvarchar80DATS(N'00000000')YesIRUECKD Allow NULL? 
80PREISABValid-From Datenvarchar80DATS(N'00000000')YesGUELTIGVON Allow NULL? 
81VERKMITARTVehiclenvarchar30CHAR(N' ')NoTJR39VKMITARTVB Allow NULL? 
NamePrimaryUniqueTypeColumns
JRTROUTE~0YesYesCLUSTEREDROUTE, MANDT
JRTROUTE~1NoNoNONCLUSTEREDHAUPTROUTE

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