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

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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
Basis Components :: Database Interface, Database Platforms :: DB2 Universal Database for UNIX NT
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DB6CSTRACE811DB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace)DB2 Universal Database for UNIX NT
SQL:  selectupdate insert create

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

SELECT PID, DBNAME, APPSERV, DMODTYPE, DMODULE, TIMESTAMP, STMTNUM, OPTLEVEL, TABLENAME, PROG, CONT, FIRST_TIME, LAST_TIME, PREP_CNT, EXEC_CNT, FET_CNT, EFET_CNT, CLSE_CNT, PREP_TIME, EXEC_TIME, FET_TIME, EFET_TIME, CLSE_TIME, PREP_5S, PREP_1S, PREP_500MS, PREP_100MS, PREP_50MS, PREP_20MS, PREP_10MS, PREP_5MS, PREP_2MS, PREP_1MS, PREP_LT1MS, EXEC_5S, EXEC_1S, EXEC_500MS, EXEC_100MS, EXEC_50MS, EXEC_20MS, EXEC_10MS, EXEC_5MS, EXEC_2MS, EXEC_1MS, EXEC_LT1MS, FET_5S, FET_1S, FET_500MS, FET_100MS, FET_50MS, FET_20MS, FET_10MS, FET_5MS, FET_2MS, FET_1MS, FET_LT1MS, EFET_5S, EFET_1S, EFET_500MS, EFET_100MS, EFET_50MS, EFET_20MS, EFET_10MS, EFET_5MS, EFET_2MS, EFET_1MS, EFET_LT1MS, CLSE_5S, CLSE_1S, CLSE_500MS, CLSE_100MS, CLSE_50MS, CLSE_20MS, CLSE_10MS, CLSE_5MS, CLSE_2MS, CLSE_1MS, CLSE_LT1MS, STMT_SUBST, STMT_LEN, STMT_TEXT FROM DB6CSTRACE
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1PIDint100 Allow NULL? 
2DBNAMEnvarchar160 Allow NULL? 
3APPSERVnvarchar640 Allow NULL? 
4DMODTYPEint100 Allow NULL? 
5DMODULEnvarchar400 Allow NULL? 
6TIMESTAMPnvarchar150 Allow NULL? 
7STMTNUMint100 Allow NULL? 
8OPTLEVELchar10 Allow NULL? 
9TABLENAMEnvarchar160 Allow NULL? 
10PROGnvarchar400 Allow NULL? 
11CONTdecimal220
12FIRST_TIMEnvarchar260 Allow NULL? 
13LAST_TIMEnvarchar260 Allow NULL? 
14PREP_CNTdecimal220
15EXEC_CNTdecimal220
16FET_CNTdecimal220
17EFET_CNTdecimal220
18CLSE_CNTdecimal220
19PREP_TIMEdecimal220
20EXEC_TIMEdecimal220
21FET_TIMEdecimal220
22EFET_TIMEdecimal220
23CLSE_TIMEdecimal220
24PREP_5Sdecimal220
25PREP_1Sdecimal220
26PREP_500MSdecimal220
27PREP_100MSdecimal220
28PREP_50MSdecimal220
29PREP_20MSdecimal220
30PREP_10MSdecimal220
31PREP_5MSdecimal220
32PREP_2MSdecimal220
33PREP_1MSdecimal220
34PREP_LT1MSdecimal220
35EXEC_5Sdecimal220
36EXEC_1Sdecimal220
37EXEC_500MSdecimal220
38EXEC_100MSdecimal220
39EXEC_50MSdecimal220
40EXEC_20MSdecimal220
41EXEC_10MSdecimal220
42EXEC_5MSdecimal220
43EXEC_2MSdecimal220
44EXEC_1MSdecimal220
45EXEC_LT1MSdecimal220
46FET_5Sdecimal220
47FET_1Sdecimal220
48FET_500MSdecimal220
49FET_100MSdecimal220
50FET_50MSdecimal220
51FET_20MSdecimal220
52FET_10MSdecimal220
53FET_5MSdecimal220
54FET_2MSdecimal220
55FET_1MSdecimal220
56FET_LT1MSdecimal220
57EFET_5Sdecimal220
58EFET_1Sdecimal220
59EFET_500MSdecimal220
60EFET_100MSdecimal220
61EFET_50MSdecimal220
62EFET_20MSdecimal220
63EFET_10MSdecimal220
64EFET_5MSdecimal220
65EFET_2MSdecimal220
66EFET_1MSdecimal220
67EFET_LT1MSdecimal220
68CLSE_5Sdecimal220
69CLSE_1Sdecimal220
70CLSE_500MSdecimal220
71CLSE_100MSdecimal220
72CLSE_50MSdecimal220
73CLSE_20MSdecimal220
74CLSE_10MSdecimal220
75CLSE_5MSdecimal220
76CLSE_2MSdecimal220
77CLSE_1MSdecimal220
78CLSE_LT1MSdecimal220
79STMT_SUBSTnvarchar2000 Allow NULL? 
80STMT_LENsmallint50
81STMT_TEXTntext10737418230
NamePrimaryUniqueTypeColumns
DB6CSTRACE~0YesYesCLUSTEREDOPTLEVEL, STMTNUM, TIMESTAMP, DMODULE, DMODTYPE, APPSERV, DBNAME, PID