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
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: Use Subcomponents :: Archive Development Kit
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ADMI_STATS251Archiving sessions: StatisticsArchive Development Kit
SQL:  selectupdate insert create

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

SELECT DOCUMENT, DB_SPACE_W, DB_SPACE_D, DB_SPACE_L, DB_INDEX_W, DB_INDEX_D, DB_INDEX_L, DB_CLUST_W, DB_CLUST_D, DB_CLUST_L, DB_STRUC_W, DB_STRUC_D, DB_STRUC_L, FILE_HEAD, FILE_DATA, RUN_TIME_W, RUN_TIME_D, JOB_TIME_W, JOB_TIME_D, JOB_TIME_L, OBJ_CNT_W, OBJ_CNT_D, OBJ_CNT_L, DEL_JOBCNT, INACCURATE FROM ADMI_STATS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1DOCUMENTArchiving Session Numbernvarchar60CHAR(N' ')NoADMI_RUN_D Allow NULL? 
2DB_SPACE_WUsed Table Space in Database [Byte]float1516FLTP((0))NoADMI_R_DSW
3DB_SPACE_DMemory Space Released in Database [Byte]float1516FLTP((0))NoADMI_R_DSD
4DB_SPACE_LReloaded Table Database Space [Byte]float1516FLTP((0))NoADMI_R_DSL
5DB_INDEX_WUsed Index Database Space [Byte]float1516FLTP((0))NoADMI_R_IXW
6DB_INDEX_DDeleted Index Database Space [Byte]float1516FLTP((0))NoADMI_R_IXD
7DB_INDEX_LReloaded Index Database Space [Byte]float1516FLTP((0))NoADMI_R_IXL
8DB_CLUST_WUsed Cluster Memory Space [Byte]float1516FLTP((0))NoADMI_R_CLW
9DB_CLUST_DDeleted Cluster Database Space [Byte]float1516FLTP((0))NoADMI_R_CLD
10DB_CLUST_LReloaded Cluster Database Space [Byte]float1516FLTP((0))NoADMI_R_CLL
11DB_STRUC_WOccupied Structure Memory Space [Byte]float1516FLTP((0))NoADMI_R_STW
12DB_STRUC_DRelease Structure Database Space [Byte]float1516FLTP((0))NoADMI_R_STD
13DB_STRUC_LReloaded Structure Database Space [Byte]float1516FLTP((0))NoADMI_R_STL
14FILE_HEADSize of All Header Data in an Archiving Session [Byte]float1516FLTP((0))NoADMI_R_FSH
15FILE_DATATotal Application Data in an Archive Sessionfloat1516FLTP((0))NoADMI_R_FSD
16RUN_TIME_WDuration of The Write Job [hh:mm:ss] (Only 4.6D)nvarchar60TIMS(N'000000')NoADMI_R_RTW Allow NULL? 
17RUN_TIME_DAverage Duration of a Deletion Job ]hh:mm:ss] (4.6D only)nvarchar60TIMS(N'000000')NoADMI_R_RTD Allow NULL? 
18JOB_TIME_WDuration of Write Job [Seconds]int100INT4((0))NoADMI_J_RTW Allow NULL? 
19JOB_TIME_DAverage Delete Job Duration [Seconds]int100INT4((0))NoADMI_J_RTD Allow NULL? 
20JOB_TIME_LReload Job Duration [Seconds]int100INT4((0))NoADMI_J_RTL Allow NULL? 
21OBJ_CNT_WNumber of Written Data Objectsint100INT4((0))NoADMI_CNT_W Allow NULL? 
22OBJ_CNT_DNumber of Deleted Objectsint100INT4((0))NoADMI_CNT_D Allow NULL? 
23OBJ_CNT_LNumber of Reloaded Data Objectsint100INT4((0))NoADMI_CNT_L Allow NULL? 
24DEL_JOBCNTNumber of Delete Jobsint100INT4((0))NoADMI_JCT_D Allow NULL? 
25INACCURATEApproximate Indicatorchar10CHAR(N' ')NoADMI_R_INA Allow NULL? 
NamePrimaryUniqueTypeColumns
ADMI_STATS~0YesYesCLUSTEREDDOCUMENT