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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Bank Components :: Bank Customer Accounts :: Master Data :: Condition
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BKK91701Value Date Transaction FiguresCondition
SQL:  selectupdate insert create

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

SELECT MANDT, BKKRS, ACNUM_INT, DATE_POST, VAL_YEAR, VAL_MONTH, CLOS_NRADD, CURR, D_AMOUNT01, D_AMOUNT02, D_AMOUNT03, D_AMOUNT04, D_AMOUNT05, D_AMOUNT06, D_AMOUNT07, D_AMOUNT08, D_AMOUNT09, D_AMOUNT10, D_AMOUNT11, D_AMOUNT12, D_AMOUNT13, D_AMOUNT14, D_AMOUNT15, D_AMOUNT16, D_AMOUNT17, D_AMOUNT18, D_AMOUNT19, D_AMOUNT20, D_AMOUNT21, D_AMOUNT22, D_AMOUNT23, D_AMOUNT24, D_AMOUNT25, D_AMOUNT26, D_AMOUNT27, D_AMOUNT28, D_AMOUNT29, D_AMOUNT30, D_AMOUNT31, C_AMOUNT01, C_AMOUNT02, C_AMOUNT03, C_AMOUNT04, C_AMOUNT05, C_AMOUNT06, C_AMOUNT07, C_AMOUNT08, C_AMOUNT09, C_AMOUNT10, C_AMOUNT11, C_AMOUNT12, C_AMOUNT13, C_AMOUNT14, C_AMOUNT15, C_AMOUNT16, C_AMOUNT17, C_AMOUNT18, C_AMOUNT19, C_AMOUNT20, C_AMOUNT21, C_AMOUNT22, C_AMOUNT23, C_AMOUNT24, C_AMOUNT25, C_AMOUNT26, C_AMOUNT27, C_AMOUNT28, C_AMOUNT29, C_AMOUNT30, C_AMOUNT31 FROM BKK91
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2BKKRSBank Areanvarchar40 Allow NULL? 
3ACNUM_INTInternal Account Number for Current Accountnvarchar100 Allow NULL? 
4DATE_POSTPosting datenvarchar80 Allow NULL? 
5VAL_YEARValue Date Yearnvarchar40 Allow NULL? 
6VAL_MONTHValue Date Monthnvarchar20 Allow NULL? 
7CLOS_NRADDAddition to Balancing Period Numbernvarchar30 Allow NULL? 
8CURRAccount Currencynvarchar50 Allow NULL? 
9D_AMOUNT01Amountdecimal232
10D_AMOUNT02Amountdecimal232
11D_AMOUNT03Amountdecimal232
12D_AMOUNT04Amountdecimal232
13D_AMOUNT05Amountdecimal232
14D_AMOUNT06Amountdecimal232
15D_AMOUNT07Amountdecimal232
16D_AMOUNT08Amountdecimal232
17D_AMOUNT09Amountdecimal232
18D_AMOUNT10Amountdecimal232
19D_AMOUNT11Amountdecimal232
20D_AMOUNT12Amountdecimal232
21D_AMOUNT13Amountdecimal232
22D_AMOUNT14Amountdecimal232
23D_AMOUNT15Amountdecimal232
24D_AMOUNT16Amountdecimal232
25D_AMOUNT17Amountdecimal232
26D_AMOUNT18Amountdecimal232
27D_AMOUNT19Amountdecimal232
28D_AMOUNT20Amountdecimal232
29D_AMOUNT21Amountdecimal232
30D_AMOUNT22Amountdecimal232
31D_AMOUNT23Amountdecimal232
32D_AMOUNT24Amountdecimal232
33D_AMOUNT25Amountdecimal232
34D_AMOUNT26Amountdecimal232
35D_AMOUNT27Amountdecimal232
36D_AMOUNT28Amountdecimal232
37D_AMOUNT29Amountdecimal232
38D_AMOUNT30Amountdecimal232
39D_AMOUNT31Amountdecimal232
40C_AMOUNT01Amountdecimal232
41C_AMOUNT02Amountdecimal232
42C_AMOUNT03Amountdecimal232
43C_AMOUNT04Amountdecimal232
44C_AMOUNT05Amountdecimal232
45C_AMOUNT06Amountdecimal232
46C_AMOUNT07Amountdecimal232
47C_AMOUNT08Amountdecimal232
48C_AMOUNT09Amountdecimal232
49C_AMOUNT10Amountdecimal232
50C_AMOUNT11Amountdecimal232
51C_AMOUNT12Amountdecimal232
52C_AMOUNT13Amountdecimal232
53C_AMOUNT14Amountdecimal232
54C_AMOUNT15Amountdecimal232
55C_AMOUNT16Amountdecimal232
56C_AMOUNT17Amountdecimal232
57C_AMOUNT18Amountdecimal232
58C_AMOUNT19Amountdecimal232
59C_AMOUNT20Amountdecimal232
60C_AMOUNT21Amountdecimal232
61C_AMOUNT22Amountdecimal232
62C_AMOUNT23Amountdecimal232
63C_AMOUNT24Amountdecimal232
64C_AMOUNT25Amountdecimal232
65C_AMOUNT26Amountdecimal232
66C_AMOUNT27Amountdecimal232
67C_AMOUNT28Amountdecimal232
68C_AMOUNT29Amountdecimal232
69C_AMOUNT30Amountdecimal232
70C_AMOUNT31Amountdecimal232
NamePrimaryUniqueTypeColumns
BKK91~0YesYesCLUSTEREDCURR, CLOS_NRADD, VAL_MONTH, VAL_YEAR, DATE_POST, ACNUM_INT, BKKRS, MANDT