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 :: Customizing :: Customizing Tools Techniques :: Cross-System Tools
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CMP_RUNS261Comparisons (will be deleted)Cross-System Tools
SQL:  selectupdate insert create

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

SELECT CMP_RUN, CMP_VIEW, CMP_DATES, CMP_TIMES, CMP_DATEE, CMP_TIMEE, VIEWNAME, MASTERNAME, CLUSTITEM, OBJ_TYPE, TR_TYPE, VARIANT, VIEW_TABLE, CLIDEP, NBR_ALL_L, NBR_ONLY_L, NBR_UPD, NBR_EQU, NBR_R_EQU, NBR_ONLY_R, NBR_ALL_R, NBR_ADJUPD, NBR_ADJINS, NBR_ADJDEL, CMP_FLAG, SM30_FLAG FROM CMP_RUNS
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CMP_RUNR/2 tablenvarchar50 Allow NULL? 
2CMP_VIEWName of SAP table viewnvarchar300 Allow NULL? 
3CMP_DATESDate of Last Changenvarchar80 Allow NULL? 
4CMP_TIMESStart time of activitynvarchar60 Allow NULL? 
5CMP_DATEEDate of Last Changenvarchar80 Allow NULL? 
6CMP_TIMEEStart time of activitynvarchar60 Allow NULL? 
7VIEWNAMEName of SAP table viewnvarchar300 Allow NULL? 
8MASTERNAMEName of SAP table viewnvarchar300 Allow NULL? 
9CLUSTITEMName of SAP table viewnvarchar300 Allow NULL? 
10OBJ_TYPEObject typechar10 Allow NULL? 
11TR_TYPEObject Typenvarchar40 Allow NULL? 
12VARIANTextended table maintenance: Name of a selection variantnvarchar140 Allow NULL? 
13VIEW_TABLEFlag (X or Blank)char10 Allow NULL? 
14CLIDEPFlag indicating client-specific entrieschar10 Allow NULL? 
15NBR_ALL_LNumber of table entriesint100 Allow NULL? 
16NBR_ONLY_LNumber of table entriesint100 Allow NULL? 
17NBR_UPDNumber of table entriesint100 Allow NULL? 
18NBR_EQUNumber of table entriesint100 Allow NULL? 
19NBR_R_EQUNumber of table entriesint100 Allow NULL? 
20NBR_ONLY_RNumber of table entriesint100 Allow NULL? 
21NBR_ALL_RNumber of table entriesint100 Allow NULL? 
22NBR_ADJUPDNumber of table entriesint100 Allow NULL? 
23NBR_ADJINSNumber of table entriesint100 Allow NULL? 
24NBR_ADJDELNumber of table entriesint100 Allow NULL? 
25CMP_FLAGVersion Number Componentnvarchar20 Allow NULL? 
26SM30_FLAGFlag (X or Blank)char10 Allow NULL? 
NamePrimaryUniqueTypeColumns
CMP_RUNS~0YesYesCLUSTEREDCMP_TIMES, CMP_DATES, CMP_VIEW, CMP_RUN