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

52 columns | Print definition?ERP 6.0  | PERMO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results22PERMOPeriod Parametersnvarchar20
2P2HK_RETIPayroll structure for retroactive accounting5PERMOPeriod Parametersnvarchar20
3P2HK_RETOPayroll structure for retroactive accounting5PERMOPeriod Parametersnvarchar20
4P2IS_RETIPayroll structure for retroactive accounting5PERMOPeriod Parametersnvarchar20
5P2IS_RETOPayroll structure for retroactive accounting5PERMOPeriod Parametersnvarchar20
6P2MX_GRORDMaintenance payment order11PERMOPeriod Parametersnvarchar20
7P2PH_SSSBHR-PH: Include for SSS structure - Philippines9PERMOPeriod Parametersnvarchar20
8P2RK_GRCUMCumulation for garnishment results7PERMOPeriod Parametersnvarchar20
9P2RK_GRORDPayroll results Canada: Garnishment order12PERMOPeriod Parametersnvarchar20
10P2RK_ROEPayroll Results - ROE7PERMOPeriod Parametersnvarchar20
11P2RK_VC2Vacation pay entitlement per reference year6PERMOPeriod Parametersnvarchar20
12P2RQ_PASUMPayment summary components6PERMOPeriod Parametersnvarchar20
13P2RU_GRCUMCumulation for garnishment results7PERMOPeriod Parametersnvarchar20
14P2RU_GRDOCPayroll Results: Garnishment for US Document32PERMOPeriod modifiernvarchar20
15P2RX_ARRRSPayroll Results: Arrears Table5PERMOPeriod Parametersnvarchar20
16P2RX_VERSCPayroll Status Information25PERMOPeriod Parametersnvarchar20
17T549QPayroll Periods2PERMOPeriod Parametersnvarchar20
18T549SPersonnel Date Specifications Per Payroll Period4PERMOPeriod Parametersnvarchar20
19T7CNREW_APRPARSPayroll result master table9PERMOPeriod Parametersnvarchar20
TOPCanada
20T5K8EHR-CA: Transfer additional external payroll results5PERMOPeriod Parametersnvarchar20
TOPCompany Pension Scheme Germany
21P01CABRActions from Payroll Accounting6PERMOPeriod Parametersnvarchar20
TOPDenmark
22T5M49Date Identifiers for Special Payroll4PERMOPeriod Parametersnvarchar20
23T5M5JSAP-PBS Interface: AGRUPPE (DK)7PERMOPeriod Parametersnvarchar20
TOPFinland
24T7FI549QFinnish pay periods to average calculation relevance2PERMOPeriod Parametersnvarchar20
25T7FIV0Holiday Bonus Handling Types8PERMOPeriod Parametersnvarchar20
TOPInterface to External Payroll Systems
26T5UOTTax Services: Terminations and Inactives7PERMOPeriod Parametersnvarchar20
TOPNetherlands
27T5N14Additional Legal Person Data for Wage Return6PERMOPeriod Parametersnvarchar20
TOPPayroll General Parts
28HRPY_RGDIRDirectory for Payroll Results20PERMOPeriod Parametersnvarchar20
29HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results20PERMOPeriod Parametersnvarchar20
30PYNOSCREENSelection Screen Fields (Only as Interface)10PERMOPeriod Parametersnvarchar20
31T506DConditions for Employee Loans7PERMOPeriod Parametersnvarchar20
32T549MMonthly Assignment: Payroll Period (no longer used)2PERMOPeriod Parametersnvarchar20
33T549ZCalendar for payment model3PERMOPeriod Parametersnvarchar20
34T54C1Calendar for Cumulation3PERMOPeriod Parametersnvarchar20
35T558BPayroll Account Transfer: Payroll Periods7PERMOPeriod Parametersnvarchar20
TOPPersonnel Administration
36PA0002HR Master Record: Infotype 0002 (Personal Data)53PERMOModifier for Personnel Identifiernvarchar20
37T510WPay Scale > Period Parameter Assignment8PERMOPeriod Parametersnvarchar20
38T549APayroll areas3PERMOPeriod Parametersnvarchar20
39T549NPeriod Modifiers3PERMOPeriod Parametersnvarchar20
40T549RPeriod Parameters2PERMOPeriod Parametersnvarchar20
41T549R_CUSTMapping of Period Modifier with Molga2PERMOPeriod Parametersnvarchar20
42T549WRecurr. Pymts/Deducs: Payment Models4PERMOPeriod Parametersnvarchar20
TOPPublic Sector
43T7MXPBS30SAR - Report Period Table2PERMOPeriod Parametersnvarchar20
TOPRecruitment
44PB0002HR Master Record: Infotype 0002 (Personal Data)53PERMOModifier for Personnel Identifiernvarchar20
TOPReporting
45T77PRNL_ADDLPDPension Return: Additional Legal Person Data5PERMOPeriod Parametersnvarchar20
TOPSingapore
46PA0412HR Master Record: Infotype 0412 [View to I0021] (SG)47PERMOModifier for Personnel Identifiernvarchar20
TOPSouth Africa
47T5W1KPension Funds and Medical Aid Schemes (RSA)8PERMOPeriod Parametersnvarchar20
48T5W2I(Old) RSA Tax Year Specifications2PERMOPeriod Parametersnvarchar20
49T5W2QSouth African Tax Year Status2PERMOPeriod Parametersnvarchar20
TOPSpain
50T5EI6Arrears by period and grouper2PERMOPeriod Parametersnvarchar20
TOPUSA
51PA0106HR Master Record: Infotype 0106 (Related Persons NA)24PERMOModifier for Personnel Identifiernvarchar20
52T5UB8Benefits Payment Model Assignment4PERMOPeriod Parametersnvarchar20