SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

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