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

113 columns | Print definition?ERP 6.0  | TRFST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee25TRFSTnvarchar20
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee26TRFSTnvarchar20
3DFKK_TRIGX_CLOutbound Interface: New Trigger Table of Cleared Items13TRFSTOutbound Intrface: Trigger Statusnvarchar10
4DFKK_TRIGX_OPOutbound Interface: New Trigger Table for Business Partner9TRFSTOutbound Intrface: Trigger Statusnvarchar10
5DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info19TRFSTOutbound Intrface: Trigger Statusnvarchar10
6DFKK_TRIGX_RCLOI: New Trigger Table for Reopened Items15TRFSTOutbound Intrface: Trigger Statusnvarchar10
7P2B2_ALPHCM Declustering B2 - Alternative Payment Table ALP22TRFSTPay Scale Levelnvarchar20
8P2B2_CWSTHCM Declustering B2 - PDC Time Tickets89TRFSTPay scale levelnvarchar20
9P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay43TRFSTPay Scale Levelnvarchar20
10P2B2_WSTHCM Declustering B2 - PDC Time Tickets89TRFSTPay scale levelnvarchar20
11P2RQ_QHDAHR-AU-PS: Payroll structure for Higher Duty Allowance27TRFSTPay scale level of the higher duty positionnvarchar20
12P2RR_RMPayroll Results: Table for Master data (SG)42TRFSTPay Scale Levelnvarchar20
13P2RV_VAPVAP Structure Norway18TRFSTPay Scale Levelnvarchar20
14P2RX_ALPAlternative Payment Table ALP20TRFSTPay Scale Levelnvarchar20
15P2RX_WPBPPayroll Results: Work Center/Basic Pay41TRFSTPay Scale Levelnvarchar20
16P2UN_QHDAHR-UN: Payroll structure for Higher Duty Allowance27TRFSTPay scale level of the higher duty positionnvarchar20
17P2UN_RSUN Rental Subsidy internal structure52TRFSTPay Scale Levelnvarchar20
18PA0576HR Master Record Infotype 057628TRFSTnvarchar20
19T510EDynamic Standard Pay Increase II7TRFSTPay Scale Levelnvarchar20
20T510NPay Scales for Annual Salaries (NA)7TRFSTPay Scale Levelnvarchar20
21T5FPBS4BEchelon6TRFSTÉchelonnvarchar20
22T5GPBSS_PSCSWF: Pay Scale6TRFSTPay Scale Levelnvarchar20
23T5GPBSS_PSC2SWF: Pay Scale6TRFSTPay Scale Levelnvarchar20
24T5PPBS5SSProgression depending on seniority session table13TRFSTPay Scale Levelnvarchar20
25T5PPBS8AIndex Value for Pay Scale Type, Area, Group, and Level6TRFSTPay Scale Levelnvarchar20
26T7UNPF_HR_CATMMapping table for Pay scale type to Salary Category5TRFSTPay Scale Levelnvarchar20
27ZCATSDBRecords changed with processing status '10'42TRFSTnvarchar20
28ZCATSDB2Records changed with processing status '10'43TRFSTnvarchar20
TOPArgentina
29T7AR65Pay scale agreement category identification6TRFSTPay Scale Levelnvarchar20
TOPAttendancesAbsences
30CATSHRCross-Application Time Sheet (CATS): Transfer to HR48TRFSTPay Scale Levelnvarchar20
TOPCompensation Management
31PA0380HR Master Data Record Infotype 0380 (Comp. Adjustment)33TRFSTPay Grade Levelnvarchar20
32T510DDynamic Standard Pay Increase7TRFSTPay Scale Levelnvarchar20
33T510RPay Scale Reclassification7TRFSTPay Scale Levelnvarchar20
34T510_PSRCLPay scale reclassification7TRFSTPay Scale Levelnvarchar20
TOPContract Accounts Receivable and Payable
35DFKK_TRIGGER_CLOutbound Interface: Trigger Table of Cleared Items12TRFSTOutbound Intrface: Trigger Statusnvarchar10
36DFKK_TRIGGER_OPOutbound Interface: Trigger Table for Business Partner8TRFSTOutbound Intrface: Trigger Statusnvarchar10
37DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information18TRFSTOutbound Intrface: Trigger Statusnvarchar10
38DFKK_TRIGGER_RCLOutbound Interface: Trigger Table for Reopened Items14TRFSTOutbound Intrface: Trigger Statusnvarchar10
TOPDenmark
39T5MF6Conversion of R/3 Pay Scale Structure to FA PS Structure6TRFSTPay Scale Levelnvarchar20
TOPESS Based on WD ABAP
40HRESS_D_CATS_FAVCATS Favorites: database table49TRFSTPay Scale Levelnvarchar20
TOPFinland
41T7FI510TVR relevant payscale group/level (Finland)7TRFSTPay Scale Levelnvarchar20
TOPGermany
42T5D3MAssignment of a Valuation of Pay Scales for Statistics9TRFSTPay Scale Levelnvarchar20
TOPIndia
43T7INA3Allowance grouping definition table7TRFSTPay Scale Levelnvarchar20
TOPItaly
44PA3214HR Master Record: Infotype 3214276TRFSTPay Scale Levelnvarchar20
45T5ITC4Lowest rate amounts7TRFSTPay Scale Levelnvarchar20
46T5ITS1Percentage pay scale jumps - percentage ceiling6TRFSTPay Scale Levelnvarchar20
47T5ITS2Amount-based pay scale jumps - number/amount-based ceiling6TRFSTPay Scale Levelnvarchar20
48T5ITS3Amount-based pay scale jumps - fractional no. based ceiling6TRFSTPay Scale Levelnvarchar20
49T5ITS4Percentage pay scale jumps - number-based ceiling6TRFSTPay Scale Levelnvarchar20
50T5ITS7Insurance pay scale jumps - class change6TRFSTPay Scale Levelnvarchar20
TOPJapan
51T5J59HR Job promotion - pay scale level ordering JPN7TRFSTPay Scale Levelnvarchar20
TOPKorea
52T7KR32Standardized monthly compensation7TRFSTPay Scale Levelnvarchar20
TOPNew Zealand
53PT2001HR Time Record: Infotype 2001 (Absences)45TRFSTPay Scale Levelnvarchar20
TOPNon Profit Organizations
54PA0961HR Master Record: Infotype 096132TRFSTPay Scale Levelnvarchar20
55PA0965HR Master Record: Infotype 096562TRFSTPay Scale Levelnvarchar20
56T7UNPAD_DPDSDependency Allowance: Lowest Entry Level Determinatio9TRFSTPay Scale Levelnvarchar20
TOPPayroll
57T5HPBS01Szorzószámok6TRFSTBérrendszerszintnvarchar20
58T5HPBS01XSzorzószámok6TRFSTBérrendszerszintnvarchar20
59T5HPBS62Közalkalmazotti pótszabadság megképzését vezérlo tábla4TRFSTBérrendszerszintnvarchar20
60T5HPBS63Generating leave quotas4TRFSTPay Scale Levelnvarchar20
61T5HPBS96Foreign exchange multipliers (for IT3265)4TRFSTPay Scale Levelnvarchar20
62T5HPBS98FX multipliers for long-term studies abroad4TRFSTPay Scale Levelnvarchar20
63T5T10Tarif groups - ext.survey7TRFSTPay Scale Levelnvarchar20
64T7SK10Tarif groups - ext.survey7TRFSTPay Scale Levelnvarchar20
TOPPayroll General Parts
65HRPY_WPBPHR-PAY: Transparent Table WPBP32TRFSTPay Scale Levelnvarchar20
TOPPension Administration
66PA0845HR Master Record Infotype 0845 (Work Relationships)29TRFSTPay Scale Levelnvarchar20
TOPPersonnel Administration
67PA0008HR Master Record: Infotype 0008 (Basic Pay)27TRFSTPay Scale Levelnvarchar20
68PA0052HR Master Record: Infotype 0052 (Wage Maintenance)28TRFSTPay Scale Levelnvarchar20
69T510Pay Scale Groups7TRFSTPay Scale Levelnvarchar20
70T510MValuation of pay scale groups acc. to hiring date7TRFSTPay Scale Levelnvarchar20
71T510UPay Scale Groups7TRFSTPay Scale Levelnvarchar20
72T528BPositions11TRFSTPay Scale Levelnvarchar20
73T5ITS5Scatti in categoria tetto massimo in numero - HR Italy6TRFSTLivello retributivonvarchar20
74T5ITS8Scatti assicurativi premio fedelta'6TRFSTLivello retributivonvarchar20
TOPPersonnel Time Events
75TPTCOR_APLDifferent Payment (Correction Scenario)6TRFSTPay Scale Levelnvarchar20
TOPPersonnel Time Management
76CC1ERPIncorrect Time Events from CC1, Postings48TRFSTPay scale levelnvarchar20
77CC1TEVTemporary Buffer for Time Events from CC143TRFSTPay Scale Levelnvarchar20
78PA2001HR Time Record: Infotype 2001 (Absences)45TRFSTPay Scale Levelnvarchar20
79PA2002HR Time Record: Infotype 2002 (Attendances)38TRFSTPay Scale Levelnvarchar20
80PA2003HR Time Record: Infotype 2003 (Substitutions)51TRFSTPay Scale Levelnvarchar20
81PA2004HR Time Record: Infotype 2004 (Availability)38TRFSTPay Scale Levelnvarchar20
82PA2005HR Time Record: Infotype 2005 (Overtime)48TRFSTPay Scale Levelnvarchar20
83PA2010HR Time Record: Infotype 2010 (Employee Remuneration Info.)40TRFSTPay Scale Levelnvarchar20
84PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)37TRFSTPay Scale Levelnvarchar20
85PTEX2003GENInterface Table for IT 2003: General Information36TRFSTPay Scale Levelnvarchar20
86PTEX2003SPECInterface Table for IT 2003: Interval Information12TRFSTPay Scale Levelnvarchar20
87PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)36TRFSTPay Scale Levelnvarchar20
88TEVENTime Events33TRFSTPay Scale Levelnvarchar20
89TEVEN_MOREAdditional Data for Time Events47TRFSTPay scale levelnvarchar20
TOPPortugal
90T5PP1HR-PT: Professional categories assignment6TRFSTPay Scale Levelnvarchar20
91T5PS1HR-PT: professional categories assignment (IRC code)6TRFSTPay Scale Levelnvarchar20
TOPPosition Budgeting and Control
92HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction20TRFSTPay Scale Levelnvarchar20
TOPPublic Sector
93PA0509HR-AU-PS: Master Data (Higher Duty Allowance)44TRFSTPay scale level of the higher duty positionnvarchar20
94PDPBSDNEUG_UEB_TCarried Over to DNeuG: Personnel Pay Scale Information7TRFSTPay Scale Levelnvarchar20
95PDPBSTVOED_UEBTransfer to TVoeD: Personnel Master Record Before Transfer8TRFSTPay Scale Levelnvarchar20
96T5APBS06Pay scale reclassification7TRFSTPay Scale Levelnvarchar20
97T5D7NDetermination of Hiring Level Model 811TRFSTPay Scale Levelnvarchar20
98T5D82Pay Scale Information for Calculation of Minimum Pension7TRFSTPay Scale Levelnvarchar20
99T5DPBS1CBasis for Activity with Higher Rate of Pay14TRFSTPayment by Pay Scale Levelnvarchar20
100T5DPBS3DTVoeD: Structural Adjustment9TRFSTRemuneration Levelnvarchar20
101T5PBSR6GBasic Component5TRFSTPay Scale Levelnvarchar20
102T5QPBS1ENational Wage Case (NWC) increase for Superannuation7TRFSTPay Scale Levelnvarchar20
103T5QPBS1HPriority Table used in calculating HDA super salary comp.5TRFSTPay scale level of the higher duty positionnvarchar20
104T5VPPS_510Table to update T510 for yrly changes-Norway Public Sector4TRFSTPay Scale Levelnvarchar20
105T5VPPS_PSRALVNorway Public Sector: IT 0509 records in ALV of RPIPSP0012TRFSTPay Scale Levelnvarchar20
TOPRecruitment
106PB0008Applicant Master Record Infotype (Basic Pay)27TRFSTPay Scale Levelnvarchar20
TOPSouth Africa
107T5W10Link pay scale groups to occupational level. - Equity6TRFSTPay Scale Levelnvarchar20
TOPSpain
108T5E51Seniority bonuses4TRFSTPay Scale Levelnvarchar20
109T5E53Amounts of seniority bonuses6TRFSTPay Scale Levelnvarchar20
TOPTime Sheet
110CATSDBCATS: Database Table for Time Sheet42TRFSTPay Scale Levelnvarchar20
111CATS_TEMPCATS: Database Table for Templates44TRFSTPay Scale Levelnvarchar20
TOPTime Tickets
112EVHRHR Order Confirmations (Times/Time Events)47TRFSTPay scale levelnvarchar20
113LSHRHR Order Confirmations (Durations/Time Tickets)47TRFSTPay scale levelnvarchar20