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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

150 columns | Print definition?ERP 6.0  | TRFGR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee24TRFGRnvarchar80
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee25TRFGRnvarchar80
3P2B2_ALPHCM Declustering B2 - Alternative Payment Table ALP21TRFGRPay Scale Groupnvarchar80
4P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay42TRFGRPay Scale Groupnvarchar80
5P2RQ_QHDAHR-AU-PS: Payroll structure for Higher Duty Allowance26TRFGRPay scale group of the higher duty positionnvarchar80
6P2RR_RMPayroll Results: Table for Master data (SG)41TRFGRPay Scale Groupnvarchar80
7P2RV_VAPVAP Structure Norway17TRFGRPay Scale Groupnvarchar80
8P2RX_ALPAlternative Payment Table ALP19TRFGRPay Scale Groupnvarchar80
9P2RX_WPBPPayroll Results: Work Center/Basic Pay40TRFGRPay Scale Groupnvarchar80
10P2UN_QHDAHR-UN: Payroll structure for Higher Duty Allowance26TRFGRPay scale group of the higher duty positionnvarchar80
11P2UN_RSUN Rental Subsidy internal structure51TRFGRPay Scale Groupnvarchar80
12PA0576HR Master Record Infotype 057627TRFGRnvarchar80
13PA0648HR Master Record: Infotype 064827TRFGRPay Scale Groupnvarchar80
14T510EDynamic Standard Pay Increase II6TRFGRPay Scale Groupnvarchar80
15T510NPay Scales for Annual Salaries (NA)6TRFGRPay Scale Groupnvarchar80
16T5BPBS01Description of pay scale rules6TRFGRPay Scale Groupnvarchar80
17T5BPBS02Description of payscale rule Jumps6TRFGRPay Scale Groupnvarchar80
18T5D14Features of Earnings Survey for State Statistics Office6TRFGRPay Scale Groupnvarchar80
19T5D5FCase groups3TRFGRPay Scale Groupnvarchar80
20T5D5LFamily-Related Bonus Classes and Career Assignment6TRFGRPay Scale Groupnvarchar80
21T5FPBS4AEchelle5TRFGREchelle, groupe hors-échelle.nvarchar80
22T5FPBS4BEchelon5TRFGREchelle, groupe hors-échelle.nvarchar80
23T5FPBS4EAffectation échelle, grade7TRFGREchelle, groupe hors-échelle.nvarchar80
24T5GPBSS_PSCSWF: Pay Scale5TRFGRPay Scale Groupnvarchar80
25T5GPBSS_PSC2SWF: Pay Scale5TRFGRPay Scale Groupnvarchar80
26T5PPBS3DFunctional comp. level/manager level based on pay scale5TRFGRPay Scale Groupnvarchar80
27T5PPBS3DTText of funct.comp. level/manager level based on pay scale6TRFGRPay Scale Groupnvarchar80
28T5PPBS8AIndex Value for Pay Scale Type, Area, Group, and Level5TRFGRPay Scale Groupnvarchar80
29T7AEPBS07Rental Allocation5TRFGRPay Scale Groupnvarchar80
30T7AEPBS51Ranking of PS Job Grades6TRFGRPay Scale Groupnvarchar80
31T7QAPBS01Pay Scale mapping table4TRFGRPay Scale Groupnvarchar80
32T7QAPBS07Pay Scale Group Sequence3TRFGRPay Scale Groupnvarchar80
33T7QAPBS34Education qualification for promotion2TRFGRPay Scale Groupnvarchar80
34T7SAPBS10Representation allowance according to Job & Category3TRFGRPay Scale Groupnvarchar80
35T7SAPBS26Define Overtime Group Based On Pay Scale5TRFGRPay Scale Groupnvarchar80
36T7SAPBS34Assign Pay Scale to Job Classification11TRFGRPay Scale Groupnvarchar80
37T7SAPBS41Refer other Pay Scale for Allowances/Benefits4TRFGRPay Scale Groupnvarchar80
38T7SAPBSM1Minimum Service Duration for KSA Military Sector5TRFGRPay Scale Groupnvarchar80
39T7UNCMT_SACIDMCMT Map Staff and Salary Assessment Category Code9TRFGRPay Scale Groupnvarchar80
40T7UNPF_HR_CATMMapping table for Pay scale type to Salary Category4TRFGRPay Scale Groupnvarchar80
41ZCATSDBRecords changed with processing status '10'41TRFGRnvarchar80
42ZCATSDB2Records changed with processing status '10'42TRFGRnvarchar80
TOPArgentina
43T7AR65Pay scale agreement category identification5TRFGRPay Scale Groupnvarchar80
TOPAttendancesAbsences
44CATSHRCross-Application Time Sheet (CATS): Transfer to HR47TRFGRPay Scale Groupnvarchar80
TOPAustralia
45T5QSSSuperannuation Defined Salary Australia5TRFGRPay Scale Groupnvarchar80
TOPBudget Management
46HRP1501DB Table for Infotype 150122TRFGRPay Scale Groupnvarchar80
47HRP1506DB Table for Infotype 150622TRFGRPay Scale Groupnvarchar80
48T7PMFSpecial Pay Scale Groups8TRFGRPay Scale Groupnvarchar80
49T7PMGAverage Amounts for Collective Agreements (PSG)6TRFGRPay Scale Groupnvarchar80
50T7PMUDefault Values for Teaching Hours6TRFGRPay Scale Groupnvarchar80
TOPCompensation Management
51PA0380HR Master Data Record Infotype 0380 (Comp. Adjustment)32TRFGRPay gradenvarchar80
52T510DDynamic Standard Pay Increase6TRFGRPay Scale Groupnvarchar80
53T510RPay Scale Reclassification6TRFGRPay Scale Groupnvarchar80
54T510_PSRCLPay scale reclassification6TRFGRPay Scale Groupnvarchar80
TOPDenmark
55T5MF6Conversion of R/3 Pay Scale Structure to FA PS Structure5TRFGRPay Scale Groupnvarchar80
TOPESS Based on WD ABAP
56HRESS_D_CATS_FAVCATS Favorites: database table48TRFGRPay Scale Groupnvarchar80
TOPFinland
57T7FI510TVR relevant payscale group/level (Finland)6TRFGRPay Scale Groupnvarchar80
TOPGermany
58T5D3MAssignment of a Valuation of Pay Scales for Statistics8TRFGRPay Scale Groupnvarchar80
TOPIndia
59T7INA3Allowance grouping definition table6TRFGRPay Scale Groupnvarchar80
TOPItaly
60PA3214HR Master Record: Infotype 3214275TRFGRPay Scale Groupnvarchar80
61T5ITC4Lowest rate amounts6TRFGRPay Scale Groupnvarchar80
62T5ITEGPay Scale Indicator 7703TRFGRPay Scale Groupnvarchar80
63T5ITNVAssignment table of INPS levels2TRFGRPay Scale Groupnvarchar80
64T5ITPMCheck Table for Higher Duties : infotype (3214) subtype 00027TRFGRPay Scale Groupnvarchar80
65T5ITS1Percentage pay scale jumps - percentage ceiling5TRFGRPay Scale Groupnvarchar80
66T5ITS2Amount-based pay scale jumps - number/amount-based ceiling5TRFGRPay Scale Groupnvarchar80
67T5ITS3Amount-based pay scale jumps - fractional no. based ceiling5TRFGRPay Scale Groupnvarchar80
68T5ITS4Percentage pay scale jumps - number-based ceiling5TRFGRPay Scale Groupnvarchar80
69T5ITS7Insurance pay scale jumps - class change5TRFGRPay Scale Groupnvarchar80
TOPJapan
70T5J59HR Job promotion - pay scale level ordering JPN6TRFGRPay Scale Groupnvarchar80
71T5J60HR Parameters for pay scale recreation JPN6TRFGRPay Scale Groupnvarchar80
TOPKorea
72T7KR32Standardized monthly compensation6TRFGRPay Scale Groupnvarchar80
TOPNew Zealand
73PT2001HR Time Record: Infotype 2001 (Absences)44TRFGRPay Scale Groupnvarchar80
TOPNon Profit Organizations
74PA0961HR Master Record: Infotype 096131TRFGRPay Scale Groupnvarchar80
75PA0965HR Master Record: Infotype 096561TRFGRPay Scale Groupnvarchar80
76T7UNOM_P_TITLEPosition Title7TRFGRPay Scale Groupnvarchar80
77T7UNPAD_CEBGRDEG CCAQ Staff Grade Mapping table3TRFGRPay Scale Groupnvarchar80
78T7UNPAD_DPDSDependency Allowance: Lowest Entry Level Determinatio8TRFGRPay Scale Groupnvarchar80
79T7UNPAD_EVE_GAGrade Adjustment for Allowances in EVE3TRFGRPay Scale Groupnvarchar80
80T7UNPAD_GAGrade Adjustment for Mobility Allowances2TRFGRPay Scale Groupnvarchar80
TOPPayroll
81T5HPBS01Szorzószámok5TRFGRBérrendszercsoportnvarchar80
82T5HPBS01XSzorzószámok5TRFGRBérrendszercsoportnvarchar80
83T5HPBS02Besorolási fokozatok3TRFGRBérrendszercsoportnvarchar80
84T5HPBS02TBesorolási fokozatok szövegei4TRFGRBérrendszercsoportnvarchar80
85T5HPBS02XBesorolási fokozatok3TRFGRBérrendszercsoportnvarchar80
86T5HPBS61Köztisztviseloi pótszabadság megképzését vezérlo tábla3TRFGRBérrendszercsoportnvarchar80
87T5HPBS62Közalkalmazotti pótszabadság megképzését vezérlo tábla3TRFGRBérrendszercsoportnvarchar80
88T5HPBS63Generating leave quotas3TRFGRPay Scale Groupnvarchar80
89T5HPBS96Foreign exchange multipliers (for IT3265)3TRFGRPay Scale Groupnvarchar80
90T5HPBS98FX multipliers for long-term studies abroad3TRFGRPay Scale Groupnvarchar80
91T5T10Tarif groups - ext.survey6TRFGRPay Scale Groupnvarchar80
92T5TPSCODPOdpocet let podle kategorie dosaženého vzdelání2TRFGRTarifní skupinanvarchar80
93T5TPSCVYJDefinice vyjímek a odpocet dle kateg. dosaženého vzdelání3TRFGRTarifní skupinanvarchar80
94T7SK10Tarif groups - ext.survey6TRFGRPay Scale Groupnvarchar80
TOPPayroll General Parts
95HRPY_WPBPHR-PAY: Transparent Table WPBP31TRFGRPay Scale Groupnvarchar80
TOPPension Administration
96PA0845HR Master Record Infotype 0845 (Work Relationships)28TRFGRPay Scale Groupnvarchar80
TOPPersonnel Administration
97PA0008HR Master Record: Infotype 0008 (Basic Pay)26TRFGRPay Scale Groupnvarchar80
98PA0052HR Master Record: Infotype 0052 (Wage Maintenance)27TRFGRPay Scale Groupnvarchar80
99T510Pay Scale Groups6TRFGRPay Scale Groupnvarchar80
100T510MValuation of pay scale groups acc. to hiring date6TRFGRPay Scale Groupnvarchar80
101T510UPay Scale Groups6TRFGRPay Scale Groupnvarchar80
102T528BPositions10TRFGRPay Scale Groupnvarchar80
103T5ITS5Scatti in categoria tetto massimo in numero - HR Italy5TRFGRGruppo contrattualenvarchar80
104T5ITS8Scatti assicurativi premio fedelta'5TRFGRGruppo contrattualenvarchar80
TOPPersonnel Time Events
105TPTCOR_APLDifferent Payment (Correction Scenario)5TRFGRPay Scale Groupnvarchar80
TOPPersonnel Time Management
106CC1TEVTemporary Buffer for Time Events from CC142TRFGRPay Scale Groupnvarchar80
107PA2001HR Time Record: Infotype 2001 (Absences)44TRFGRPay Scale Groupnvarchar80
108PA2002HR Time Record: Infotype 2002 (Attendances)37TRFGRPay Scale Groupnvarchar80
109PA2003HR Time Record: Infotype 2003 (Substitutions)50TRFGRPay Scale Groupnvarchar80
110PA2004HR Time Record: Infotype 2004 (Availability)37TRFGRPay Scale Groupnvarchar80
111PA2005HR Time Record: Infotype 2005 (Overtime)47TRFGRPay Scale Groupnvarchar80
112PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)39TRFGRPay Scale Groupnvarchar80
113PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)36TRFGRPay Scale Groupnvarchar80
114PTEX2003GENInterface Table for IT 2003: General Information35TRFGRPay Scale Groupnvarchar80
115PTEX2003SPECInterface Table for IT 2003: Interval Information11TRFGRPay Scale Groupnvarchar80
116PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)35TRFGRPay Scale Groupnvarchar80
117TEVENTime Events32TRFGRPay Scale Groupnvarchar80
TOPPortugal
118T5PP1HR-PT: Professional categories assignment5TRFGRPay Scale Groupnvarchar80
119T5PS1HR-PT: professional categories assignment (IRC code)5TRFGRPay Scale Groupnvarchar80
TOPPosition Budgeting and Control
120HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction21TRFGRPay Scale Groupnvarchar80
121T77HRFPM_STOVMaintenance of FTE Limits7TRFGRPay Scale Groupnvarchar80
TOPPublic Sector
122PA0509HR-AU-PS: Master Data (Higher Duty Allowance)43TRFGRPay scale group of the higher duty positionnvarchar80
123PDPBSDNEUG_UEB_TCarried Over to DNeuG: Personnel Pay Scale Information6TRFGRPay Scale Groupnvarchar80
124PDPBSTVOED_UEBTransfer to TVoeD: Personnel Master Record Before Transfer7TRFGRPay Scale Groupnvarchar80
125T5APBS06Pay scale reclassification6TRFGRPay Scale Groupnvarchar80
126T5D5LNPay Scale Assign. for Guaranteed Payts: COLA/Fam.-Rel Bonus6TRFGRPay Scale Groupnvarchar80
127T5D7KParameters for Determining Proposed Pay Seniority6TRFGRPay Scale Groupnvarchar80
128T5D7MValue of Remuneration Groups6TRFGRPay Scale Groupnvarchar80
129T5D7MNValue of Pay Scale Groups6TRFGRPay Scale Groupnvarchar80
130T5D7NDetermination of Hiring Level Model 86TRFGRPay Scale Groupnvarchar80
131T5D7RModels for Controlling Vacation Bonus10TRFGRLimit Pay Scale Group, Lower Half (PSG)nvarchar80
132T5D82Pay Scale Information for Calculation of Minimum Pension6TRFGRPay Scale Groupnvarchar80
133T5D8MPosition Table for College Statistics9TRFGRPay Scale Groupnvarchar80
134T5D95Foreign Service Bonus7TRFGRPay Scale Groupnvarchar80
135T5DPBS08Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp8TRFGRPay Scale Groupnvarchar80
136T5DPBS09Spec. and Non-Rec. Payts, Cumul. WTs for Each Pay Scale Grp8TRFGRPay Scale Groupnvarchar80
137T5DPBS0ESpec. and Non-Rec. Payments: Pay Scale-Dependent Percentages8TRFGRPay Scale Groupnvarchar80
138T5DPBS1CBasis for Activity with Higher Rate of Pay13TRFGRPayment According to Pay Scale Groupnvarchar80
139T5DPBS1GValidity of Variable Key for Each Pay Scale Group6TRFGRPay Scale Groupnvarchar80
140T5DPBS3BAssignment to Internal Pay Scale Group6TRFGRPay Scale Groupnvarchar80
141T5QPBS1ENational Wage Case (NWC) increase for Superannuation6TRFGRPay Scale Groupnvarchar80
142T5QPBS1HPriority Table used in calculating HDA super salary comp.4TRFGRPay scale group of the higher duty positionnvarchar80
143T5QPBS6CAssignment of APS classification structure5TRFGRPay Scale Groupnvarchar80
144T5VPPS_PSRALVNorway Public Sector: IT 0509 records in ALV of RPIPSP0011TRFGRPay Scale Groupnvarchar80
TOPRecruitment
145PB0008Applicant Master Record Infotype (Basic Pay)26TRFGRPay Scale Groupnvarchar80
TOPSouth Africa
146T5W10Link pay scale groups to occupational level. - Equity5TRFGRPay Scale Groupnvarchar80
TOPSpain
147T5E51Seniority bonuses3TRFGRPay Scale Groupnvarchar80
148T5E53Amounts of seniority bonuses5TRFGRPay Scale Groupnvarchar80
TOPTime Sheet
149CATSDBCATS: Database Table for Time Sheet41TRFGRPay Scale Groupnvarchar80
150CATS_TEMPCATS: Database Table for Templates43TRFGRPay Scale Groupnvarchar80