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 :: Test Workbench :: Test Organizer
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TNODE02_AS311Test case attributes: Training-specific CATT attributesTest Organizer
SQL:  selectupdate insert create

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

SELECT TC_NAME, TWB_TRA_1, TWB_TRA_2, TWB_TRA_3, TWB_TRA_4, TWB_TRA_5, TWB_TRA_6, TWB_TRA_7, TWB_TRA_8, TWB_TRA_9, TWB_TRA_10, TWB_TRA_11, TWB_TRA_12, TWB_TRA_13, TWB_TRA_14, TWB_TRA_15, TWB_TRA_16, TWB_TRA_17, TWB_TRA_18, TWB_TRA_19, TWB_TRA_20, TWB_TRA_21, TWB_TRA_22, TWB_TRA_23, TWB_TRA_24, TWB_TRA_25, TWB_TRA_26, TWB_TRA_27, TWB_TRA_28, TWB_TRA_29, TWB_TRA_30 FROM TNODE02_AS
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1TC_NAMETestnvarchar300 Allow NULL? 
2TWB_TRA_1Character Field Length = 10nvarchar100 Allow NULL? 
3TWB_TRA_2Character Field Length = 10nvarchar100 Allow NULL? 
4TWB_TRA_3Character Field Length = 10nvarchar100 Allow NULL? 
5TWB_TRA_4Character Field Length = 10nvarchar100 Allow NULL? 
6TWB_TRA_5Character Field Length = 10nvarchar100 Allow NULL? 
7TWB_TRA_6Character Field Length = 10nvarchar100 Allow NULL? 
8TWB_TRA_7Character Field Length = 10nvarchar100 Allow NULL? 
9TWB_TRA_8Character Field Length = 10nvarchar100 Allow NULL? 
10TWB_TRA_9Character Field Length = 10nvarchar100 Allow NULL? 
11TWB_TRA_10Character Field Length = 10nvarchar100 Allow NULL? 
12TWB_TRA_11Character Field Length = 10nvarchar100 Allow NULL? 
13TWB_TRA_12Character Field Length = 10nvarchar100 Allow NULL? 
14TWB_TRA_13Character Field Length = 10nvarchar100 Allow NULL? 
15TWB_TRA_14Character Field Length = 10nvarchar100 Allow NULL? 
16TWB_TRA_15Character Field Length = 10nvarchar100 Allow NULL? 
17TWB_TRA_16Character Field Length = 10nvarchar100 Allow NULL? 
18TWB_TRA_17Character Field Length = 10nvarchar100 Allow NULL? 
19TWB_TRA_18Character Field Length = 10nvarchar100 Allow NULL? 
20TWB_TRA_19Character Field Length = 10nvarchar100 Allow NULL? 
21TWB_TRA_20Character Field Length = 10nvarchar100 Allow NULL? 
22TWB_TRA_21Character Field Length = 10nvarchar100 Allow NULL? 
23TWB_TRA_22Character Field Length = 10nvarchar100 Allow NULL? 
24TWB_TRA_23Character Field Length = 10nvarchar100 Allow NULL? 
25TWB_TRA_24Character Field Length = 10nvarchar100 Allow NULL? 
26TWB_TRA_25Character Field Length = 10nvarchar100 Allow NULL? 
27TWB_TRA_26Character Field Length = 10nvarchar100 Allow NULL? 
28TWB_TRA_27Character Field Length = 10nvarchar100 Allow NULL? 
29TWB_TRA_28Character Field Length = 10nvarchar100 Allow NULL? 
30TWB_TRA_29Character Field Length = 10nvarchar100 Allow NULL? 
31TWB_TRA_30Character Field Length = 10nvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
TNODE02_AS~0YesYesCLUSTEREDTC_NAME