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
Without Description :: Without Description :: Data Staging
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0RSSTART521Admin.Workbench start tableData Staging
SQL:  selectupdate insert create

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

SELECT UNAME, UPMODE, VARIANT, ISTREENODE, ISTREENODE_P, ISTREENODE_G, ISTREETYPE, ISTREETYPE_P, ISTREETYPE_G, ICTREENODE, ICTREENODE_P, ICTREENODE_G, ICTREETYPE, ICTREETYPE_P, ICTREETYPE_G, LGTREENODE, LGTREENODE_P, LGTREENODE_G, LGTREETYPE, LGTREETYPE_P, LGTREETYPE_G, IOTREENODE, IOTREENODE_P, IOTREENODE_G, IOTREETYPE, IOTREETYPE_P, IOTREETYPE_G, IPGTREENODE, IPGTREENODE_P, IPGTREENODE_G, IPGTREETYPE, IPGTREETYPE_P, IPGTREETYPE_G, ODSTREENODE, ODSTREENODE_P, ODSTREENODE_G, ODSTREETYPE, ODSTREETYPE_P, ODSTREETYPE_G, DSTREENODE, DSTREENODE_P, DSTREENODE_G, DSTREETYPE, DSTREETYPE_P, DSTREETYPE_G, ODS_DATE_FROM, ODS_DATE_TO, ODS_TIME_SEL, ODS_ALL_SEL, DRAGDROPNEXT, SHOW_INVISIBLE, ODS_VISIBLE FROM RSSTART
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1UNAMEUser Namenvarchar120 Allow NULL? 
2UPMODE30 Charactersnvarchar300 Allow NULL? 
3VARIANTVariantnvarchar120 Allow NULL? 
4ISTREENODE30 Charactersnvarchar300 Allow NULL? 
5ISTREENODE_P30 Charactersnvarchar300 Allow NULL? 
6ISTREENODE_G30 Charactersnvarchar300 Allow NULL? 
7ISTREETYPECharacter Field Length = 10nvarchar100 Allow NULL? 
8ISTREETYPE_PCharacter Field Length = 10nvarchar100 Allow NULL? 
9ISTREETYPE_GCharacter Field Length = 10nvarchar100 Allow NULL? 
10ICTREENODE30 Charactersnvarchar300 Allow NULL? 
11ICTREENODE_P30 Charactersnvarchar300 Allow NULL? 
12ICTREENODE_G30 Charactersnvarchar300 Allow NULL? 
13ICTREETYPECharacter Field Length = 10nvarchar100 Allow NULL? 
14ICTREETYPE_PCharacter Field Length = 10nvarchar100 Allow NULL? 
15ICTREETYPE_GCharacter Field Length = 10nvarchar100 Allow NULL? 
16LGTREENODE30 Charactersnvarchar300 Allow NULL? 
17LGTREENODE_P30 Charactersnvarchar300 Allow NULL? 
18LGTREENODE_G30 Charactersnvarchar300 Allow NULL? 
19LGTREETYPECharacter Field Length = 10nvarchar100 Allow NULL? 
20LGTREETYPE_PCharacter Field Length = 10nvarchar100 Allow NULL? 
21LGTREETYPE_GCharacter Field Length = 10nvarchar100 Allow NULL? 
22IOTREENODE30 Charactersnvarchar300 Allow NULL? 
23IOTREENODE_P30 Charactersnvarchar300 Allow NULL? 
24IOTREENODE_G30 Charactersnvarchar300 Allow NULL? 
25IOTREETYPECharacter Field Length = 10nvarchar100 Allow NULL? 
26IOTREETYPE_PCharacter Field Length = 10nvarchar100 Allow NULL? 
27IOTREETYPE_GCharacter Field Length = 10nvarchar100 Allow NULL? 
28IPGTREENODE30 Charactersnvarchar300 Allow NULL? 
29IPGTREENODE_P30 Charactersnvarchar300 Allow NULL? 
30IPGTREENODE_G30 Charactersnvarchar300 Allow NULL? 
31IPGTREETYPECharacter Field Length = 10nvarchar100 Allow NULL? 
32IPGTREETYPE_PCharacter Field Length = 10nvarchar100 Allow NULL? 
33IPGTREETYPE_GCharacter Field Length = 10nvarchar100 Allow NULL? 
34ODSTREENODE30 Charactersnvarchar300 Allow NULL? 
35ODSTREENODE_P30 Charactersnvarchar300 Allow NULL? 
36ODSTREENODE_G30 Charactersnvarchar300 Allow NULL? 
37ODSTREETYPECharacter Field Length = 10nvarchar100 Allow NULL? 
38ODSTREETYPE_PCharacter Field Length = 10nvarchar100 Allow NULL? 
39ODSTREETYPE_GCharacter Field Length = 10nvarchar100 Allow NULL? 
40DSTREENODE30 Charactersnvarchar300 Allow NULL? 
41DSTREENODE_P30 Charactersnvarchar300 Allow NULL? 
42DSTREENODE_G30 Charactersnvarchar300 Allow NULL? 
43DSTREETYPECharacter Field Length = 10nvarchar100 Allow NULL? 
44DSTREETYPE_PCharacter Field Length = 10nvarchar100 Allow NULL? 
45DSTREETYPE_GCharacter Field Length = 10nvarchar100 Allow NULL? 
46ODS_DATE_FROMSystem Datenvarchar80 Allow NULL? 
47ODS_DATE_TOSystem Datenvarchar80 Allow NULL? 
48ODS_TIME_SELSingle-Character Indicatorchar10 Allow NULL? 
49ODS_ALL_SELSingle-Character Indicatorchar10 Allow NULL? 
50DRAGDROPNEXTSingle-Character Indicatorchar10 Allow NULL? 
51SHOW_INVISIBLEBooleanchar10 Allow NULL? 
52ODS_VISIBLEBooleanchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
RSSTART~0YesYesCLUSTEREDUNAME