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

59 columns | Print definition?B1 9.2  | 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 Information13ModelFiscal Document ModelnVarChar60
5IGN21Goods Receipt - Document Reference Information13ModelFiscal Document ModelnVarChar60
6OIGEGoods Issue236ModelNota Fiscal ModelnVarChar600
7OIGNGoods Receipt236ModelNota Fiscal ModelnVarChar600
8OWTQInventory Transfer Request236ModelNota Fiscal ModelnVarChar600
9OWTRInventory Transfer236ModelNota Fiscal ModelnVarChar600
10WTQ21Inventory Transfer Request - Document Reference Information13ModelFiscal Document ModelnVarChar60
11WTR21Inventory Transfer - Document Reference Information13ModelFiscal Document ModelnVarChar60
TOPMarketing Documents
12ADO21A/R Invoice - Document Reference Information - History13ModelFiscal Document ModelnVarChar60
13ADOCInvoice - History236ModelNota Fiscal ModelnVarChar600
14CIN21Correction Invoice - Document Reference Information13ModelFiscal Document ModelnVarChar60
15CPI21A/P Correction Invoice - Document Reference Information13ModelFiscal Document ModelnVarChar60
16CPV21A/P Correction Invoice Reversal - Document Reference Information13ModelFiscal Document ModelnVarChar60
17CSI21A/R Correction Invoice - Document Reference Information13ModelFiscal Document ModelnVarChar60
18CSV21A/R Correction Invoice Reversal - Document Reference Information13ModelFiscal Document ModelnVarChar60
19DLN21Delivery - Document Reference Information13ModelFiscal Document ModelnVarChar60
20DPI21A/R Down Payment - Document Reference Information13ModelFiscal Document ModelnVarChar60
21DPO21A/P Down Payment - Document Reference Information13ModelFiscal Document ModelnVarChar60
22DRF21Draft - Document Reference Information13ModelFiscal Document ModelnVarChar60
23IEI21Incoming Excise Invoice - Document Reference Information13ModelFiscal Document ModelnVarChar60
24INV21A/R Invoice - Document Reference Information13ModelFiscal 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 Information13ModelFiscal 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
43OQUTSales Quotation236ModelNota Fiscal ModelnVarChar600
44ORDNReturns236ModelNota Fiscal ModelnVarChar600
45ORDRSales Order236ModelNota Fiscal ModelnVarChar600
46ORINA/R Credit Memo236ModelNota Fiscal ModelnVarChar600
47ORPCA/P Credit Memo236ModelNota Fiscal ModelnVarChar600
48ORPDGoods Return236ModelNota Fiscal ModelnVarChar600
49PCH21A/P Invoice - Document Reference Information13ModelFiscal Document ModelnVarChar60
50PDN21Goods Receipt PO - Document Reference Information13ModelFiscal Document ModelnVarChar60
51POR21Purchase Order - Document Reference Information13ModelFiscal Document ModelnVarChar60
52PQT21Purchase Quotation - Document Reference Information13ModelFiscal Document ModelnVarChar60
53PRQ21Purchase Request - Document Reference Information13ModelFiscal Document ModelnVarChar60
54QUT21Sales Quotation - Document Reference Information13ModelFiscal Document ModelnVarChar60
55RDN21Returns - Document Reference Information13ModelFiscal Document ModelnVarChar60
56RDR21Sales Order - Document Reference Information13ModelFiscal Document ModelnVarChar60
57RIN21A/R Credit Memo - Document Reference Information13ModelFiscal Document ModelnVarChar60
58RPC21A/P Credit Memo - Document Reference Information13ModelFiscal Document ModelnVarChar60
59RPD21Goods Return - Document Reference Information13ModelFiscal Document ModelnVarChar60