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

Home | ERP 6.0  | J_8A3T0008
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
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
10OBOT10Bill Of Exchang Transaction
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2USRChanged bynvarchar120CHAR(N' ')NoUSER Allow NULL? 
3BEG_RO_POSbegin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
4BEG_CO_POSbegin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
5LOGINGloggingchar10CHAR(N' ')YesJ_8A3E0045 Allow NULL? 
6MULTI_SUPPMultiple sendto supportchar10CHAR(N' ')YesJ_8A3E0064 Allow NULL? 
7ICON_MULTIicon for multiselectnvarchar400CHAR(N' ')YesJ_8A3E0067 Allow NULL? 
8ICON_STACKicon for stacknvarchar400CHAR(N' ')YesJ_8A3E0068 Allow NULL? 
9BEG_RO_400begin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
10BEG_CO_400begin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
11END_RO_400end rownvarchar20NUMC(N'00')YesJ_8A3E0019 Allow NULL? 
12END_CO_400end columnnvarchar30NUMC(N'000')YesJ_8A3E0020 Allow NULL? 
13BTN_KO_400button configchar10CHAR(N' ')YesJ_8A3E0021 Allow NULL? 
14BTN_PO_400button positchar10CHAR(N' ')YesJ_8A3E0023 Allow NULL? 
15BTN_IN_400button infochar10CHAR(N' ')YesJ_8A3E0024 Allow NULL? 
16BEG_RO_TREbegin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
17BEG_CO_TREbegin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
18END_RO_TREend rownvarchar20NUMC(N'00')YesJ_8A3E0019 Allow NULL? 
19END_CO_TREend columnnvarchar30NUMC(N'000')YesJ_8A3E0020 Allow NULL? 
20BTN_KO_TREbutton configchar10CHAR(N' ')YesJ_8A3E0021 Allow NULL? 
21BTN_PO_TREbutton positchar10CHAR(N' ')YesJ_8A3E0023 Allow NULL? 
22BTN_IN_TREbutton infochar10CHAR(N' ')YesJ_8A3E0024 Allow NULL? 
23TOPMAX_TREmaximal number of rows in top of page text in dynpro 400nvarchar20NUMC(N'00')YesJ_8A3E0086 Allow NULL? 
24BEG_RO_410begin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
25BEG_CO_410begin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
26END_RO_410end rownvarchar20NUMC(N'00')YesJ_8A3E0019 Allow NULL? 
27END_CO_410end columnnvarchar30NUMC(N'000')YesJ_8A3E0020 Allow NULL? 
28DA_POS_410position onto last document typeschar10CHAR(N' ')YesJ_8A3E0030 Allow NULL? 
29DA_USE_410use last document types automaticallychar10CHAR(N' ')YesJ_8A3E0031 Allow NULL? 
30SZ_POS_410position onto last scenariochar10CHAR(N' ')YesJ_8A3E0032 Allow NULL? 
31SZ_USE_410use last scenario automaticallychar10CHAR(N' ')YesJ_8A3E0033 Allow NULL? 
32SZ_FIX_410use fix scenario automaticallychar10CHAR(N' ')YesJ_8A3E0034 Allow NULL? 
33USRVON_410user fromchar10CHAR(N' ')YesJ_8A3E0025 Allow NULL? 
34USRBIS_410user tochar10CHAR(N' ')YesJ_8A3E0026 Allow NULL? 
35BTN_IN_410button infochar10CHAR(N' ')YesJ_8A3E0024 Allow NULL? 
36BTN_ST_410button 'Reset to Defaultsettings'char10CHAR(N' ')YesJ_8A3E0035 Allow NULL? 
37BTN_UA_410button User link to 'All'char10CHAR(N' ')YesJ_8A3E0036 Allow NULL? 
38BEG_CO_411begin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
39BEG_RO_411begin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
40END_CO_411end rownvarchar20NUMC(N'00')YesJ_8A3E0019 Allow NULL? 
41END_RO_411end columnnvarchar30NUMC(N'000')YesJ_8A3E0020 Allow NULL? 
42STORE_FIUSstore filename and usernamechar10CHAR(N' ')YesJ_8A3E0091 Allow NULL? 
43BEG_RO_420begin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
44BEG_CO_420begin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
45END_RO_420end rownvarchar20NUMC(N'00')YesJ_8A3E0019 Allow NULL? 
46END_CO_420end columnnvarchar30NUMC(N'000')YesJ_8A3E0020 Allow NULL? 
47BTN_PO_420button positchar10CHAR(N' ')YesJ_8A3E0023 Allow NULL? 
48BTN_IN_420button infochar10CHAR(N' ')YesJ_8A3E0024 Allow NULL? 
49BTN_EX_420button extended search at ODMA-Selectchar10CHAR(N' ')YesJ_8A3E0039 Allow NULL? 
50BEG_RO_421begin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
51BEG_CO_421begin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
52END_RO_421end rownvarchar20NUMC(N'00')YesJ_8A3E0019 Allow NULL? 
53END_CO_421end columnnvarchar30NUMC(N'000')YesJ_8A3E0020 Allow NULL? 
54BTN_PO_421button positchar10CHAR(N' ')YesJ_8A3E0023 Allow NULL? 
55BTN_IN_421button infochar10CHAR(N' ')YesJ_8A3E0024 Allow NULL? 
56BEG_RO_422begin rownvarchar20NUMC(N'00')YesJ_8A3E0017 Allow NULL? 
57BEG_CO_422begin columnnvarchar20NUMC(N'00')YesJ_8A3E0018 Allow NULL? 
58END_RO_422end rownvarchar20NUMC(N'00')YesJ_8A3E0019 Allow NULL? 
59END_CO_422end columnnvarchar30NUMC(N'000')YesJ_8A3E0020 Allow NULL? 
60BTN_PO_422button positchar10CHAR(N' ')YesJ_8A3E0023 Allow NULL? 
61BTN_IN_422button infochar10CHAR(N' ')YesJ_8A3E0024 Allow NULL? 
62BTN_AL_422button All documents at ODMA-Selectchar10CHAR(N' ')YesJ_8A3E0040 Allow NULL? 
63TRE_NODATAflag, no data in top of page of treechar10CHAR(N' ')YesJ_8A3E0100 Allow NULL? 
64SURROGATEodma attributenvarchar500CHAR(N' ')YesJ_8A3E0014 Allow NULL? 
65CLOSE_MODEclose sapgui modus after desktoplinkchar10CHAR(N' ')YesJ_8A3E0104 Allow NULL? 
NamePrimaryUniqueTypeColumns
J_8A3T0008~0YesYesCLUSTEREDUSR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy