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

41 columns | Print definition?ERP 6.0  | CURRE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RX_BENTABBenefits payroll results international12CURRECurrency Keynvarchar50
2PA0430HR Master Record, Infotype 043033CURRECurrency Keynvarchar50
3PA0510HR Master Record: Infotype 0510 (Tax-sheltered annuity)34CURREBenefit Currency Keynvarchar50
4PA0718HR Master Record: Infotype 071837CURREBenefit Currency Keynvarchar50
TOPBenefits
5PA0167HR Master Record: Infotype 0167 (Health Plans)46CURREBenefit Currency Keynvarchar50
6PA0168HR Master Record: Infotype 0168 (Insurance Plans)36CURREBenefit Currency Keynvarchar50
7PA0169HR Master Record: Infotype 0169 (Savings Plan)175CURREBenefit Currency Keynvarchar50
8PA0170HR Master Record: Infotype 0170 (Flexible Spending Accounts)35CURREBenefit Currency Keynvarchar50
9PA0172HR Master Record: Infotype 0172 (FSA Claims)29CURREBenefit Currency Keynvarchar50
10PA0236HR Master Record: Infotype 0236 (Credit Plans)36CURREBenefit Currency Keynvarchar50
11PA0270HR Master Data Record: Infotype 0270 (COBRA Payments)26CURREBenefit Currency Keynvarchar50
12PA0377HR Master Record: Infotype 0377 (Miscellaneous Plans)53CURREBenefit Currency Keynvarchar50
13PA0379HR Master Record: Infotype 0379 (Stock Purchase Plans)36CURREBenefit Currency Keynvarchar50
14PA0565HR Master Record: Infotype 0565 (Retirement Plan Val. Res.)63CURREBenefit Currency Keynvarchar50
15PA0602HR Master Record: Infotype 0602 (Retirement Plan Cumulation)32CURREBenefit Currency Keynvarchar50
16T5UB3Benefit area3CURREBenefit Currency Keynvarchar50
17T5UBYBenefits Parameter Group4CURREBenefit Currency Keynvarchar50
18T5UD3Benefit area currency5CURREBenefit Currency Keynvarchar50
19T74FMBenefit Standard Savings Selection12CURREBenefit Currency Keynvarchar50
20T74FNBenefit Standard Spending Account Selection8CURREBenefit Currency Keynvarchar50
21T74FPBenefit Standard Miscellaneous Selection14CURREBenefit Currency Keynvarchar50
22T74FQBenefit standard stock purchase selection10CURREBenefit Currency Keynvarchar50
23T74FUBenefit combined coverage limit6CURREBenefit Currency Keynvarchar50
24T74FWBenefit combined contribution limit6CURREBenefit Currency Keynvarchar50
TOPChina
25T7CNC0Contribution Calculation9CURRECurrency Keynvarchar50
TOPCompensation Administration
26PA0759HR Master Record: Infotype 0759 (Compensation Process)31CURRECurrency Keynvarchar50
27T71ADM03Compensation Plan Attributes12CURRECurrency Keynvarchar50
28T71ADM17Compensation Guideline19CURRECurrency Keynvarchar50
29T71ADM18Compensation Guideline Proration Rule13CURRECurrency Keynvarchar50
30T71ADM23Compensation Matrix Values18CURRECurrency Keynvarchar50
31T71ADM25Rounding Formula Definitions3CURRECurrency Keynvarchar50
TOPEnterprise Compensation Management
32T71ADM_EE_HISTCompensation Tracking for Employees20CURRECurrency Keynvarchar50
TOPHong Kong
33PA0440HR Master Record: Infotype 0440 (Receipts)26CURRECurrency Keynvarchar50
34T7HK2YEmployee Group Criteria ID for Retirement Plan3CURREBenefit Currency Keynvarchar50
35T7HK4BFactor & constants for LSP/severance payments9CURRECurrency Keynvarchar50
36T7HK4CMaximum amounts and reckonable YOS for LSP/severance payment5CURRECurrency Keynvarchar50
TOPLong-Term Incentives
37PA0761HR Master Record: Infotype 0761 (LTI Grant)33CURRECurrency Keynvarchar50
38PA0762HR Master Record: Infotype 0762 (LTI Exercising)32CURRECurrency Keynvarchar50
39T71LTI03LTI Plan Pricing Information6CURRECurrency Keynvarchar50
40T71LTI06Conversion of Stock Units8CURRECurrency Keynvarchar50
TOPPortugal
41PA0338HR Master Record: Infotype 0338 (Absence pay.clearing - PT)29CURRECurrency Keynvarchar50