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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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

31 columns | Print definition?B1 8.8  | BASENUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinance
1JST1TDS Adjustment - Rows4BaseNumBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment
TOPInventory and Production
2IGE5Goods Issue - Withholding Tax21BaseNumBase Document TypeInt110-1202=Production Order
3IGN5Goods Receipt - Withholding Tax21BaseNumBase Document TypeInt110-1202=Production Order
4OIBTBatch No. for Item15BaseNumBase Document NumberInt110
5OSRISerial Numbers for Items17BaseNumBase Document NumberInt110
6WTR5Inventory Transfer - Withholding Tax21BaseNumBase Document TypeInt110-120=Goods Receipt PO, 59=Goods Receipt, 67=Inventory Transfer
TOPMarketing Documents
7ADO5Withholding Tax - History21BaseNumBase Document TypeInt110-113=Invoices, 15=Delivery notes, 16=Revert Delivery Notes, 17=Orders, 18=Purchases, 20=Purchase Delivery Notes, 21=Revert Purchase Delivery Notes, 22=Purchase orders, 23=Quotations
8AJD2Withholding Tax - History21BaseNumBase Document TypeInt110-1
9BTF2Journal Voucher Withholding Tax - History21BaseNumBase Document TypeInt110
10CIN5AR Correction Invoice - Withholding Tax21BaseNumBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
11CPI5Withholding Tax Data21BaseNumBase Document TypeInt110-1163=A/P Correction Invoice, 18=A/P Invoice
12CPV5A/P Correction Invoice Reversal - WTax21BaseNumBase Document TypeInt110-1163=A/P Correction Invoice
13CSI5A/R Correction Invoice - Withholding Tax21BaseNumBase Document TypeInt110-113=A/R Invoice, 165=A/R Correction Invoice
14CSV5A/R Correction Invoice Reversal - WTax21BaseNumBase Document TypeInt110-1165=A/R Correction Invoice
15DLN5Delivery - Withholding Tax21BaseNumBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
16DPI5A/R Down Payment - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
17DPO5A/P Down Payment - Withholding Tax21BaseNumBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
18DRF5Draft Documents - Withholding Tax21BaseNumBase Document TypeInt11013=A/R Invoice, 14=A/R Credit Memo, 15=Delivery notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Good Receipt PO, 21=Goods Return, 22=Purchase order, 23=Sales Quotation, 59=Goods Receipt (inv), 60=Goods Issue (inv), 67=Warehouse Transfer
19IEI5Incoming Excise Invoice - Withholding Tax21BaseNumBase Document TypeInt110-1
20INV5A/R Invoice - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
21JDT2Withholding Tax - History21BaseNumBase Document TypeInt110-1
22OEI5Outgoing Excise Invoice - Withholding Tax21BaseNumBase Document TypeInt110-1
23PCH5A/P Invoice - Withholding Tax Data21BaseNumBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
24PDN5Goods Reciept PO - Withholding Tax21BaseNumBase Document TypeInt110-118=A/P Invoice, 21=Goods Return, 22=Purchase orders
25POR5Purchase Order - Withholding Tax21BaseNumBase Document TypeInt110-117=Sales Order
26QUT5Sales Quotation - Tax21BaseNumBase Document TypeInt110-1
27RDN5Returns - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery
28RDR5Sales Order - Withholding Tax21BaseNumBase Document TypeInt110-123=Sales Quotation
29RIN5A/R Credit Memo - Withholding Tax21BaseNumBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment
30RPC5A/P Credit Memo - Withholding Tax21BaseNumBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment, 21=Goods Return
31RPD5Goods Return - Withholding Tax Data21BaseNumBase Document TypeInt110-120=Purchase Delivery Notes