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_8A3T0008651technical customizing 5.xCross-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_POS, BEG_CO_POS, LOGING, MULTI_SUPP, ICON_MULTI, ICON_STACK, BEG_RO_400, BEG_CO_400, END_RO_400, END_CO_400, BTN_KO_400, BTN_PO_400, BTN_IN_400, BEG_RO_TRE, BEG_CO_TRE, END_RO_TRE, END_CO_TRE, BTN_KO_TRE, BTN_PO_TRE, BTN_IN_TRE, TOPMAX_TRE, BEG_RO_410, BEG_CO_410, END_RO_410, END_CO_410, DA_POS_410, DA_USE_410, SZ_POS_410, SZ_USE_410, SZ_FIX_410, USRVON_410, USRBIS_410, BTN_IN_410, BTN_ST_410, BTN_UA_410, BEG_CO_411, BEG_RO_411, END_CO_411, END_RO_411, STORE_FIUS, BEG_RO_420, BEG_CO_420, END_RO_420, END_CO_420, BTN_PO_420, BTN_IN_420, BTN_EX_420, BEG_RO_421, BEG_CO_421, END_RO_421, END_CO_421, BTN_PO_421, BTN_IN_421, BEG_RO_422, BEG_CO_422, END_RO_422, END_CO_422, BTN_PO_422, BTN_IN_422, BTN_AL_422, TRE_NODATA, SURROGATE, CLOSE_MODE FROM J_8A3T0008
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2USRChanged bynvarchar120 Allow NULL? 
3BEG_RO_POSbegin rownvarchar20 Allow NULL? 
4BEG_CO_POSbegin columnnvarchar20 Allow NULL? 
5LOGINGloggingchar10 Allow NULL? 
6MULTI_SUPPMultiple sendto supportchar10 Allow NULL? 
7ICON_MULTIicon for multiselectnvarchar400 Allow NULL? 
8ICON_STACKicon for stacknvarchar400 Allow NULL? 
9BEG_RO_400begin rownvarchar20 Allow NULL? 
10BEG_CO_400begin columnnvarchar20 Allow NULL? 
11END_RO_400end rownvarchar20 Allow NULL? 
12END_CO_400end columnnvarchar30 Allow NULL? 
13BTN_KO_400button configchar10 Allow NULL? 
14BTN_PO_400button positchar10 Allow NULL? 
15BTN_IN_400button infochar10 Allow NULL? 
16BEG_RO_TREbegin rownvarchar20 Allow NULL? 
17BEG_CO_TREbegin columnnvarchar20 Allow NULL? 
18END_RO_TREend rownvarchar20 Allow NULL? 
19END_CO_TREend columnnvarchar30 Allow NULL? 
20BTN_KO_TREbutton configchar10 Allow NULL? 
21BTN_PO_TREbutton positchar10 Allow NULL? 
22BTN_IN_TREbutton infochar10 Allow NULL? 
23TOPMAX_TREmaximal number of rows in top of page text in dynpro 400nvarchar20 Allow NULL? 
24BEG_RO_410begin rownvarchar20 Allow NULL? 
25BEG_CO_410begin columnnvarchar20 Allow NULL? 
26END_RO_410end rownvarchar20 Allow NULL? 
27END_CO_410end columnnvarchar30 Allow NULL? 
28DA_POS_410position onto last document typeschar10 Allow NULL? 
29DA_USE_410use last document types automaticallychar10 Allow NULL? 
30SZ_POS_410position onto last scenariochar10 Allow NULL? 
31SZ_USE_410use last scenario automaticallychar10 Allow NULL? 
32SZ_FIX_410use fix scenario automaticallychar10 Allow NULL? 
33USRVON_410user fromchar10 Allow NULL? 
34USRBIS_410user tochar10 Allow NULL? 
35BTN_IN_410button infochar10 Allow NULL? 
36BTN_ST_410button 'Reset to Defaultsettings'char10 Allow NULL? 
37BTN_UA_410button User link to 'All'char10 Allow NULL? 
38BEG_CO_411begin rownvarchar20 Allow NULL? 
39BEG_RO_411begin columnnvarchar20 Allow NULL? 
40END_CO_411end rownvarchar20 Allow NULL? 
41END_RO_411end columnnvarchar30 Allow NULL? 
42STORE_FIUSstore filename and usernamechar10 Allow NULL? 
43BEG_RO_420begin rownvarchar20 Allow NULL? 
44BEG_CO_420begin columnnvarchar20 Allow NULL? 
45END_RO_420end rownvarchar20 Allow NULL? 
46END_CO_420end columnnvarchar30 Allow NULL? 
47BTN_PO_420button positchar10 Allow NULL? 
48BTN_IN_420button infochar10 Allow NULL? 
49BTN_EX_420button extended search at ODMA-Selectchar10 Allow NULL? 
50BEG_RO_421begin rownvarchar20 Allow NULL? 
51BEG_CO_421begin columnnvarchar20 Allow NULL? 
52END_RO_421end rownvarchar20 Allow NULL? 
53END_CO_421end columnnvarchar30 Allow NULL? 
54BTN_PO_421button positchar10 Allow NULL? 
55BTN_IN_421button infochar10 Allow NULL? 
56BEG_RO_422begin rownvarchar20 Allow NULL? 
57BEG_CO_422begin columnnvarchar20 Allow NULL? 
58END_RO_422end rownvarchar20 Allow NULL? 
59END_CO_422end columnnvarchar30 Allow NULL? 
60BTN_PO_422button positchar10 Allow NULL? 
61BTN_IN_422button infochar10 Allow NULL? 
62BTN_AL_422button All documents at ODMA-Selectchar10 Allow NULL? 
63TRE_NODATAflag, no data in top of page of treechar10 Allow NULL? 
64SURROGATEodma attributenvarchar500 Allow NULL? 
65CLOSE_MODEclose sapgui modus after desktoplinkchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
J_8A3T0008~0YesYesCLUSTEREDUSR, MANDT