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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
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
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

110 columns | Print definition?B1 9.2  | 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
7AFADAsset Document - History7DocDateDocument DateDate80
8GBI7GBI Row 7 - Accounting Vouchers3DocDateDocument DatenVarChar80
9OACDCredit Memo7DocDateDocument DateDate80
10OACQCapitalization7DocDateDocument DateDate80
11OFARFixed Asset Revaluation13DocDateDocument DateDate80
12OFTRTransfer7DocDateDocument DateDate80
13OJSTTDS Adjustment2DocDatePosting DateDate80
14OMDPManual Depreciation7DocDateDocument DateDate80
15ORTIRetirement7DocDateDocument DateDate80
16OSLMSpecial Ledger - Analytical Accounting Report: Material2DocDateDate of Report GenerationDate80
17OSLRSpecial Ledger - Analytical Accounting Report: Revenues & Expenses2DocDateDate of Report GenerationDate80
18OZRDPOS Daily Summary2DocDateDocument DateDate80
19VRW2VAT Reposting Wizard - Rows 27DocDateDocument DateDate80
TOPInventory and Production
20AIQIInventory Opening Balance6DocDatePosting DateDate80
21AIQRInventory Posting6DocDatePosting DateDate80
22AMRVInventory Revaluation - History3DocDatePosting DateDate80
23IGE1Goods Issue - Rows33DocDatePosting DateDate80
24IGN1Goods Receipt - Rows33DocDatePosting DateDate80
25OAIMArchive Inventory Message19DocDateDocument DateDate80
26OENTShipping Types6DocDatePosting DateDate80
27OIGEGoods Issue11DocDatePosting DateDate80
28OIGNGoods Receipt11DocDatePosting DateDate80
29OILMInventory Log Message24DocDateDoc DateDate80
30OIODInventory Opening Balance Draft6DocDatePosting DateDate80
31OIPDInventory Posting Draft6DocDatePosting DateDate80
32OIPFLanded Costs3DocDatePosting DateDate80
33OIQIInventory Opening Balance6DocDatePosting DateDate80
34OIQRInventory Posting6DocDatePosting DateDate80
35OITLInventory Transactions Log16DocDateDoc. Posting DateDate80
36OIVLWhse Journal5DocDatePosting DateDate80
37OMRLAdvanced Inventory Revaluation4DocDatePosting DateDate80
38OMRVInventory Revaluation3DocDatePosting DateDate80
39OWTQInventory Transfer Request11DocDatePosting DateDate80
40OWTRInventory Transfer11DocDatePosting DateDate80
41SIVLWhse Journal5DocDatePosting DateDate80
42UILMIVI Inventory Log Message24DocDateDoc DateDate80
43UIVLWhse Journal5DocDatePosting DateDate80
44WTQ1Inventory Transfer Request - Rows33DocDatePosting DateDate80
45WTR1Inventory Transfer - Rows33DocDatePosting DateDate80
TOPMarketing Documents
46ADO1A/R Invoice (Rows) - History33DocDatePosting DateDate80
47ADOCInvoice - History11DocDatePosting DateDate80
48ATXITax Invoice - History9DocDatePosting DateDate80
49CIN1Correction Invoice - Rows33DocDatePosting DateDate80
50CPI1A/P Correction Invoice - Rows33DocDatePosting DateDate80
51CPV1A/P Correction Invoice Reversal - Rows33DocDatePosting DateDate80
52CSI1A/R Correction Invoice - Rows33DocDatePosting DateDate80
53CSV1A/R Correction Invoice Reversal - Rows33DocDatePosting DateDate80
54DLN1Delivery - Rows33DocDatePosting DateDate80
55DPI1A/R Down Payment - Rows33DocDatePosting DateDate80
56DPO1A/P Down Payment - Rows33DocDatePosting DateDate80
57DRF1Draft - Rows33DocDatePosting DateDate80
58GPA3Gross Profit Adjustment - JE Details3DocDateDocument DateDate80
59GPA7Product Cost Adjustment - Journal Entry Details3DocDateDocument DateDate80
60IEI1Incoming Excise Invoice - Rows33DocDatePosting DateDate80
61INV1A/R Invoice - Rows33DocDatePosting DateDate80
62MIN1Monthly Invoice Report Document Information5DocDateDocument Posting DateDate80
63MIN2Item Imformation of MI4DocDateDocument DateDate80
64MIV1A/P Monthly Invoice - Document5DocDateDocument Posting DateDate80
65MIV2A/P Monthly Invoice - Item4DocDateDocument DateDate80
66OCINA/R Correction Invoice11DocDatePosting DateDate80
67OCPIA/P Correction Invoice11DocDatePosting DateDate80
68OCPVA/P Correction Invoice Reversal11DocDatePosting DateDate80
69OCSIA/R Correction Invoice11DocDatePosting DateDate80
70OCSVA/R Correction Invoice Reversal11DocDatePosting DateDate80
71ODLNDelivery11DocDatePosting DateDate80
72ODPIA/R Down Payment11DocDatePosting DateDate80
73ODPOA/P Down Payment11DocDatePosting DateDate80
74ODRFDrafts11DocDatePosting DateDate80
75OEI1Outgoing Excise Invoice - Rows33DocDatePosting DateDate80
76OGTIGTS Invoice9DocDateDocument DateDate80
77OIEIIncoming Excise Invoice11DocDatePosting DateDate80
78OINVA/R Invoice11DocDatePosting DateDate80
79OOEIOutgoing Excise Invoice11DocDatePosting DateDate80
80OPCHA/P Invoice11DocDatePosting DateDate80
81OPDNGoods Receipt PO11DocDatePosting DateDate80
82OPORPurchase Order11DocDatePosting DateDate80
83OPQNPurchase Quotation Group2DocDatePosting DateDate80
84OPQTPurchase Quotation11DocDatePosting DateDate80
85OPRQPurchase Request11DocDatePosting DateDate80
86OQUTSales Quotation11DocDatePosting DateDate80
87ORDNReturns11DocDatePosting DateDate80
88ORDRSales Order11DocDatePosting DateDate80
89ORINA/R Credit Memo11DocDatePosting DateDate80
90ORPCA/P Credit Memo11DocDatePosting DateDate80
91ORPDGoods Return11DocDatePosting DateDate80
92OSALOutgoing6DocDatePosting DateDate80
93OTPIPurchase Tax Invoice9DocDatePosting DateDate80
94OTRATransition6DocDatePosting DateDate80
95OTSISales Tax Invoice9DocDatePosting DateDate80
96OTXDTax Invoice Draft9DocDatePosting DateDate80
97OWDDDocs. for Confirmation6DocDatePosting DateDate80
98PCH1A/P Invoice - Rows33DocDatePosting DateDate80
99PDN1Goods Receipt PO - Rows33DocDatePosting DateDate80
100POR1Purchase Order - Rows33DocDatePosting DateDate80
101PQT1Purchase Quotation - Rows33DocDatePosting DateDate80
102PRQ1Purchase Request - Rows33DocDatePosting DateDate80
103QUT1Sales Quotation - Rows33DocDatePosting DateDate80
104RDN1Returns - Rows33DocDatePosting DateDate80
105RDR1Sales Order - Rows33DocDatePosting DateDate80
106RIN1A/R Credit Memo - Rows33DocDatePosting DateDate80
107RPC1A/P Credit Memo - Rows33DocDatePosting DateDate80
108RPD1Goods Return - Rows33DocDatePosting DateDate80
109VRT2Tax Invoice Report Grid Info6DocDateDoc. DateDate80
TOPMRP
110ORCMRecommendation Data16DocDateGeneration DateDate80