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

81 tablesERP 6.0 

Basis Components :: Database Interface, Database Platforms :: DB2 for OS39
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DB2ALERTSLIMITS61Table needed for collecting data for DB2 limits alert monit.DB2 for OS39
2ERP EHP76.0DB2BPTUNE171DB2/390: Buffer Pool Tuning SettingsDB2 for OS39
3ERP EHP76.0DB2CCACCOR271Parameters of Control Center stored procedure DSNACCORDB2 for OS39
4ERP EHP76.0DB2CCACCOX351Parameters stored procedure DSNACCOXDB2 for OS39
5ERP EHP76.0DB2CCDAILY471List of TS/IXS needing utility treatment (DSNACCOR Daily)DB2 for OS39
6ERP EHP76.0DB2CCDAILYX571List of TS/IXS needing utility treatment (DSNACCOX Daily)DB2 for OS39
7ERP EHP76.0DB2CCDL_OUTTS141DSNACCDL: History of output tableDB2 for OS39
8ERP EHP76.0DB2CCDL_PARMS101DSNACCDL: History of execution parameters for DB13 jobsDB2 for OS39
9ERP EHP76.0DB2CCDS_IN41DSNACCDS: History of input table for DB13 jobsDB2 for OS39
10ERP EHP76.0DB2CCDS_PARMS91DSNACCDS: History of execution parameters for DB13 jobsDB2 for OS39
11ERP EHP76.0DB2CCHOUR471List of TS/IXS needing utility treatment (DSNACCOR Hourly)DB2 for OS39
12ERP EHP76.0DB2CCMO_ERROR41DSNACCMO: History of error info with length > 255 CHARDB2 for OS39
13ERP EHP76.0DB2CCMO_IN1461History of input table 1 for DB13 jobs executed via DSNACCMODB2 for OS39
14ERP EHP76.0DB2CCMO_IN251History of input table 2 for DB13 jobs executed via DSNACCMODB2 for OS39
15ERP EHP76.0DB2CCMO_OBJERR101DSNACCMO: History of failed utility executionsDB2 for OS39
16ERP EHP76.0DB2CCMO_OUTTS51History of output table for DB13 jobs executed via DSNACCMODB2 for OS39
17ERP EHP76.0DB2CCMO_PARMS151History of execution parameters for DB13 jobs via DSNACCMODB2 for OS39
18ERP EHP76.0DB2COPYI201DB2 copy information from SYSIBM.SYSCOPYDB2 for OS39
19ERP EHP76.0DB2DB02CONTROL61Control table for information in DB02DB2 for OS39
20ERP EHP76.0DB2DB02EXTENTS131Tx DB02: Data for DB02's Extent MonitorDB2 for OS39
21ERP EHP76.0DB2DB02IXDYN342Tx DB02: Dynamics of the size of indexesDB2 for OS39
22ERP EHP76.0DB2DB02IXSIZE173Tx DB02: List of indexspace datasetsDB2 for OS39
23ERP EHP76.0DB2DB02IX_SUM205Tx DB02: Summary of Index info. Partitions are summed upDB2 for OS39
24ERP EHP76.0DB2DB02MISSOBJ11Tx DB02: Missing objectsDB2 for OS39
25ERP EHP76.0DB2DB02SUMMARY211Tx DB02: Summary information on first screenincl. size histoDB2 for OS39
26ERP EHP76.0DB2DB02TBDYN253Tx DB02: Dynamics of the size of tablesDB2 for OS39
27ERP EHP76.0DB2DB02TBSIZE162Transaction DB02: List of tables and tablespace (Details)DB2 for OS39
28ERP EHP76.0DB2DB02TBTOPGROW251Tx DB02: Top Twenty of table growth for fast accessDB2 for OS39
29ERP EHP76.0DB2DB02TSDYN201Tx DB02: Dynamics of the size of tablespacesDB2 for OS39
30ERP EHP76.0DB2DB02TSSIZE162Transaction DB02: List of tablespace datasetsDB2 for OS39
31ERP EHP76.0DB2DB02TS_HIS102Tx DB02: Short history of TS infoDB2 for OS39
32ERP EHP76.0DB2DB02TS_SUM183Tx DB02: Summary of TS info. Partitions are summed upDB2 for OS39
33ERP EHP76.0DB2DB02VOLFREE31Tx DB02: Volume freespace listDB2 for OS39
34ERP EHP76.0DB2IREORG121Information for Database Reorgcheck: IndexesDB2 for OS39
35ERP EHP76.0DB2IXBACK301List of indexes that need a backupDB2 for OS39
36ERP EHP76.0DB2JOB51JCL Jobs for OS/390DB2 for OS39
37ERP EHP76.0DB2JOBIDMAP21Maps JCL Job ID for backwards compatibility with FTP JES IDDB2 for OS39
38ERP EHP76.0DB2JSINF61Header Table of JCL AdministrationDB2 for OS39
39ERP EHP76.0DB2JSTATUS61Status of Submitted JCL JobsDB2 for OS39
40ERP EHP76.0DB2JU31TSO User on OS/390DB2 for OS39
41ERP EHP76.0DB2LODLK161RFC - Deadlock TableDB2 for OS39
42ERP EHP76.0DB2LODRS391RFC - Deadlock ResourcesDB2 for OS39
43ERP EHP76.0DB2LOGS81RFC - Active Log ShortageDB2 for OS39
44ERP EHP76.0DB2LOTHW201RFC - Timeout Waiter and HolderDB2 for OS39
45ERP EHP76.0DB2LOTRS261RFC - Timeout ResourcesDB2 for OS39
46ERP EHP76.0DB2LRUR181RFC - Long Running URsDB2 for OS39
47ERP EHP76.0DB2LSCONFIG41DB2 Landscape Tool ConfigurationDB2 for OS39
48ERP EHP76.0DB2MISC31Miscellaneous CCMS on DB2 for z/OS settings and propertiesDB2 for OS39
49ERP EHP76.0DB2MON11DB2/390 Monitor TableDB2 for OS39
50ERP EHP76.0DB2NETSTATS511Contains network statistics collected by DB2 ConnectDB2 for OS39
51ERP EHP76.0DB2NORUN21Exclude table spaces from RUNSTATS ALLDB2 for OS39
52ERP EHP76.0DB2REOIX51REORG of IndexesDB2 for OS39
53ERP EHP76.0DB2REOTS51REORG of TablespacesDB2 for OS39
54ERP EHP76.0DB2RFCCONN131RFC - ConnectionDB2 for OS39
55ERP EHP76.0DB2SAPSYS101SAP systems located in one DB2 subsystemDB2 for OS39
56ERP EHP76.0DB2TBLX241RFC - Table ExtentsDB2 for OS39
57ERP EHP76.0DB2THREAD2201DB2 for OS39
58ERP EHP76.0DB2TREORG121Information for Database reorgcheck: TablesDB2 for OS39
59ERP EHP76.0DB2TSBACK341List of tablespaces that need a backupDB2 for OS39
60ERP EHP76.0DB2TSSIZE_T151DB2/390: Storage Information on R/3 TablespacesDB2 for OS39
61ERP EHP76.0DB2UTILS_OUT41History of output table for DB13 jobs executed via DSNUTILSDB2 for OS39
62ERP EHP76.0DB2UTILS_PARMS441History of execution parameters for DB13 jobs via DSNUTILSDB2 for OS39
63ERP EHP76.0DB2UTPARM31DB2/390: Parameters for DB2 UtilitiesDB2 for OS39
64ERP EHP76.0DB2ZPARMCONFIG71ZPARM Configuration TableDB2 for OS39
65ERP EHP76.0DBCHECKDB2221Configuration of DB2/390 System Check ParametersDB2 for OS39
66ERP EHP76.0DBMSGDB2151DB2/390 System Check MessagesDB2 for OS39
67ERP EHP76.0DBSTAIHDB2141DB2/390 Statistics for IndexesDB2 for OS39
68ERP EHP76.0DBSTATHDB2101DB2/390 Statistics for Tables (History)DB2 for OS39
69ERP EHP76.0DBSTATIDB2141DB2/390 Statistics for IndexesDB2 for OS39
70ERP EHP76.0DBSTATTDB2101DB2/390 Statistics for TablesDB2 for OS39
71ERP EHP76.0DBSYCHKDB271DB2/390: Global Information for Database System CheckDB2 for OS39
72ERP EHP76.0DD02DB271DB2/390: Table ParametersDB2 for OS39
73ERP EHP76.0DD12DB281DB2/390: Index ParametersDB2 for OS39
74ERP EHP76.0IADB221DB2/390: TABART <-> Index storage parametersDB2 for OS39
75ERP EHP76.0IGDB231DB2/390: TABKAT <-> Index storage parametersDB2 for OS39
76ERP EHP76.0SDBADDB241Detail Table for DBA LogsDB2 for OS39
77ERP EHP76.0STU3COTABC171Definition of DB2 OS/390 and OS/390 Commands(Customer Table)DB2 for OS39
78ERP EHP76.0STU3COTABS171Definition of DB2 for OS/390 and OS/390 Commands (SAP Table)DB2 for OS39
79ERP EHP76.0TADB232DB2/390: TABART <-> Table storage parametersDB2 for OS39
80ERP EHP76.0TGDB231DB2/390: TABKAT <-> Table storage parametersDB2 for OS39
81ERP EHP76.0TPDB241DB2/390: Pagesize <-> table storage parametersDB2 for OS39