SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

60 columns | Print definition?B1 9.2  | 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
55QUT5Sales Quotation - Tax2WTCodeWT CodenVarChar40
56RDN5Returns - Withholding Tax2WTCodeWT CodenVarChar40
57RDR5Sales Order - Withholding Tax2WTCodeWT CodenVarChar40
58RIN5A/R Credit Memo - Withholding Tax2WTCodeWT CodenVarChar40
59RPC5A/P Credit Memo - Withholding Tax2WTCodeWT CodenVarChar40
60RPD5Goods Return - Withholding Tax Data2WTCodeWT CodenVarChar40