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
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BKKRSBank Areanvarchar40CHAR(N' ')NoTBKK01BKK_BKKRS Allow NULL? 
3ACNUM_INTInternal Account Number for Current Accountnvarchar100CHAR(N' ')NoBKK40BKK_ACCNT Allow NULL? 
4DATE_POSTPosting datenvarchar80DATS(N'00000000')NoBKK_PSTDAT Allow NULL? 
5VAL_YEARValue Date Yearnvarchar40NUMC(N'0000')NoBKK_VYEAR Allow NULL? 
6VAL_MONTHValue Date Monthnvarchar20NUMC(N'00')NoBKK_VMONTH Allow NULL? 
7CLOS_NRADDAddition to Balancing Period Numbernvarchar30NUMC(N'000')NoBKK_CLNRAD Allow NULL? 
8CURRAccount Currencynvarchar50CUKY(N' ')NoTCURCBKK_ACUR Allow NULL? 
9D_AMOUNT01Amountdecimal232CURR((0))YesBKK_AMTMD
10D_AMOUNT02Amountdecimal232CURR((0))YesBKK_AMTMD
11D_AMOUNT03Amountdecimal232CURR((0))YesBKK_AMTMD
12D_AMOUNT04Amountdecimal232CURR((0))YesBKK_AMTMD
13D_AMOUNT05Amountdecimal232CURR((0))YesBKK_AMTMD
14D_AMOUNT06Amountdecimal232CURR((0))YesBKK_AMTMD
15D_AMOUNT07Amountdecimal232CURR((0))YesBKK_AMTMD
16D_AMOUNT08Amountdecimal232CURR((0))YesBKK_AMTMD
17D_AMOUNT09Amountdecimal232CURR((0))YesBKK_AMTMD
18D_AMOUNT10Amountdecimal232CURR((0))YesBKK_AMTMD
19D_AMOUNT11Amountdecimal232CURR((0))YesBKK_AMTMD
20D_AMOUNT12Amountdecimal232CURR((0))YesBKK_AMTMD
21D_AMOUNT13Amountdecimal232CURR((0))YesBKK_AMTMD
22D_AMOUNT14Amountdecimal232CURR((0))YesBKK_AMTMD
23D_AMOUNT15Amountdecimal232CURR((0))YesBKK_AMTMD
24D_AMOUNT16Amountdecimal232CURR((0))YesBKK_AMTMD
25D_AMOUNT17Amountdecimal232CURR((0))YesBKK_AMTMD
26D_AMOUNT18Amountdecimal232CURR((0))YesBKK_AMTMD
27D_AMOUNT19Amountdecimal232CURR((0))YesBKK_AMTMD
28D_AMOUNT20Amountdecimal232CURR((0))YesBKK_AMTMD
29D_AMOUNT21Amountdecimal232CURR((0))YesBKK_AMTMD
30D_AMOUNT22Amountdecimal232CURR((0))YesBKK_AMTMD
31D_AMOUNT23Amountdecimal232CURR((0))YesBKK_AMTMD
32D_AMOUNT24Amountdecimal232CURR((0))YesBKK_AMTMD
33D_AMOUNT25Amountdecimal232CURR((0))YesBKK_AMTMD
34D_AMOUNT26Amountdecimal232CURR((0))YesBKK_AMTMD
35D_AMOUNT27Amountdecimal232CURR((0))YesBKK_AMTMD
36D_AMOUNT28Amountdecimal232CURR((0))YesBKK_AMTMD
37D_AMOUNT29Amountdecimal232CURR((0))YesBKK_AMTMD
38D_AMOUNT30Amountdecimal232CURR((0))YesBKK_AMTMD
39D_AMOUNT31Amountdecimal232CURR((0))YesBKK_AMTMD
40C_AMOUNT01Amountdecimal232CURR((0))YesBKK_AMTMD
41C_AMOUNT02Amountdecimal232CURR((0))YesBKK_AMTMD
42C_AMOUNT03Amountdecimal232CURR((0))YesBKK_AMTMD
43C_AMOUNT04Amountdecimal232CURR((0))YesBKK_AMTMD
44C_AMOUNT05Amountdecimal232CURR((0))YesBKK_AMTMD
45C_AMOUNT06Amountdecimal232CURR((0))YesBKK_AMTMD
46C_AMOUNT07Amountdecimal232CURR((0))YesBKK_AMTMD
47C_AMOUNT08Amountdecimal232CURR((0))YesBKK_AMTMD
48C_AMOUNT09Amountdecimal232CURR((0))YesBKK_AMTMD
49C_AMOUNT10Amountdecimal232CURR((0))YesBKK_AMTMD
50C_AMOUNT11Amountdecimal232CURR((0))YesBKK_AMTMD
51C_AMOUNT12Amountdecimal232CURR((0))YesBKK_AMTMD
52C_AMOUNT13Amountdecimal232CURR((0))YesBKK_AMTMD
53C_AMOUNT14Amountdecimal232CURR((0))YesBKK_AMTMD
54C_AMOUNT15Amountdecimal232CURR((0))YesBKK_AMTMD
55C_AMOUNT16Amountdecimal232CURR((0))YesBKK_AMTMD
56C_AMOUNT17Amountdecimal232CURR((0))YesBKK_AMTMD
57C_AMOUNT18Amountdecimal232CURR((0))YesBKK_AMTMD
58C_AMOUNT19Amountdecimal232CURR((0))YesBKK_AMTMD
59C_AMOUNT20Amountdecimal232CURR((0))YesBKK_AMTMD
60C_AMOUNT21Amountdecimal232CURR((0))YesBKK_AMTMD
61C_AMOUNT22Amountdecimal232CURR((0))YesBKK_AMTMD
62C_AMOUNT23Amountdecimal232CURR((0))YesBKK_AMTMD
63C_AMOUNT24Amountdecimal232CURR((0))YesBKK_AMTMD
64C_AMOUNT25Amountdecimal232CURR((0))YesBKK_AMTMD
65C_AMOUNT26Amountdecimal232CURR((0))YesBKK_AMTMD
66C_AMOUNT27Amountdecimal232CURR((0))YesBKK_AMTMD
67C_AMOUNT28Amountdecimal232CURR((0))YesBKK_AMTMD
68C_AMOUNT29Amountdecimal232CURR((0))YesBKK_AMTMD
69C_AMOUNT30Amountdecimal232CURR((0))YesBKK_AMTMD
70C_AMOUNT31Amountdecimal232CURR((0))YesBKK_AMTMD
NamePrimaryUniqueTypeColumns
BKK91~0YesYesCLUSTEREDCURR, CLOS_NRADD, VAL_MONTH, VAL_YEAR, DATE_POST, ACNUM_INT, BKKRS, MANDT