SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

64 columns | Print definition?B1 9.3  | TOTALEXPNS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1IGE6Goods Issue - Installments20TotalExpnsTotal Freight ChargesNum196
2IGN6Goods Receipt- Installments20TotalExpnsTotal Freight ChargesNum196
3OIGEGoods Issue85TotalExpnsTotal ExpensesNum196
4OIGNGoods Receipt85TotalExpnsTotal ExpensesNum196
5OWTQInventory Transfer Request85TotalExpnsTotal Freight ChargesNum196
6OWTRInventory Transfer85TotalExpnsTotal Freight ChargesNum196
7WTQ6Inventory Transfer Request - Installments20TotalExpnsTotal Freight ChargesNum196
8WTR6Inventory Transfer - Installments20TotalExpnsTotal Freight ChargesNum196
TOPMarketing Documents
9ADO6Documents History - Installments20TotalExpnsTotal Freight ChargesNum196
10ADOCInvoice - History85TotalExpnsTotal ExpensesNum196
11CIN6Correction Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
12CPI6Documents History - Installments20TotalExpnsTotal Freight ChargesNum196
13CPV6A/P Correction Invoice Reversal - Installments20TotalExpnsTotal Freight ChargesNum196
14CSI6A/R Corr. Inv. - Installments20TotalExpnsTotal Freight ChargesNum196
15CSV6A/R Correction Invoice Reversal - Installments20TotalExpnsTotal Freight ChargesNum196
16DLN6Delivery - Installments20TotalExpnsTotal Freight ChargesNum196
17DPI6A/R Down Payment - Installments20TotalExpnsTotal Freight ChargesNum196
18DPO6Down Payment Out - Installments20TotalExpnsTotal Freight ChargesNum196
19DRF6Document Drafts - Installments20TotalExpnsTotal Freight ChargesNum196
20IEI6IEI - Installments20TotalExpnsTotal Freight ChargesNum196
21INV6A/R Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
22OCINA/R Correction Invoice85TotalExpnsTotal FreightNum196
23OCPIA/P Correction Invoice85TotalExpnsTotal ExpensesNum196
24OCPVA/P Correction Invoice Reversal85TotalExpnsTotal ExpensesNum196
25OCSIA/R Correction Invoice85TotalExpnsTotal ExpensesNum196
26OCSVA/R Correction Invoice Reversal85TotalExpnsTotal ExpensesNum196
27ODLNDelivery85TotalExpnsTotal ExpensesNum196
28ODPIA/R Down Payment85TotalExpnsTotal ExpensesNum196
29ODPOA/P Down Payment85TotalExpnsTotal ExpensesNum196
30ODRFDrafts85TotalExpnsTotal FreightNum196
31OEI6Outgoing Excise Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
32OIEIIncoming Excise Invoice85TotalExpnsTotal Freight ChargesNum196
33OINVA/R Invoice85TotalExpnsTotal Freight ChargesNum196
34OOEIOutgoing Excise Invoice85TotalExpnsTotal Freight ChargesNum196
35OPCHA/P Invoice85TotalExpnsTotal Freight ChargesNum196
36OPDNGoods Receipt PO85TotalExpnsTotal Freight ChargesNum196
37OPORPurchase Order85TotalExpnsTotal ExpensesNum196
38OPQTPurchase Quotation85TotalExpnsTotal ExpensesNum196
39OPRQPurchase Request85TotalExpnsTotal ExpensesNum196
40OPRRGoods Return Request85TotalExpnsTotal Freight ChargesNum196
41OQUTSales Quotation85TotalExpnsTotal Freight ChargesNum196
42ORDNReturns85TotalExpnsTotal FreightNum196
43ORDRSales Order85TotalExpnsTotal Freight ChargesNum196
44ORINA/R Credit Memo85TotalExpnsTotal ExpensesNum196
45ORPCA/P Credit Memo85TotalExpnsTotal Freight ChargesNum196
46ORPDGoods Return85TotalExpnsTotal FreightNum196
47ORRRReturn Request85TotalExpnsTotal Freight ChargesNum196
48OSFCSelf Credit Memo85TotalExpnsTotal Freight ChargesNum196
49OSFISelf Invoice85TotalExpnsTotal Freight ChargesNum196
50PCH6A/P Invoice - Installments20TotalExpnsTotal Freight ChargesNum196
51PDN6Goods Receipt PO - Installments20TotalExpnsTotal Freight ChargesNum196
52POR6Purchase Order - Installments20TotalExpnsTotal Freight ChargesNum196
53PQT6Purchase Quotation - Installments20TotalExpnsTotal Freight ChargesNum196
54PRQ6Purchase Request - Installments20TotalExpnsTotal Freight ChargesNum196
55PRR6A/P Return Request - Installments20TotalExpnsTotal Freight ChargesNum196
56QUT6Sales Quotation - Installments20TotalExpnsTotal Freight ChargesNum196
57RDN6Returns - Installments20TotalExpnsTotal Freight ChargesNum196
58RDR6Sales Order - Installments20TotalExpnsTotal Freight ChargesNum196
59RIN6A/R Credit Memo - Installments20TotalExpnsTotal Freight ChargesNum196
60RPC6A/P Credit Memo - Installments20TotalExpnsTotal Freight ChargesNum196
61RPD6Goods Return - Installments20TotalExpnsTotal Freight ChargesNum196
62RRR6A/R Return Request - Installments20TotalExpnsTotal Freight ChargesNum196
63SFC6Self Credit Memo - Installments20TotalExpnsTotal Freight ChargesNum196
64SFI6Self Invoice - Installments20TotalExpnsTotal Freight ChargesNum196