Tuesday, December 27, 2011

SAP HR Tables

After making few search on SAP HR Tables, i had found good website listing all the table which are might useful for anyone who deal with SAP HR.

source: http://www.sd-solutions.com/SAP-HR-Tables.html


TableTable Description
PA
T503*Employee groups and sub-groups. Use T503* and then F4 to search for the correct table.
T001PPersonnel areas and sub-areas. The total view (V_001P_ALL) is useful.
Actions
T529AMain table - controls all the actions
T588DSet up which infotypes are linked to each info groups (action)
T588MInfotype Screen Modifications - allows you to hide fields etc.
T530Reasons - Text for each reason linked to each action
T529UStatus texts
T529FFast data entry
T588ZControls the config for dynamic actions
Wage Type related
T512W_BValuation bases
T512W_CAverages
T512W_DProcessing, cumulation and evaluation classes
T512W_OComplete view: good for documentation: click on Info icon
T512W_TTexts
T510Pay scale types, areas, groups and levels
T510J/td>Constant values for indirect valuation
T511Wage type characteristics
T511AUsed for calculating averages
T511KPayroll constants
T511PPayroll parameters
T512TLong and short text
T512ZPermissibility per infotype
T539AWage type models which work in conjunction with feature LGMST
T539JNeed to enter wage types for Indirect Valuation
T549APayroll areas and period parameters
T549SPayroll areas, periods, pay dates and posting dates
V_511_BWage type permissibility
V_T52DZAssign customizing wage type to model wagetype
V_T52EKSymbolic accounts
V_T52ELWage type posting
V_T52EL_COMPWage type posting -complete view by end date
V_T52EZTime dependency of wage type posting
Payslip
T512DLine layouts in payslip window
T512EContents of groups within windows
T512FWindow coordinates
T512NRules
T512PBackground
T512QSingle Fields
T514KAllowed tables
T514NAllowed fields
UK Specific
T5G01Tax Rates
T5G02Special Tax Code
T5G03Tax Increase and Limit
T5G05NIC Limits
T5G06NIC Percentages
T5G08NI Control Data Texts
T5G09NI Categories (GB)
T5G0AEmployee Group/Subgroup
T5G10Pension Fund
T5G15Court Order Deductions
T5G16Court Order Indicator
T5G1TPension Fund Texts
T5G20SSP System Data (GB)
T5G21SMP System Data
T5G22SSP Qualifying Day Pattern
T5G23Time Models for SSP Qualifying Day Patterns
T5G24SSP Qualifying Day Pattern Calendars
T5G25Occupational Sick Pay Schemes
T5G26OSP-Related Data for SSP Offsetting
T5G27SSP Rates Payable (GB)
T5G28SMP Rates Payable
T5G2ESSP/SMP Exclusion Reason Texts
T5G2FSSP/SMP Exclusion Reasons
T5G2TText for Occupational Sick Pay Schemes
T5G30Pension Schemes
T5G31Pension Contribution Calculation Rules
T5G32Pension Holidays
T5G33Pension Contribution Calculation Rule Bands
T5G34Pension Contribution Calculation Rule - Flat Rates
T5G35Pension Contribution Calculation Rule - Percentages
T5G36Pension Contribution Calculation Rule - Mix
T5G37Pension Scheme Types
T5G3TPension Scheme Names
T5G40National Insurance Earnings Ranges
T5G_NICLIMNational Insurance Limits
T5G41National Insurance Percentage Rates
T5G_NICPCTNational Insurance Percentages
T5G4TText for Court Order Indicator
T5G50Tax Districts
T5G51Payroll Area PAYE Reference
T5G52Tax District and Reference Details
T5G53Permit Numbers
T5G54End Of Year Processing Stamp
T5G55HR-GB: Default Tax Code
T5G5TTax District Name
T5G61Business Mileage Bands
T5G62Payment of Petrol Costs (Based on Engine Size)
T5G63Payments for Private Fuel (Basis: Car List Price)
T5G64Unavailability Reasons
T5G6TUnavailability Reasons Text
T5G70Official rates for company loans
Schema and PCR
T52C0SAP standard schemas
T52C1customer-created schemas and modified SAP-standard schemas
T52C2Texts for Schemas
T52C3Texts for Schemas
T52CCSchema Directory
T52CC_TSchema descriptions
T52C5PCR's in the system
T52CEDirectory of Personnel Calculation Rules
T52CE_TText Table for PCR Directory
T52CTText Elements
Time Mgt
T551APeriod Work Schedule
T508AWork Schedule Rule Overview
T552AWork Schedules - Complete View
Org Mgt
T77S0Holds all the PD settings and other HR settings
Other
ICONGives you all the icons in the SAP system
TPARAHolds all the user parameters in the system
TSTCHolds all the transaction codes in the system - use SE11, SE16 or SE16N to display them all
E070Holds all the transport attributes in the system
E07THolds all the transport descriptions in the system
V_T51AV_2WAssignment of wage types to average bases
V_T582AHolds all the available Infotypes and their names