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

79 columns | Print definition?B1 9.3  | 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
TOPGeneral
28APH8Project Management - Summary - History33DueDateDue DateDate80
29APHAProject Management Subproject - History16DUEDATEDue DateDate80
30APM8Project Management - Summary - History33DueDateDue DateDate80
31APMGProject Management Document - History16DUEDATEDue DateDate80
32OPHAProject Management Subproject16DUEDATEDue DateDate80
33OPMGProject Management Document16DUEDATEDue DateDate80
34OUGRAuthorization Group7DueDateDue DateDate80
35PHA8Project Management - Summary33DueDateDue DateDate80
36PMG8Project Management - Summary33DueDateDue DateDate80
37USR7Group User Association5DueDateDue DateDate80
TOPInventory and Production
38AWORProduction Order - History11DueDateDue DateDate80
39IGE6Goods Issue - Installments5DueDateDue DateDate80
40IGN6Goods Receipt- Installments5DueDateDue DateDate80
41OWORProduction Order11DueDateDue DateDate80
42OWTCWTax Certificates7DueDateDue DateDate80
43UWORProduction Order11DueDateDue DateDate80
44WOR2VProduction Order - Base6DueDateDue DatenVarChar80
45WTQ6Inventory Transfer Request - Installments5DueDateDue DateDate80
46WTR6Inventory Transfer - Installments5DueDateDue DateDate80
TOPMarketing Documents
47ADO6Documents History - Installments5DueDateDue DateDate80
48CIN6Correction Invoice - Installments5DueDateDue DateDate80
49CPI6Documents History - Installments5DueDateDue DateDate80
50CPV6A/P Correction Invoice Reversal - Installments5DueDateDue DateDate80
51CSI6A/R Corr. Inv. - Installments5DueDateDue DateDate80
52CSV6A/R Correction Invoice Reversal - Installments5DueDateDue DateDate80
53DLN6Delivery - Installments5DueDateDue DateDate80
54DPI6A/R Down Payment - Installments5DueDateDue DateDate80
55DPO6Down Payment Out - Installments5DueDateDue DateDate80
56DRF6Document Drafts - Installments5DueDateDue DateDate80
57DWZ2Dunning Wizard Array 2-Invoice Filter18DueDateDue DateDate80
58DWZ4Dunning Wizard Array 4-Paging Grid13DueDateDue DateDate80
59GPA3Gross Profit Adjustment - JE Details4DueDateDue DateDate80
60IEI6IEI - Installments5DueDateDue DateDate80
61INV6A/R Invoice - Installments5DueDateDue DateDate80
62OEI6Outgoing Excise Invoice - Installments5DueDateDue DateDate80
63PCH6A/P Invoice - Installments5DueDateDue DateDate80
64PDN6Goods Receipt PO - Installments5DueDateDue DateDate80
65POR6Purchase Order - Installments5DueDateDue DateDate80
66PQT6Purchase Quotation - Installments5DueDateDue DateDate80
67PRQ6Purchase Request - Installments5DueDateDue DateDate80
68PRR6A/P Return Request - Installments5DueDateDue DateDate80
69QUT6Sales Quotation - Installments5DueDateDue DateDate80
70RDN6Returns - Installments5DueDateDue DateDate80
71RDR6Sales Order - Installments5DueDateDue DateDate80
72RIN6A/R Credit Memo - Installments5DueDateDue DateDate80
73RPC6A/P Credit Memo - Installments5DueDateDue DateDate80
74RPD6Goods Return - Installments5DueDateDue DateDate80
75RRR6A/R Return Request - Installments5DueDateDue DateDate80
76SFC6Self Credit Memo - Installments5DueDateDue DateDate80
77SFI6Self Invoice - Installments5DueDateDue DateDate80
TOPMRP
78ORCMRecommendation Data5DueDateOrder Due DateDate80
TOPReports
79OTRBTax Report Wizard for Brazil13DueDateDue DateDate80