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

23 columns | Print definition?ERP 6.0  | DTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/SQLHISTSQL Monitor: Delta records for top SQL statements37DTIMEnvarchar60
2/SDF/SQLTOPSQL Monitor: Top Statements37DTIMEnvarchar60
3/SDF/ZQLMDSQL Monitor: Data29DTIMETime for Runtime Monitor data entrynvarchar60
4ANONYMIZATIONDStatus Table for Deanonymization5DTIMELast changed atnvarchar60
5SQLMDSQL Monitor: Data29DTIMETime for Runtime Monitor data entrynvarchar60
6SQLMHCDSQL Monitor: Data30DTIMETime for Runtime Monitor data entrynvarchar60
7SQLMSHCDSQL Monitor: Data / Request31DTIMETime for Runtime Monitor data entrynvarchar60
8SRTMP_DATARuntime Monitoring: Data Table7DTIMETime for Runtime Monitor data entrynvarchar60
TOPBasis Components
9/SSF/DHEADService Software Framework: Analysis/download control header22DTIMEnvarchar60
TOPBelgium
10T5BSDSI Declaration: directory table12DTIMEnvarchar60
TOPContract Accounts Receivable and Payable
11IST000CService Data Distribution for Telecommunications Component4DTIMEIST: Period to Key Date for Deletion of Services [Days]nvarchar40
TOPData Retention Tool
12TXX_ADMI_VWDART Administration: Tax View File17DTIMEDeletion Timenvarchar60
TOPGeneral Functions
13/PTGWFI/F_DELINVDeleted / Cancelled invoice log table8DTIMEDelete timenvarchar60
TOPGeneral Ledger Accounting
14FAGL_CUST_DETCustomizing Versions: Detailed Information10DTIMETimenvarchar60
TOPLocal Currency Changeover
15EWUCLSTATEMU Cnv: Status Table for Conversion with Clusters21DTIMEEMU conversion: Program net runtime for a restart in secondsint100
TOPPurchasing
16WDFR_DISPPerishables Planning Header69DTIMESchedule-line interval (days)smallint50
17WDFR_POSPerishables Planninng Item247DTIMESchedule-line interval (days)smallint50
TOPSyntax, Compiler, Runtime
18SRTM_DAABRuntime Monitoring: Data Table5DTIMETime for Runtime Monitor data entrynvarchar60
19SRTM_DATARuntime Monitoring: Data Table5DTIMETime for Runtime Monitor data entrynvarchar60
20SRTM_DATAXRuntime Monitoring: Data Table for Hexadecimal Strings5DTIMETime for Runtime Monitor data entrynvarchar60
TOPWorkbench Tools Editors, Painters, Modelers
21COVTKEYDELCoverage Analyzer: Recreate Locked Test Groups3DTIMESystem Timenvarchar60
TOPWorkbench Utilities
22FLIGHTMFlight master data4DTIMEDeparture/Arrival timenvarchar60
23FLLOGFlight data4DTIMEDeparture Timenvarchar60