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 :: Oracle
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0INDEX_STAT221index_stats Cache: Result of VALIDATE Index (Oracle)Oracle
SQL:  selectupdate insert create

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

SELECT NAME, DATUM, UZEIT, HEIGHT, BLOCKS, LF_ROWS, LF_BLKS, LF_ROW_LEN, LF_BLK_LEN, BR_ROWS, BR_BLKS, BR_ROW_LEN, BR_BLK_LEN, DEL_LF_ROW, DEL_LF_LEN, DIST_KEYS, REP_KEYS, BTREE_SPAC, USED_SPACE, PCT_USED, ROWS_PER_K, BLKS_GETS FROM INDEX_STAT
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1NAMEObject: Name of table or indexnvarchar810 Allow NULL? 
2DATUMDatenvarchar80 Allow NULL? 
3UZEITTimenvarchar60 Allow NULL? 
4HEIGHTheight of the b-treedecimal140
5BLOCKSNumber of blocksdecimal140
6LF_ROWSnumber of leaf rows (values in the index)decimal140
7LF_BLKSnumber of leaf blocks in the b-treedecimal140
8LF_ROW_LENsum of the lengths of all the branch blocksdecimal140
9LF_BLK_LENnumber of leaf blocks in the b-treedecimal140
10BR_ROWSnumber of branch rowsdecimal140
11BR_BLKSnumber of branch blocks in the b-treedecimal140
12BR_ROW_LENsum of the lengths of all the branch blocksdecimal140
13BR_BLK_LENusable space in a branch blockdecimal140
14DEL_LF_ROWnumber of deleted leaf rows in the indexdecimal140
15DEL_LF_LENtotal length of all deleted rows in the indexdecimal140
16DIST_KEYSNumber of distinct keys in indexdecimal140
17REP_KEYShow many times the most repeated key is repeateddecimal140
18BTREE_SPACtotal space currently allocated in the b-treedecimal140
19USED_SPACEtotal space that is currently being useddecimal140
20PCT_USEDPCT_USEDdecimal140
21ROWS_PER_Kaverage number of rows per distinct keydecimal140
22BLKS_GETSExpected number of consistent mode block gets per rowdecimal140
NamePrimaryUniqueTypeColumns
INDEX_STAT~0YesYesCLUSTEREDNAME