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

65 columns | Print definition?B1 9.2  | DUEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AWLSWorkflow - Task Details12DueDateDue DateDate80
2DAR2Data Archive - Transaction Log9DueDateDue DateDate80
3OWJBWorkflow Job Entity5DueDateDue DateDate80
4OWLSWorkflow - Task Details12DueDateDue DateDate80
TOPBanking
5ABOEBill of Exchange for Payment - History7DueDateBill of Exchange Due DateDate80
6ARC1Incoming Payment - Checks - History3DueDateCheck DateDate80
7ARC6Incoming Payments - WTax Rows - History5DueDateDue DateDate80
8BOT1Bill of Exchange Transactions4DueDateBill of Exchange Due DateDate80
9MTH1VJournal Entries of External Reconciliation7DueDateDue DateDate80
10MTH2VBank Statements of External Reconciliation6DueDateDue DateDate80
11OBNKExternal Bank Statement Received6DueDateDue DateDate80
12OBOEBill of Exchange for Payment7DueDateBill of Exchange Due DateDate80
13PDF1Payment Draft - Checks3DueDateCheck DateDate80
14PDF6Payment Drafts - Withholding Tax - Rows5DueDateDue DateDate80
15RCT1Incoming Payment - Checks3DueDateCheck DateDate80
16RCT6Incoming Payments - WTax Rows5DueDateDue DateDate80
17VPM1Outgoing Payments - Check Rows3DueDateCheck DateDate80
18VPM6Outgoing Payments - WTax Rows5DueDateDue DateDate80
TOPFinance
19AJD1Journal Entry - History - Rows11DueDateValue DateDate80
20AJDTJournal Entry - History20DueDateDue DateDate80
21BTF1Journal Voucher - Rows11DueDateDue DateDate80
22CCPDPeriod-End Closing6DueDateDue DateDate80
23JDT1Journal Entry - Rows11DueDateDue DateDate80
24OBTFJournal Voucher Entry20DueDateValue DateDate80
25OHSVHasavsevet Journal Entry5DueDateDue DatenVarChar60
26OJDTJournal Entry20DueDateDue DateDate80
27RTM1Rate Differences - Rows16DueDateDue DateDate80
TOPInventory and Production
28AWORProduction Order - History11DueDateDue DateDate80
29IGE6Goods Issue - Installments5DueDateDue DateDate80
30IGN6Goods Receipt- Installments5DueDateDue DateDate80
31OWORProduction Order11DueDateDue DateDate80
32OWTCWTax Certificates7DueDateDue DateDate80
33UWORProduction Order11DueDateDue DateDate80
34WOR2VProduction Order - Base6DueDateDue DatenVarChar80
35WTQ6Inventory Transfer Request - Installments5DueDateDue DateDate80
36WTR6Inventory Transfer - Installments5DueDateDue DateDate80
TOPMarketing Documents
37ADO6Documents History - Installments5DueDateDue DateDate80
38CIN6Correction Invoice - Installments5DueDateDue DateDate80
39CPI6Documents History - Installments5DueDateDue DateDate80
40CPV6A/P Correction Invoice Reversal - Installments5DueDateDue DateDate80
41CSI6A/R Corr. Inv. - Installments5DueDateDue DateDate80
42CSV6A/R Correction Invoice Reversal - Installments5DueDateDue DateDate80
43DLN6Delivery - Installments5DueDateDue DateDate80
44DPI6A/R Down Payment - Installments5DueDateDue DateDate80
45DPO6Down Payment Out - Installments5DueDateDue DateDate80
46DRF6Document Drafts - Installments5DueDateDue DateDate80
47DWZ2Dunning Wizard Array 2-Invoice Filter18DueDateDue DateDate80
48DWZ4Dunning Wizard Array 4-Paging Grid13DueDateDue DateDate80
49GPA3Gross Profit Adjustment - JE Details4DueDateDue DateDate80
50IEI6IEI - Installments5DueDateDue DateDate80
51INV6A/R Invoice - Installments5DueDateDue DateDate80
52OEI6Outgoing Excise Invoice - Installments5DueDateDue DateDate80
53PCH6A/P Invoice - Installments5DueDateDue DateDate80
54PDN6Goods Receipt PO - Installments5DueDateDue DateDate80
55POR6Purchase Order - Installments5DueDateDue DateDate80
56PQT6Purchase Quotation - Installments5DueDateDue DateDate80
57PRQ6Purchase Request - Installments5DueDateDue DateDate80
58QUT6Sales Quotation - Installments5DueDateDue DateDate80
59RDN6Returns - Installments5DueDateDue DateDate80
60RDR6Sales Order - Installments5DueDateDue DateDate80
61RIN6A/R Credit Memo - Installments5DueDateDue DateDate80
62RPC6A/P Credit Memo - Installments5DueDateDue DateDate80
63RPD6Goods Return - Installments5DueDateDue DateDate80
TOPMRP
64ORCMRecommendation Data5DueDateOrder Due DateDate80
TOPReports
65OTRBTax Report Wizard for Brazil13DueDateDue DateDate80