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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

225 columns | Print definition?ERP 6.0  | TRFAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee21TRFARnvarchar20
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee23TRFARnvarchar20
3P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay40TRFARPay scale typenvarchar20
4P2RQ_QHDAHR-AU-PS: Payroll structure for Higher Duty Allowance24TRFARPay scale type of the higher duty positionnvarchar20
5P2RV_VAPVAP Structure Norway15TRFARPay scale typenvarchar20
6P2RX_WPBPPayroll Results: Work Center/Basic Pay38TRFARPay scale typenvarchar20
7P2UN_QHDAHR-UN: Payroll structure for Higher Duty Allowance24TRFARPay scale type of the higher duty positionnvarchar20
8PA0648HR Master Record: Infotype 064825TRFARPay scale typenvarchar20
9T510EDynamic Standard Pay Increase II3TRFARPay scale typenvarchar20
10T510NPay Scales for Annual Salaries (NA)3TRFARPay scale typenvarchar20
11T5BPBS01Description of pay scale rules3TRFARPay scale typenvarchar20
12T5BPBS02Description of payscale rule Jumps3TRFARPay scale typenvarchar20
13T5D14Features of Earnings Survey for State Statistics Office3TRFARPay scale typenvarchar20
14T5D5LFamily-Related Bonus Classes and Career Assignment3TRFARPay scale typenvarchar20
15T5FPBS4AEchelle3TRFARType conv. collec.nvarchar20
16T5FPBS4BEchelon3TRFARType conv. collec.nvarchar20
17T5FPBS4CCorps, cadre d'emploi6TRFARType conv. collec.nvarchar20
18T5FPBS4EAffectation échelle, grade3TRFARType conv. collec.nvarchar20
19T5FPBS5UDéfinition d'une règle de conversion3TRFARType conv. collec.nvarchar20
20T5GPBSS_PSCSWF: Pay Scale3TRFARPay scale typenvarchar20
21T5GPBSS_PSC2SWF: Pay Scale3TRFARPay scale typenvarchar20
22T5M4F!Not Used: Default Values for Leave2TRFARPay scale typenvarchar20
23T5M4S!Not Used: Default Values for SH2TRFARPay scale typenvarchar20
24T5PPBS3DFunctional comp. level/manager level based on pay scale2TRFARPay scale typenvarchar20
25T5PPBS3DTText of funct.comp. level/manager level based on pay scale3TRFARPay scale typenvarchar20
26T5PPBS8AIndex Value for Pay Scale Type, Area, Group, and Level2TRFARPay scale typenvarchar20
27T5PPBS8BIndex 100 Grouping2TRFARPay scale typenvarchar20
28T7AEPBS05Job Categories Series6TRFARPay scale typenvarchar20
29T7AEPBS07Rental Allocation3TRFARPay scale typenvarchar20
30T7AEPBS51Ranking of PS Job Grades3TRFARPay scale typenvarchar20
31T7PBS00TRF_BETRGAmounts for Constants on Pay Scale Basis or Statutory Basis5TRFARPay scale typenvarchar20
32T7QAPBS01Pay Scale mapping table2TRFARPay scale typenvarchar20
33T7RU52WPercent bonus for Work Conditions3TRFARPay scale typenvarchar20
34T7SAPBS05Job Categories Series6TRFARPay scale typenvarchar20
35T7SAPBS26Define Overtime Group Based On Pay Scale3TRFARPay scale typenvarchar20
36T7SAPBS34Assign Pay Scale to Job Classification9TRFARPay scale typenvarchar20
37T7SAPBS41Refer other Pay Scale for Allowances/Benefits2TRFARPay scale typenvarchar20
38T7SAPBS70Job Categories Series (Customer)6TRFARPay scale typenvarchar20
39T7SAPBSM1Minimum Service Duration for KSA Military Sector3TRFARPay scale typenvarchar20
40T7UNCMT_PCATMCMT Payscale Category Mapping7TRFARPay scale typenvarchar20
41T7UNCMT_SACIDMCMT Map Staff and Salary Assessment Category Code7TRFARPay scale typenvarchar20
42T7UNPF_HR_CATMMapping table for Pay scale type to Salary Category3TRFARPay scale typenvarchar20
43ZA0008Importtabelle Fehlerliste Sollbezüge20TRFARTarif-/Gehaltsartnvarchar20
TOPArgentina
44T7AR59Assign pay scale (II) to collective agreement class2TRFARPay scale typenvarchar20
45T7AR65Pay scale agreement category identification2TRFARPay scale typenvarchar20
46T7AR91Assign collective agreement to pay scale type2TRFARPay scale typenvarchar20
TOPAustralia
47T5QSSSuperannuation Defined Salary Australia3TRFARPay scale typenvarchar20
TOPBudget Management
48HRP1501DB Table for Infotype 150119TRFARPay scale typenvarchar20
49HRP1506DB Table for Infotype 150619TRFARPay scale typenvarchar20
50T7PMFSpecial Pay Scale Groups3TRFARPay scale typenvarchar20
51T7PMGAverage Amounts for Collective Agreements (PSG)3TRFARPay scale typenvarchar20
52T7PMHCareer Groups3TRFARPay scale typenvarchar20
53T7PMOCareer Group Names4TRFARPay scale typenvarchar20
54T7PMUDefault Values for Teaching Hours3TRFARPay scale typenvarchar20
TOPCompensation Management
55HRP1005DB Table for Infotype 1005 (Planned Compensation)19TRFARPay Scale/Pay Grade Typenvarchar20
56PA0380HR Master Data Record Infotype 0380 (Comp. Adjustment)30TRFARPay Grade Typenvarchar20
57T510DDynamic Standard Pay Increase3TRFARPay scale typenvarchar20
58T510RPay Scale Reclassification3TRFARPay scale typenvarchar20
59T510_PSRCLPay scale reclassification3TRFARPay scale typenvarchar20
60T71D2Pay Scale Group Rule5TRFARPay scale typenvarchar20
TOPDenmark
61T5MF6Conversion of R/3 Pay Scale Structure to FA PS Structure2TRFARPay scale typenvarchar20
TOPFinland
62T7FI510TVR relevant payscale group/level (Finland)3TRFARPay scale typenvarchar20
63T7FIDCDowntime Compensation Days (Finland F&P)3TRFARPay scale typenvarchar20
64T7FIPFAttributes of reserves posted to Financials (Finland)5TRFARPay scale typenvarchar20
65T7FISSeniority Allowance Attributes (Finland)3TRFARPay scale typenvarchar20
TOPGermany
66T5D0UAssignment to Pay Scale Area Groups4TRFARPay scale typenvarchar20
67T5D3MAssignment of a Valuation of Pay Scales for Statistics5TRFARPay scale typenvarchar20
TOPIndia
68T7INA3Allowance grouping definition table4TRFARPay scale typenvarchar20
TOPItaly
69PA3214HR Master Record: Infotype 3214273TRFARPay scale typenvarchar20
70T5ITADWage types to recalculate (not used anymore)2TRFARPay scale typenvarchar20
71T5ITAWWage types to recalculate3TRFARPay scale typenvarchar20
72T5ITC1Contributions2TRFARPay scale typenvarchar20
73T5ITC2Negative tax bases2TRFARPay scale typenvarchar20
74T5ITC3Lowest rate management2TRFARPay scale typenvarchar20
75T5ITC4Lowest rate amounts2TRFARPay scale typenvarchar20
76T5ITC5Tax scale rounding2TRFARPay scale typenvarchar20
77T5ITC6Contribution table extention for settlement2TRFARPay scale typenvarchar20
78T5ITCGSettlement request for contributions2TRFARPay scale typenvarchar20
79T5ITCHContrib.settlement type2TRFARPay scale typenvarchar20
80T5ITCIWT which form the tax base2TRFARPay scale typenvarchar20
81T5ITCJTaxation type text3TRFARPay scale typenvarchar20
82T5ITCSContribution indicator2TRFARPay scale typenvarchar20
83T5ITCTTaxation type2TRFARPay scale typenvarchar20
84T5ITCWContribution indicator text3TRFARPay scale typenvarchar20
85T5ITCXSettlement request text for contributions3TRFARPay scale typenvarchar20
86T5ITCYContribution settlement type text3TRFARPay scale typenvarchar20
87T5ITD6Deduction expected income table2TRFARPay scale typenvarchar20
88T5ITDAMiscellaneous data deductions2TRFARPay scale typenvarchar20
89T5ITEHActivity area 7702TRFARPay scale typenvarchar20
90T5ITF3Provision accrual2TRFARPay scale typenvarchar20
91T5ITF5Severance indemnity revaluation table (IT)2TRFARPay scale typenvarchar20
92T5ITF7Severance pay2TRFARPay scale typenvarchar20
93T5ITF8Accrual settlement2TRFARPay scale typenvarchar20
94T5ITFTProvision indicator2TRFARPay scale typenvarchar20
95T5ITFXSeverance indemnity provision indicator description3TRFARPay scale typenvarchar20
96T5ITFYProvision indicator description3TRFARPay scale typenvarchar20
97T5ITGBAssign EEF Grouping4TRFARPay scale typenvarchar20
98T5ITI2INPS general data table2TRFARPay scale typenvarchar20
99T5ITIANursing table2TRFARPay scale typenvarchar20
100T5ITICMarriage leave table2TRFARPay scale typenvarchar20
101T5ITIDBlood donation table2TRFARPay scale typenvarchar20
102T5ITIGOrdinary days/hours table2TRFARPay scale typenvarchar20
103T5ITIISickness handling c/INPS table2TRFARPay scale typenvarchar20
104T5ITIMSickness handling c/company2TRFARPay scale typenvarchar20
105T5ITINAccident handling table2TRFARPay scale typenvarchar20
106T5ITIPMaternity table2TRFARPay scale typenvarchar20
107T5ITISSickness handling scale c/company2TRFARPay scale typenvarchar20
108T5ITL3Monthly decontribution2TRFARPay scale typenvarchar20
109T5ITMECurrent Yr Mun Surch Payment Exc Table (Fin Law 2007)2TRFARPay scale typenvarchar20
110T5ITN5INPS contract indicator2TRFARPay scale typenvarchar20
111T5ITNG01/M data table - section B2TRFARPay scale typenvarchar20
112T5ITQ2Net pay rounding table - Italy only3TRFARPay scale typenvarchar20
113T5ITQITable for ICOMP Indirect Valuation form5TRFARPay scale typenvarchar20
114T5ITQLTaxation types to be highlighted in the payroll2TRFARPay scale typenvarchar20
115T5ITQNINAIL status and taxation indicators2TRFARPay scale typenvarchar20
116T5ITQTSettlement indicator2TRFARPay scale typenvarchar20
117T5ITQXSettlement indicator text3TRFARPay scale typenvarchar20
118T5ITS1Percentage pay scale jumps - percentage ceiling2TRFARPay scale typenvarchar20
119T5ITS2Amount-based pay scale jumps - number/amount-based ceiling2TRFARPay scale typenvarchar20
120T5ITS3Amount-based pay scale jumps - fractional no. based ceiling2TRFARPay scale typenvarchar20
121T5ITS4Percentage pay scale jumps - number-based ceiling2TRFARPay scale typenvarchar20
122T5ITS7Insurance pay scale jumps - class change2TRFARPay scale typenvarchar20
123T5ITTBIRPEF miscellaneous data settlement2TRFARPay scale typenvarchar20
124T5ITU1Collective Labour Agreement coefficients2TRFARPay scale typenvarchar20
TOPJapan
125T5J59HR Job promotion - pay scale level ordering JPN3TRFARPay scale typenvarchar20
126T5J60HR Parameters for pay scale recreation JPN3TRFARPay scale typenvarchar20
TOPKorea
127T7KR32Standardized monthly compensation3TRFARPay scale typenvarchar20
TOPNon Profit Organizations
128PA0961HR Master Record: Infotype 096129TRFARPay scale typenvarchar20
129T7UNPAD_DPDSDependency Allowance: Lowest Entry Level Determinatio7TRFARPay scale typenvarchar20
130T7UNPAD_DS0GDuty Station Relation to SAP Entities Payscale Area4TRFARPay scale typenvarchar20
TOPPayroll
131T5HPBS01Szorzószámok3TRFARBérrendszerfajtanvarchar20
132T5HPBS01XSzorzószámok3TRFARBérrendszerfajtanvarchar20
133T5HPBS02Besorolási fokozatok1TRFARBérrendszerfajtanvarchar20
134T5HPBS02TBesorolási fokozatok szövegei2TRFARBérrendszerfajtanvarchar20
135T5HPBS02XBesorolási fokozatok1TRFARBérrendszerfajtanvarchar20
136T5HPBS25Besorolási fokozatba kerülés alapja kód1TRFARBérrendszerfajtanvarchar20
137T5HPBS25TBesorolási fokozatba kerülés alapja megnevezés2TRFARBérrendszerfajtanvarchar20
138T5HPBS41Besorolási fokozat kódja1TRFARBérrendszerfajtanvarchar20
139T5HPBS41TBesorolási fokozat megnevezése2TRFARBérrendszerfajtanvarchar20
140T5T10Tarif groups - ext.survey3TRFARPay scale typenvarchar20
141T7SK10Tarif groups - ext.survey3TRFARPay scale typenvarchar20
TOPPayroll General Parts
142HRPY_WPBPHR-PAY: Transparent Table WPBP29TRFARPay scale typenvarchar20
143T510CAdjust Bases for Calculating Av.Vals.acc.to PScale3TRFARPay scale typenvarchar20
TOPPension Administration
144PA0845HR Master Record Infotype 0845 (Work Relationships)26TRFARPay scale typenvarchar20
145T7PBS00TRF_DATPayscale Group-Dependent Data4TRFARPay scale typenvarchar20
146T7PBS00TRF_DATESPayscale Group-Dependent Data4TRFARPay scale typenvarchar20
147T7PBSCA2EAssignmt of Public Serv. Regulation to Pay Scale Type/Area3TRFARPay scale typenvarchar20
TOPPersonnel Administration
148PA0008HR Master Record: Infotype 0008 (Basic Pay)24TRFARPay scale typenvarchar20
149PA0052HR Master Record: Infotype 0052 (Wage Maintenance)25TRFARPay scale typenvarchar20
150T001PPersonnel Area/Subarea8TRFARPay scale typenvarchar20
151T510Pay Scale Groups3TRFARPay scale typenvarchar20
152T510APay Scale Types3TRFARPay scale typenvarchar20
153T510BAppraisal Constants3TRFARPay scale typenvarchar20
154T510FAssign Pay Scale --> Currency3TRFARPay scale typenvarchar20
155T510MValuation of pay scale groups acc. to hiring date3TRFARPay scale typenvarchar20
156T510UPay Scale Groups3TRFARPay scale typenvarchar20
157T510WPay Scale > Period Parameter Assignment3TRFARPay scale typenvarchar20
158T528BPositions7TRFARPay scale typenvarchar20
159T5ITI1Standard period table2TRFARPay scale typenvarchar20
160T5ITS5Scatti in categoria tetto massimo in numero - HR Italy2TRFARTipo contratto coll.nvarchar20
161T5ITS8Scatti assicurativi premio fedelta'2TRFARTipo contratto coll.nvarchar20
162T7SITAValue of points6TRFARPay scale typenvarchar20
TOPPersonnel Time Management
163T510IStandard Working Hours3TRFARPay scale typenvarchar20
TOPPortugal
164T5PP1HR-PT: Professional categories assignment2TRFARPay scale typenvarchar20
165T5PP4HR-PT: Professional Category designation2TRFARPay scale typenvarchar20
166T5PPSHR-PT: Pay scale types additional information3TRFARPay scale typenvarchar20
167T5PS1HR-PT: professional categories assignment (IRC code)2TRFARPay scale typenvarchar20
168T5PS4HR-PT: Professional Category designation2TRFARPay scale typenvarchar20
169T5PS4THR-PT: text table for professional category designation3TRFARPay scale typenvarchar20
170T5PSCHR-PT: Pay scale types additional information3TRFARPay scale typenvarchar20
171T5PSTHR-PT: text table for additional information wage types4TRFARPay scale typenvarchar20
TOPPosition Budgeting and Control
172HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction17TRFARPay scale typenvarchar20
173HRP1511DB Table for Infotype 151119TRFARPay Scale/Pay Grade Typenvarchar20
174T77HRFPM_STOVMaintenance of FTE Limits4TRFARPay scale typenvarchar20
TOPProcess Controls -Automated Controls
175GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 001522TRFARPay scale typenvarchar20
TOPPublic Sector
176PA0509HR-AU-PS: Master Data (Higher Duty Allowance)41TRFARPay scale type of the higher duty positionnvarchar20
177PDPBSDNEUG_UEB_TCarried Over to DNeuG: Personnel Pay Scale Information4TRFARPay scale typenvarchar20
178PDPBSTVOED_UEBTransfer to TVoeD: Personnel Master Record Before Transfer5TRFARPay scale typenvarchar20
179T5APBS06Pay scale reclassification3TRFARPay scale typenvarchar20
180T5D5LNPay Scale Assign. for Guaranteed Payts: COLA/Fam.-Rel Bonus3TRFARPay scale typenvarchar20
181T5D71Period Calculation3TRFARPay scale typenvarchar20
182T5D71TFunction Model Texts for Period Calculation4TRFARPay scale typenvarchar20
183T5D7JControl of BDA and COLA Relevance (Basic Pay)3TRFARPay scale typenvarchar20
184T5D7KParameters for Determining Proposed Pay Seniority3TRFARPay scale typenvarchar20
185T5D7LAuxiliary Table for Higher Grouping and Promotion3TRFARPay scale typenvarchar20
186T5D7LNNext Pay Scale Group for Higher/Lower Grouping3TRFARPay scale typenvarchar20
187T5D7MValue of Remuneration Groups3TRFARPay scale typenvarchar20
188T5D7MNValue of Pay Scale Groups3TRFARPay scale typenvarchar20
189T5D7NDetermination of Hiring Level Model 83TRFARPay scale typenvarchar20
190T5D7QModels for Control of Contribution3TRFARPay scale typenvarchar20
191T5D7QTFunction Model Texts: Special Payment4TRFARPay scale typenvarchar20
192T5D7RModels for Controlling Vacation Bonus3TRFARPay scale typenvarchar20
193T5D7RTFunction Model Texts: Vacation Bonus4TRFARPay scale typenvarchar20
194T5D82Pay Scale Information for Calculation of Minimum Pension4TRFARPay scale typenvarchar20
195T5D88Function Models for Leave and Sick Pay Premium3TRFARPay scale typenvarchar20
196T5D88TFunction Model Texts: Leave and Sick Pay Premium4TRFARPay scale typenvarchar20
197T5D8MPosition Table for College Statistics6TRFARPay scale typenvarchar20
198T5D95Foreign Service Bonus3TRFARPay scale typenvarchar20
199T5D97Supplement for Child Living Abroad3TRFARPay scale typenvarchar20
200T5DPBS08Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp5TRFARPay scale typenvarchar20
201T5DPBS09Spec. and Non-Rec. Payts, Cumul. WTs for Each Pay Scale Grp5TRFARPay scale typenvarchar20
202T5DPBS0ESpec. and Non-Rec. Payments: Pay Scale-Dependent Percentages5TRFARPay scale typenvarchar20
203T5DPBS1CBasis for Activity with Higher Rate of Pay11TRFARRemuneration By Pay Scale Typenvarchar20
204T5DPBS1GValidity of Variable Key for Each Pay Scale Group3TRFARPay scale typenvarchar20
205T5DPBS3ATransfer to TVoeD: Assignment Pay Scale Type Old/New3TRFARPay scale typenvarchar20
206T5DPBS3BAssignment to Internal Pay Scale Group3TRFARPay scale typenvarchar20
207T5DPBS3DTVoeD: Structural Adjustment3TRFARPay scale typenvarchar20
208T5DPBS3ETVoeD: COLA Class for Guaranteed Payment (Children)3TRFARPay scale typenvarchar20
209T5PBSR6IGuideline for Salary Components3TRFARPay scale typenvarchar20
210T5PBSR6MAssignment between Pay Scale Types and Scheme Code3TRFARPay scale typenvarchar20
211T5QPBS1ENational Wage Case (NWC) increase for Superannuation3TRFARPay scale typenvarchar20
212T5QPBS1HPriority Table used in calculating HDA super salary comp.2TRFARPay scale type of the higher duty positionnvarchar20
213T5QPBS6CAssignment of APS classification structure3TRFARPay scale typenvarchar20
214T5VPPS_510Table to update T510 for yrly changes-Norway Public Sector3TRFARPay scale typenvarchar20
215T5VPPS_PSRALVNorway Public Sector: IT 0509 records in ALV of RPIPSP009TRFARPay scale typenvarchar20
TOPRecruitment
216PB0008Applicant Master Record Infotype (Basic Pay)24TRFARPay scale typenvarchar20
TOPSouth Africa
217T5W10Link pay scale groups to occupational level. - Equity2TRFARPay scale typenvarchar20
218T5W11Link pay scale groups to occupational level. - Equity2TRFARPay scale typenvarchar20
TOPSpain
219PA0480HR master record for infotype 048027TRFARPay scale typenvarchar20
220PB0480HR master record infotype 0480 (Candidates)27TRFARPay scale typenvarchar20
221T5E10Extension of pay scales2TRFARPay scale typenvarchar20
222T5E53Amounts of seniority bonuses2TRFARPay scale typenvarchar20
223T5E60Contract entity according to the company5TRFARPay scale typenvarchar20
224T5E61Contract transformations allowed5TRFARPay scale typenvarchar20
225T5E6IContract texts according to company6TRFARPay scale typenvarchar20