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

160 columns | Print definition?B1 9.3  | PAIDTODATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1IGE13Goods Issue Rows - Distributed Expenses8PaidToDatePaid to DateNum196
2IGE2Goods Issue - Freight - Rows8PaidToDatePaid to DateNum196
3IGE3Goods Issue - Freight6PaidToDatePaid to DateNum196
4IGE6Goods Issue - Installments11PaidToDatePaid to DateNum196
5IGN13Goods Receipt Rows - Distributed Expenses8PaidToDatePaid to DateNum196
6IGN2Goods Receipt - Freight - Rows8PaidToDatePaid to DateNum196
7IGN3Goods Receipt - Freight6PaidToDatePaid to DateNum196
8IGN6Goods Receipt- Installments11PaidToDatePaid to DateNum196
9OIGEGoods Issue27PaidToDatePaid to DateNum196
10OIGNGoods Receipt27PaidToDatePaid to DateNum196
11OWTQInventory Transfer Request27PaidToDatePaid to DateNum196
12OWTRInventory Transfer27PaidToDatePaid to DateNum196
13WTQ13Inventory Transfer Request Rows - Distributed Freights8PaidToDatePaid to DateNum196
14WTQ2Inventory Transfer Request - Freight - Rows8PaidToDatePaid to DateNum196
15WTQ3Inventory Transfer Request - Freight6PaidToDatePaid to DateNum196
16WTQ6Inventory Transfer Request - Installments11PaidToDatePaid to DateNum196
17WTR13Inventory Transfer Rows - Distributed Freights8PaidToDatePaid to DateNum196
18WTR2Inventory Transfer - Freight - Rows8PaidToDatePaid to DateNum196
19WTR3Inventory Transfer - Freight6PaidToDatePaid to DateNum196
20WTR6Inventory Transfer - Installments11PaidToDatePaid to DateNum196
TOPMarketing Documents
21ADO13A/R Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
22ADO2A/R Invoice - Freight - Rows8PaidToDatePaid to DateNum196
23ADO3A/R Invoice - Freight - History6PaidToDatePaid to DateNum196
24ADO6Documents History - Installments11PaidToDatePaid to DateNum196
25ADOCInvoice - History27PaidToDatePaid to DateNum196
26CIN13Correction Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
27CIN2A/R Correction Invoice - Freight - Rows8PaidToDatePaid to DateNum196
28CIN3A/R Correction Invoice - Freight6PaidToDatePaid to DateNum196
29CIN6Correction Invoice - Installments11PaidToDatePaid to DateNum196
30CPI13A/P Correction Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
31CPI2A/P Correction Invoice - Freight - Rows8PaidToDatePaid to DateNum196
32CPI3A/P Correction Invoice - Freight6PaidToDatePaid to DateNum196
33CPI6Documents History - Installments11PaidToDatePaid to DateNum196
34CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses8PaidToDatePaid to DateNum196
35CPV2A/P Correction Invoice Reversal - Freight - Rows8PaidToDatePaid to DateNum196
36CPV3A/P Correction Invoice Reversal - Freight6PaidToDatePaid to DateNum196
37CPV6A/P Correction Invoice Reversal - Installments11PaidToDatePaid to DateNum196
38CSI13A/R Correction Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
39CSI2A/R Corr Inv - Freight - Rows8PaidToDatePaid to DateNum196
40CSI3A/R Correction Invoice - Freight6PaidToDatePaid to DateNum196
41CSI6A/R Corr. Inv. - Installments11PaidToDatePaid to DateNum196
42CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses8PaidToDatePaid to DateNum196
43CSV2A/R Correction Invoice Reversal - Freight - Rows8PaidToDatePaid to DateNum196
44CSV3A/R Correction Invoice Reversal - Freight6PaidToDatePaid to DateNum196
45CSV6A/R Correction Invoice Reversal - Installments11PaidToDatePaid to DateNum196
46DLN13Delivery Rows - Distributed Expenses8PaidToDatePaid to DateNum196
47DLN2Delivery Notes - Freight - Rows8PaidToDatePaid to DateNum196
48DLN3Delivery Notes - Freight6PaidToDatePaid to DateNum196
49DLN6Delivery - Installments11PaidToDatePaid to DateNum196
50DPI13A/R Down Payment Rows - Distributed Expenses8PaidToDatePaid to DateNum196
51DPI2A/R Down Payment - Freight - Rows8PaidToDatePaid to DateNum196
52DPI3A/R Down Payment - Freight6PaidToDatePaid to DateNum196
53DPI6A/R Down Payment - Installments11PaidToDatePaid to DateNum196
54DPO13A/P Down Payment Rows - Distributed Expenses8PaidToDatePaid to DateNum196
55DPO2A/P Down Payment - Freight - Rows8PaidToDatePaid to DateNum196
56DPO3A/P Down Payment - Freight6PaidToDatePaid to DateNum196
57DPO6Down Payment Out - Installments11PaidToDatePaid to DateNum196
58DRF13Draft Rows - Distributed Expenses8PaidToDatePaid to DateNum196
59DRF2Draft - Freight - Rows8PaidToDatePaid to DateNum196
60DRF3Draft - Freight6PaidToDatePaid to DateNum196
61DRF6Document Drafts - Installments11PaidToDatePaid to DateNum196
62IEI13Incoming Excise Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
63IEI2Incoming Excise Invoice - Freight - History - Rows8PaidToDatePaid to DateNum196
64IEI3IEI - Freight6PaidToDatePaid to DateNum196
65IEI6IEI - Installments11PaidToDatePaid to DateNum196
66INV13A/R Invoice Rows - Distributed Freights8PaidToDatePaid to DateNum196
67INV2A/R Invoice - Freight - Rows8PaidToDatePaid to DateNum196
68INV3A/R Invoice - Freight6PaidToDatePaid to DateNum196
69INV6A/R Invoice - Installments11PaidToDatePaid to DateNum196
70OCINA/R Correction Invoice27PaidToDatePaid to DateNum196
71OCPIA/P Correction Invoice27PaidToDatePaid to DateNum196
72OCPVA/P Correction Invoice Reversal27PaidToDatePaid to DateNum196
73OCSIA/R Correction Invoice27PaidToDatePaid to DateNum196
74OCSVA/R Correction Invoice Reversal27PaidToDatePaid to DateNum196
75ODLNDelivery27PaidToDatePaid to DateNum196
76ODPIA/R Down Payment27PaidToDatePaid to DateNum196
77ODPOA/P Down Payment27PaidToDatePaid to DateNum196
78ODRFDrafts27PaidToDatePaid to DateNum196
79OEI13Outgoing Excise Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
80OEI2OEI - Freight Rows8PaidToDatePaid to DateNum196
81OEI3OEI - Freight6PaidToDatePaid to DateNum196
82OEI6Outgoing Excise Invoice - Installments11PaidToDatePaid to DateNum196
83OIEIIncoming Excise Invoice27PaidToDatePaid to DateNum196
84OINVA/R Invoice27PaidToDatePaid to DateNum196
85OOEIOutgoing Excise Invoice27PaidToDatePaid to DateNum196
86OPCHA/P Invoice27PaidToDatePaid to DateNum196
87OPDNGoods Receipt PO27PaidToDatePaid to DateNum196
88OPORPurchase Order27PaidToDatePaid to DateNum196
89OPQTPurchase Quotation27PaidToDatePaid to DateNum196
90OPRQPurchase Request27PaidToDatePaid to DateNum196
91OPRRGoods Return Request27PaidToDatePaid to DateNum196
92OQUTSales Quotation27PaidToDatePaid to DateNum196
93ORDNReturns27PaidToDatePaid to DateNum196
94ORDRSales Order27PaidToDatePaid to DateNum196
95ORINA/R Credit Memo27PaidToDatePaid to DateNum196
96ORPCA/P Credit Memo27PaidToDatePaid to DateNum196
97ORPDGoods Return27PaidToDatePaid to DateNum196
98ORRRReturn Request27PaidToDatePaid to DateNum196
99OSFCSelf Credit Memo27PaidToDatePaid to DateNum196
100OSFISelf Invoice27PaidToDatePaid to DateNum196
101PCH13A/P Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
102PCH2A/P Invoice - Freight - Rows8PaidToDatePaid to DateNum196
103PCH3A/P Invoice - Freight6PaidToDatePaid to DateNum196
104PCH6A/P Invoice - Installments11PaidToDatePaid to DateNum196
105PDN13Goods Receipt PO Rows - Distributed Expenses8PaidToDatePaid to DateNum196
106PDN2Goods Receipt PO - Freight - Rows8PaidToDatePaid to DateNum196
107PDN3Goods Receipt PO - Freight6PaidToDatePaid to DateNum196
108PDN6Goods Receipt PO - Installments11PaidToDatePaid to DateNum196
109POR13Purchase Order Rows - Distributed Expenses8PaidToDatePaid to DateNum196
110POR2Purchase Order - Freight - Rows8PaidToDatePaid to DateNum196
111POR3Purchase Order - Freight6PaidToDatePaid to DateNum196
112POR6Purchase Order - Installments11PaidToDatePaid to DateNum196
113PQT13Purchase Quotation Rows - Distributed Expenses8PaidToDatePaid to DateNum196
114PQT2Purchase Quotation - Freight - Rows8PaidToDatePaid to DateNum196
115PQT3Purchase Quotation - Freight6PaidToDatePaid to DateNum196
116PQT6Purchase Quotation - Installments11PaidToDatePaid to DateNum196
117PRQ13Purchase Request Rows - Distributed Expenses8PaidToDatePaid to DateNum196
118PRQ2Purchase Request - Freight - Rows8PaidToDatePaid to DateNum196
119PRQ3Purchase Request - Freight6PaidToDatePaid to DateNum196
120PRQ6Purchase Request - Installments11PaidToDatePaid to DateNum196
121PRR13A/P Return Request - Distributed Freights8PaidToDatePaid to DateNum196
122PRR2A/P Return Request - Freight - Rows8PaidToDatePaid to DateNum196
123PRR3A/P Return Request - Freight6PaidToDatePaid to DateNum196
124PRR6A/P Return Request - Installments11PaidToDatePaid to DateNum196
125QUT13Sales Quotation Rows - Distributed Expenses8PaidToDatePaid to DateNum196
126QUT2Sales Quotation - Freight - Rows8PaidToDatePaid to DateNum196
127QUT3Sales Quotation - Freight6PaidToDatePaid to DateNum196
128QUT6Sales Quotation - Installments11PaidToDatePaid to DateNum196
129RDN13Returns Rows - Distributed Expenses8PaidToDatePaid to DateNum196
130RDN2Return - Freight - Rows8PaidToDatePaid to DateNum196
131RDN3Return - Freight6PaidToDatePaid to DateNum196
132RDN6Returns - Installments11PaidToDatePaid to DateNum196
133RDR13Sales Order Rows - Distributed Expenses8PaidToDatePaid to DateNum196
134RDR2Sales Order - Freight - Rows8PaidToDatePaid to DateNum196
135RDR3Sales Order - Freight6PaidToDatePaid to DateNum196
136RDR6Sales Order - Installments11PaidToDatePaid to DateNum196
137RIN13A/R Credit Memo Rows - Distributed Expenses8PaidToDatePaid to DateNum196
138RIN2A/R Credit Memo - Freight - Rows8PaidToDatePaid to DateNum196
139RIN3A/R Credit Memo - Freight6PaidToDatePaid to DateNum196
140RIN6A/R Credit Memo - Installments11PaidToDatePaid to DateNum196
141RPC13A/P Credit Memo Rows - Distributed Expenses8PaidToDatePaid to DateNum196
142RPC2A/P Credit Memo Rows - Expenses8PaidToDatePaid to DateNum196
143RPC3A/P Credit Memo - Freight6PaidToDatePaid to DateNum196
144RPC6A/P Credit Memo - Installments11PaidToDatePaid to DateNum196
145RPD13Goods Returns Rows - Distributed Expenses8PaidToDatePaid to DateNum196
146RPD2Goods Return - Freight - Rows8PaidToDatePaid to DateNum196
147RPD3Goods Return - Freight6PaidToDatePaid to DateNum196
148RPD6Goods Return - Installments11PaidToDatePaid to DateNum196
149RRR13A/R Return Request - Distributed Freights8PaidToDatePaid to DateNum196
150RRR2A/R Return Request - Freight - Rows8PaidToDatePaid to DateNum196
151RRR3A/R Return Request - Freight6PaidToDatePaid to DateNum196
152RRR6A/R Return Request - Installments11PaidToDatePaid to DateNum196
153SFC13Self Credit Memo Rows - Distributed Freights8PaidToDatePaid to DateNum196
154SFC2Self Credit Memo - Freight - Rows8PaidToDatePaid to DateNum196
155SFC3Self Credit Memo - Freight6PaidToDatePaid to DateNum196
156SFC6Self Credit Memo - Installments11PaidToDatePaid to DateNum196
157SFI13Self Invoice Rows - Distributed Freights8PaidToDatePaid to DateNum196
158SFI2Self Invoice - Freight - Rows8PaidToDatePaid to DateNum196
159SFI3Self Invoice - Freight6PaidToDatePaid to DateNum196
160SFI6Self Invoice - Installments11PaidToDatePaid to DateNum196