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

50 columns | Print definition?ERP 6.0  | DDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/SQLHISTSQL Monitor: Delta records for top SQL statements36DDATEnvarchar80
2/SDF/SQLTOPSQL Monitor: Top Statements36DDATEnvarchar80
3/SDF/ZQLMDSQL Monitor: Data28DDATEDate for Runtime Monitor DATA entrynvarchar80
4ANONYMIZATIONDStatus Table for Deanonymization4DDATEDate of Last Changenvarchar80
5FAGL_GCDVC_VERGCD Revision: Value of Items6DDATEDate of GCD Datanvarchar80
6FAGL_GCDVC_XBRLGCD-Structure: Value of Items4DDATEField of type DATSnvarchar80
7P08P1CLDCLASS Interface Clear-down Parameter File5DDATECLASS CPX INTERFACE Delete Snapshot Obsolete Datenvarchar80
8P2RN_PRAPPension Return8DDATEDate of Deathnvarchar80
9PA3257HR Master Record: Infotype 3257 (Leave Passage UAE)24DDATEAccrual Start Datenvarchar80
10PA3259HR Master Record: Infotype 325924DDATEAccrual Start Datenvarchar80
11PA3308HR Master Record: Infotype 330824DDATEAccrual Start Datenvarchar80
12PA3353HR Master Record: Infotype 335324DDATEAccrual Start Datenvarchar80
13PA3357HR Master Record: Infotype 335724DDATEAccrual Start Datenvarchar80
14PA3369HR Master Record: Infotype 336924DDATEAccrual Start Datenvarchar80
15PA3370HR Master Record: Infotype 337024DDATEAccrual Start Datenvarchar80
16PB3257Applicant data infotype 3257 (model)24DDATEAccrual Start Datenvarchar80
17PB3259Applicant data infotype 3259 (model)24DDATEAccrual Start Datenvarchar80
18PB3308Applicant data infotype 3308 (model)24DDATEAccrual Start Datenvarchar80
19SQLMDSQL Monitor: Data28DDATEDate for Runtime Monitor DATA entrynvarchar80
20SQLMHCDSQL Monitor: Data29DDATEDate for Runtime Monitor DATA entrynvarchar80
21SQLMSHCDSQL Monitor: Data / Request30DDATEDate for Runtime Monitor DATA entrynvarchar80
22SRTMP_DATARuntime Monitoring: Data Table6DDATEDate for Runtime Monitor DATA entrynvarchar80
TOPAccounting - General
23TFC_INSTANCEInstances of a Profile4DDATESystem Datenvarchar80
TOPBasis Components
24/SSF/DHEADService Software Framework: Analysis/download control header21DDATEnvarchar80
TOPBelgium
25T5BSDSI Declaration: directory table11DDATERejection date SI declarationnvarchar80
TOPConsumption-Based Planning See Also PP-MRP
26MDRDDelivery Relationships: Recipients per Plant and Material7DDATEDelivery Relationship: Determination Datenvarchar80
27MDRD_EXTWGDelivery Relationships: Recipients per Plant and Material7DDATEDelivery Relationship: Determination Datenvarchar80
28WDRDDelivery Relationships: Recipients per Plant and Material7DDATEDelivery Relationship: Determination Datenvarchar80
29WDRD_EXTWGDelivery Relationships: Recipients per Plant and Material7DDATEDelivery Relationship: Determination Datenvarchar80
TOPData Retention Tool
30TXX_ADMI_VWDART Administration: Tax View File16DDATEDeletion Datenvarchar80
TOPGeneral Functions
31/PTGWFI/F_DELINVDeleted / Cancelled invoice log table7DDATEDelete datenvarchar80
TOPGeneral Ledger Accounting
32FAGL_CUST_DETCustomizing Versions: Detailed Information9DDATEDatenvarchar80
TOPI18N Unicode
33UM4PMDIIAdditional Information for UMGPMIC5DDATEnvarchar80
34UMGPMDIIAdditional Information for UMGPMIC5DDATESystem Datenvarchar80
TOPJust-In-Time Processing
35JITITComponents Group15DDATEActual Time of Shippingdecimal150
TOPLocalization
36J_3RSEXTRACTDExctract details (obsolete)12DDATEDelivery datenvarchar80
TOPReporting
37P05TPRNL_EE_PDPension Return: Personal Data - Pers Level19DDATEDate of Deathnvarchar80
TOPSales and Distribution
38J_1USEXTRACTDEXTRACTD12DDATEnvarchar80
TOPSyntax, Compiler, Runtime
39SRTM_DAABRuntime Monitoring: Data Table4DDATEDate for Runtime Monitor DATA entrynvarchar80
40SRTM_DATARuntime Monitoring: Data Table4DDATEDate for Runtime Monitor DATA entrynvarchar80
41SRTM_DATAXRuntime Monitoring: Data Table for Hexadecimal Strings4DDATEDate for Runtime Monitor DATA entrynvarchar80
TOPTask Resource Management
42LLGRHRequest log15DDATERequest Due Datedecimal150
43LRQSHRequest7DDATERequest Due Datedecimal150
44LTKPLTask pool10DDATETask Due Datedecimal150
TOPTreasury
45VTB_MARKETDatafeed: Market data20DDATEDatafeed: Value date in SAP formatnvarchar80
46VTB_MARKET_TDatafeed: Temporary market data copy for workflow20DDATEDatafeed: Value date in SAP formatnvarchar80
TOPUSA
47T5UGJPrint Request of Notification Letters4DDATEDate for data selectionnvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
48COVDATVOLCoverage Analyzer: Data Volume Monitor1DDATEDatenvarchar80
49COVRES0Temporary Storage for Coverage Results3DDATESystem Datenvarchar80
50COVTKEYDELCoverage Analyzer: Recreate Locked Test Groups2DDATESystem Datenvarchar80