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
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal
Basis Components :: Musing Tools :: Personal Object Worklist
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0POWL_EASY_HDR101Definition for Easy-POWL FeederPersonal Object Worklist
SQL:  selectupdate insert create

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

SELECT FEEDER_CLASS, POWL_TYPE, HELPER_CLASS, TABLE_TYPE, KEY_FIELD, DETAIL_WD_COMP, NUM_COLUMNS, NUM_ROWS, APPEND_COLUMNS, FIX_KEY_FIELD FROM POWL_EASY_HDR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1FEEDER_CLASSEasy-POWL Feeder Classnvarchar300CHAR(N' ')NoSEOMETARELPOWL_EASY_FEEDER_TY Allow NULL? 
2POWL_TYPEPOWL-Typenvarchar300CHAR(N' ')NoPOWL_TYPEPOWL_EASY_TYPE_TY Allow NULL? 
3HELPER_CLASSName of the class implementing IF_POWL_EASY_FEEDERnvarchar300CHAR(N' ')YesSEOMETARELPOWL_EASY_HELPER_CLASS_TY Allow NULL? 
4TABLE_TYPEName of the Table Type holding the POWL Datanvarchar300CHAR(N' ')Yes*POWL_EASY_TABLE_TYPE_TY Allow NULL? 
5KEY_FIELDName of the Field(s) uniquely identifying a Table Linenvarchar600CHAR(N' ')YesPOWL_EASY_KEY_FIELD_TY Allow NULL? 
6DETAIL_WD_COMPName of the WebDynpro Component used for POWL-Detail screennvarchar300CHAR(N' ')YesPOWL_EASY_DETAIL_WD_COMP_TY Allow NULL? 
7NUM_COLUMNSNumber of Columns that are visible by defaultint100INT4((0))YesPOWL_EASY_NUM_COLUMNS_TY Allow NULL? 
8NUM_ROWSNumber of Rows that are visible by defaultint100INT4((0))YesPOWL_EASY_NUM_ROWS_TY Allow NULL? 
9APPEND_COLUMNSSpecifies how unlisted Structure Fields are handledchar10CHAR(N' ')YesPOWL_EASY_APPEND_COLUMNS_TY Allow NULL? 
10FIX_KEY_FIELDKey fields are fixed and can not be scrolledchar10CHAR(N' ')YesPOWL_EASY_FIX_KEY_FIELD_TY Allow NULL? 
NamePrimaryUniqueTypeColumns
POWL_EASY_HDR~0YesYesCLUSTEREDPOWL_TYPE, FEEDER_CLASS