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

50 columns | Print definition?ERP 6.0  | WAEHI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2IN_CCOPayroll India - Car and Conveyance13WAEHICurrency Keynvarchar50
2P2IN_EPFPayroll structure for Provident Fund Infotype40WAEHICurrency Keynvarchar50
3P2IN_EXMPayroll structure for exemptions12WAEHICurrency Keynvarchar50
4P2IN_HFSPayroll India - Hard Furnishing Scheme9WAEHICurrency Keynvarchar50
5P2IN_HRAHousing(HRA/CLA/COA) details17WAEHICurrency Keynvarchar50
6P2IN_IOSIncome from other sources21WAEHICurrency Keynvarchar50
7P2IN_PETPayroll structure for previous employment tax details13WAEHICurrency Keynvarchar50
8P2IN_S80Section 80 Contributions7WAEHICurrency Keynvarchar50
9P2IN_S88Payroll India Sec88 Investment Details12WAEHICurrency Keynvarchar50
10P2IS_INSPayroll Indonesia JAMSOSTEK & Other Insurance Data10WAEHICurrency Keynvarchar50
11P2IS_TAXPayroll Indonesia Tax Data12WAEHICurrency Keynvarchar50
12P2IS_TAXCUPayroll structure for cumulative tax data (Indonesia)14WAEHICurrency Keynvarchar50
13T7M9Y1Round Option Table9WAEHICurrency Keynvarchar50
TOPIndia
14PA0580Previous Employment Tax Details30WAEHICurrency Keynvarchar50
15PA0581Housing31WAEHICurrency Keynvarchar50
16PA0582Exemptions34WAEHICurrency Keynvarchar50
17PA0583Car and Conveyance24WAEHICurrency Keynvarchar50
18PA0584Income from other sources40WAEHICurrency Keynvarchar50
19PA0585Section 80 - Tax Exemptions24WAEHICurrency Keynvarchar50
20PA0586Section 88 - Tax rebate24WAEHICurrency Keynvarchar50
21PA0587Provident Fund contribution34WAEHICurrency Keynvarchar50
22PA0589Individual Reimbursements69WAEHICurrency Keynvarchar50
23PA0590Furnishing Scheme - India24WAEHICurrency Keynvarchar50
24T7INA7Reimbursements Allowances and Perks - base slabs8WAEHICurrency Keynvarchar50
25T7INA9Reimbursement Allowances Perks - eligibility and calculati10WAEHICurrency Keynvarchar50
26T7INB7Basic Slabs10WAEHICurrency Keynvarchar50
27T7INC5Perk value of car10WAEHICurrency Keynvarchar50
28T7INC7Eligibility for car schemes(COCS/OYCS)9WAEHICurrency Keynvarchar50
29T7IND5Dearness alloowance basic slab details12WAEHICurrency Keynvarchar50
30T7IND7Dearness allowance calculation rules15WAEHICurrency Keynvarchar50
31T7IND9Dearness allowance consumer price index slabs6WAEHICurrency Keynvarchar50
32T7INF3Statutory rates for Provident fund14WAEHICurrency Keynvarchar50
33T7INI0Investment category limits4WAEHICurrency Keynvarchar50
34T7INI4Investment limits5WAEHICurrency Keynvarchar50
35T7INI7Sub section limits4WAEHICurrency Keynvarchar50
36T7INI9Subsection division details5WAEHICurrency Keynvarchar50
37T7INJ3HR-IN: Loans Eligibility checks and limits16WAEHICurrency Keynvarchar50
38T7INJ7Define slab rates for loans6WAEHICurrency Keynvarchar50
39T7INP4Professional tax rates6WAEHICurrency Keynvarchar50
40T7INT3Taxation slabs5WAEHICurrency Keynvarchar50
41T7INT9Taxability of wage types10WAEHICurrency Keynvarchar50
42T7INU5Contribution Value for Each Slab9WAEHICurrency Keynvarchar50
43T7INW3Labour welfare fund rates9WAEHICurrency Keynvarchar50
44T7INY1Round off recovery9WAEHICurrency Keynvarchar50
TOPIndonesia
45PA0319Indonesia Private Insurances27WAEHICurrency Keynvarchar50
46T7ID13Insurance Scheme Levels and Contributions (Indonesia)10WAEHICurrency Keynvarchar50
47T7ID2GTax and Grsup grouping -- ID5WAEHICurrency Keynvarchar50
48T7ID2LTax Constant Amounts (Indonesia)8WAEHICurrency Keynvarchar50
49T7ID2RIndonesian Tax Rates6WAEHICurrency Keynvarchar50
TOPPhilippines
50T7PHTPTax Projection Method details12WAEHICurrency Keynvarchar50