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

23 columns | Print definition?ERP 6.0  | TAXCD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2NZ_TAXPPayroll Result: Taxation TAXP - NZ5TAXCDTax Codenvarchar60
2T7ID1TTax Object Code2TAXCDTax Object Codenvarchar90
3T7ID1TTTax Object Code Description3TAXCDTax Object Codenvarchar90
TOPExchanges
4OIA08LIA Document: Item Data24TAXCDTax on sales/purchases codenvarchar20
TOPFinland
5T7FIA1Tax Codes (ATS)2TAXCDTax code (ATS)nvarchar30
6T7FIA1TTax Code Texts (ATS)2TAXCDTax code (ATS)nvarchar30
7T7FIA2Tax Code Assignments to ATS Data Records3TAXCDTax code (ATS)nvarchar30
8T7FIA3Assign Structure Fields to Tax Codes (ATS)6TAXCDTax code (ATS)nvarchar30
9T7FIA4Wage Type Assignment to Tax Codes (ATS)5TAXCDTax code (ATS)nvarchar30
TOPIndia
10T7INAASalary years for Pay scale grouping for allowances4TAXCDTax code for evaluating tax exemptionsnvarchar40
11T7INAEClaims carry forward3TAXCDTax code for evaluating tax exemptionsnvarchar40
12T7INR7Code for Housing Type3TAXCDTax code for evaluating tax exemptionsnvarchar40
13T7INT7Taxabilty codes for rule based tax exemptions3TAXCDTax code for evaluating tax exemptionsnvarchar40
14T7INT8Text for taxability codes3TAXCDTax code for evaluating tax exemptionsnvarchar40
15T7INT9Taxability of wage types9TAXCDTax code for evaluating tax exemptionsnvarchar40
TOPNew Zealand
16PA0313Employee Taxation Detail Infotype NZ24TAXCDTax Codenvarchar60
17T7NZTCTax Code Check table NZ2TAXCDTax Codenvarchar60
18T7NZTDTax Code Designation NZ3TAXCDTax Codenvarchar60
19T7NZTETaxation Earner Premium NZ2TAXCDTax Codenvarchar60
20T7NZTIIndependent Earner Tax Credit NZ2TAXCDTax Codenvarchar60
21T7NZTLTaxation Student Loan Deduction NZ2TAXCDTax Codenvarchar60
22T7NZTRTaxation Rebates NZ2TAXCDTax Codenvarchar60
23T7NZTXTax Codes NZ2TAXCDTax Codenvarchar60