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

218 columns | Print definition?ERP 6.0  | TRFGB

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee22TRFGBnvarchar20
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee24TRFGBnvarchar20
3P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay41TRFGBPay Scale Areanvarchar20
4P2RD_ANVERSPayroll Result - Cluster RD: Structure for Imp. on Pension32TRFGBPay Scale Area for Pensionnvarchar20
5P2RQ_QHDAHR-AU-PS: Payroll structure for Higher Duty Allowance25TRFGBPay scale area of the higher duty positionnvarchar20
6P2RV_VAPVAP Structure Norway16TRFGBPay Scale Areanvarchar20
7P2RX_WPBPPayroll Results: Work Center/Basic Pay39TRFGBPay Scale Areanvarchar20
8P2UN_QHDAHR-UN: Payroll structure for Higher Duty Allowance25TRFGBPay scale area of the higher duty positionnvarchar20
9PA0648HR Master Record: Infotype 064826TRFGBPay Scale Areanvarchar20
10T510EDynamic Standard Pay Increase II4TRFGBPay Scale Areanvarchar20
11T510NPay Scales for Annual Salaries (NA)4TRFGBPay Scale Areanvarchar20
12T5BPBS01Description of pay scale rules4TRFGBPay Scale Areanvarchar20
13T5BPBS02Description of payscale rule Jumps4TRFGBPay Scale Areanvarchar20
14T5D14Features of Earnings Survey for State Statistics Office4TRFGBPay Scale Areanvarchar20
15T5D5LFamily-Related Bonus Classes and Career Assignment4TRFGBPay Scale Areanvarchar20
16T5FPBS4AEchelle4TRFGBChamp d'applicationnvarchar20
17T5FPBS4BEchelon4TRFGBChamp d'applicationnvarchar20
18T5FPBS4CCorps, cadre d'emploi7TRFGBChamp d'applicationnvarchar20
19T5FPBS4EAffectation échelle, grade4TRFGBChamp d'applicationnvarchar20
20T5FPBS5UDéfinition d'une règle de conversion4TRFGBChamp d'applicationnvarchar20
21T5GPBSS_PSCSWF: Pay Scale4TRFGBPay Scale Areanvarchar20
22T5GPBSS_PSC2SWF: Pay Scale4TRFGBPay Scale Areanvarchar20
23T5PPBS3DFunctional comp. level/manager level based on pay scale3TRFGBPay Scale Areanvarchar20
24T5PPBS3DTText of funct.comp. level/manager level based on pay scale4TRFGBPay Scale Areanvarchar20
25T5PPBS5SSProgression depending on seniority session table14TRFGBPay Scale Areanvarchar20
26T5PPBS8AIndex Value for Pay Scale Type, Area, Group, and Level3TRFGBPay Scale Areanvarchar20
27T5PPBS9NPortugal Public Sector - Professional Situation2TRFGBPay Scale Areanvarchar20
28T5UPBSPA32Pay Plan: Conversion Table of Pay Scale Area to Federal Code3TRFGBPay Scale Areanvarchar20
29T7AEPBS05Job Categories Series7TRFGBPay Scale Areanvarchar20
30T7AEPBS07Rental Allocation4TRFGBPay Scale Areanvarchar20
31T7AEPBS51Ranking of PS Job Grades4TRFGBPay Scale Areanvarchar20
32T7PBS00TRF_BETRGAmounts for Constants on Pay Scale Basis or Statutory Basis6TRFGBPay Scale Areanvarchar20
33T7QAPBS01Pay Scale mapping table3TRFGBPay Scale Areanvarchar20
34T7RU52WPercent bonus for Work Conditions4TRFGBPay Scale Areanvarchar20
35T7SAPBS05Job Categories Series7TRFGBPay Scale Areanvarchar20
36T7SAPBS26Define Overtime Group Based On Pay Scale4TRFGBPay Scale Areanvarchar20
37T7SAPBS34Assign Pay Scale to Job Classification10TRFGBPay Scale Areanvarchar20
38T7SAPBS41Refer other Pay Scale for Allowances/Benefits3TRFGBPay Scale Areanvarchar20
39T7SAPBS70Job Categories Series (Customer)7TRFGBPay Scale Areanvarchar20
40T7SAPBSM1Minimum Service Duration for KSA Military Sector4TRFGBPay Scale Areanvarchar20
41T7UNCMTC_TRFGBCustomizing table for Personnel SubArea and Employee Group3TRFGBPay Scale Areanvarchar20
42ZA0008Importtabelle Fehlerliste Sollbezüge21TRFGBTarif-/Gehaltsgebietnvarchar20
TOPArgentina
43T7AR59Assign pay scale (II) to collective agreement class3TRFGBPay Scale Areanvarchar20
44T7AR65Pay scale agreement category identification3TRFGBPay Scale Areanvarchar20
TOPAustralia
45T5QSSSuperannuation Defined Salary Australia4TRFGBPay Scale Areanvarchar20
TOPBudget Management
46HRP1501DB Table for Infotype 150120TRFGBPay Scale Areanvarchar20
47HRP1506DB Table for Infotype 150620TRFGBPay Scale Areanvarchar20
48T7PMFSpecial Pay Scale Groups4TRFGBPay Scale Areanvarchar20
49T7PMGAverage Amounts for Collective Agreements (PSG)4TRFGBPay Scale Areanvarchar20
50T7PMUDefault Values for Teaching Hours4TRFGBPay Scale Areanvarchar20
TOPCompensation Management
51HRP1005DB Table for Infotype 1005 (Planned Compensation)20TRFGBPS/Pay Grade Areanvarchar20
52PA0380HR Master Data Record Infotype 0380 (Comp. Adjustment)31TRFGBPay Grade Areanvarchar20
53T510DDynamic Standard Pay Increase4TRFGBPay Scale Areanvarchar20
54T510RPay Scale Reclassification4TRFGBPay Scale Areanvarchar20
55T510_PSRCLPay scale reclassification4TRFGBPay Scale Areanvarchar20
56T71D2Pay Scale Group Rule6TRFGBPay Scale Areanvarchar20
TOPDenmark
57T5MF6Conversion of R/3 Pay Scale Structure to FA PS Structure3TRFGBPay Scale Areanvarchar20
TOPFinland
58T7FI510TVR relevant payscale group/level (Finland)4TRFGBPay Scale Areanvarchar20
TOPGermany
59T5D0UAssignment to Pay Scale Area Groups5TRFGBPay Scale Areanvarchar20
60T5D3MAssignment of a Valuation of Pay Scales for Statistics6TRFGBPay Scale Areanvarchar20
TOPIndia
61T7INA3Allowance grouping definition table3TRFGBPay Scale Areanvarchar20
TOPItaly
62PA3214HR Master Record: Infotype 3214274TRFGBPay Scale Areanvarchar20
63T5ITADWage types to recalculate (not used anymore)3TRFGBPay Scale Areanvarchar20
64T5ITAWWage types to recalculate4TRFGBPay Scale Areanvarchar20
65T5ITC1Contributions3TRFGBPay Scale Areanvarchar20
66T5ITC2Negative tax bases3TRFGBPay Scale Areanvarchar20
67T5ITC3Lowest rate management3TRFGBPay Scale Areanvarchar20
68T5ITC4Lowest rate amounts3TRFGBPay Scale Areanvarchar20
69T5ITC5Tax scale rounding3TRFGBPay Scale Areanvarchar20
70T5ITC6Contribution table extention for settlement3TRFGBPay Scale Areanvarchar20
71T5ITCGSettlement request for contributions3TRFGBPay Scale Areanvarchar20
72T5ITCHContrib.settlement type3TRFGBPay Scale Areanvarchar20
73T5ITCIWT which form the tax base3TRFGBPay Scale Areanvarchar20
74T5ITCJTaxation type text4TRFGBPay Scale Areanvarchar20
75T5ITCSContribution indicator3TRFGBPay Scale Areanvarchar20
76T5ITCTTaxation type3TRFGBPay Scale Areanvarchar20
77T5ITCWContribution indicator text4TRFGBPay Scale Areanvarchar20
78T5ITCXSettlement request text for contributions4TRFGBPay Scale Areanvarchar20
79T5ITCYContribution settlement type text4TRFGBPay Scale Areanvarchar20
80T5ITD6Deduction expected income table3TRFGBPay Scale Areanvarchar20
81T5ITDAMiscellaneous data deductions3TRFGBPay Scale Areanvarchar20
82T5ITEHActivity area 7703TRFGBPay Scale Areanvarchar20
83T5ITF3Provision accrual3TRFGBPay Scale Areanvarchar20
84T5ITF5Severance indemnity revaluation table (IT)3TRFGBPay Scale Areanvarchar20
85T5ITF7Severance pay3TRFGBPay Scale Areanvarchar20
86T5ITF8Accrual settlement3TRFGBPay Scale Areanvarchar20
87T5ITFTProvision indicator3TRFGBPay Scale Areanvarchar20
88T5ITFXSeverance indemnity provision indicator description4TRFGBPay Scale Areanvarchar20
89T5ITFYProvision indicator description4TRFGBPay Scale Areanvarchar20
90T5ITI2INPS general data table3TRFGBPay Scale Areanvarchar20
91T5ITIANursing table3TRFGBPay Scale Areanvarchar20
92T5ITICMarriage leave table3TRFGBPay Scale Areanvarchar20
93T5ITIDBlood donation table3TRFGBPay Scale Areanvarchar20
94T5ITIGOrdinary days/hours table3TRFGBPay Scale Areanvarchar20
95T5ITIISickness handling c/INPS table3TRFGBPay Scale Areanvarchar20
96T5ITIMSickness handling c/company3TRFGBPay Scale Areanvarchar20
97T5ITINAccident handling table3TRFGBPay Scale Areanvarchar20
98T5ITIPMaternity table3TRFGBPay Scale Areanvarchar20
99T5ITISSickness handling scale c/company3TRFGBPay Scale Areanvarchar20
100T5ITL3Monthly decontribution3TRFGBPay Scale Areanvarchar20
101T5ITNG01/M data table - section B3TRFGBPay Scale Areanvarchar20
102T5ITQ2Net pay rounding table - Italy only4TRFGBPay Scale Areanvarchar20
103T5ITQITable for ICOMP Indirect Valuation form6TRFGBPay Scale Areanvarchar20
104T5ITQLTaxation types to be highlighted in the payroll3TRFGBPay Scale Areanvarchar20
105T5ITQNINAIL status and taxation indicators3TRFGBPay Scale Areanvarchar20
106T5ITQTSettlement indicator3TRFGBPay Scale Areanvarchar20
107T5ITQXSettlement indicator text4TRFGBPay Scale Areanvarchar20
108T5ITS1Percentage pay scale jumps - percentage ceiling3TRFGBPay Scale Areanvarchar20
109T5ITS2Amount-based pay scale jumps - number/amount-based ceiling3TRFGBPay Scale Areanvarchar20
110T5ITS3Amount-based pay scale jumps - fractional no. based ceiling3TRFGBPay Scale Areanvarchar20
111T5ITS4Percentage pay scale jumps - number-based ceiling3TRFGBPay Scale Areanvarchar20
112T5ITS7Insurance pay scale jumps - class change3TRFGBPay Scale Areanvarchar20
113T5ITTBIRPEF miscellaneous data settlement3TRFGBPay Scale Areanvarchar20
114T5ITU1Collective Labour Agreement coefficients3TRFGBPay Scale Areanvarchar20
TOPJapan
115T5J59HR Job promotion - pay scale level ordering JPN4TRFGBPay Scale Areanvarchar20
116T5J60HR Parameters for pay scale recreation JPN4TRFGBPay Scale Areanvarchar20
TOPKorea
117T7KR32Standardized monthly compensation4TRFGBPay Scale Areanvarchar20
TOPNon Profit Organizations
118PA0961HR Master Record: Infotype 096130TRFGBPay Scale Areanvarchar20
119T7UNPAD_DS0GDuty Station Relation to SAP Entities Payscale Area7TRFGBPay Scale Areanvarchar20
TOPPayroll
120T5HPBS01Szorzószámok4TRFGBBérrendszerterületnvarchar20
121T5HPBS01XSzorzószámok4TRFGBBérrendszerterületnvarchar20
122T5HPBS02Besorolási fokozatok2TRFGBBérrendszerterületnvarchar20
123T5HPBS02TBesorolási fokozatok szövegei3TRFGBBérrendszerterületnvarchar20
124T5HPBS02XBesorolási fokozatok2TRFGBBérrendszerterületnvarchar20
125T5HPBS12School leaving certificate level code2TRFGBPay Scale Areanvarchar20
126T5HPBS41Besorolási fokozat kódja2TRFGBBérrendszerterületnvarchar20
127T5HPBS41TBesorolási fokozat megnevezése3TRFGBBérrendszerterületnvarchar20
128T5HPBS61Köztisztviseloi pótszabadság megképzését vezérlo tábla2TRFGBBérrendszerterületnvarchar20
129T5HPBS62Közalkalmazotti pótszabadság megképzését vezérlo tábla2TRFGBBérrendszerterületnvarchar20
130T5HPBS63Generating leave quotas2TRFGBPay Scale Areanvarchar20
131T5HPBS96Foreign exchange multipliers (for IT3265)2TRFGBPay Scale Areanvarchar20
132T5HPBS98FX multipliers for long-term studies abroad2TRFGBPay Scale Areanvarchar20
133T5T10Tarif groups - ext.survey4TRFGBPay Scale Areanvarchar20
134T7SK10Tarif groups - ext.survey4TRFGBPay Scale Areanvarchar20
TOPPayroll General Parts
135HRPY_WPBPHR-PAY: Transparent Table WPBP30TRFGBPay Scale Areanvarchar20
136T510CAdjust Bases for Calculating Av.Vals.acc.to PScale4TRFGBPay Scale Areanvarchar20
TOPPension Administration
137PA0785HR Master Record Infotype 078538TRFGBPay Scale Area for Pensionnvarchar20
138PA0788HR Master Record Infotype 078827TRFGBPay Scale Areanvarchar20
139PA0789HR Master Record Infotype 078927TRFGBPay Scale Areanvarchar20
140PA0845HR Master Record Infotype 0845 (Work Relationships)27TRFGBPay Scale Areanvarchar20
141T7DEPBSVAVG01Current Pension Value (East, West)3TRFGBPay Scale Areanvarchar20
142T7DEPBSVAVG02Conversion Values Pension3TRFGBPay Scale Areanvarchar20
143T7PBS00TRF_DATPayscale Group-Dependent Data5TRFGBPay Scale Areanvarchar20
144T7PBS00TRF_DATESPayscale Group-Dependent Data5TRFGBPay Scale Areanvarchar20
145T7PBSCA2EAssignmt of Public Serv. Regulation to Pay Scale Type/Area4TRFGBPay Scale Areanvarchar20
TOPPersonnel Administration
146PA0008HR Master Record: Infotype 0008 (Basic Pay)25TRFGBPay Scale Areanvarchar20
147PA0052HR Master Record: Infotype 0052 (Wage Maintenance)26TRFGBPay Scale Areanvarchar20
148T001PPersonnel Area/Subarea7TRFGBPay Scale Areanvarchar20
149T510Pay Scale Groups4TRFGBPay Scale Areanvarchar20
150T510BAppraisal Constants4TRFGBPay Scale Areanvarchar20
151T510FAssign Pay Scale --> Currency4TRFGBPay Scale Areanvarchar20
152T510GPay Scale Areas3TRFGBPay Scale Areanvarchar20
153T510MValuation of pay scale groups acc. to hiring date4TRFGBPay Scale Areanvarchar20
154T510UPay Scale Groups4TRFGBPay Scale Areanvarchar20
155T510WPay Scale > Period Parameter Assignment4TRFGBPay Scale Areanvarchar20
156T528BPositions8TRFGBPay Scale Areanvarchar20
157T5ITI1Standard period table3TRFGBPay Scale Areanvarchar20
158T5ITS5Scatti in categoria tetto massimo in numero - HR Italy3TRFGBArea contrattualenvarchar20
159T5ITS8Scatti assicurativi premio fedelta'3TRFGBArea contrattualenvarchar20
TOPPersonnel Time Management
160T510IStandard Working Hours4TRFGBPay Scale Areanvarchar20
TOPPortugal
161T5PP1HR-PT: Professional categories assignment3TRFGBPay Scale Areanvarchar20
162T5PP4HR-PT: Professional Category designation3TRFGBPay Scale Areanvarchar20
163T5PS1HR-PT: professional categories assignment (IRC code)3TRFGBPay Scale Areanvarchar20
164T5PS4HR-PT: Professional Category designation3TRFGBPay Scale Areanvarchar20
165T5PS4THR-PT: text table for professional category designation4TRFGBPay Scale Areanvarchar20
TOPPosition Budgeting and Control
166HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction18TRFGBPay Scale Areanvarchar20
167HRP1511DB Table for Infotype 151120TRFGBPS/Pay Grade Areanvarchar20
168T77HRFPM_STOVMaintenance of FTE Limits5TRFGBPay Scale Areanvarchar20
TOPPublic Sector
169PA0326HR Master Rec.: Infotype 0326 (Imputation to Pension Payts)57TRFGBPay Scale Area for Pensionnvarchar20
170PA0330Infotype 0330 (Non-Monetary Remuneration)25TRFGBPay Scale Areanvarchar20
171PA0509HR-AU-PS: Master Data (Higher Duty Allowance)42TRFGBPay scale area of the higher duty positionnvarchar20
172PDPBSDNEUG_UEB_TCarried Over to DNeuG: Personnel Pay Scale Information5TRFGBPay Scale Areanvarchar20
173PDPBSTVOED_UEBTransfer to TVoeD: Personnel Master Record Before Transfer6TRFGBPay Scale Areanvarchar20
174T5APBS06Pay scale reclassification4TRFGBPay Scale Areanvarchar20
175T5D5LNPay Scale Assign. for Guaranteed Payts: COLA/Fam.-Rel Bonus4TRFGBPay Scale Areanvarchar20
176T5D71Period Calculation4TRFGBPay Scale Areanvarchar20
177T5D71TFunction Model Texts for Period Calculation5TRFGBPay Scale Areanvarchar20
178T5D7JControl of BDA and COLA Relevance (Basic Pay)4TRFGBPay Scale Areanvarchar20
179T5D7KParameters for Determining Proposed Pay Seniority4TRFGBPay Scale Areanvarchar20
180T5D7LAuxiliary Table for Higher Grouping and Promotion4TRFGBPay Scale Areanvarchar20
181T5D7LNNext Pay Scale Group for Higher/Lower Grouping4TRFGBPay Scale Areanvarchar20
182T5D7MValue of Remuneration Groups4TRFGBPay Scale Areanvarchar20
183T5D7MNValue of Pay Scale Groups4TRFGBPay Scale Areanvarchar20
184T5D7NDetermination of Hiring Level Model 84TRFGBPay Scale Areanvarchar20
185T5D7QModels for Control of Contribution4TRFGBPay Scale Areanvarchar20
186T5D7QTFunction Model Texts: Special Payment5TRFGBPay Scale Areanvarchar20
187T5D7RModels for Controlling Vacation Bonus4TRFGBPay Scale Areanvarchar20
188T5D7RTFunction Model Texts: Vacation Bonus5TRFGBPay Scale Areanvarchar20
189T5D82Pay Scale Information for Calculation of Minimum Pension5TRFGBPay Scale Areanvarchar20
190T5D8EAccommodation, Infotype 30 (payments in kind)4TRFGBPay Scale Areanvarchar20
191T5D8FNon-Monetary Remuneration: Meals, Infotype 03304TRFGBPay Scale Areanvarchar20
192T5D8MPosition Table for College Statistics7TRFGBPay Scale Areanvarchar20
193T5D95Foreign Service Bonus4TRFGBPay Scale Areanvarchar20
194T5D97Supplement for Child Living Abroad4TRFGBPay Scale Areanvarchar20
195T5DPBS08Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp6TRFGBPay Scale Areanvarchar20
196T5DPBS09Spec. and Non-Rec. Payts, Cumul. WTs for Each Pay Scale Grp6TRFGBPay Scale Areanvarchar20
197T5DPBS0ESpec. and Non-Rec. Payments: Pay Scale-Dependent Percentages6TRFGBPay Scale Areanvarchar20
198T5DPBS1CBasis for Activity with Higher Rate of Pay12TRFGBRemuneration By Pay Scale Areanvarchar20
199T5DPBS1GValidity of Variable Key for Each Pay Scale Group4TRFGBPay Scale Areanvarchar20
200T5DPBS3BAssignment to Internal Pay Scale Group4TRFGBPay Scale Areanvarchar20
201T5DPBS3DTVoeD: Structural Adjustment4TRFGBPay Scale Areanvarchar20
202T5DPBS3ETVoeD: COLA Class for Guaranteed Payment (Children)4TRFGBPay Scale Areanvarchar20
203T5PBSR6IGuideline for Salary Components4TRFGBPay Scale Areanvarchar20
204T5PBSR6NAssignment between Pay scale area and division3TRFGBPay Scale Areanvarchar20
205T5QPBS1ENational Wage Case (NWC) increase for Superannuation4TRFGBPay Scale Areanvarchar20
206T5QPBS1HPriority Table used in calculating HDA super salary comp.3TRFGBPay scale area of the higher duty positionnvarchar20
207T5QPBS6CAssignment of APS classification structure4TRFGBPay Scale Areanvarchar20
208T5VPPS_PSRALVNorway Public Sector: IT 0509 records in ALV of RPIPSP0010TRFGBPay Scale Areanvarchar20
TOPRecruitment
209PB0008Applicant Master Record Infotype (Basic Pay)25TRFGBPay Scale Areanvarchar20
TOPSouth Africa
210T5W10Link pay scale groups to occupational level. - Equity3TRFGBPay Scale Areanvarchar20
211T5W11Link pay scale groups to occupational level. - Equity3TRFGBPay Scale Areanvarchar20
TOPSpain
212PA0480HR master record for infotype 048028TRFGBPay Scale Areanvarchar20
213PB0480HR master record infotype 0480 (Candidates)28TRFGBPay Scale Areanvarchar20
214T5E10Extension of pay scales3TRFGBPay Scale Areanvarchar20
215T5E53Amounts of seniority bonuses3TRFGBPay Scale Areanvarchar20
216T5E60Contract entity according to the company6TRFGBPay Scale Areanvarchar20
217T5E61Contract transformations allowed6TRFGBPay Scale Areanvarchar20
218T5E6IContract texts according to company7TRFGBPay Scale Areanvarchar20