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

61 columns | Print definition?ERP 6.0  | INST_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1STFUTRACEORATrace Switch for Oracle2INST_IDint100
TOPFunctions for U.S. Federal Government
2FMRES_INST_HISTLog of all installments created6INST_IDInstallment Identifiernvarchar100
TOPOnline Correction Support Support Package and Add-On Tools
3STACKCOMPSSoftware Components in Software (SP) Stack2INST_IDPPMS - General IDnvarchar200
TOPOracle Database Monitors
4GVD_CURR_BLKSRVcopy of gv$current_block_server2INST_IDOracle monitor: Instance IDdecimal220
5GVD_INSTANCECopy of GV$INSTANCE2INST_IDOracle monitor: Instance IDdecimal220
6GVD_MANGD_STANBYcopy of GV$MANAGED_STANDBY (currently not provided w. snaps)2INST_IDOracle monitor: Instance IDdecimal220
7GVD_SPPARAMETEROracle Monitoring: Copy of GV$SPPARAMETER2INST_IDOracle monitor: Instance IDdecimal220
TOPPerformance Monitors TCC
8GVD_BGPROCESSOracle monitoring: Copy of GV$BGPROCESS2INST_IDOracle monitor: Instance IDdecimal220
9GVD_BUFF_POOL_STOracle Monitoring: Copy of gv$buffer_pool_statistics2INST_IDOracle monitor: Instance IDdecimal220
10GVD_DATABASECopy of GV$DATABASE (currently not provided with snapshots)2INST_IDOracle monitor: Instance IDdecimal220
11GVD_DATAFILECopy of GV$DATAFILE2INST_IDOracle monitor: Instance IDdecimal220
12GVD_DATAGUARD_STCopy of GV$DATAGUARD_STATUS2INST_IDOracle monitor: Instance IDdecimal220
13GVD_DB_CACHE_ADVCopy of GV$DB_CACHE_ADVICE (currently not provided w. snaps)2INST_IDOracle monitor: Instance IDdecimal220
14GVD_ENQUEUE_STATCopy of GV$ENQUEUE_STAT2INST_IDOracle monitor: Instance IDdecimal220
15GVD_FILESTATCopy of GV$FILESTAT2INST_IDOracle monitor: Instance IDdecimal220
16GVD_LATCHCopy of GV$LATCH2INST_IDOracle monitor: Instance IDdecimal220
17GVD_LATCHCHILDSCopy of GV$LATCH_CHILDREN2INST_IDOracle monitor: Instance IDdecimal220
18GVD_LATCHHOLDERCopy of GV$LATCHHOLDER (currently not provided with snapsh)2INST_IDOracle monitor: Instance IDdecimal220
19GVD_LATCHNAMECopy of GV$LATCHNAME (currently not provided with snapshots)2INST_IDOracle monitor: Instance IDdecimal220
20GVD_LATCH_MISSESCopy of GV$LATCH_MISSES2INST_IDOracle monitor: Instance IDdecimal220
21GVD_LATCH_PARENTCopy of GV$LATCH_PARENT (currently not provided with snaps)2INST_IDOracle monitor: Instance IDdecimal220
22GVD_LIBRARYCACHEOracle monitoring: Copy of GV$LIBRARYCACHE2INST_IDOracle monitor: Instance IDdecimal220
23GVD_LOCKCopy of GV$LOCK2INST_IDOracle monitor: Instance IDdecimal220
24GVD_LOCKED_OBJECCopy of GV$LOCKED_OBJECT2INST_IDOracle monitor: Instance IDdecimal220
25GVD_LOCK_ACTIVTYCopy of GV$LOCK_ACTIVITY2INST_IDOracle monitor: Instance IDdecimal220
26GVD_LOGFILEOracle monitoring: Copy of GV$LOGFILE2INST_IDOracle monitor: Instance IDdecimal220
27GVD_OBJECT_DEPENOracle monitoring: copy of GV$OBJECT_DEPENDENCY2INST_IDOracle monitor: Instance IDdecimal220
28GVD_PARAMETERCopy of GV$PARAMETER2INST_IDOracle monitor: Instance IDdecimal220
29GVD_PARAMETER2Copy of GV$PARAMETER2 (currently not provided with snapshot2INST_IDOracle monitor: Instance IDdecimal220
30GVD_PGASTATCopy of GV$PGASTAT2INST_IDOracle monitor: Instance IDdecimal220
31GVD_PGA_TARGET_ACopy of GV$PGA_TARGET_ADVICE2INST_IDOracle monitor: Instance IDdecimal220
32GVD_PGA_TARGET_HCopy of GV$PGA_TARGET_ADVICE_HISTOGRAM2INST_IDOracle monitor: Instance IDdecimal220
33GVD_PROCESSCopy of GV$PROCESS2INST_IDOracle monitor: Instance IDdecimal220
34GVD_PX_SESSIONOracle monitoring: Copy of GV$PX_SESSION2INST_IDOracle monitor: Instance IDdecimal220
35GVD_ROWCACHEOracle monitoring: Copy of GV$ROWCACHE2INST_IDOracle monitor: Instance IDdecimal220
36GVD_SEGMENT_STATCopy of GV$SEGMENT_STATISTICS (curr. not provided w. snaps)2INST_IDOracle monitor: Instance IDdecimal220
37GVD_SEGSTATOracle monitoring: Copy of GV$SEGSTAT2INST_IDOracle monitor: Instance IDdecimal220
38GVD_SESSIONOracle monitoring: Snapshot table for GV$SESSION2INST_IDOracle monitor: Instance IDdecimal220
39GVD_SESSION_EVTOracle monitoring: copy of GV$SESSION_EVENT2INST_IDOracle monitor: Instance IDdecimal220
40GVD_SESSION_WAITOracle monitoring: Copy of GV$SESSION_WAIT2INST_IDOracle monitor: Instance IDdecimal220
41GVD_SESSTATSnapshot table for GV$SESSTAT (curr. not provided w. snaps)2INST_IDOracle monitor: Instance IDdecimal220
42GVD_SESS_IOCopy of GV$SESS_IO (currently not provided with snapshots)2INST_IDOracle monitor: Instance IDdecimal220
43GVD_SGAOracle monitoring: Snapshot table for GV$SGA2INST_IDOracle monitor: Instance IDdecimal220
44GVD_SGACURRRESIZOracle monitoring: Snapshot table for GV$SGA_CURRENT_RESIZE2INST_IDOracle monitor: Instance IDdecimal220
45GVD_SGADYNCOMPOracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON2INST_IDOracle monitor: Instance IDdecimal220
46GVD_SGADYNFREEOracle monitoring: Snapshot table for GV$SGA_DYNAMIC_FREE_M2INST_IDOracle monitor: Instance IDdecimal220
47GVD_SGARESIZEOPSOracle Monitoring: Copy of GV$SGA_RESIZE_OPS2INST_IDOracle monitor: Instance IDdecimal220
48GVD_SGASTATOracle monitoring: Snapshot table for GV$SGASTAT2INST_IDOracle monitor: Instance IDdecimal220
49GVD_SHAR_P_ADVOracle Monitoring: Copy of gv$shared_pool_advice2INST_IDOracle monitor: Instance IDdecimal220
50GVD_SQLCopy of GV$SQL (currently not provided with snapshots)2INST_IDOracle monitor: Instance IDdecimal220
51GVD_SQLAREACopy of GV$SQLAREA (currently not provided with snapshots)2INST_IDOracle monitor: Instance IDdecimal220
52GVD_SQLTEXTCopy of GV$SQLTEXT (currently not provided with snapshots)2INST_IDOracle monitor: Instance IDdecimal220
53GVD_SQL_WA_ACTIVOracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE2INST_IDOracle monitor: Instance IDdecimal220
54GVD_SQL_WA_HISTOOracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM2INST_IDOracle monitor: Instance IDdecimal220
55GVD_SQL_WORKAREAOracle Monitoring: Copy of GV$SQL_WORKAREA2INST_IDOracle monitor: Instance IDdecimal220
56GVD_SYSSTATCopy of GV$SYSTAT2INST_IDOracle monitor: Instance IDdecimal220
57GVD_SYSTEM_EVENTCopy of GVSSYSTEM_EVENT2INST_IDOracle monitor: Instance IDdecimal220
58GVD_TEMPFILECopy of GV$TEMPFILE2INST_IDOracle monitor: Instance IDdecimal220
59GVD_UNDOSTATOracle monitoring: copy of GV$UNDOSTAT2INST_IDOracle monitor: Instance IDdecimal220
60GVD_WAITSTATOracle Monitoring: Copy of GV$WAITSTAT2INST_IDOracle monitor: Instance IDdecimal220
61ORA_SAPKCBFWAITCopy of SAP$KCBFWAIT3INST_IDOracle monitor: Instance IDdecimal220