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
Cross-Application Components
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_8A3TECHN721technical customizing - Old Version, don't useCross-Application Components
SQL:  selectupdate insert create

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

SELECT MANDT, USR, BEG_RO_120, BEG_CO_120, END_RO_120, END_CO_120, BTN_KO_120, BTN_PO_120, BTN_IN_120, BEG_RO_110, BEG_CO_110, END_RO_110, END_CO_110, VE_OFF_110, VE_POS_110, VE_USE_110, DA_POS_110, DA_USE_110, SZ_POS_110, SZ_USE_110, SZ_FIX_110, USRVON_110, USRBIS_110, BTN_IN_110, BTN_ST_110, BTN_UA_110, BEG_RO_130, BEG_CO_130, END_RO_130, END_CO_130, END_CB_130, BTN_KO_130, BTN_PO_130, BTN_TE_130, BTN_IN_130, SIZEVA_130, BEG_RO_POS, BEG_CO_POS, BEG_RO_100, BEG_CO_100, END_RO_100, END_CO_100, BTN_KO_100, BTN_PO_100, BTN_IN_100, BEG_RO_300, BEG_CO_300, END_RO_300, END_CO_300, BTN_PO_300, BTN_IN_300, BTN_EX_300, BEG_RO_310, BEG_CO_310, END_RO_310, END_CO_310, BTN_PO_310, BTN_IN_310, BEG_RO_320, BEG_CO_320, END_RO_320, END_CO_320, BTN_PO_320, BTN_IN_320, BTN_AL_320, OBJKY_AUTO, OBJBE_AUTO, BEG_CO_111, BEG_RO_111, END_CO_111, END_RO_111, LOGING FROM J_8A3TECHN
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2USRChanged bynvarchar120 Allow NULL? 
3BEG_RO_120begin row - Old Version, don't usenvarchar20 Allow NULL? 
4BEG_CO_120begin column - Old Version, don't usenvarchar20 Allow NULL? 
5END_RO_120end row - Old Version, don't usenvarchar20 Allow NULL? 
6END_CO_120end column - Old Version, don't usenvarchar20 Allow NULL? 
7BTN_KO_120button config - Old Version, don't usechar10 Allow NULL? 
8BTN_PO_120button posit - Old Version, don't usechar10 Allow NULL? 
9BTN_IN_120button info - Old Version, don't usechar10 Allow NULL? 
10BEG_RO_110begin row - Old Version, don't usenvarchar20 Allow NULL? 
11BEG_CO_110begin column - Old Version, don't usenvarchar20 Allow NULL? 
12END_RO_110end row - Old Version, don't usenvarchar20 Allow NULL? 
13END_CO_110end column - Old Version, don't usenvarchar20 Allow NULL? 
14VE_OFF_110switch off presettings - Old Version, don't usechar10 Allow NULL? 
15VE_POS_110position onto last presetting - Old Version, don't usechar10 Allow NULL? 
16VE_USE_110use last Presetting automatically - Old Version, don't usechar10 Allow NULL? 
17DA_POS_110position onto last Document type - Old Version, don't usechar10 Allow NULL? 
18DA_USE_110use last Document type automatically- Old Version, don't usechar10 Allow NULL? 
19SZ_POS_110position onto last Scenario - Old Version, don't usechar10 Allow NULL? 
20SZ_USE_110use last Scenario automatically - Old Version, don't usechar10 Allow NULL? 
21SZ_FIX_110use fix Scenario automatically - Old Version, don't usechar10 Allow NULL? 
22USRVON_110user from - Old Version, don't usechar10 Allow NULL? 
23USRBIS_110user to - Old Version, don't usechar10 Allow NULL? 
24BTN_IN_110button info - Old Version, don't usechar10 Allow NULL? 
25BTN_ST_110button 'Reset to Defaultsettings' - Old Version, don't usechar10 Allow NULL? 
26BTN_UA_110button User link to 'All' - Old Version, don't usechar10 Allow NULL? 
27BEG_RO_130begin row - Old Version, don't usenvarchar20 Allow NULL? 
28BEG_CO_130begin column - Old Version, don't usenvarchar20 Allow NULL? 
29END_RO_130end row - Old Version, don't usenvarchar20 Allow NULL? 
30END_CO_130end column - Old Version, don't usenvarchar20 Allow NULL? 
31END_CB_130end column big - Old Version, don't usenvarchar20 Allow NULL? 
32BTN_KO_130button config - Old Version, don't usechar10 Allow NULL? 
33BTN_PO_130button posit - Old Version, don't usechar10 Allow NULL? 
34BTN_TE_130button show technical settings - Old Version, don't usechar10 Allow NULL? 
35BTN_IN_130button info - Old Version, don't usechar10 Allow NULL? 
36SIZEVA_130permit big window - Old Version, don't usechar10 Allow NULL? 
37BEG_RO_POSbegin row - Old Version, don't usenvarchar20 Allow NULL? 
38BEG_CO_POSbegin column - Old Version, don't usenvarchar20 Allow NULL? 
39BEG_RO_100begin row - Old Version, don't usenvarchar20 Allow NULL? 
40BEG_CO_100begin column - Old Version, don't usenvarchar20 Allow NULL? 
41END_RO_100end row - Old Version, don't usenvarchar20 Allow NULL? 
42END_CO_100end column - Old Version, don't usenvarchar20 Allow NULL? 
43BTN_KO_100button config - Old Version, don't usechar10 Allow NULL? 
44BTN_PO_100button posit - Old Version, don't usechar10 Allow NULL? 
45BTN_IN_100button info - Old Version, don't usechar10 Allow NULL? 
46BEG_RO_300begin row - Old Version, don't usenvarchar20 Allow NULL? 
47BEG_CO_300begin column - Old Version, don't usenvarchar20 Allow NULL? 
48END_RO_300end row - Old Version, don't usenvarchar20 Allow NULL? 
49END_CO_300end column - Old Version, don't usenvarchar20 Allow NULL? 
50BTN_PO_300button posit - Old Version, don't usechar10 Allow NULL? 
51BTN_IN_300button info - Old Version, don't usechar10 Allow NULL? 
52BTN_EX_300button extended search at ODMA-Selec- Old Version, don't usechar10 Allow NULL? 
53BEG_RO_310begin row - Old Version, don't usenvarchar20 Allow NULL? 
54BEG_CO_310begin column - Old Version, don't usenvarchar20 Allow NULL? 
55END_RO_310end row - Old Version, don't usenvarchar20 Allow NULL? 
56END_CO_310end column - Old Version, don't usenvarchar20 Allow NULL? 
57BTN_PO_310button posit - Old Version, don't usechar10 Allow NULL? 
58BTN_IN_310button info - Old Version, don't usechar10 Allow NULL? 
59BEG_RO_320begin row - Old Version, don't usenvarchar20 Allow NULL? 
60BEG_CO_320begin column - Old Version, don't usenvarchar20 Allow NULL? 
61END_RO_320end row - Old Version, don't usenvarchar20 Allow NULL? 
62END_CO_320end column - Old Version, don't usenvarchar20 Allow NULL? 
63BTN_PO_320button posit - Old Version, don't usechar10 Allow NULL? 
64BTN_IN_320button info - Old Version, don't usechar10 Allow NULL? 
65BTN_AL_320button All documents at ODMA-Select - Old Version, don't usechar10 Allow NULL? 
66OBJKY_AUTOselect objectkey automatically - Old Version, don't usechar10 Allow NULL? 
67OBJBE_AUTOconfirm objectkey automatically - Old Version, don't usechar10 Allow NULL? 
68BEG_CO_111begin row - Old Version, don't usenvarchar20 Allow NULL? 
69BEG_RO_111begin column - Old Version, don't usenvarchar20 Allow NULL? 
70END_CO_111end row - Old Version, don't usenvarchar20 Allow NULL? 
71END_RO_111end column - Old Version, don't usenvarchar20 Allow NULL? 
72LOGINGlogging - Old Version, don't usechar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
J_8A3TECHN~0YesYesCLUSTEREDUSR, MANDT