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
Basis Components :: Use Subcomponents :: Monitoring
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ALPFCOLLREORGSCH571Collection/Reorganization Schemata for PerfDBMonitoring
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT POLICYID, MIN_DAY_K, MIN_DAY_D, MIN_WEEK_K, MIN_WEEK_D, MIN_XDAY_K, MIN_XDAY_D, MIN_MONTH_K, MIN_MONTH_D, MIN_QUART_K, MIN_QUART_D, MIN_YEAR_K, MIN_YEAR_D, QTR_DAY_K, QTR_DAY_D, QTR_WEEK_K, QTR_WEEK_D, QTR_XDAY_K, QTR_XDAY_D, QTR_MONTH_K, QTR_MONTH_D, QTR_QUART_K, QTR_QUART_D, QTR_YEAR_K, QTR_YEAR_D, HR_DAY_K, HR_DAY_D, HR_WEEK_K, HR_WEEK_D, HR_XDAY_K, HR_XDAY_D, HR_MONTH_K, HR_MONTH_D, HR_QUART_K, HR_QUART_D, HR_YEAR_K, HR_YEAR_D, DAY_DAY_K, DAY_DAY_D, DAY_WEEK_K, DAY_WEEK_D, DAY_XDAY_K, DAY_XDAY_D, DAY_MONTH_K, DAY_MONTH_D, DAY_QUART_K, DAY_QUART_D, DAY_YEAR_K, DAY_YEAR_D, X_VALUE, COLLPERIOD, AVGMETHOD, WEIGHTSCHEM, SFTNAME, COLL_METHOD, COLL_TIMEZONE, REORG_TIMEZONE FROM ALPFCOLLREORGSCH
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1POLICYIDName of a CPH Collection and Reorganization Schemanvarchar400 Allow NULL? 
2MIN_DAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
3MIN_DAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
4MIN_WEEK_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
5MIN_WEEK_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
6MIN_XDAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
7MIN_XDAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
8MIN_MONTH_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
9MIN_MONTH_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
10MIN_QUART_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
11MIN_QUART_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
12MIN_YEAR_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
13MIN_YEAR_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
14QTR_DAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
15QTR_DAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
16QTR_WEEK_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
17QTR_WEEK_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
18QTR_XDAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
19QTR_XDAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
20QTR_MONTH_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
21QTR_MONTH_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
22QTR_QUART_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
23QTR_QUART_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
24QTR_YEAR_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
25QTR_YEAR_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
26HR_DAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
27HR_DAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
28HR_WEEK_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
29HR_WEEK_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
30HR_XDAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
31HR_XDAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
32HR_MONTH_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
33HR_MONTH_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
34HR_QUART_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
35HR_QUART_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
36HR_YEAR_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
37HR_YEAR_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
38DAY_DAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
39DAY_DAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
40DAY_WEEK_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
41DAY_WEEK_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
42DAY_XDAY_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
43DAY_XDAY_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
44DAY_MONTH_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
45DAY_MONTH_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
46DAY_QUART_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
47DAY_QUART_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
48DAY_YEAR_KKeep Value for PerfDB Reorganizationint100 Allow NULL? 
49DAY_YEAR_DDelete Value for PerfDB Reorganizationint100 Allow NULL? 
50X_VALUENatural Numberint100 Allow NULL? 
51COLLPERIODAlert: integer used in performance DBint100 Allow NULL? 
52AVGMETHODAlert: type of averagenvarchar40 Allow NULL? 
53WEIGHTSCHEMName of a CPH Collection and Reorganization Schemanvarchar400 Allow NULL? 
54SFTNAMEName of a CPH Collection and Reorganization Schemanvarchar400 Allow NULL? 
55COLL_METHODSingle-Character Indicatorchar10 Allow NULL? 
56COLL_TIMEZONETime Zonenvarchar60 Allow NULL? 
57REORG_TIMEZONETime Zonenvarchar60 Allow NULL? 
NamePrimaryUniqueTypeColumns
ALPFCOLLREORGSCH~0YesYesCLUSTEREDPOLICYID