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

165 columns | Print definition?B1 9.3  | 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
50ACLGActivities - History15DocNumLinked Document NumbernVarChar500
51OCLGActivities15DocNumLinked Document NumbernVarChar500
TOPFinance
52AFADAsset Document - History2DocNumDocument NumberInt110
53AJD1Journal Entry - History - Rows131DocNumSource Document NumberInt110
54BTF1Journal Voucher - Rows131DocNumSource Document NumberInt110
55GBI7GBI Row 7 - Accounting Vouchers29DocNumDocument NumbernVarChar200
56ISW3Declaration Rows7DocNumDocument NumberInt110
57JDT1Journal Entry - Rows131DocNumSource Document NumberInt110
58OACDCredit Memo2DocNumDocument NumberInt110
59OACQCapitalization2DocNumDocument NumberInt110
60ODRNDepreciation Run2DocNumDocument NumberInt110
61OFARFixed Asset Revaluation2DocNumDocument NumberInt110
62OFTRTransfer2DocNumDocument NumberInt110
63OMDPManual Depreciation2DocNumDocument NumberInt110
64ORTIRetirement2DocNumDocument NumberInt110
TOPGeneral
65AIRIInput Service Distribution - Recipient Invoice2DocNumDocument NumberInt110
66AIRRInput Service Distribution - Recipient Credit Memo2DocNumDocument NumberInt110
67AISCInput Service Distribution - Credit Memo2DocNumDocument NumberInt110
68AISDInput Service Distribution2DocNumDocument NumberInt110
69AISIInput Service Distribution - Invoice2DocNumDocument NumberInt110
70APH4Project Management - Stages - Documents - History5DOCNUMDocument NumberInt110
71APH7Project Management - Workorders - History4DOCNUMDocument NumberInt110
72APM4Project Management - Stages - Documents - History5DOCNUMDocument NumberInt110
73APM7Project Management - Workorders - History4DOCNUMDocument NumberInt110
74APMGProject Management Document - History6DocNumDocument NumberInt110
75ATSHProject Management Time Sheet - Header - History3DocNumDocument NumberInt110
76OBTABrazil - Tax Adjustment4DocNumDocument NumberInt110
77OIRIInput Service Distribution - Recipient Invoice2DocNumDocument NumberInt110
78OIRRInput Service Distribution - Recipient Credit Memo2DocNumDocument NumberInt110
79OISCInput Service Distribution - Credit Memo2DocNumDocument NumberInt110
80OISDInput Service Distribution2DocNumDocument NumberInt110
81OISIInput Service Distribution - Invoice2DocNumDocument NumberInt110
82OPMGProject Management Document6DocNumDocument NumberInt110
83OTSHProject Management Time Sheet - Header3DocNumDocument NumberInt110
84PHA4Project Management - Stages - Documents5DOCNUMDocument NumberInt110
85PHA7Project Management - Workorders4DOCNUMDocument NumberInt110
86PMG4Project Management - Stages - Documents5DOCNUMDocument NumberInt110
87PMG7Project Management - Workorders4DOCNUMDocument NumberInt110
TOPInventory and Production
88AINCInventory Counting2DocNumDocument NumberInt110
89AIQIInventory Opening Balance16DocNumDocument NumberInt110
90AIQRInventory Posting16DocNumDocument NumberInt110
91AMRVInventory Revaluation - History2DocNumDocument NumberInt110
92AWORProduction Order - History2DocNumDocument NumberInt110
93OENTShipping Types2DocNumDocument NumberInt110
94OICDInventory Counting Draft2DocNumDocument NumberInt110
95OIGEGoods Issue2DocNumDocument NumberInt110
96OIGNGoods Receipt2DocNumDocument NumberInt110
97OINCInventory Counting2DocNumDocument NumberInt110
98OIODInventory Opening Balance Draft16DocNumDocument NumberInt110
99OIPDInventory Posting Draft16DocNumDocument NumberInt110
100OIPFLanded Costs2DocNumDocument NumberInt110
101OIQIInventory Opening Balance16DocNumDocument NumberInt110
102OIQRInventory Posting16DocNumDocument NumberInt110
103OITLInventory Transactions Log9DocNumDoc. NumberInt110
104OMRLAdvanced Inventory Revaluation2DocNumDocument NumberInt110
105OMRVInventory Revaluation2DocNumDocument NumberInt110
106ORTLResource Transaction Log20DocNumDocument NumbernVarChar110
107OTNLCCD Log7DocNumDoc NumberInt110
108OWORProduction Order2DocNumDocument NumberInt110
109OWTQInventory Transfer Request2DocNumDocument NumberInt110
110OWTRInventory Transfer2DocNumDocument NumberInt110
111UWORProduction Order2DocNumDocument NumberInt110
TOPMarketing Documents
112ADOCInvoice - History2DocNumDocument NumberInt110
113ATXITax Invoice - History2DocNumDocument NumberInt110
114DWZ2Dunning Wizard Array 2-Invoice Filter10DocNumDoc. No.Int110
115DWZ3Dunning Wizard Array 3 - Recommended Service Invoice20DocNumDocument NumberInt110
116DWZ4Dunning Wizard Array 4-Paging Grid11DocNumDoc. No.Int110
117GPA1Gross Profit Adjustment - Documents6DocNumDocument NumberInt110
118GPA5Product Cost Adjustment - Recalculation of Product Cost11DocNumDocument NumberInt110
119MIN1Monthly Invoice Report Document Information3DocNumDocument NumberInt110
120MIN2Item Imformation of MI2DocNumDocument NumberInt110
121MIV1A/P Monthly Invoice - Document3DocNumDocument NumberInt110
122MIV2A/P Monthly Invoice - Item2DocNumDocument NumberInt110
123OCINA/R Correction Invoice2DocNumDocument NumberInt110
124OCPIA/P Correction Invoice2DocNumDocument NumberInt110
125OCPVA/P Correction Invoice Reversal2DocNumDocument NumberInt110
126OCSIA/R Correction Invoice2DocNumDocument NumberInt110
127OCSVA/R Correction Invoice Reversal2DocNumDocument NumberInt110
128ODLNDelivery2DocNumDocument NumberInt110
129ODPIA/R Down Payment2DocNumDocument NumberInt110
130ODPOA/P Down Payment2DocNumDocument NumberInt110
131ODRFDrafts2DocNumDocument NumberInt110
132OIEIIncoming Excise Invoice2DocNumDocument NumberInt110
133OINVA/R Invoice2DocNumDocument NumberInt110
134OOEIOutgoing Excise Invoice2DocNumDocument NumberInt110
135OPCHA/P Invoice2DocNumDocument NumberInt110
136OPDNGoods Receipt PO2DocNumDocument NumberInt110
137OPORPurchase Order2DocNumDocument NumberInt110
138OPQTPurchase Quotation2DocNumDocument NumberInt110
139OPRQPurchase Request2DocNumDocument NumberInt110
140OPRRGoods Return Request2DocNumDocument NumberInt110
141OQUTSales Quotation2DocNumDocument NumberInt110
142ORDNReturns2DocNumDocument NumberInt110
143ORDRSales Order2DocNumDocument NumberInt110
144ORINA/R Credit Memo2DocNumDocument NumberInt110
145ORPCA/P Credit Memo2DocNumDocument NumberInt110
146ORPDGoods Return2DocNumDocument NumberInt110
147ORRRReturn Request2DocNumDocument NumberInt110
148OSALOutgoing2DocNumDocument NumberInt110
149OSFCSelf Credit Memo2DocNumDocument NumberInt110
150OSFISelf Invoice2DocNumDocument NumberInt110
151OTPIPurchase Tax Invoice2DocNumDocument NumberInt110
152OTRATransition2DocNumDocument NumberInt110
153OTSISales Tax Invoice2DocNumDocument NumberInt110
154OTXDTax Invoice Draft2DocNumDocument NumberInt110
155TGPAGross Profit Adjustment - Log7DocNumDocument NumberInt110
TOPReports
156AEC5List of Canceled Reconciliations for Actions in Electronic Communication5DocNumDocument NumberInt110
157ECM5List of Related Documents for Actions in Electronic Communication5DocNumDocument NumberInt110
158OEMLE-mail Log6DocNumDocument NumberInt110
159SOI4Statement of Import - Invoices5DocNumDoc. No.Int110
TOPSales Opportunities
160AOPROpportunity47DocNumLinked Document NumberInt110
161OOPROpportunity47DocNumLinked Document NumberInt110
TOPService
162ACTRService Contracts19DocNumSource DocumentInt110
163ASCLHistory59DocNumDocument NumberInt110
164OCTRService Contracts19DocNumSource DocumentInt110
165OSCLService Calls59DocNumDocument NumberInt110