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

143 columns | Print definition?B1 9.3  | GROUPNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARC5Reciept log vat adjustment-History21GroupNumGroup NumberInt1100
2OCTGPayment Terms1GroupNumGroup NumberInt60
3PDF5PaymentDraft - vat adjustment21GroupNumGroup NumberInt1100
4PMN5Payment - VAT Adjustment21GroupNumGroup NumberInt1100
5RCT5Reciept vat adjustment21GroupNumGroup NumberInt1100
6VPM5Outgoing Payments - Vat Adjustment21GroupNumGroup NumberInt1100
TOPBusiness Partners
7ACRDBusiness Partners - History19GroupNumPayment Terms CodeInt60-1
8AOATBlanket Agreement32GroupNumPayment Terms CodeInt60
9OCRDBusiness Partner19GroupNumPayment Terms CodeInt60-1
10OOATBlanket Agreement32GroupNumPayment Terms CodeInt60
TOPGeneral
11MFLDMetaData Tables Fields15GroupNumGroup NumberInt600-1=System, 0=User
TOPInventory and Production
12IGE13Goods Issue Rows - Distributed Expenses3GroupNumGroup NumberInt110
13IGE2Goods Issue - Freight - Rows3GroupNumGroup NumberInt110
14IGE4Goods Issue - Tax Amount per Document3GroupNumGroup NumberInt110-1
15IGN13Goods Receipt Rows - Distributed Expenses3GroupNumGroup NumberInt110
16IGN2Goods Receipt - Freight - Rows3GroupNumGroup NumberInt110
17IGN4Goods Receipt - Tax Amount per Document3GroupNumGroup NumberInt110-1
18OARGCustoms Groups3GroupNumNumbernVarChar200
19OENTShipping Types27GroupNumPayment Terms CodeInt60
20OIGEGoods Issue37GroupNumPrice ListInt60
21OIGNGoods Receipt37GroupNumPrice ListInt60
22OWTQInventory Transfer Request37GroupNumPayment Terms CodeInt60
23OWTRInventory Transfer37GroupNumPrice ListsInt60
24WTQ13Inventory Transfer Request Rows - Distributed Freights3GroupNumGroup NumberInt110
25WTQ2Inventory Transfer Request - Freight - Rows3GroupNumGroup No.Int110
26WTQ4Inventory Transfer Request - Tax Amount per Document3GroupNumGroup No.Int110-1
27WTR13Inventory Transfer Rows - Distributed Freights3GroupNumGroup NumberInt110
28WTR2Inventory Transfer - Freight - Rows3GroupNumGroup NumberInt110
29WTR4Inventory Transfer - Tax Amount per Document3GroupNumGroup NumberInt110-1
TOPMarketing Documents
30ADO13A/R Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
31ADO2A/R Invoice - Freight - Rows3GroupNumGroup No.Int110
32ADO4Documents - Tax - History3GroupNumGroup No.Int110-1
33ADOCInvoice - History37GroupNumPayment Terms CodeInt60
34CIN13Correction Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
35CIN2A/R Correction Invoice - Freight - Rows3GroupNumExpense GroupInt110
36CIN4Correction Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
37CPI13A/P Correction Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
38CPI2A/P Correction Invoice - Freight - Rows3GroupNumExpense GroupInt110
39CPI4A/P Correction Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
40CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses3GroupNumGroup NumberInt110
41CPV2A/P Correction Invoice Reversal - Freight - Rows3GroupNumExpense GroupInt110
42CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.3GroupNumGroup NumberInt110-1
43CSI13A/R Correction Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
44CSI2A/R Corr Inv - Freight - Rows3GroupNumExpense GroupInt110
45CSI4A/R Correction Invoice - Tax Amount Per Document3GroupNumGroup NumberInt110-1
46CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses3GroupNumGroup NumberInt110
47CSV2A/R Correction Invoice Reversal - Freight - Rows3GroupNumExpense GroupInt110
48CSV4A/R Correction Invoice Reversal - Tax Amount Per Document3GroupNumGroup NumberInt110-1
49DLN13Delivery Rows - Distributed Expenses3GroupNumGroup NumberInt110
50DLN2Delivery Notes - Freight - Rows3GroupNumGroup NumberInt110
51DLN4Delivery - Tax Amount per Document3GroupNumGroup NumberInt110-1
52DPI13A/R Down Payment Rows - Distributed Expenses3GroupNumGroup NumberInt110
53DPI2A/R Down Payment - Freight - Rows3GroupNumGroup NumberInt110
54DPI4A/R Down Payment - Tax Amount per Document3GroupNumGroup NumberInt110-1
55DPO13A/P Down Payment Rows - Distributed Expenses3GroupNumGroup NumberInt110
56DPO2A/P Down Payment - Freight - Rows3GroupNumGroup NumberInt110
57DPO4A/P Down Payment - Tax Amount per Document3GroupNumGroup NumberInt110-1
58DRF13Draft Rows - Distributed Expenses3GroupNumGroup NumberInt110
59DRF2Draft - Freight - Rows3GroupNumGroup NumberInt110
60DRF4Draft Documents - Tax3GroupNumGroup NumberInt110-1
61IEI13Incoming Excise Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
62IEI2Incoming Excise Invoice - Freight - History - Rows3GroupNumGroup NumberInt110
63IEI4Incoming Excise Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
64INV13A/R Invoice Rows - Distributed Freights3GroupNumGroup NumberInt110
65INV2A/R Invoice - Freight - Rows3GroupNumGroup NumberInt110
66INV4A/R Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
67OCINA/R Correction Invoice37GroupNumPayment Terms CodeInt60
68OCPIA/P Correction Invoice37GroupNumPayment Terms CodeInt60
69OCPVA/P Correction Invoice Reversal37GroupNumPayment Terms CodeInt60
70OCSIA/R Correction Invoice37GroupNumPayment Terms CodeInt60
71OCSVA/R Correction Invoice Reversal37GroupNumPayment Terms CodeInt60
72ODLNDelivery37GroupNumPayment Terms CodeInt60
73ODPIA/R Down Payment37GroupNumPayment Terms CodeInt60
74ODPOA/P Down Payment37GroupNumPayment Terms CodeInt60
75ODRFDrafts37GroupNumPayment Terms CodeInt60
76OEI13Outgoing Excise Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
77OEI2OEI - Freight Rows3GroupNumGroup NumberInt110
78OEI4Outgoing Excise Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
79OIEIIncoming Excise Invoice37GroupNumPayment Terms CodeInt60
80OINVA/R Invoice37GroupNumPayment Terms CodeInt60
81OOEIOutgoing Excise Invoice37GroupNumPayment Terms CodeInt60
82OPCHA/P Invoice37GroupNumPayment Terms CodeInt60
83OPDNGoods Receipt PO37GroupNumPayment Terms CodeInt60
84OPORPurchase Order37GroupNumPayment Terms CodeInt60
85OPQTPurchase Quotation37GroupNumPayment Terms CodeInt60
86OPRQPurchase Request37GroupNumPayment Terms CodeInt60
87OPRRGoods Return Request37GroupNumPayment Terms CodeInt60
88OQUTSales Quotation37GroupNumPayment Terms CodeInt60
89ORDNReturns37GroupNumPayment Terms CodeInt60
90ORDRSales Order37GroupNumPayment Terms CodeInt60
91ORINA/R Credit Memo37GroupNumPayment Terms CodeInt60
92ORPCA/P Credit Memo37GroupNumPayment Terms CodeInt60
93ORPDGoods Return37GroupNumPayment Terms CodeInt60
94ORRRReturn Request37GroupNumPayment Terms CodeInt60
95OSALOutgoing27GroupNumPayment Terms CodeInt60
96OSFCSelf Credit Memo37GroupNumPayment Terms CodeInt60
97OSFISelf Invoice37GroupNumPayment Terms CodeInt60
98OTRATransition27GroupNumPayment Terms CodeInt60
99PCH13A/P Invoice Rows - Distributed Expenses3GroupNumGroup NumberInt110
100PCH2A/P Invoice - Freight - Rows3GroupNumFreight GroupInt110
101PCH4A/P Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1
102PDN13Goods Receipt PO Rows - Distributed Expenses3GroupNumGroup NumberInt110
103PDN2Goods Receipt PO - Freight - Rows3GroupNumFreight GroupInt110
104PDN4Goods Receipt PO - Tax Amount per Document3GroupNumGroup NumberInt110-1
105POR13Purchase Order Rows - Distributed Expenses3GroupNumGroup NumberInt110
106POR2Purchase Order - Freight - Rows3GroupNumGroup NumberInt110
107POR4Purchase Order - Tax Amount per Document3GroupNumGroup NumberInt110-1
108PQT13Purchase Quotation Rows - Distributed Expenses3GroupNumGroup NumberInt110
109PQT2Purchase Quotation - Freight - Rows3GroupNumGroup NumberInt110
110PQT4Purchase Quotation - Tax Amount per Document3GroupNumGroup NumberInt110-1
111PRQ13Purchase Request Rows - Distributed Expenses3GroupNumGroup NumberInt110
112PRQ2Purchase Request - Freight - Rows3GroupNumGroup NumberInt110
113PRQ4Purchase Request - Tax Amount per Document3GroupNumGroup NumberInt110-1
114PRR13A/P Return Request - Distributed Freights3GroupNumGroup NumberInt110
115PRR2A/P Return Request - Freight - Rows3GroupNumGroup NumberInt110
116PRR4A/P Return Request - Tax Amount per Document3GroupNumGroup NumberInt110-1
117QUT13Sales Quotation Rows - Distributed Expenses3GroupNumGroup NumberInt110
118QUT2Sales Quotation - Freight - Rows3GroupNumGroup NumberInt110
119QUT4Sales Quotation - Tax Amount per Document3GroupNumGroup NumberInt110-1
120RDN13Returns Rows - Distributed Expenses3GroupNumGroup NumberInt110
121RDN2Return - Freight - Rows3GroupNumFreight GroupInt110
122RDN4Returns - Tax Amount per Document3GroupNumGroup NumberInt110-1
123RDR13Sales Order Rows - Distributed Expenses3GroupNumGroup NumberInt110
124RDR2Sales Order - Freight - Rows3GroupNumGroup NumberInt110
125RDR4Sales Order - Tax Amount per Document3GroupNumGroup NumberInt110-1
126RIN13A/R Credit Memo Rows - Distributed Expenses3GroupNumGroup NumberInt110
127RIN2A/R Credit Memo - Freight - Rows3GroupNumGroup NumberInt110
128RIN4A/R Credit Memo - Tax Amount per Document3GroupNumGroup NumberInt110-1
129RPC13A/P Credit Memo Rows - Distributed Expenses3GroupNumGroup NumberInt110
130RPC2A/P Credit Memo Rows - Expenses3GroupNumGroup NumberInt110
131RPC4A/P Credit Memo - Tax Amount per Document3GroupNumGroup NumberInt110-1
132RPD13Goods Returns Rows - Distributed Expenses3GroupNumGroup NumberInt110
133RPD2Goods Return - Freight - Rows3GroupNumGroup NumberInt110
134RPD4Goods Return - Tax Amount per Document3GroupNumGroup NumberInt110-1
135RRR13A/R Return Request - Distributed Freights3GroupNumGroup NumberInt110
136RRR2A/R Return Request - Freight - Rows3GroupNumGroup NumberInt110
137RRR4A/R Return Request - Tax Amount per Document3GroupNumGroup NumberInt110-1
138SFC13Self Credit Memo Rows - Distributed Freights3GroupNumGroup NumberInt110
139SFC2Self Credit Memo - Freight - Rows3GroupNumGroup NumberInt110
140SFC4Self Credit Memo - Tax Amount per Document3GroupNumGroup NumberInt110-1
141SFI13Self Invoice Rows - Distributed Freights3GroupNumGroup NumberInt110
142SFI2Self Invoice - Freight - Rows3GroupNumGroup NumberInt110
143SFI4Self Invoice - Tax Amount per Document3GroupNumGroup NumberInt110-1