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  | MSQSNAP
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 :: Database Interface, Database Platforms :: Microsoft SQL Server
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MSQSNAP951MS SQL Server: Database performance snapshotMicrosoft SQL Server
SQL:  selectupdate insert create

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

SELECT RECORDDATE, RECORDTIME, ELAPSEDSEC, HOSTNAME, SQLVERSION, SQLBUILDNM, PRODLEVEL, SQLSTARTTM, SQLEE, NTVER, PARAMDIFF, DISKPERF, ISCLUSTER, IS3GB, ISPAE, ISAWE, CHIP, WINVER, NUMCPUS, SQLCPUS, MASK, PHYMEM, TRACEFLAGS, MEMSETTING, AGTLOGLOC, ERRLOGLOC, CONNECTMEM, WRKPROCMEM, LOCKMEMORY, MAXWSPMEM, OPTQRYMEM, SQLCACMEM, TARSRVMEM, TTLSRVMEM, USERCONCTS, CACHEHIT, DATACACHSZ, CACHESIZE, BUFFCOMMIT, FREEBUFFER, STLPAGECNT, FULLSCANS, INDEXSRCH, EXTALLOCS, EXTDEALLS, PAGEALLOCS, PAGEDEALLS, PAGESPLITS, PROBESCANS, RANGESCANS, WORKFILES, WORKTABLES, LAZYWRITES, PAGEREADS, PAGEWRITES, REQBUFFPG, READAHEAD, AUTOPARAM, SQLBATCHS, SQLCOMPILE, AVGLTCHWT, LATCHWAITS, DB_SIZE, DB_ALLOC, LOG_SIZE, LOG_ALLOC, RESERVED, NUMTABS, TABDATA, NUMINDS, INDDATA, UNUSED, NUMPROCS, SQLUPTIME, CPUBUSY, CPUIDLE, IOBUSY, PCTCPU, PCTIDLE, PCTIO, PACKRECD, PACKSENT, CONNECTS, PACKERRORS, TOTALREAD, TOTALWRITE, TOTALERROR, CACHETYPE, HITRATIO, OBJECTCNT, OBJPAGES, USECOUNTS, R3USERS, OTHERUSER, UNIUSER FROM MSQSNAP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1RECORDDATEDatenvarchar80DATS(N'00000000')NoDATUM Allow NULL? 
2RECORDTIMETimenvarchar60TIMS(N'000000')NoUZEIT Allow NULL? 
3ELAPSEDSECMS SQL Server number of seconds elapsed since DB startupint100INT4((0))YesMSSELAPSED Allow NULL? 
4HOSTNAMEHostname of the application server logged into SQL Servernvarchar300CHAR(N' ')YesMSSHOSTNM_ Allow NULL? 
5SQLVERSIONVersion of the database management system.nvarchar500CHAR(N' ')YesMSQVERSN Allow NULL? 
6SQLBUILDNMSQL Server build number (corresponding to a Service Pack).int100INT4((0))YesMSQDBVER Allow NULL? 
7PRODLEVELDate the executable sqlservr.exe was created.nvarchar120CHAR(N' ')YesMSQSSBLDDT Allow NULL? 
8SQLSTARTTMDate and time of last SQL Server start.nvarchar200CHAR(N' ')YesMSQDBUPTME Allow NULL? 
9SQLEESQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in usechar10CHAR(N' ')YesMSQSSSQLEE Allow NULL? 
10NTVEROS edition: A=Advanced Server, S=Server, D=Datacenter.char10CHAR(N' ')YesMSQSSNTEE Allow NULL? 
11PARAMDIFFSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
12DISKPERFSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
13ISCLUSTERIs SQL Server clustered 'Y' or 'N'char10CHAR(N' ')YesMSSISCLUSTER Allow NULL? 
14IS3GBIs SQL Server on machine with /3GB switch on 'Y' or 'N'char10CHAR(N' ')YesMSSIS3GB Allow NULL? 
15ISPAEIs SQL Server on machine with PAE 'Y' or 'N'char10CHAR(N' ')YesMSSISPAE Allow NULL? 
16ISAWEIs SQL Server AWE enabled Y' or 'N'char10CHAR(N' ')YesMSSISAWE Allow NULL? 
17CHIPProcessor type being used on the host running SQL Server.nvarchar200CHAR(N' ')YesMSQSSCHIP Allow NULL? 
18WINVEROperating system version running on SQL Server host.nvarchar800CHAR(N' ')YesMSQSSWVER Allow NULL? 
19NUMCPUSNumber of CPUs on the host which runs SQL Server.int100INT4((0))YesMSQSSCPUS Allow NULL? 
20SQLCPUSMaximum number of CPUs SQL Server is configured to use.int100INT4((0))YesMSQSQLCPUS Allow NULL? 
21MASKBitmask representing the CPUs available to Windows.nvarchar80CHAR(N' ')YesMSQSSMASK Allow NULL? 
22PHYMEMAmount of RAM on the server running SQL Serverint100INT4((0))YesMSQSSRAM Allow NULL? 
23TRACEFLAGSTrace flags which are currently set for SQL Server.nvarchar2550CHAR(N' ')YesMSQSSTFLG Allow NULL? 
24MEMSETTINGSpecifies how SQL Server memory parameters have been setnvarchar100CHAR(N' ')YesMSQMEMSET Allow NULL? 
25AGTLOGLOCUNC path to a file used by SQL Servernvarchar2550CHAR(N' ')YesMSSPATH Allow NULL? 
26ERRLOGLOCUNC path to a file used by SQL Servernvarchar2550CHAR(N' ')YesMSSPATH Allow NULL? 
27CONNECTMEMAmount of dynamic memory the server is using for connectionsdecimal230DEC((0))YesMSSPMCONN
28WRKPROCMEMAmount of memory granted to executing processes in KBdecimal230DEC((0))YesMSSPMGWSPM
29LOCKMEMORYAmount of dynamic memory used for locks in KBdecimal230DEC((0))YesMSSPMLCKM
30MAXWSPMEMMaximum amount of memory available for executing SQL processdecimal230DEC((0))YesMSSPMMWSPM
31OPTQRYMEMAmount of memory SQL Server is using for query optimizationdecimal230DEC((0))YesMSSPMOPMEM
32SQLCACMEMAmount of memory being used for dynamic SQL cache in KBdecimal230DEC((0))YesMSSPMCACM
33TARSRVMEMAmount of memory SQL Server is willing to consume in KBdecimal230DEC((0))YesMSSPMTARSM
34TTLSRVMEMAmount of memory SQL Server is currently using in KB.decimal230DEC((0))YesMSSPMTTLSM
35USERCONCTSNumber of user connections to the SQL Server systemdecimal230DEC((0))YesMSSPSUSCON
36CACHEHITPercentage of pages found in the buffer cachedecimal133DEC((0))YesMSSPBCACHT
37DATACACHSZSize in KB of the data cache, including unused spacedecimal230DEC((0))YesMSSPBDATAC
38CACHESIZESize in KB of the procedure cache, including unused space.decimal230DEC((0))YesMSSPBCACSZ
39BUFFCOMMITNumber of committed pages in cache.decimal230DEC((0))YesMSSPBCOMIT
40FREEBUFFERNumber of free pages available in cache.decimal230DEC((0))YesMSSPBFREBF
41STLPAGECNTNumber of buffer pages taken for other memory requirementsdecimal230DEC((0))YesMSSPBSTPCT
42FULLSCANSNumber of unrestricted base table or index scansdecimal230DEC((0))YesMSSPAFULLS
43INDEXSRCHNumber of index searchesdecimal230DEC((0))YesMSSPAIDXSR
44EXTALLOCSNumber of extents allocated to database objectsdecimal230DEC((0))YesMSSPAEXAL
45EXTDEALLSNumber of extents deallocated in a databasedecimal230DEC((0))YesMSSPAEXDE
46PAGEALLOCSNumber of pages allocated to database objectsdecimal230DEC((0))YesMSSPAPGAL
47PAGEDEALLSNumber of pages deallocated in a databasedecimal230DEC((0))YesMSSPAPGDE
48PAGESPLITSNumber of index page splits in a databasedecimal230DEC((0))YesMSSPAPGSPL
49PROBESCANSNumber of probe scans in a databasedecimal230DEC((0))YesMSSPAPRBSN
50RANGESCANSNumber of range scans through indexesdecimal230DEC((0))YesMSSPARNGSN
51WORKFILESNumber of work files createddecimal230DEC((0))YesMSSPAWFCRE
52WORKTABLESNumber of work tables createddecimal230DEC((0))YesMSSPAWTCRE
53LAZYWRITESNumber of pages written by the lazy writer to disk.decimal230DEC((0))YesMSSPBLZWTS
54PAGEREADSNumber of physical page readsdecimal230DEC((0))YesMSSPBPGRDS
55PAGEWRITESNumber of physical page writesdecimal230DEC((0))YesMSSPBPGWRT
56REQBUFFPGNumber of requests to find a page in the buffer pool.decimal230DEC((0))YesMSSPBUFREQ
57READAHEADNumber of pages read in anticipation of use.decimal230DEC((0))YesMSSPBRAPGS
58AUTOPARAMNumber of auto-parameterization attemptsdecimal230DEC((0))YesMSSPSAUTO
59SQLBATCHSNumber of SQL batch requests received by server.decimal230DEC((0))YesMSSPSBATCH
60SQLCOMPILENumber of SQL compilationsdecimal230DEC((0))YesMSSPSQLCMP
61AVGLTCHWTAverage wait time in ms for latch requests that waited.decimal230DEC((0))YesMSSPSALTWT
62LATCHWAITSNumber of latch requests that had to wait before granted.decimal230DEC((0))YesMSSPSLTHWT
63DB_SIZEDatabase size in MBdecimal150DEC((0))YesMSS_DBSIZE
64DB_ALLOCAllocated space in database in MBdecimal150DEC((0))YesMSS_DBALLOC
65LOG_SIZELog size in MBdecimal150DEC((0))YesMSS_LOGSIZE
66LOG_ALLOCAllocated space in log in MBdecimal150DEC((0))YesMSS_LOGALLOC
67RESERVEDReserved size in KBdecimal150DEC((0))YesMSSRESSIZE
68NUMTABSNumber of user tablesint100INT4((0))YesMSSNUMTABLES Allow NULL? 
69TABDATAData size in KBdecimal150DEC((0))YesMSSDATASIZE
70NUMINDSNumber of indexes of user tablesint100INT4((0))YesMSSNUMINDEXES Allow NULL? 
71INDDATAIndex size in KBdecimal150DEC((0))YesMSSINDEXSIZE
72UNUSEDUnused size in KBdecimal150DEC((0))YesMSSUNUSEDSIZE
73NUMPROCSNumber of stored procedures created in DBIint100INT4((0))YesMSSNUMPROCS Allow NULL? 
74SQLUPTIMENumber of seconds SQL Server has been running.int100INT4((0))YesMSQDSSQLSC Allow NULL? 
75CPUBUSYNumber of seconds CPUs have been busy (sum for all CPUs) .int100INT4((0))YesMSQDSCPUBY Allow NULL? 
76CPUIDLENumber of seconds CPUs have been idle (sum for all CPUs) .int100INT4((0))YesMSQDSCPUID Allow NULL? 
77IOBUSYNumber of seconds SQL Server tasks were busy with IO.int100INT4((0))YesMSQDSIOBSY Allow NULL? 
78PCTCPUPercent of time the CPUs have been busy.int100INT4((0))YesMSQDSCPPCT Allow NULL? 
79PCTIDLEPercent of time CPUs have been idle.int100INT4((0))YesMSQDSIDPCT Allow NULL? 
80PCTIOPercent of time SQL Server tasks have beeen busy whit IO.int100INT4((0))YesMSQDSIOPCT Allow NULL? 
81PACKRECDNumber of network packets received.int100INT4((0))YesMSQDSPCKRD Allow NULL? 
82PACKSENTNumber of network packets sent out by SQL Server.int100INT4((0))YesMSQDSPCKST Allow NULL? 
83CONNECTSNumber of attempted connections to SQL Server.int100INT4((0))YesMSQDSCONN Allow NULL? 
84PACKERRORSNumber of network packets with error since SQL Server start.int100INT4((0))YesMSQDSPCKER Allow NULL? 
85TOTALREADNumber of disk reads done by SQL Server (physical reads).int100INT4((0))YesMSQDSTOTRD Allow NULL? 
86TOTALWRITENumber of physical disk writes done by SQL Server.int100INT4((0))YesMSQDSTOTWR Allow NULL? 
87TOTALERRORNumber of disk read or write errors since SQL Server startedint100INT4((0))YesMSQDSTOTER Allow NULL? 
88CACHETYPEType of object in SQL Server procedure cache.nvarchar400CHAR(N' ')YesMSSPCTYPE Allow NULL? 
89HITRATIOProcedure cache hit ratio as percentage.decimal133DEC((0))YesMSSPCRATIO
90OBJECTCNTNumber of objects stored in the procedure cache.decimal230DEC((0))YesMSSPCOBJCT
91OBJPAGESNumber of pages used by this object type in the cache.decimal230DEC((0))YesMSSPCPAGES
92USECOUNTSNumber of times an object of this type has been used.decimal230DEC((0))YesMSSPCUSECT
93R3USERSNumber of connections to SAP database from SAP application.int100INT4((0))YesMSQDBSAPPC Allow NULL? 
94OTHERUSERNumber of non-SAP processes connected to SAP database.int100INT4((0))YesMSQDBNUMPC Allow NULL? 
95UNIUSERNumber of different users connected to SAP databaseint100INT4((0))YesMSQDBNDUSR Allow NULL? 
NamePrimaryUniqueTypeColumns
MSQSNAP~0YesYesCLUSTEREDRECORDTIME, RECORDDATE

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