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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

66 columns | Print definition?B1 9.3  | REMARK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ADP1Object Settings - History7RemarkStandard RemarksText160
2NFN1Not a Fiscal Sequence9RemarkRemarksnVarChar500
3NNM1Documents Numbering - Series9RemarkRemarksnVarChar500
4NNM4Electronic Series10RemarkRemarksnVarChar500
5OWFERWorkflow Error Message9RemarkRemarksText160
6UDG1User Defaults - Documents7RemarkPermanent RemarkText160
TOPFinance
7FIX1Fixed Asset Transaction - Rows32RemarkRemarksnVarChar2540
8GBI7GBI Row 7 - Accounting Vouchers7RemarkDetails of Each LinenVarChar500
TOPHuman Resources
9AHEMEmployees - History55remarkRemarksText160
10OHEMEmployees55remarkRemarksText160
TOPInventory and Production
11AIN1Inventory Counting - Rows12RemarkRemarksnVarChar2540
12AQI1Inventory Opening Balance - Rows31RemarkRemarksnVarChar2540
13AQR1Inventory Posting - Rows38RemarkRemarksnVarChar2540
14AWO5Production Order - Document Reference Information - History10RemarkRemarksnVarChar2540
15ICD1Inventory Counting Draft - Rows12RemarkRemarksnVarChar2540
16IGE21Goods Issue - Document Reference Information20RemarkRemarksnVarChar2540
17IGN21Goods Receipt - Document Reference Information20RemarkRemarksnVarChar2540
18INC1Inventory Counting - Rows12RemarkRemarksnVarChar2540
19IOD1Inventory Opening Balance Draft - Rows31RemarkRemarksnVarChar2540
20IPD1Inventory Posting Draft - Rows38RemarkRemarksnVarChar2540
21IQI1Inventory Opening Balance - Rows31RemarkRemarksnVarChar2540
22IQR1Inventory Posting - Rows38RemarkRemarksnVarChar2540
23UWOR5Production Order - Document Reference Information10RemarkRemarksnVarChar2540
24WOR2VProduction Order - Base8RemarkDocument RemarksnVarChar2540
25WOR5Production Order - Document Reference Information10RemarkRemarksnVarChar2540
26WTQ21Inventory Transfer Request - Document Reference Information20RemarkRemarksnVarChar2540
27WTR21Inventory Transfer - Document Reference Information20RemarkRemarksnVarChar2540
TOPMarketing Documents
28ADO21A/R Invoice - Document Reference Information - History20RemarkRemarksnVarChar2540
29ATX3Tax Invoice Archive - Document Reference Information10RemarkRemarksnVarChar2540
30CIN21Correction Invoice - Document Reference Information20RemarkRemarksnVarChar2540
31CPI21A/P Correction Invoice - Document Reference Information20RemarkRemarksnVarChar2540
32CPV21A/P Correction Invoice Reversal - Document Reference Information20RemarkRemarksnVarChar2540
33CSI21A/R Correction Invoice - Document Reference Information20RemarkRemarksnVarChar2540
34CSV21A/R Correction Invoice Reversal - Document Reference Information20RemarkRemarksnVarChar2540
35DLN21Delivery - Document Reference Information20RemarkRemarksnVarChar2540
36DPI21A/R Down Payment - Document Reference Information20RemarkRemarksnVarChar2540
37DPO21A/P Down Payment - Document Reference Information20RemarkRemarksnVarChar2540
38DRF21Draft - Document Reference Information20RemarkRemarksnVarChar2540
39IEI21Incoming Excise Invoice - Document Reference Information20RemarkRemarksnVarChar2540
40INV21A/R Invoice - Document Reference Information20RemarkRemarksnVarChar2540
41OEI21Outgoing Excise Invoice - Document Reference Information20RemarkRemarksnVarChar2540
42OGTMGTS Mapping Object11RemarkRemarksnVarChar2540
43PCH21A/P Invoice - Document Reference Information20RemarkRemarksnVarChar2540
44PDN21Goods Receipt PO - Document Reference Information20RemarkRemarksnVarChar2540
45POR21Purchase Order - Document Reference Information20RemarkRemarksnVarChar2540
46PQT21Purchase Quotation - Document Reference Information20RemarkRemarksnVarChar2540
47PRQ21Purchase Request - Document Reference Information20RemarkRemarksnVarChar2540
48PRR21A/P Return Request - Document Reference Information20RemarkRemarksnVarChar2540
49QUT21Sales Quotation - Document Reference Information20RemarkRemarksnVarChar2540
50RDN21Returns - Document Reference Information20RemarkRemarksnVarChar2540
51RDR21Sales Order - Document Reference Information20RemarkRemarksnVarChar2540
52RIN21A/R Credit Memo - Document Reference Information20RemarkRemarksnVarChar2540
53RPC21A/P Credit Memo - Document Reference Information20RemarkRemarksnVarChar2540
54RPD21Goods Return - Document Reference Information20RemarkRemarksnVarChar2540
55RRR21A/R Return Request - Document Reference Information20RemarkRemarksnVarChar2540
56SFC21Self Credit Memo - Document Reference Information20RemarkRemarksnVarChar2540
57SFI21Self Invoice - Document Reference Information20RemarkRemarksnVarChar2540
58TPI3Purchase Tax Invoice - Document Reference Information10RemarkRemarksnVarChar2540
59TSI3Sales Tax Invoice - Document Reference Information10RemarkRemarksnVarChar2540
60TXD3Tax Invoice Draft - Document Reference Information10RemarkRemarksnVarChar2540
61VRT1Tax Invoice Report - Rows10RemarkRemarksnVarChar1000
62VRT2Tax Invoice Report Grid Info19RemarkRemarksnVarChar1000
TOPReports
63SRT2Korean Summary Report - Rows29RemarkLine Item Remark, do not usenVarChar1000
TOPService
64ASC6Service Call Scheduling - History40RemarkRemarksnVarChar2540
65OCTTContract Template38RemarkRemarksText160
66SCL6Service Call Scheduling40RemarkRemarksnVarChar2540