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
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

123 columns | Print definition?B1 9.2  | 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 vat adjustment-History1DocNumDocument 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 - vat adjustment1DocNumDocument 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 Rows1DocNumDocument NumberInt110
48VPM7Outgoing Payments - Tax Amount per Document1DocNumDocument NumberInt110
49VPM8Outgoing Payment - TDS Entries1DocNumDocument NumberInt110
TOPBusiness Partners
50OCLGActivities15DocNumLinked Document NumbernVarChar200
TOPFinance
51AFADAsset Document - History2DocNumDocument NumberInt110
52GBI7GBI Row 7 - Accounting Vouchers29DocNumDocument NumbernVarChar200
53ISW3Declaration Rows7DocNumDocument NumberInt110
54OACDCredit Memo2DocNumDocument NumberInt110
55OACQCapitalization2DocNumDocument NumberInt110
56ODRNDepreciation Run2DocNumDocument NumberInt110
57OFARFixed Asset Revaluation2DocNumDocument NumberInt110
58OFTRTransfer2DocNumDocument NumberInt110
59OMDPManual Depreciation2DocNumDocument NumberInt110
60ORTIRetirement2DocNumDocument NumberInt110
TOPGeneral
61OBTABrazil - Tax Adjustment4DocNumDocument NumberInt110
TOPInventory and Production
62AINCInventory Counting2DocNumDocument NumberInt110
63AIQIInventory Opening Balance16DocNumDocument NumberInt110
64AIQRInventory Posting16DocNumDocument NumberInt110
65AMRVInventory Revaluation - History2DocNumDocument NumberInt110
66AWORProduction Order - History2DocNumDocument NumberInt110
67OENTShipping Types2DocNumDocument NumberInt110
68OICDInventory Counting Draft2DocNumDocument NumberInt110
69OIGEGoods Issue2DocNumDocument NumberInt110
70OIGNGoods Receipt2DocNumDocument NumberInt110
71OINCInventory Counting2DocNumDocument NumberInt110
72OIODInventory Opening Balance Draft16DocNumDocument NumberInt110
73OIPDInventory Posting Draft16DocNumDocument NumberInt110
74OIPFLanded Costs2DocNumDocument NumberInt110
75OIQIInventory Opening Balance16DocNumDocument NumberInt110
76OIQRInventory Posting16DocNumDocument NumberInt110
77OITLInventory Transactions Log9DocNumDoc. NumberInt110
78OMRLAdvanced Inventory Revaluation2DocNumDocument NumberInt110
79OMRVInventory Revaluation2DocNumDocument NumberInt110
80OWORProduction Order2DocNumDocument NumberInt110
81OWTQInventory Transfer Request2DocNumDocument NumberInt110
82OWTRInventory Transfer2DocNumDocument NumberInt110
83UWORProduction Order2DocNumDocument NumberInt110
TOPMarketing Documents
84ADOCInvoice - History2DocNumDocument NumberInt110
85ATXITax Invoice - History2DocNumDocument NumberInt110
86DWZ2Dunning Wizard Array 2-Invoice Filter10DocNumDoc. No.Int110
87DWZ3Dunning Wizard Array 3 - Recommended Service Invoice20DocNumDocument NumberInt110
88DWZ4Dunning Wizard Array 4-Paging Grid11DocNumDoc. No.Int110
89GPA1Gross Profit Adjustment - Documents6DocNumDocument NumberInt110
90GPA5Product Cost Adjustment - Recalculation of Product Cost11DocNumDocument NumberInt110
91MIN1Monthly Invoice Report Document Information3DocNumDocument NumberInt110
92MIN2Item Imformation of MI2DocNumDocument NumberInt110
93MIV1A/P Monthly Invoice - Document3DocNumDocument NumberInt110
94MIV2A/P Monthly Invoice - Item2DocNumDocument NumberInt110
95OCINA/R Correction Invoice2DocNumDocument NumberInt110
96OCPIA/P Correction Invoice2DocNumDocument NumberInt110
97OCPVA/P Correction Invoice Reversal2DocNumDocument NumberInt110
98OCSIA/R Correction Invoice2DocNumDocument NumberInt110
99OCSVA/R Correction Invoice Reversal2DocNumDocument NumberInt110
100ODLNDelivery2DocNumDocument NumberInt110
101ODPIA/R Down Payment2DocNumDocument NumberInt110
102ODPOA/P Down Payment2DocNumDocument NumberInt110
103ODRFDrafts2DocNumDocument NumberInt110
104OIEIIncoming Excise Invoice2DocNumDocument NumberInt110
105OINVA/R Invoice2DocNumDocument NumberInt110
106OOEIOutgoing Excise Invoice2DocNumDocument NumberInt110
107OPCHA/P Invoice2DocNumDocument NumberInt110
108OPDNGoods Receipt PO2DocNumDocument NumberInt110
109OPORPurchase Order2DocNumDocument NumberInt110
110OPQTPurchase Quotation2DocNumDocument NumberInt110
111OPRQPurchase Request2DocNumDocument NumberInt110
112OQUTSales Quotation2DocNumDocument NumberInt110
113ORDNReturns2DocNumDocument NumberInt110
114ORDRSales Order2DocNumDocument NumberInt110
115ORINA/R Credit Memo2DocNumDocument NumberInt110
116ORPCA/P Credit Memo2DocNumDocument NumberInt110
117ORPDGoods Return2DocNumDocument NumberInt110
118OSALOutgoing2DocNumDocument NumberInt110
119OTPIPurchase Tax Invoice2DocNumDocument NumberInt110
120OTRATransition2DocNumDocument NumberInt110
121OTSISales Tax Invoice2DocNumDocument NumberInt110
122OTXDTax Invoice Draft2DocNumDocument NumberInt110
123TGPAGross Profit Adjustment - Log7DocNumDocument NumberInt110