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

56 columns | Print definition?ERP 6.0  | DBSYS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/BC_INFOBasis information9DBSYSName of operating systemnvarchar100
2CNVMBTSHELLRELShell Creation: Released Database SAP Release Combinations1DBSYSDatabase system of Shell Systemnvarchar100
3CNVPERFDATATable for database performance11DBSYSCentral Database Systemnvarchar100
4CNVTDMS_13_RELTDMS: Released Database SAP Release Combinations1DBSYSName of database systemnvarchar100
5DBA_ALRT_METDBA: Alerting Metrics25DBSYSCentral Database Systemnvarchar100
6DBA_ALRT_MET_CDBA: Alerting Metric Components20DBSYSCentral Database Systemnvarchar100
7DBA_ALRT_MET_RDBA: Alerting Metrics Rules11DBSYSCentral Database Systemnvarchar100
8DBA_CHK_IMPACTSDBA-CHK: Check Impact1DBSYSDatabase systemnvarchar30
9DBA_GEN_DYNDBA Cockpit: Dynpro Numbers for Generated Screens1DBSYSDatabase systemnvarchar30
10DBA_XCHG_DATADBA Cockpit: Exchange Data for Action Controllers5DBSYSCentral Database Systemnvarchar100
11DDDBFUNCDD: Creation/Transport of Database Functions2DBSYS3-place identifier for databasenvarchar30
12DDDBSTMTHDDD: Information on DB Statements2DBSYSCentral Database Systemnvarchar100
13DDDBSTMTPARDD: Parameters for Generation of Database Statements1DBSYSCentral Database Systemnvarchar100
14DDDBSTMTUCINFODD: Unicode-Relevance for Generating Database Statements1DBSYSCentral Database Systemnvarchar100
15IUUC_SPC_PROCOPTdefine field-content-specific trigger behaviour (freeze/delt3DBSYSCentral Database Systemnvarchar100
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
16DBDIFFDefinition of (Intended) Differences Between DD and DB2DBSYSDatabase system namenvarchar100
17DBDIFFINFOFurther Info on DBDIFF (Differences between DD and DB)2DBSYSDatabase system namenvarchar100
18SYSTABSTMTContains SQL Statements for Change of Nametab2DBSYS3-Byte fieldnvarchar30
19UTCMPVerification Table for Decider in DD_DECIDE10DBSYSCentral Database Systemnvarchar100
TOPCATT Computer Aided Test Tool
20CATKCATT: Log Process Data20DBSYSCentral Database Systemnvarchar100
TOPCCMS Database Monitors for Oracle
21SDBACDBA Action Table2DBSYSDatabase System for DBAnvarchar100
TOPClient Copy
22CCDBCHECKDatabase without OPEN CURSOR WITH HOLD1DBSYSCentral Database Systemnvarchar100
TOPData Staging
23RSDBSESPARLOCAL Database Parameters for BW that1DBSYSCentral Database Systemnvarchar100
TOPDatabase Interface, Database Platforms
24DB6NAVSYSTDB6: System Registration Table10DBSYSDatabase systemnvarchar30
25DBA_CONFIGDBA Cockpit: Monitoring Settings2DBSYSCentral Database Systemnvarchar100
26DBA_DBH_CATEGORYDBA-DBH: Category for Web Templates2DBSYSDatabase systemnvarchar30
27DBA_DBH_COLL_CFGDBA-DBH: Collector Configuration3DBSYSDatabase systemnvarchar30
28DBA_DBH_REPORTDBA-DBH: Web Reports3DBSYSDatabase systemnvarchar30
29DBA_DBH_SRV_DBSLDBA-DBH: Application Servers and installed DBSL2DBSYSDatabase systemnvarchar30
30DBA_DBH_TPLDBA-DBH: Collector Template2DBSYSDatabase systemnvarchar30
31MIGREXTABException Table for DDL Generation3DBSYSCharacter field, 8 characters longnvarchar80
32SDBAC_DATADB13: DBA Action Table - Configuration Data Part2DBSYSDatabase System for DBAnvarchar100
33SDBAC_PATDB13: List of proposed actions1DBSYSDatabase System for DBAnvarchar100
34SDBAC_RECRecurrence of DBA action1DBSYSDatabase System for DBAnvarchar100
35SDBAC_TEXTDB13: DBA Action Table - Language Dependent Part2DBSYSDatabase System for DBAnvarchar100
36SDBAC_VARDB13: Pattern Variants1DBSYSDatabase System for DBAnvarchar100
TOPDB2 for OS39
37DB2DB02SUMMARYTx DB02: Summary information on first screenincl. size histo3DBSYSCentral Database Systemnvarchar100
TOPF4 Help
38DD97SStatements for Trigger and Stored Procedures3DBSYS3-place identifier for databasenvarchar30
TOPMessages
39DNOD_NOTIF_SNotification: SAP Support Data10DBSYSDatabase System with Versionnvarchar300
TOPMonitoring
40SCSM_MONSYS_BUFBuffer Table ALSYSTEM7DBSYSOperating System of Application Servernvarchar100
TOPProfitability Analysis
41TKETRNDCO-PA: Fast rollup of summ. levels: DBMS-spec. parameters1DBSYSCentral Database Systemnvarchar100
TOPQuality Notifications
42/SAPSMOSS/DBSYDatabases2DBSYSDatabase systemnvarchar100
43/SAPSMOSS/DBSYTTexts for Databases3DBSYSDatabase systemnvarchar100
44/SAPSMOSS/INSTNTable of Installation Numbers4DBSYSDatabase systemnvarchar100
TOPQuantity optimizing
45WLC_SELOPT_ENTRYLoad Control/Ext. Parallel Processing: Entries in SelectOpt.1DBSYSDatabasenvarchar100
TOPService Data Download
46/BDL/BDLFUVERSService Definition, Definition of all versions of a Logfun12DBSYSSYSTEM: Datenbanksystemnvarchar100
47/SDF/CMOJOBSBDL: Planned Jobs to be analyzed8DBSYSnvarchar100
48/SDF/PERIODICJOBPlanned Periodic Jobs to be analyzed8DBSYSnvarchar100
49BDLFUVERSDefinition of all Versions for one Logical Function11DBSYSSYSTEM: Datenbanksystemnvarchar100
50CMOJOBSBDL: Planned Jobs to be analyzed8DBSYSnvarchar100
TOPTransport Management System
51TMSPCONFTMS tp Profile Manager: Configuration5DBSYStp Database Systemnvarchar30
TOPWithout Description
52RSTT_ERRORError Archive36DBSYSTrace Tool: Char 10 Fieldnvarchar100
53RSTT_LOGRUNArchive for Test Runs13DBSYSTrace Tool: Char 10 Fieldnvarchar100
54RSTT_TESTStore of Existing Test Sequences17DBSYSTrace Tool: Char 10 Fieldnvarchar100
55RSTT_TREQArchive for Test Requests18DBSYSTrace Tool: Char 10 Fieldnvarchar100
56RSTT_TREQSTAStatus Buffer for Test Requests19DBSYSTrace Tool: Char 10 Fieldnvarchar100