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

124 columns | Print definition?ERP 6.0  | TRFKZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee23TRFKZnvarchar10
2T510EDynamic Standard Pay Increase II5TRFKZES grouping for collective agreement provisionnvarchar10
3T510NPay Scales for Annual Salaries (NA)5TRFKZES grouping for collective agreement provisionnvarchar10
4T546Employee Subgroup for PersCalcRule/CollAgreemProvision3TRFKZES grouping for collective agreement provisionnvarchar10
5T5BPBS01Description of pay scale rules5TRFKZES grouping for collective agreement provisionnvarchar10
6T5BPBS02Description of payscale rule Jumps5TRFKZES grouping for collective agreement provisionnvarchar10
7T5D14Features of Earnings Survey for State Statistics Office5TRFKZES grouping for collective agreement provisionnvarchar10
8T5D5LFamily-Related Bonus Classes and Career Assignment5TRFKZES grouping for collective agreement provisionnvarchar10
9T5PPBS3DFunctional comp. level/manager level based on pay scale4TRFKZES grouping for collective agreement provisionnvarchar10
10T5PPBS3DTText of funct.comp. level/manager level based on pay scale5TRFKZES grouping for collective agreement provisionnvarchar10
11T5PPBS8AIndex Value for Pay Scale Type, Area, Group, and Level4TRFKZES grouping for collective agreement provisionnvarchar10
12T7AEPBS51Ranking of PS Job Grades5TRFKZES grouping for collective agreement provisionnvarchar10
13T7PBS00TRF_BETRGAmounts for Constants on Pay Scale Basis or Statutory Basis7TRFKZES grouping for collective agreement provisionnvarchar10
14T7UNCMT_PCATMCMT Payscale Category Mapping6TRFKZES grouping for collective agreement provisionnvarchar10
15T7UNCMT_SACIDMCMT Map Staff and Salary Assessment Category Code8TRFKZES grouping for collective agreement provisionnvarchar10
16T7UNPAD_UNISOLADuty Station Unified SOLA Rates4TRFKZES grouping for collective agreement provisionnvarchar10
17ZA0008Importtabelle Fehlerliste Sollbezüge22TRFKZGruppierung der Mitarbeiterkreise für Tarifregelungnvarchar10
TOPArgentina
18T7AR65Pay scale agreement category identification4TRFKZES grouping for collective agreement provisionnvarchar10
TOPBudget Management
19HRP1501DB Table for Infotype 150121TRFKZES grouping for collective agreement provisionnvarchar10
20HRP1506DB Table for Infotype 150621TRFKZES grouping for collective agreement provisionnvarchar10
21T7PMFSpecial Pay Scale Groups5TRFKZES grouping for collective agreement provisionnvarchar10
22T7PMGAverage Amounts for Collective Agreements (PSG)5TRFKZES grouping for collective agreement provisionnvarchar10
23T7PMUDefault Values for Teaching Hours5TRFKZES grouping for collective agreement provisionnvarchar10
TOPCompensation Management
24HRP1005DB Table for Infotype 1005 (Planned Compensation)21TRFKZES grouping for collective agreement provisionnvarchar10
25T510DDynamic Standard Pay Increase5TRFKZES grouping for collective agreement provisionnvarchar10
26T510RPay Scale Reclassification5TRFKZES grouping for collective agreement provisionnvarchar10
27T510_PSRCLPay scale reclassification5TRFKZES grouping for collective agreement provisionnvarchar10
28T5EMUPROTLog table for currency translation EMU6TRFKZES grouping for collective agreement provisionnvarchar10
29T71D2Pay Scale Group Rule7TRFKZES grouping for collective agreement provisionnvarchar10
TOPDenmark
30T5MF6Conversion of R/3 Pay Scale Structure to FA PS Structure4TRFKZES grouping for collective agreement provisionnvarchar10
TOPFinland
31T7FI510TVR relevant payscale group/level (Finland)5TRFKZES grouping for collective agreement provisionnvarchar10
TOPGermany
32T5D3MAssignment of a Valuation of Pay Scales for Statistics7TRFKZES grouping for collective agreement provisionnvarchar10
TOPIndia
33T7INA3Allowance grouping definition table5TRFKZES grouping for collective agreement provisionnvarchar10
TOPItaly
34T5ITC1Contributions4TRFKZES grouping for collective agreement provisionnvarchar10
35T5ITC2Negative tax bases4TRFKZES grouping for collective agreement provisionnvarchar10
36T5ITC3Lowest rate management4TRFKZES grouping for collective agreement provisionnvarchar10
37T5ITC4Lowest rate amounts5TRFKZES grouping for collective agreement provisionnvarchar10
38T5ITC5Tax scale rounding4TRFKZES grouping for collective agreement provisionnvarchar10
39T5ITC6Contribution table extention for settlement4TRFKZES grouping for collective agreement provisionnvarchar10
40T5ITEGPay Scale Indicator 7702TRFKZES grouping for collective agreement provisionnvarchar10
41T5ITF3Provision accrual4TRFKZES grouping for collective agreement provisionnvarchar10
42T5ITF7Severance pay4TRFKZES grouping for collective agreement provisionnvarchar10
43T5ITF8Accrual settlement4TRFKZES grouping for collective agreement provisionnvarchar10
44T5ITGBAssign EEF Grouping5TRFKZES grouping for collective agreement provisionnvarchar10
45T5ITI2INPS general data table4TRFKZES grouping for collective agreement provisionnvarchar10
46T5ITIANursing table4TRFKZES grouping for collective agreement provisionnvarchar10
47T5ITICMarriage leave table4TRFKZES grouping for collective agreement provisionnvarchar10
48T5ITIDBlood donation table4TRFKZES grouping for collective agreement provisionnvarchar10
49T5ITIGOrdinary days/hours table4TRFKZES grouping for collective agreement provisionnvarchar10
50T5ITIISickness handling c/INPS table4TRFKZES grouping for collective agreement provisionnvarchar10
51T5ITIMSickness handling c/company4TRFKZES grouping for collective agreement provisionnvarchar10
52T5ITINAccident handling table4TRFKZES grouping for collective agreement provisionnvarchar10
53T5ITIPMaternity table4TRFKZES grouping for collective agreement provisionnvarchar10
54T5ITISSickness handling scale c/company4TRFKZES grouping for collective agreement provisionnvarchar10
55T5ITNG01/M data table - section B4TRFKZES grouping for collective agreement provisionnvarchar10
56T5ITNJSpecial remunerations table2TRFKZES grouping for collective agreement provisionnvarchar10
57T5ITQITable for ICOMP Indirect Valuation form7TRFKZES grouping for collective agreement provisionnvarchar10
58T5ITQLTaxation types to be highlighted in the payroll4TRFKZES grouping for collective agreement provisionnvarchar10
59T5ITS1Percentage pay scale jumps - percentage ceiling4TRFKZES grouping for collective agreement provisionnvarchar10
60T5ITS2Amount-based pay scale jumps - number/amount-based ceiling4TRFKZES grouping for collective agreement provisionnvarchar10
61T5ITS3Amount-based pay scale jumps - fractional no. based ceiling4TRFKZES grouping for collective agreement provisionnvarchar10
62T5ITS4Percentage pay scale jumps - number-based ceiling4TRFKZES grouping for collective agreement provisionnvarchar10
63T5ITS7Insurance pay scale jumps - class change4TRFKZES grouping for collective agreement provisionnvarchar10
64T5ITU1Collective Labour Agreement coefficients4TRFKZES grouping for collective agreement provisionnvarchar10
TOPJapan
65T5J59HR Job promotion - pay scale level ordering JPN5TRFKZES grouping for collective agreement provisionnvarchar10
66T5J60HR Parameters for pay scale recreation JPN5TRFKZES grouping for collective agreement provisionnvarchar10
TOPKorea
67T7KR32Standardized monthly compensation5TRFKZES grouping for collective agreement provisionnvarchar10
TOPNon Profit Organizations
68T7UNPAD_DDSADuty Station DSA Rates (Daily Subsistence Allowance)4TRFKZES grouping for collective agreement provisionnvarchar10
69T7UNPAD_DMSADuty Station MSA Rates (Mission Subsistence Allowance)4TRFKZES grouping for collective agreement provisionnvarchar10
70T7UNPAD_DPDSDependency Allowance: Lowest Entry Level Determinatio11TRFKZES grouping for collective agreement provisionnvarchar10
71T7UNPAD_DSDADuty Station Dependency Allowance4TRFKZES grouping for collective agreement provisionnvarchar10
72T7UNPAD_DSPADuty Station Post Adjustment4TRFKZES grouping for collective agreement provisionnvarchar10
73T7UNPAD_DSPTDuty Station PTA Personnel Transition Allowance4TRFKZES grouping for collective agreement provisionnvarchar10
74T7UNPAD_DS_TDuty Station Text Table4TRFKZnvarchar10
75T7UNPAD_RGSTRepatriation Grant Number Translation5TRFKZES grouping for collective agreement provisionnvarchar10
TOPPayroll
76T5T10Tarif groups - ext.survey5TRFKZES grouping for collective agreement provisionnvarchar10
77T7SK10Tarif groups - ext.survey5TRFKZES grouping for collective agreement provisionnvarchar10
TOPPayroll General Parts
78T510CAdjust Bases for Calculating Av.Vals.acc.to PScale5TRFKZES grouping for collective agreement provisionnvarchar10
TOPPension Administration
79T7PBS00TRF_DATPayscale Group-Dependent Data6TRFKZES grouping for collective agreement provisionnvarchar10
80T7PBS00TRF_DATESPayscale Group-Dependent Data6TRFKZES grouping for collective agreement provisionnvarchar10
TOPPersonnel Administration
81T503Employee Group/Subgroup7TRFKZES grouping for collective agreement provisionnvarchar10
82T510Pay Scale Groups5TRFKZES grouping for collective agreement provisionnvarchar10
83T510FAssign Pay Scale --> Currency5TRFKZES grouping for collective agreement provisionnvarchar10
84T510MValuation of pay scale groups acc. to hiring date5TRFKZES grouping for collective agreement provisionnvarchar10
85T510UPay Scale Groups5TRFKZES grouping for collective agreement provisionnvarchar10
86T510WPay Scale > Period Parameter Assignment5TRFKZES grouping for collective agreement provisionnvarchar10
87T528BPositions9TRFKZES grouping for collective agreement provisionnvarchar10
88T5ITS5Scatti in categoria tetto massimo in numero - HR Italy4TRFKZRaggruppamento dei tipi dipendente per condizioni contr.nvarchar10
89T5ITS8Scatti assicurativi premio fedelta'4TRFKZRaggruppamento dei tipi dipendente per condizioni contr.nvarchar10
TOPPersonnel Time Management
90T510IStandard Working Hours5TRFKZES grouping for collective agreement provisionnvarchar10
TOPPortugal
91T5PP1HR-PT: Professional categories assignment4TRFKZES grouping for collective agreement provisionnvarchar10
92T5PS1HR-PT: professional categories assignment (IRC code)4TRFKZES grouping for collective agreement provisionnvarchar10
TOPPosition Budgeting and Control
93HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction19TRFKZES grouping for collective agreement provisionnvarchar10
94HRP1511DB Table for Infotype 151121TRFKZES grouping for collective agreement provisionnvarchar10
95T77HRFPM_STOVMaintenance of FTE Limits6TRFKZES grouping for collective agreement provisionnvarchar10
TOPPublic Sector
96T5APBS06Pay scale reclassification5TRFKZES grouping for collective agreement provisionnvarchar10
97T5D5LNPay Scale Assign. for Guaranteed Payts: COLA/Fam.-Rel Bonus5TRFKZES grouping for collective agreement provisionnvarchar10
98T5D7JControl of BDA and COLA Relevance (Basic Pay)5TRFKZES grouping for collective agreement provisionnvarchar10
99T5D7KParameters for Determining Proposed Pay Seniority5TRFKZES grouping for collective agreement provisionnvarchar10
100T5D7LAuxiliary Table for Higher Grouping and Promotion5TRFKZES grouping for collective agreement provisionnvarchar10
101T5D7LNNext Pay Scale Group for Higher/Lower Grouping5TRFKZES grouping for collective agreement provisionnvarchar10
102T5D7MValue of Remuneration Groups5TRFKZES grouping for collective agreement provisionnvarchar10
103T5D7MNValue of Pay Scale Groups5TRFKZES grouping for collective agreement provisionnvarchar10
104T5D7NDetermination of Hiring Level Model 85TRFKZES grouping for collective agreement provisionnvarchar10
105T5D7QModels for Control of Contribution5TRFKZES grouping for collective agreement provisionnvarchar10
106T5D7QTFunction Model Texts: Special Payment6TRFKZES grouping for collective agreement provisionnvarchar10
107T5D7RModels for Controlling Vacation Bonus5TRFKZES grouping for collective agreement provisionnvarchar10
108T5D7RTFunction Model Texts: Vacation Bonus6TRFKZES grouping for collective agreement provisionnvarchar10
109T5D8MPosition Table for College Statistics8TRFKZES grouping for collective agreement provisionnvarchar10
110T5D95Foreign Service Bonus5TRFKZES grouping for collective agreement provisionnvarchar10
111T5D97Supplement for Child Living Abroad5TRFKZES grouping for collective agreement provisionnvarchar10
112T5DPBS08Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp7TRFKZES grouping for collective agreement provisionnvarchar10
113T5DPBS09Spec. and Non-Rec. Payts, Cumul. WTs for Each Pay Scale Grp7TRFKZES grouping for collective agreement provisionnvarchar10
114T5DPBS0ESpec. and Non-Rec. Payments: Pay Scale-Dependent Percentages7TRFKZES grouping for collective agreement provisionnvarchar10
115T5DPBS1GValidity of Variable Key for Each Pay Scale Group5TRFKZES grouping for collective agreement provisionnvarchar10
116T5DPBS3BAssignment to Internal Pay Scale Group5TRFKZES grouping for collective agreement provisionnvarchar10
117T5DPBS3DTVoeD: Structural Adjustment5TRFKZES grouping for collective agreement provisionnvarchar10
118T5DPBS3ETVoeD: COLA Class for Guaranteed Payment (Children)5TRFKZES grouping for collective agreement provisionnvarchar10
119T5PBSR6IGuideline for Salary Components5TRFKZES grouping for collective agreement provisionnvarchar10
120T5QPBS1ENational Wage Case (NWC) increase for Superannuation5TRFKZES grouping for collective agreement provisionnvarchar10
TOPSouth Africa
121T5W10Link pay scale groups to occupational level. - Equity4TRFKZES grouping for collective agreement provisionnvarchar10
TOPSpain
122T5E10Extension of pay scales4TRFKZES grouping for collective agreement provisionnvarchar10
123T5E53Amounts of seniority bonuses4TRFKZES grouping for collective agreement provisionnvarchar10
TOPUnited Kingdom
124T5GASHE2ASHE Collective Agreement Type2TRFKZES grouping for collective agreement provisionnvarchar10