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

67 columns | Print definition?B1 9.3  | MODEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1NFN1Not a Fiscal Sequence19ModelNota Fiscal ModelnVarChar600
2NFN4Manual Nota Fiscal Number8ModelNota Fiscal ModelnVarChar60
3OPOSPOS Master Data2ModelModelnVarChar200
TOPInventory and Production
4IGE21Goods Issue - Document Reference Information14ModelFiscal Document ModelnVarChar60
5IGN21Goods Receipt - Document Reference Information14ModelFiscal Document ModelnVarChar60
6OIGEGoods Issue236ModelNota Fiscal ModelnVarChar600
7OIGNGoods Receipt236ModelNota Fiscal ModelnVarChar600
8OWTQInventory Transfer Request236ModelNota Fiscal ModelnVarChar600
9OWTRInventory Transfer236ModelNota Fiscal ModelnVarChar600
10WTQ21Inventory Transfer Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
11WTR21Inventory Transfer - Document Reference Information14ModelFiscal Document ModelnVarChar60
TOPMarketing Documents
12ADO21A/R Invoice - Document Reference Information - History14ModelFiscal Document ModelnVarChar60
13ADOCInvoice - History236ModelNota Fiscal ModelnVarChar600
14CIN21Correction Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
15CPI21A/P Correction Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
16CPV21A/P Correction Invoice Reversal - Document Reference Information14ModelFiscal Document ModelnVarChar60
17CSI21A/R Correction Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
18CSV21A/R Correction Invoice Reversal - Document Reference Information14ModelFiscal Document ModelnVarChar60
19DLN21Delivery - Document Reference Information14ModelFiscal Document ModelnVarChar60
20DPI21A/R Down Payment - Document Reference Information14ModelFiscal Document ModelnVarChar60
21DPO21A/P Down Payment - Document Reference Information14ModelFiscal Document ModelnVarChar60
22DRF21Draft - Document Reference Information14ModelFiscal Document ModelnVarChar60
23IEI21Incoming Excise Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
24INV21A/R Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
25OCINA/R Correction Invoice236ModelNota Fiscal ModelnVarChar600
26OCPIA/P Correction Invoice236ModelNota Fiscal ModelnVarChar600
27OCPVA/P Correction Invoice Reversal236ModelNota Fiscal ModelnVarChar600
28OCSIA/R Correction Invoice236ModelNota Fiscal ModelnVarChar600
29OCSVA/R Correction Invoice Reversal236ModelNota Fiscal ModelnVarChar600
30ODLNDelivery236ModelNota Fiscal ModelnVarChar600
31ODPIA/R Down Payment236ModelNota Fiscal ModelnVarChar600
32ODPOA/P Down Payment236ModelNota Fiscal ModelnVarChar600
33ODRFDrafts236ModelNota Fiscal ModelnVarChar600
34OEI21Outgoing Excise Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
35OIEIIncoming Excise Invoice236ModelNota Fiscal ModelnVarChar600
36OINVA/R Invoice236ModelNota Fiscal ModelnVarChar600
37OOEIOutgoing Excise Invoice236ModelNota Fiscal ModelnVarChar600
38OPCHA/P Invoice236ModelNota Fiscal ModelnVarChar600
39OPDNGoods Receipt PO236ModelNota Fiscal ModelnVarChar600
40OPORPurchase Order236ModelNota Fiscal ModelnVarChar600
41OPQTPurchase Quotation236ModelNota Fiscal ModelnVarChar600
42OPRQPurchase Request236ModelNota Fiscal ModelnVarChar600
43OPRRGoods Return Request236ModelNota Fiscal ModelnVarChar600
44OQUTSales Quotation236ModelNota Fiscal ModelnVarChar600
45ORDNReturns236ModelNota Fiscal ModelnVarChar600
46ORDRSales Order236ModelNota Fiscal ModelnVarChar600
47ORINA/R Credit Memo236ModelNota Fiscal ModelnVarChar600
48ORPCA/P Credit Memo236ModelNota Fiscal ModelnVarChar600
49ORPDGoods Return236ModelNota Fiscal ModelnVarChar600
50ORRRReturn Request236ModelNota Fiscal ModelnVarChar600
51OSFCSelf Credit Memo236ModelNota Fiscal ModelnVarChar600
52OSFISelf Invoice236ModelNota Fiscal ModelnVarChar600
53PCH21A/P Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
54PDN21Goods Receipt PO - Document Reference Information14ModelFiscal Document ModelnVarChar60
55POR21Purchase Order - Document Reference Information14ModelFiscal Document ModelnVarChar60
56PQT21Purchase Quotation - Document Reference Information14ModelFiscal Document ModelnVarChar60
57PRQ21Purchase Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
58PRR21A/P Return Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
59QUT21Sales Quotation - Document Reference Information14ModelFiscal Document ModelnVarChar60
60RDN21Returns - Document Reference Information14ModelFiscal Document ModelnVarChar60
61RDR21Sales Order - Document Reference Information14ModelFiscal Document ModelnVarChar60
62RIN21A/R Credit Memo - Document Reference Information14ModelFiscal Document ModelnVarChar60
63RPC21A/P Credit Memo - Document Reference Information14ModelFiscal Document ModelnVarChar60
64RPD21Goods Return - Document Reference Information14ModelFiscal Document ModelnVarChar60
65RRR21A/R Return Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
66SFC21Self Credit Memo - Document Reference Information14ModelFiscal Document ModelnVarChar60
67SFI21Self Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60