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

134 columns | Print definition?B1 9.3  | 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
TOPGeneral
20AIRIInput Service Distribution - Recipient Invoice5DocDateDocument DateDate80
21AIRRInput Service Distribution - Recipient Credit Memo5DocDateDocument DateDate80
22AISCInput Service Distribution - Credit Memo5DocDateDocument DateDate80
23AISDInput Service Distribution7DocDateDocument DateDate80
24AISIInput Service Distribution - Invoice5DocDateDocument DateDate80
25APH4Project Management - Stages - Documents - History7DocDateDocument DateDate80
26APM4Project Management - Stages - Documents - History7DocDateDocument DateDate80
27OIRIInput Service Distribution - Recipient Invoice5DocDateDocument DateDate80
28OIRRInput Service Distribution - Recipient Credit Memo5DocDateDocument DateDate80
29OISCInput Service Distribution - Credit Memo5DocDateDocument DateDate80
30OISDInput Service Distribution7DocDateDocument DateDate80
31OISIInput Service Distribution - Invoice5DocDateDocument DateDate80
32PHA4Project Management - Stages - Documents7DocDateDocument DateDate80
33PMG4Project Management - Stages - Documents7DocDateDocument DateDate80
TOPInventory and Production
34AIQIInventory Opening Balance6DocDatePosting DateDate80
35AIQRInventory Posting6DocDatePosting DateDate80
36AMRVInventory Revaluation - History3DocDatePosting DateDate80
37IGE1Goods Issue - Rows33DocDatePosting DateDate80
38IGN1Goods Receipt - Rows33DocDatePosting DateDate80
39OAIMArchive Inventory Message19DocDateDocument DateDate80
40OENTShipping Types6DocDatePosting DateDate80
41OIGEGoods Issue11DocDatePosting DateDate80
42OIGNGoods Receipt11DocDatePosting DateDate80
43OILMInventory Log Message24DocDateDoc DateDate80
44OIODInventory Opening Balance Draft6DocDatePosting DateDate80
45OIPDInventory Posting Draft6DocDatePosting DateDate80
46OIPFLanded Costs3DocDatePosting DateDate80
47OIQIInventory Opening Balance6DocDatePosting DateDate80
48OIQRInventory Posting6DocDatePosting DateDate80
49OITLInventory Transactions Log16DocDateDoc. Posting DateDate80
50OIVLWhse Journal5DocDatePosting DateDate80
51OMRLAdvanced Inventory Revaluation4DocDatePosting DateDate80
52OMRVInventory Revaluation3DocDatePosting DateDate80
53OWTQInventory Transfer Request11DocDatePosting DateDate80
54OWTRInventory Transfer11DocDatePosting DateDate80
55SIVLWhse Journal5DocDatePosting DateDate80
56UILMIVI Inventory Log Message24DocDateDoc DateDate80
57UIVLWhse Journal5DocDatePosting DateDate80
58WTQ1Inventory Transfer Request - Rows33DocDatePosting DateDate80
59WTR1Inventory Transfer - Rows33DocDatePosting DateDate80
TOPMarketing Documents
60ADO1A/R Invoice (Rows) - History33DocDatePosting DateDate80
61ADOCInvoice - History11DocDatePosting DateDate80
62ATXITax Invoice - History9DocDatePosting DateDate80
63CIN1Correction Invoice - Rows33DocDatePosting DateDate80
64CPI1A/P Correction Invoice - Rows33DocDatePosting DateDate80
65CPV1A/P Correction Invoice Reversal - Rows33DocDatePosting DateDate80
66CSI1A/R Correction Invoice - Rows33DocDatePosting DateDate80
67CSV1A/R Correction Invoice Reversal - Rows33DocDatePosting DateDate80
68DLN1Delivery - Rows33DocDatePosting DateDate80
69DPI1A/R Down Payment - Rows33DocDatePosting DateDate80
70DPO1A/P Down Payment - Rows33DocDatePosting DateDate80
71DRF1Draft - Rows33DocDatePosting DateDate80
72GPA3Gross Profit Adjustment - JE Details3DocDateDocument DateDate80
73GPA7Product Cost Adjustment - Journal Entry Details3DocDateDocument DateDate80
74IEI1Incoming Excise Invoice - Rows33DocDatePosting DateDate80
75INV1A/R Invoice - Rows33DocDatePosting DateDate80
76MIN1Monthly Invoice Report Document Information5DocDateDocument Posting DateDate80
77MIN2Item Imformation of MI4DocDateDocument DateDate80
78MIV1A/P Monthly Invoice - Document5DocDateDocument Posting DateDate80
79MIV2A/P Monthly Invoice - Item4DocDateDocument DateDate80
80OCINA/R Correction Invoice11DocDatePosting DateDate80
81OCPIA/P Correction Invoice11DocDatePosting DateDate80
82OCPVA/P Correction Invoice Reversal11DocDatePosting DateDate80
83OCSIA/R Correction Invoice11DocDatePosting DateDate80
84OCSVA/R Correction Invoice Reversal11DocDatePosting DateDate80
85ODLNDelivery11DocDatePosting DateDate80
86ODPIA/R Down Payment11DocDatePosting DateDate80
87ODPOA/P Down Payment11DocDatePosting DateDate80
88ODRFDrafts11DocDatePosting DateDate80
89OEI1Outgoing Excise Invoice - Rows33DocDatePosting DateDate80
90OGTIGTS Invoice9DocDateDocument DateDate80
91OIEIIncoming Excise Invoice11DocDatePosting DateDate80
92OINVA/R Invoice11DocDatePosting DateDate80
93OOEIOutgoing Excise Invoice11DocDatePosting DateDate80
94OPCHA/P Invoice11DocDatePosting DateDate80
95OPDNGoods Receipt PO11DocDatePosting DateDate80
96OPORPurchase Order11DocDatePosting DateDate80
97OPQNPurchase Quotation Group2DocDatePosting DateDate80
98OPQTPurchase Quotation11DocDatePosting DateDate80
99OPRQPurchase Request11DocDatePosting DateDate80
100OPRRGoods Return Request11DocDatePosting DateDate80
101OQUTSales Quotation11DocDatePosting DateDate80
102ORDNReturns11DocDatePosting DateDate80
103ORDRSales Order11DocDatePosting DateDate80
104ORINA/R Credit Memo11DocDatePosting DateDate80
105ORPCA/P Credit Memo11DocDatePosting DateDate80
106ORPDGoods Return11DocDatePosting DateDate80
107ORRRReturn Request11DocDatePosting DateDate80
108OSALOutgoing6DocDatePosting DateDate80
109OSFCSelf Credit Memo11DocDatePosting DateDate80
110OSFISelf Invoice11DocDatePosting DateDate80
111OTPIPurchase Tax Invoice9DocDatePosting DateDate80
112OTRATransition6DocDatePosting DateDate80
113OTSISales Tax Invoice9DocDatePosting DateDate80
114OTXDTax Invoice Draft9DocDatePosting DateDate80
115OWDDDocs. for Confirmation6DocDatePosting DateDate80
116PCH1A/P Invoice - Rows33DocDatePosting DateDate80
117PDN1Goods Receipt PO - Rows33DocDatePosting DateDate80
118POR1Purchase Order - Rows33DocDatePosting DateDate80
119PQT1Purchase Quotation - Rows33DocDatePosting DateDate80
120PRQ1Purchase Request - Rows33DocDatePosting DateDate80
121PRR1A/P Return Request - Rows33DocDatePosting DateDate80
122QUT1Sales Quotation - Rows33DocDatePosting DateDate80
123RDN1Returns - Rows33DocDatePosting DateDate80
124RDR1Sales Order - Rows33DocDatePosting DateDate80
125RIN1A/R Credit Memo - Rows33DocDatePosting DateDate80
126RPC1A/P Credit Memo - Rows33DocDatePosting DateDate80
127RPD1Goods Return - Rows33DocDatePosting DateDate80
128RRR1A/R Return Request - Rows33DocDatePosting DateDate80
129SFC1Self Credit Memo - Rows33DocDatePosting DateDate80
130SFI1Self Invoice - Rows33DocDatePosting DateDate80
131VRT2Tax Invoice Report Grid Info6DocDateDoc. DateDate80
TOPMRP
132ORCMRecommendation Data16DocDateGeneration DateDate80
TOPReports
133EML1E-mail Log - Rows4DocDatePosting DateDate80
134SOI4Statement of Import - Invoices6DocDatePosting DateDate80