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
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

87 columns | Print definition?B1 8.8  | DOCDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1OCCDCargo Customs Declaration Numbers5DocDateImp./Exp. Document DateDate80
TOPBanking
2ARCTIncoming Payment - History7DocDatePosting DateDate80
3OPDFPayment Draft7DocDatePosting DateDate80
4ORCTIncoming Payment7DocDatePosting DateDate80
5OVPMOutgoing Payments7DocDatePosting DateDate80
6PEX1Payment Results Table - Rows12DocDateDocument Posting DateDate80
TOPFinance
7GBI7GBI Row 7 - Accounting Vouchers3DocDateDocument DatenVarChar80
8OJSTTDS Adjustment2DocDatePosting DateDate80
9OSLMSpecial Ledger - Analytical Accounting Report: Material2DocDateDate of Report GenerationDate80
10OSLRSpecial Ledger - Analytical Accounting Report: Revenues & Expenses2DocDateDate of Report GenerationDate80
TOPInventory and Production
11AMRVInventory Revaluation - History3DocDatePosting DateDate80
12IGE1Goods Issue - Rows33DocDatePosting DateDate80
13IGN1Goods Receipt - Rows33DocDatePosting DateDate80
14OAIMArchive Inventory Message19DocDateDocument DateDate80
15OENTShipping Types6DocDatePosting DateDate80
16OIGEGoods Issue11DocDatePosting DateDate80
17OIGNGoods Receipt11DocDatePosting DateDate80
18OILMInventory Log Message24DocDateDoc DateDate80
19OINMWhse Journal6DocDatePosting DateDate80
20OIPFLanded Costs3DocDatePosting DateDate80
21OIQIInventory Initial Quantity6DocDatePosting DateDate80
22OIQRInventory Stock Posting (Reconcile)6DocDatePosting DateDate80
23OITLInventory Transactions Log16DocDateDoc. Posting DateDate80
24OIVLWhse Journal5DocDatePosting DateDate80
25OMRLAdvanced Inventory Revaluation4DocDatePosting DateDate80
26OMRVInventory Revaluation3DocDatePosting DateDate80
27OWTRInventory Transfer11DocDatePosting DateDate80
28UILMIVI Inventory Log Message24DocDateDoc DateDate80
29UIVLWhse Journal5DocDatePosting DateDate80
30WTR1Inventory Transfer - Rows33DocDatePosting DateDate80
TOPMarketing Documents
31ADO1A/R Invoice (Rows) - History33DocDatePosting DateDate80
32ADOCInvoice - History11DocDatePosting DateDate80
33ATXITax Invoice - History9DocDatePosting DateDate80
34CIN1Correction Invoice - Rows33DocDatePosting DateDate80
35CPI1A/P Correction Invoice - Rows33DocDatePosting DateDate80
36CPV1A/P Correction Invoice Reversal - Rows33DocDatePosting DateDate80
37CSI1A/R Correction Invoice - Rows33DocDatePosting DateDate80
38CSV1A/R Correction Invoice Reversal - Rows33DocDatePosting DateDate80
39DLN1Delivery - Rows33DocDatePosting DateDate80
40DPI1A/R Down Payment - Rows33DocDatePosting DateDate80
41DPO1A/P Down Payment - Rows33DocDatePosting DateDate80
42DRF1Draft - Rows33DocDatePosting DateDate80
43IEI1Incoming Excise Invoice - Rows33DocDatePosting DateDate80
44INV1A/R Invoice - Rows33DocDatePosting DateDate80
45MIN1Monthly Invoice Report Document Information5DocDateDocument Posting DateDate80
46MIN2Item Imformation of MI4DocDateDocument DateDate80
47MIV1A/P Monthly Invoice - Document5DocDateDocument Posting DateDate80
48MIV2A/P Monthly Invoice - Item4DocDateDocument DateDate80
49OCINA/R Correction Invoice11DocDatePosting DateDate80
50OCPIA/P Correction Invoice11DocDatePosting DateDate80
51OCPVA/P Correction Invoice Reversal11DocDatePosting DateDate80
52OCSIA/R Correction Invoice11DocDatePosting DateDate80
53OCSVA/R Correction Invoice Reversal11DocDatePosting DateDate80
54ODLNDelivery11DocDatePosting DateDate80
55ODPIA/R Down Payment11DocDatePosting DateDate80
56ODPOA/P Down Payment11DocDatePosting DateDate80
57ODRFDrafts11DocDatePosting DateDate80
58OEI1Outgoing Excise Invoice - Rows33DocDatePosting DateDate80
59OIEIIncoming Excise Invoice11DocDatePosting DateDate80
60OINVA/R Invoice11DocDatePosting DateDate80
61OOEIOutgoing Excise Invoice11DocDatePosting DateDate80
62OPCHA/P Invoice11DocDatePosting DateDate80
63OPDNGoods Receipt PO11DocDatePosting DateDate80
64OPORPurchase Order11DocDatePosting DateDate80
65OQUTSales Quotation11DocDatePosting DateDate80
66ORDNReturns11DocDatePosting DateDate80
67ORDRSales Order11DocDatePosting DateDate80
68ORINA/R Credit Memo11DocDatePosting DateDate80
69ORPCA/P Credit Memo11DocDatePosting DateDate80
70ORPDGoods Return11DocDatePosting DateDate80
71OSALOutgoing6DocDatePosting DateDate80
72OTPIPurchase Tax Invoice9DocDatePosting DateDate80
73OTRATransition6DocDatePosting DateDate80
74OTSISales Tax Invoice9DocDatePosting DateDate80
75OTXDTax Invoice Draft9DocDatePosting DateDate80
76OWDDDocs. for Confirmation6DocDatePosting DateDate80
77PCH1A/P Invoice - Rows33DocDatePosting DateDate80
78PDN1Goods Receipt PO - Rows33DocDatePosting DateDate80
79POR1Purchase Order - Rows33DocDatePosting DateDate80
80QUT1Sales Quotation - Rows33DocDatePosting DateDate80
81RDN1Returns - Rows33DocDatePosting DateDate80
82RDR1Sales Order - Rows33DocDatePosting DateDate80
83RIN1A/R Credit Memo - Rows33DocDatePosting DateDate80
84RPC1A/P Credit Memo - Rows33DocDatePosting DateDate80
85RPD1Goods Return - Rows33DocDatePosting DateDate80
86VRT2Tax Invoice Report Grid Info6DocDateDoc. DateDate80
TOPMRP
87ORCMRecommendation Data16DocDateGeneration DateDate80