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

64 columns | Print definition?B1 9.3  | WTCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1TCD4Withholding Tax Code Determination3WTCodeWTax CodenVarChar80
TOPBanking
2ARC6Incoming Payments - WTax Rows - History3WTCodeWTax CodenVarChar40
3ARCTIncoming Payment - History97WtCodeWTax CodenVarChar40
4OPDFPayment Draft97WtCodeWT CodenVarChar40
5ORCTIncoming Payment97WtCodeWTax CodenVarChar40
6OVPMOutgoing Payments97WtCodeWTax CodenVarChar40
7PDF6Payment Drafts - Withholding Tax - Rows3WTCodeWTax CodenVarChar40
8RCT6Incoming Payments - WTax Rows3WTCodeWTax CodenVarChar40
9VPM6Outgoing Payments - WTax Rows3WTCodeWTax CodenVarChar40
TOPBusiness Partners
10ACR4Allowed WTax Codes for BP - History2WTCodeWTax CodenVarChar40
11ACRDBusiness Partners - History220WTCodeWithholding Tax CodenVarChar40
12AWD3WTax Codes Details for BP3WTCodeWTax CodenVarChar40
13AWD4WTax Codes Details for Item3WTCodeWTax CodenVarChar40
14AWD5WTax Codes Details for Freight3WTCodeWTax CodenVarChar40
15CRD4Allowed WTax Codes for BP2WTCodeWTax CodenVarChar40
16OCRDBusiness Partner220WTCodeWTax CodenVarChar40
17WTD3WTax Codes Details for BP3WTCodeWTax CodenVarChar40
18WTD4WTax Codes Details for Item3WTCodeWTax CodenVarChar40
19WTD5WTax Codes Details for Freight3WTCodeWTax CodenVarChar40
TOPFinance
20AJD2Withholding Tax - History2WTCodeWTax CodenVarChar40
21AWH1Tax Definition1WTCodeWTax CodenVarChar40
22AWH3Value Range2WTCodeWTax CodenVarChar40
23AWHTWithholding Tax1WTCodeWTax CodenVarChar40
24AWTDWithholding Tax Definition2WTCodeWTax CodenVarChar40
25BTF2Journal Voucher Withholding Tax - History2WTCodeWTax CodenVarChar40
26JDT2Withholding Tax - History2WTCodeWTax CodenVarChar40
27JST1TDS Adjustment - Rows3WTCodeWTax CodenVarChar40
28OACMAccumulation3WTCodeWTax CodenVarChar40
29OWHTWithholding Tax1WTCodeWTax CodenVarChar40
30OWTDWithholding Tax Definition2WTCodeWTax CodenVarChar40
31WHT1Withholding Tax Definition1WTCodeWTax CodenVarChar40
32WHT3Value Range2WTCodeWTax CodenVarChar40
TOPInventory and Production
33IGE5Goods Issue - Withholding Tax2WTCodeWT CodenVarChar40
34IGN5Goods Receipt - Withholding Tax2WTCodeWT CodenVarChar40
35WTQ5Inventory Transfer Request - Withholding Tax2WTCodeWTax CodenVarChar40
36WTR5Inventory Transfer - Withholding Tax2WTCodeWT CodenVarChar40
TOPMarketing Documents
37ADO5Withholding Tax - History2WTCodeWTax CodenVarChar40
38CIN5AR Correction Invoice - Withholding Tax2WTCodeWT CodenVarChar40
39CPI5Withholding Tax Data2WTCodeWT CodenVarChar40
40CPV5A/P Correction Invoice Reversal - WTax2WTCodeWT CodenVarChar40
41CSI5A/R Correction Invoice - Withholding Tax2WTCodeWT CodenVarChar40
42CSV5A/R Correction Invoice Reversal - WTax2WTCodeWT CodenVarChar40
43DLN5Delivery - Withholding Tax2WTCodeWTax CodenVarChar40
44DPI5A/R Down Payment - Withholding Tax2WTCodeWT CodenVarChar40
45DPO5A/P Down Payment - Withholding Tax2WTCodeWT CodenVarChar40
46DRF5Draft Documents - Withholding Tax2WTCodeWT CodenVarChar40
47IEI5Incoming Excise Invoice - Withholding Tax2WTCodeWTax CodenVarChar40
48INV5A/R Invoice - Withholding Tax2WTCodeWTax CodenVarChar40
49OEI5Outgoing Excise Invoice - Withholding Tax2WTCodeWTax CodenVarChar40
50PCH5A/P Invoice - Withholding Tax Data2WTCodeWT CodenVarChar40
51PDN5Goods Reciept PO - Withholding Tax2WTCodeWT CodenVarChar40
52POR5Purchase Order - Withholding Tax2WTCodeWT CodenVarChar40
53PQT5Purchase Quotation - Withholding Tax2WTCodeWT CodenVarChar40
54PRQ5Purchase Request - Withholding Tax2WTCodeWT CodenVarChar40
55PRR5A/P Return Request - Withholding Tax2WTCodeWTax CodenVarChar40
56QUT5Sales Quotation - Tax2WTCodeWT CodenVarChar40
57RDN5Returns - Withholding Tax2WTCodeWT CodenVarChar40
58RDR5Sales Order - Withholding Tax2WTCodeWT CodenVarChar40
59RIN5A/R Credit Memo - Withholding Tax2WTCodeWT CodenVarChar40
60RPC5A/P Credit Memo - Withholding Tax2WTCodeWT CodenVarChar40
61RPD5Goods Return - Withholding Tax Data2WTCodeWT CodenVarChar40
62RRR5A/R Return Request - Withholding Tax2WTCodeWTax CodenVarChar40
63SFC5Self Credit Memo - Withholding Tax2WTCodeWTax CodenVarChar40
64SFI5Self Invoice - Withholding Tax2WTCodeWTax CodenVarChar40