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  | PAIDSYS

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