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

35 columns | Print definition?B1 9.3  | TOTALSC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1OILMInventory Log Message11TotalSCInventory Total SCNum196
2UILMIVI Inventory Log Message11TotalSCInventory Total SCNum196
TOPMarketing Documents
3ADO20Intrastat Expenses5TotalSCTotal (SC)Num196
4CIN20Intrastat Expenses5TotalSCTotal (SC)Num196
5CPI20Intrastat Expenses5TotalSCTotal (SC)Num196
6CPV20Intrastat Expenses5TotalSCTotal (SC)Num196
7CSI20Intrastat Expenses5TotalSCTotal (SC)Num196
8CSV20Intrastat Expenses5TotalSCTotal (SC)Num196
9DLN20Intrastat Expenses5TotalSCTotal (SC)Num196
10DOC20Intrastat Expenses5TotalSCTotal (SC)Num196
11DPI20Intrastat Expenses5TotalSCTotal (SC)Num196
12DPO20Intrastat Expenses5TotalSCTotal (SC)Num196
13DRF20Intrastat Expenses5TotalSCTotal (SC)Num196
14IEI20Intrastat Expenses5TotalSCTotal (SC)Num196
15IGE20Intrastat Expenses5TotalSCTotal (SC)Num196
16IGN20Intrastat Expenses5TotalSCTotal (SC)Num196
17INV20Intrastat Expenses5TotalSCTotal (SC)Num196
18OEI20Intrastat Expenses5TotalSCTotal (SC)Num196
19PCH20Intrastat Expenses5TotalSCTotal (SC)Num196
20PDN20Intrastat Expenses5TotalSCTotal (SC)Num196
21POR20Intrastat Expenses5TotalSCTotal (SC)Num196
22PQT20Intrastat Expenses5TotalSCTotal (SC)Num196
23PRQ20Intrastat Expenses5TotalSCTotal (SC)Num196
24PRR20Intrastat Expenses5TotalSCTotal (SC)Num196
25QUT20Intrastat Expenses5TotalSCTotal (SC)Num196
26RDN20Intrastat Expenses5TotalSCTotal (SC)Num196
27RDR20Intrastat Expenses5TotalSCTotal (SC)Num196
28RIN20Intrastat Expenses5TotalSCTotal (SC)Num196
29RPC20Intrastat Expenses5TotalSCTotal (SC)Num196
30RPD20Intrastat Expenses5TotalSCTotal (SC)Num196
31RRR20Intrastat Expenses5TotalSCTotal (SC)Num196
32SFC20Intrastat Expenses5TotalSCTotal (SC)Num196
33SFI20Intrastat Expenses5TotalSCTotal (SC)Num196
34WTQ20Intrastat Expenses5TotalSCTotal (SC)Num196
35WTR20Intrastat Expenses5TotalSCTotal (SC)Num196