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

48 columns | Print definition?ERP 6.0  | DBNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_ALRT_INFInterface <-> Table names5DBNAMEPI Database Mapping Tablenvarchar300
2MSSPPACKMSSQL : list of DB performance snapshots13DBNAMEDatabase namenvarchar1280
3sap_dblocks16dbnamesysname1280
4T390DPM: Destinations and database names for download4DBNAMEPC Database Name for Downloadnvarchar640
5TPTABTable parameters for DB25DBNAMEDatabase namenvarchar80
6TPTSPTablespace parameters for DB22DBNAMEDatabase namenvarchar80
7ZCLUSTDATAData "piece" definitions for data cluster reporting3DBNAMETable Namenvarchar300
8ZCLUSTIDCluster IDs for data cluster reporting2DBNAMETable Namenvarchar300
9ZCLUSTKEYCluster key definitions for data cluster reporting2DBNAMETable Namenvarchar300
10ZCLUSTKEY2Actual key information for data cluster reporting2DBNAMETable Namenvarchar300
TOPAddress ManagementBusiness Address
11SADRAddress Management: Company Data37DBNAMEAddresses: System IDnvarchar100
12SADRPAddress Management: Personal Data20DBNAMEAddresses: System IDnvarchar100
TOPCCMS Database Monitors for Oracle
13DBACUSTTool-Specific Settings for DB241DBNAMEDatabase systemnvarchar100
14DBAERRLook-Up Table for Database Operation Errors1DBNAMEDatabase systemnvarchar100
15DBAFIDLook-Up Table for Database Operations1DBNAMEDatabase systemnvarchar100
16DBAGRPLookup Table Operation Group Tables1DBNAMEDatabase systemnvarchar100
17DBATIDLookup Table for Database Tasks1DBNAMEDatabase systemnvarchar100
18DBATRIALLook-Up Tables for Database Sub-Operations1DBNAMEDatabase systemnvarchar100
TOPClinical System
19N1ANFTYPIS-H*MED: Request Type26DBNAMEDatabase Name for the Graphical F4-Helpnvarchar800
TOPDatabase Interface, Database Platforms
20DBA_DBH_COLL_CFGDBA-DBH: Collector Configuration6DBNAMEDBA Cockpit: Database Namenvarchar1280
TOPDB2 for OS39
21DB2CCDAILYList of TS/IXS needing utility treatment (DSNACCOR Daily)8DBNAMEDatabase namenvarchar80
22DB2CCDAILYXList of TS/IXS needing utility treatment (DSNACCOX Daily)8DBNAMEDatabase namenvarchar80
23DB2CCHOURList of TS/IXS needing utility treatment (DSNACCOR Hourly)8DBNAMEDatabase namenvarchar80
24DB2COPYIDB2 copy information from SYSIBM.SYSCOPY2DBNAMEColumn DBNAME of table SYSIBM.SYSCOPY (DB2 on OS/390)nvarchar80
25DB2DB02IXDYNTx DB02: Dynamics of the size of indexes4DBNAMEDatabase namenvarchar80
26DB2DB02IXSIZETx DB02: List of indexspace datasets6DBNAMEDatabase namenvarchar80
27DB2DB02IX_SUMTx DB02: Summary of Index info. Partitions are summed up5DBNAMEDatabase namenvarchar80
28DB2DB02TBDYNTx DB02: Dynamics of the size of tables3DBNAMEDatabase namenvarchar80
29DB2DB02TBSIZETransaction DB02: List of tables and tablespace (Details)6DBNAMEDatabase namenvarchar80
30DB2DB02TBTOPGROWTx DB02: Top Twenty of table growth for fast access3DBNAMEDatabase namenvarchar80
31DB2DB02TSDYNTx DB02: Dynamics of the size of tablespaces1DBNAMEDatabase namenvarchar80
32DB2DB02TSSIZETransaction DB02: List of tablespace datasets1DBNAMEDatabase namenvarchar80
33DB2DB02TS_HISTx DB02: Short history of TS info2DBNAMEDatabase namenvarchar80
34DB2DB02TS_SUMTx DB02: Summary of TS info. Partitions are summed up1DBNAMEDatabase namenvarchar80
35DB2IXBACKList of indexes that need a backup18DBNAMEDatabase namenvarchar80
36DB2NORUNExclude table spaces from RUNSTATS ALL1DBNAMEDatabase namenvarchar80
37DB2REOTSREORG of Tablespaces1DBNAMEDatabase namenvarchar80
38DB2TSBACKList of tablespaces that need a backup23DBNAMEDatabase namenvarchar80
39DB2TSSIZE_TDB2/390: Storage Information on R/3 Tablespaces2DBNAMEDatabase namenvarchar80
40DD02DB2DB2/390: Table Parameters6DBNAMEnvarchar80
TOPDB2 Universal Database for UNIX NT
41DB6CSTRACEDB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace)2DBNAMEnvarchar160
TOPLogical DB, Selection Screens, Selection Variants
42TLDBABAP: Directory and Structure of Logical Databases1DBNAMECHAR02 data element for SYSTnvarchar20
43TLDBTSystem Table TLDBT2DBNAMECHAR02 data element for SYSTnvarchar20
TOPMaxDB
44DBANBuffer for dban_state4DBNAMEText Fieldnvarchar500
45SDBDBMRFCSAP DB: DBMRFC Control Table3DBNAMESAP DB: DBNamenvarchar180
46SDBDBMRFC2SAP DB: Current DBMRFC Sessions5DBNAMESAP DB: DBNamenvarchar180
47SDBPAHISAP DB: Parameter History4DBNAMESAP DB: DBNamenvarchar180
TOPRecycling Administration Core Functions
48J_7LSADRAddress Management: Company Data37DBNAMEAddresses: System IDnvarchar100