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

40 columns | Print definition?B1 9.3  | BASENUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinance
1AJD2Withholding Tax - History21BaseNumBase Document TypeInt110-1
2BTF2Journal Voucher Withholding Tax - History21BaseNumBase Document TypeInt110
3JDT2Withholding Tax - History21BaseNumBase Document TypeInt110-1
4JST1TDS Adjustment - Rows4BaseNumBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment
TOPInventory and Production
5AWO2Production Order - Base3BaseNumProduction Order Base NumberInt110
6IGE5Goods Issue - Withholding Tax21BaseNumBase Document TypeInt110-1202=Production Order
7IGN5Goods Receipt - Withholding Tax21BaseNumBase Document TypeInt110-1202=Production Order
8UWO2Production Order - Base3BaseNumProduction Order Base NumberInt110
9WOR2Production Order - Base3BaseNumProduction Order Base NumberInt110
10WOR2VProduction Order - Base3BaseNumProduction Order Base NumberInt110
11WTQ5Inventory Transfer Request - Withholding Tax21BaseNumBase Document TypeInt110-120=Goods Receipt PO, 59=Goods Receipt
12WTR5Inventory Transfer - Withholding Tax21BaseNumBase Document TypeInt110-11250000001=Inventory Transfer Request, 20=Goods Receipt PO, 59=Goods Receipt, 67=Inventory Transfer
TOPMarketing Documents
13ADO5Withholding 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
14CIN5AR Correction Invoice - Withholding Tax21BaseNumBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
15CPI5Withholding Tax Data21BaseNumBase Document TypeInt110-1163=A/P Correction Invoice, 18=A/P Invoice
16CPV5A/P Correction Invoice Reversal - WTax21BaseNumBase Document TypeInt110-1163=A/P Correction Invoice
17CSI5A/R Correction Invoice - Withholding Tax21BaseNumBase Document TypeInt110-113=A/R Invoice, 165=A/R Correction Invoice
18CSV5A/R Correction Invoice Reversal - WTax21BaseNumBase Document TypeInt110-1165=A/R Correction Invoice
19DLN5Delivery - Withholding Tax21BaseNumBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
20DPI5A/R Down Payment - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
21DPO5A/P Down Payment - Withholding Tax21BaseNumBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
22DRF5Draft 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, 540000006=Purchase Quotation, 59=Goods Receipt (inv), 60=Goods Issue (inv), 67=Warehouse Tran
23IEI5Incoming Excise Invoice - Withholding Tax21BaseNumBase Document TypeInt110-1
24INV5A/R Invoice - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
25OEI5Outgoing Excise Invoice - Withholding Tax21BaseNumBase Document TypeInt110-1
26PCH5A/P Invoice - Withholding Tax Data21BaseNumBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
27PDN5Goods Reciept PO - Withholding Tax21BaseNumBase Document TypeInt110-118=A/P Invoice, 21=Goods Return, 22=Purchase orders
28POR5Purchase Order - Withholding Tax21BaseNumBase Document TypeInt110-117=Sales Order
29PQT5Purchase Quotation - Withholding Tax21BaseNumBase Document TypeInt110-117=Sales Order
30PRQ5Purchase Request - Withholding Tax21BaseNumBase Document TypeInt110-117=Sales Order
31PRR5A/P Return Request - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
32QUT5Sales Quotation - Tax21BaseNumBase Document TypeInt110-1
33RDN5Returns - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery
34RDR5Sales Order - Withholding Tax21BaseNumBase Document TypeInt110-123=Sales Quotation
35RIN5A/R Credit Memo - Withholding Tax21BaseNumBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment
36RPC5A/P Credit Memo - Withholding Tax21BaseNumBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment, 21=Goods Return
37RPD5Goods Return - Withholding Tax Data21BaseNumBase Document TypeInt110-120=Purchase Delivery Notes
38RRR5A/R Return Request - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
39SFC5Self Credit Memo - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
40SFI5Self Invoice - Withholding Tax21BaseNumBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation