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

90 columns | Print definition?B1 9.3  | BASEENTRY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPInventory and Production
1AIQRInventory Posting35BaseEntryBase Counting Doc. EntryInt110
2AQR1Inventory Posting - Rows35BaseEntryBase Document Internal IDInt110
3AWO2Production Order - Base2BaseEntryProduction Order Base EntryInt110
4ENT1Entry - Rows3BaseEntryBase Document Internal IDInt110
5IGE1Goods Issue - Rows7BaseEntryBase Document Internal IDInt110
6IGN1Goods Receipt - Rows7BaseEntryBase Document Internal IDInt110
7IPD1Inventory Posting Draft - Rows35BaseEntryBase Document Internal IDInt110
8IPF1Landed Costs - Rows4BaseEntryBase Document Internal IDInt110
9IQR1Inventory Posting - Rows35BaseEntryBase Document Internal IDInt110
10OIGEGoods Issue409BaseEntryBase Document Internal KeyInt110
11OIGNGoods Receipt409BaseEntryBase Document Internal KeyInt110
12OIPDInventory Posting Draft35BaseEntryBase Counting Doc. EntryInt110
13OIQRInventory Posting35BaseEntryBase Counting Doc. EntryInt110
14OITLInventory Transactions Log10BaseEntryBase Document Internal IDInt110-1
15ORTLResource Transaction Log7BaseEntryBase Document Internal IDInt110
16OWTQInventory Transfer Request409BaseEntryBase Document Internal KeyInt110
17OWTRInventory Transfer409BaseEntryBase Document Internal KeyInt110
18UWO2Production Order - Base2BaseEntryProduction Order Base EntryInt110
19WOR2Production Order - Base2BaseEntryProduction Order Base EntryInt110
20WOR2VProduction Order - Base2BaseEntryProduction Order Base EntryInt110
21WTQ1Inventory Transfer Request - Rows7BaseEntryBase Document Internal IDInt110
22WTR1Inventory Transfer - Rows7BaseEntryBase Document Internal IDInt110
TOPMarketing Documents
23ADO1A/R Invoice (Rows) - History7BaseEntryBase Document Internal IDInt110
24ADOCInvoice - History409BaseEntryBase Document Internal KeyInt110
25ATX1Tax Invoice - History - Rows1BaseEntryBase Document Internal IDInt110
26ATX2Tax Invoice Operation Codes1BaseEntryAbs. EntryInt110
27CIN1Correction Invoice - Rows7BaseEntryBase Document Internal IDInt110
28CPI1A/P Correction Invoice - Rows7BaseEntryBase Document Internal IDInt110
29CPV1A/P Correction Invoice Reversal - Rows7BaseEntryBase Document Internal IDInt110
30CSI1A/R Correction Invoice - Rows7BaseEntryBase Document Internal IDInt110
31CSV1A/R Correction Invoice Reversal - Rows7BaseEntryBase Document Internal IDInt110
32DLN1Delivery - Rows7BaseEntryBase Document Internal IDInt110
33DPI1A/R Down Payment - Rows7BaseEntryBase Document Internal IDInt110
34DPO1A/P Down Payment - Rows7BaseEntryBase Document Internal IDInt110
35DRF1Draft - Rows7BaseEntryBase Document Internal IDInt110
36IEI1Incoming Excise Invoice - Rows7BaseEntryBase Document Internal IDInt110
37INV1A/R Invoice - Rows7BaseEntryBase Document Internal IDInt110
38OCINA/R Correction Invoice409BaseEntryBase Document Internal KeyInt110
39OCPIA/P Correction Invoice409BaseEntryBase Document Internal KeyInt110
40OCPVA/P Correction Invoice Reversal409BaseEntryBase Document Internal KeyInt110
41OCSIA/R Correction Invoice409BaseEntryBase Document Internal KeyInt110
42OCSVA/R Correction Invoice Reversal409BaseEntryBase Document Internal KeyInt110
43ODLNDelivery409BaseEntryBase Document Internal KeyInt110
44ODPIA/R Down Payment409BaseEntryBase Document Internal KeyInt110
45ODPOA/P Down Payment409BaseEntryBase Document Internal KeyInt110
46ODRFDrafts409BaseEntryBase Document Internal KeyInt110
47OEI1Outgoing Excise Invoice - Rows7BaseEntryBase Document Internal IDInt110
48OIEIIncoming Excise Invoice409BaseEntryBase Document Internal KeyInt110
49OINVA/R Invoice409BaseEntryBase Document Internal KeyInt110
50OOEIOutgoing Excise Invoice409BaseEntryBase Document Internal KeyInt110
51OPCHA/P Invoice409BaseEntryBase Document Internal KeyInt110
52OPDNGoods Receipt PO409BaseEntryBase Document Internal KeyInt110
53OPORPurchase Order409BaseEntryBase Document Internal KeyInt110
54OPQTPurchase Quotation409BaseEntryBase Document Internal KeyInt110
55OPRQPurchase Request409BaseEntryBase Document Internal KeyInt110
56OPRRGoods Return Request409BaseEntryBase Document Internal KeyInt110
57OQUTSales Quotation409BaseEntryBase Document Internal KeyInt110
58ORDNReturns409BaseEntryBase Document Internal KeyInt110
59ORDRSales Order409BaseEntryBase Document Internal KeyInt110
60ORINA/R Credit Memo409BaseEntryBase Document Internal KeyInt110
61ORPCA/P Credit Memo409BaseEntryBase Document Internal KeyInt110
62ORPDGoods Return409BaseEntryBase Document Internal KeyInt110
63ORRRReturn Request409BaseEntryBase Document Internal KeyInt110
64OSFCSelf Credit Memo409BaseEntryBase Document Internal KeyInt110
65OSFISelf Invoice409BaseEntryBase Document Internal KeyInt110
66PCH1A/P Invoice - Rows7BaseEntryBase Document Internal IDInt110
67PDN1Goods Receipt PO - Rows7BaseEntryBase Document Internal IDInt110
68POR1Purchase Order - Rows7BaseEntryBase Document Internal IDInt110
69PQT1Purchase Quotation - Rows7BaseEntryBase Document Internal IDInt110
70PRQ1Purchase Request - Rows7BaseEntryBase Document Internal IDInt110
71PRR1A/P Return Request - Rows7BaseEntryBase Document Internal IDInt110
72QUT1Sales Quotation - Rows7BaseEntryBase Document Internal IDInt110
73RDN1Returns - Rows7BaseEntryBase Document Internal IDInt110
74RDR1Sales Order - Rows7BaseEntryBase Document Internal IDInt110
75RIN1A/R Credit Memo - Rows7BaseEntryBase Document Internal IDInt110
76RPC1A/P Credit Memo - Rows7BaseEntryBase Document Internal IDInt110
77RPD1Goods Return - Rows7BaseEntryBase Document Internal IDInt110
78RRR1A/R Return Request - Rows7BaseEntryBase Document Internal IDInt110
79SAL1Salida - Rows3BaseEntryBase Document Internal IDInt110
80SFC1Self Credit Memo - Rows7BaseEntryBase Document Internal IDInt110
81SFI1Self Invoice - Rows7BaseEntryBase Document Internal IDInt110
82TPI1Purchase Tax Invoice - Rows1BaseEntryBase Document Internal IDInt110
83TPI2Tax Invoice Operation Codes1BaseEntryAbs. EntryInt110
84TRA1Transition - Rows3BaseEntryBase Document Internal IDInt110
85TSI1Sales Tax Invoice - Rows11BaseEntryBase Document Internal IDInt110
86TSI2Tax Invoice Operation Codes1BaseEntryAbs. EntryInt110
87TXD1Tax Invoice Drafts - Rows1BaseEntryBase Document Internal IDInt110
88TXD2Tax Invoice Draft Operation Codes1BaseEntryAbs. EntryInt110
TOPMRP
89MSN3MRP Pegging Information5BaseEntryBase Document Internal IDInt110
TOPReports
90SOI5Statement of Import - Lines18BaseEntryBase EntryInt110