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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

140 columns | Print definition?B1 9.2  | 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
91OQUTSales Quotation27PaidToDatePaid to DateNum196
92ORDNReturns27PaidToDatePaid to DateNum196
93ORDRSales Order27PaidToDatePaid to DateNum196
94ORINA/R Credit Memo27PaidToDatePaid to DateNum196
95ORPCA/P Credit Memo27PaidToDatePaid to DateNum196
96ORPDGoods Return27PaidToDatePaid to DateNum196
97PCH13A/P Invoice Rows - Distributed Expenses8PaidToDatePaid to DateNum196
98PCH2A/P Invoice - Freight - Rows8PaidToDatePaid to DateNum196
99PCH3A/P Invoice - Freight6PaidToDatePaid to DateNum196
100PCH6A/P Invoice - Installments11PaidToDatePaid to DateNum196
101PDN13Goods Receipt PO Rows - Distributed Expenses8PaidToDatePaid to DateNum196
102PDN2Goods Receipt PO - Freight - Rows8PaidToDatePaid to DateNum196
103PDN3Goods Receipt PO - Freight6PaidToDatePaid to DateNum196
104PDN6Goods Receipt PO - Installments11PaidToDatePaid to DateNum196
105POR13Purchase Order Rows - Distributed Expenses8PaidToDatePaid to DateNum196
106POR2Purchase Order - Freight - Rows8PaidToDatePaid to DateNum196
107POR3Purchase Order - Freight6PaidToDatePaid to DateNum196
108POR6Purchase Order - Installments11PaidToDatePaid to DateNum196
109PQT13Purchase Quotation Rows - Distributed Expenses8PaidToDatePaid to DateNum196
110PQT2Purchase Quotation - Freight - Rows8PaidToDatePaid to DateNum196
111PQT3Purchase Quotation - Freight6PaidToDatePaid to DateNum196
112PQT6Purchase Quotation - Installments11PaidToDatePaid to DateNum196
113PRQ13Purchase Request Rows - Distributed Expenses8PaidToDatePaid to DateNum196
114PRQ2Purchase Request - Freight - Rows8PaidToDatePaid to DateNum196
115PRQ3Purchase Request - Freight6PaidToDatePaid to DateNum196
116PRQ6Purchase Request - Installments11PaidToDatePaid to DateNum196
117QUT13Sales Quotation Rows - Distributed Expenses8PaidToDatePaid to DateNum196
118QUT2Sales Quotation - Freight - Rows8PaidToDatePaid to DateNum196
119QUT3Sales Quotation - Freight6PaidToDatePaid to DateNum196
120QUT6Sales Quotation - Installments11PaidToDatePaid to DateNum196
121RDN13Returns Rows - Distributed Expenses8PaidToDatePaid to DateNum196
122RDN2Return - Freight - Rows8PaidToDatePaid to DateNum196
123RDN3Return - Freight6PaidToDatePaid to DateNum196
124RDN6Returns - Installments11PaidToDatePaid to DateNum196
125RDR13Sales Order Rows - Distributed Expenses8PaidToDatePaid to DateNum196
126RDR2Sales Order - Freight - Rows8PaidToDatePaid to DateNum196
127RDR3Sales Order - Freight6PaidToDatePaid to DateNum196
128RDR6Sales Order - Installments11PaidToDatePaid to DateNum196
129RIN13A/R Credit Memo Rows - Distributed Expenses8PaidToDatePaid to DateNum196
130RIN2A/R Credit Memo - Freight - Rows8PaidToDatePaid to DateNum196
131RIN3A/R Credit Memo - Freight6PaidToDatePaid to DateNum196
132RIN6A/R Credit Memo - Installments11PaidToDatePaid to DateNum196
133RPC13A/P Credit Memo Rows - Distributed Expenses8PaidToDatePaid to DateNum196
134RPC2A/P Credit Memo Rows - Expenses8PaidToDatePaid to DateNum196
135RPC3A/P Credit Memo - Freight6PaidToDatePaid to DateNum196
136RPC6A/P Credit Memo - Installments11PaidToDatePaid to DateNum196
137RPD13Goods Returns Rows - Distributed Expenses8PaidToDatePaid to DateNum196
138RPD2Goods Return - Freight - Rows8PaidToDatePaid to DateNum196
139RPD3Goods Return - Freight6PaidToDatePaid to DateNum196
140RPD6Goods Return - Installments11PaidToDatePaid to DateNum196