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
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OPCH268A/P Invoice
5OVPM154Outgoing Payments
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

103 columns | Print definition?B1 8.82  | DOCNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log4DocNumDocument NumberInt110
2DAR2Data Archive - Transaction Log5DocNumDocument NumberInt110
3DAR3Data Archive - Handwritten Documents5DocNumDocument NumberInt110
4OCCDCargo Customs Declaration Numbers4DocNumImp./Exp. Document NumbernVarChar200
5OSRLSerial Numbers4DocNumInvoice NumberInt110
TOPBanking
6ARC1Incoming Payment - Checks - History1DocNumDocument NumberInt110
7ARC2Incoming Payment - Invoices - History1DocNumDocument NumberInt110
8ARC3Credit Vouchers History1DocNumDocument No.Int110
9ARC4Incoming Payment - Account List - History1DocNumDocument NumberInt110
10ARC5Reciept log 1DocNumDocument No. - HistoryInt110
11ARC6Incoming Payments - WTax Rows - History1DocNumDocument NumberInt110
12ARC7Incoming Payments - Tax Amount per Document - History1DocNumDocument NumberInt110
13ARC8Incoming Payment - TDS Entries - History1DocNumDocument NumberInt110
14ARCTIncoming Payment - History2DocNumDocument NumberInt110
15BNK2Bank Statement - Recommendation List19DocNumDocument NumberInt110
16OBNKExternal Bank Statement Received20DocNumInvoice DocumentnVarChar270
17OPDFPayment Draft2DocNumDocument NumberInt110
18ORCTIncoming Payment2DocNumDocument NumberInt110
19OVPMOutgoing Payments2DocNumDocument NumberInt110
20PDF1Payment Draft - Checks1DocNumDocument NumberInt110
21PDF2Payment Draft - Invoices1DocNumDocument NumberInt110
22PDF3Payment Draft - Credit Vouchers1DocNumDocument No.Int110
23PDF4Payment Draft - Account List1DocNumDocument NumberInt110
24PDF5PaymentDraft - 1DocNumDocument NumberInt110
25PDF6Payment Drafts - Withholding Tax - Rows1DocNumDocument NumberInt110
26PDF7Payment Draft - Tax Amount per Document1DocNumDocument NumberInt110
27PDF8Payment Draft - TDS Entries1DocNumDocument NumberInt110
28PEX1Payment Results Table - Rows26DocNumDocument NumberInt110
29PMN5Payment - VAT Adjustment1DocNumDocument NumberInt110
30PMV8Incoming Payment - TDS Entries1DocNumDocument NumberInt110
31PWZ3Payment Wizard - Rows 312DocNumDocument NumberInt110
32RCC4Incoming Payment - Credit Vouchers1DocNumDocument NumberInt110
33RCT1Incoming Payment - Checks1DocNumDocument NumberInt110
34RCT2Incoming Payments - Invoices1DocNumDocument NumberInt110
35RCT3Incoming Pmt - Credit Vouchers1DocNumDocument No.Int110
36RCT4Incoming Payment - Account List1DocNumDocument NumberInt110
37RCT5Reciept vat adjustment1DocNumDocument NumberInt110
38RCT6Incoming Payments - WTax Rows1DocNumDocument NumberInt110
39RCT7Incoming Pmt - Tax Amount per Document1DocNumDocument NumberInt110
40RCT8Incoming Payment - TDS Entries1DocNumDocument NumberInt110
41TMP8Incoming Payment - TDS Entries1DocNumDocument NumberInt110
42VPM1Outgoing Payments - Check Rows1DocNumDocument NumberInt110
43VPM2Outgoing Payments - Invoices1DocNumDocument NumberInt110
44VPM3Outgoing Payments - Credit Vouchers1DocNumDocument No.Int110
45VPM4Outgoing Payments - Accounts1DocNumDocument NumberInt110
46VPM5Outgoing Payments - Vat Adjustment1DocNumDocument NumberInt110
47VPM6Outgoing Payments - WTax 1DocNumDocument NumberInt110
48VPM7Outgoing Payments - Tax Amount per Document1DocNumDocument NumberInt110
49VPM8Outgoing Payment - TDS Entries1DocNumDocument NumberInt110
TOPBusiness Partners
50OCLGActivities15DocNumLinked Document NumbernVarChar200
TOPFinance
51GBI7GBI Row 7 - Accounting Vouchers29DocNumDocument NumbernVarChar200
TOPInventory and Production
52AMRVInventory Revaluation - History2DocNumDocument NumberInt110
53AWORProduction Order - History2DocNumDocument NumberInt110
54OENTShipping Types2DocNumDocument NumberInt110
55OIGEGoods Issue2DocNumDocument NumberInt110
56OIGNGoods Receipt2DocNumDocument NumberInt110
57OIPFLanded Costs2DocNumDocument NumberInt110
58OITLInventory Transactions Log9DocNumDoc. NumberInt110
59OMRLAdvanced Inventory Revaluation2DocNumDocument NumberInt110
60OMRVInventory Revaluation2DocNumDocument NumberInt110
61OWORProduction Order2DocNumDocument NumberInt110
62OWTQInventory Transfer Request2DocNumDocument NumberInt110
63OWTRInventory Transfer2DocNumDocument NumberInt110
64UWORProduction Order2DocNumDocument NumberInt110
TOPMarketing Documents
65ADOCInvoice - History2DocNumDocument NumberInt110
66ATXITax Invoice - History2DocNumDocument NumberInt110
67DWZ2Dunning Wizard Array 2-Invoice Filter10DocNumDoc. No.Int110
68DWZ3Dunning Wizard Array 3 - Recommended Service Invoice20DocNumDocument NumberInt110
69MIN1Monthly Invoice Report Document Information3DocNumDocument NumberInt110
70MIN2Item Imformation of MI2DocNumDocument NumberInt110
71MIV1A/P Monthly Invoice - Document3DocNumDocument NumberInt110
72MIV2A/P Monthly Invoice - Item2DocNumDocument NumberInt110
73OCINA/R Correction Invoice2DocNumDocument NumberInt110
74OCPIA/P Correction Invoice2DocNumDocument NumberInt110
75OCPVA/P Correction Invoice Reversal2DocNumDocument NumberInt110
76OCSIA/R Correction Invoice2DocNumDocument NumberInt110
77OCSVA/R Correction Invoice Reversal2DocNumDocument NumberInt110
78ODLNDelivery2DocNumDocument NumberInt110
79ODPIA/R Down Payment2DocNumDocument NumberInt110
80ODPOA/P Down Payment2DocNumDocument NumberInt110
81ODRFDrafts2DocNumDocument NumberInt110
82OIEIIncoming Excise Invoice2DocNumDocument NumberInt110
83OINVA/R Invoice2DocNumDocument NumberInt110
84OOEIOutgoing Excise Invoice2DocNumDocument NumberInt110
85OPCHA/P Invoice2DocNumDocument NumberInt110
86OPDNGoods Receipt PO2DocNumDocument NumberInt110
87OPORPurchase Order2DocNumDocument NumberInt110
88OPQTPurchase Quotation2DocNumDocument NumberInt110
89OQUTSales Quotation2DocNumDocument NumberInt110
90ORDNReturns2DocNumDocument NumberInt110
91ORDRSales Order2DocNumDocument NumberInt110
92ORINA/R Credit Memo2DocNumDocument NumberInt110
93ORPCA/P Credit Memo2DocNumDocument NumberInt110
94ORPDGoods Return2DocNumDocument NumberInt110
95OSALOutgoing2DocNumDocument NumberInt110
96OTPIPurchase Tax Invoice2DocNumDocument NumberInt110
97OTRATransition2DocNumDocument NumberInt110
98OTSISales Tax Invoice2DocNumDocument NumberInt110
99OTXDTax Invoice Draft2DocNumDocument NumberInt110
TOPSales Opportunities
100OOPRSales Opportunity47DocNumLinked Document NumberInt110
TOPService
101ASCLHistory59DocNumDocument NumberInt110
102OCTRService Contracts19DocNumSource DocumentInt110
103OSCLService Calls59DocNumDocument NumberInt110