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

Sunday, October 23, 2011

Monday, October 17, 2011

Payroll T Codes


PC00_M99_CLSTR Display Payroll Results
PC00_M99_CALC Payroll Driver (International)
PC00_M99_ABKRS Specify a payroll area
PC00_M99_CLSTPC Display PC Cluster: Personal Calendar
PC00_M99_TLEA Leave Overview
PC00_M99_TLEA30 Batch-Input: Annual Leave
PC00_M99_CPRC Access Payroll Calendar
PC00_M99_MOLGA Specify a personnel country grouping
PC00_M99_CLJN Payroll Journal - International
PC00_M99_DLGA20 Use of Wage Types in Payroll
PC00_M99_UDIR Restore the Payroll Results Directory
PU00 Delete Personnel Data
PU01 Delete Current Payroll Result
PU03 Change Payroll Status
PU2 Archive Data
PU0 Wage Type Copier
PU95 Edit Wage Type Groups and Logical Views
PU96 Edit Wage Type Groups
PU97 Edit Logical Views
PU98 Assign Wage Types to Wage Type Groups
PUOC_xx (xx = Country Code) Off-Cycle Workbench
PEST Maintenance of Process Model
PUST HR Process Workbench


PC00 - Run Payroll
PC10 - Payroll menu USA
PE00 - Starts Transactions PE01 PE02 PE03
PE01 - Schemas
PE02 - Calculation Rules
PE03 - Features
PE04 - Create functions and Operations
PE51 - HR form editor
PRCA - Payroll Calendar
PRCT - Current Settings
PRCU - Printing checks USA
PRD1 - Create DME
SM31 - Maintain Table
SM12 - Locked Secessions
TSTC - Table Look up
SPRO - IMG
SE16 - Data Browser (Table Reports)
PP03 - PD Tables
PPOM - Change Org Unit
PO13 - Maintain Positions
PO03 - Maintain Jobs

Pay scales:
PC00_M99_U510 Simple Std Pay Increase for Indirectly Valuated WTs
PC00_M99_IRTF Enhanced Std Pay Increase (Indirect and Direct WTs) with Batch Input
PC00_M99_ITUM Pay Scale Reclassification acc.to Age or Pay Scale Membership Period
Forms
PC00_M99_CEDT Remuneration Statements
PDF7 Delete Form in Customer Client
PDF8 Copy Form from SAP Client to Customer Client
PDF9 Copy Form within Customer Client
PC00_M99_CLGA00 Wage Type Statement
PC00_M99_CLGV00 Wage Type Distribution
PC00_M99_CKTO Payroll Accounts
PDF0 Conversion Report for Remuneration Statement Forms
PDFA Conversion of Payroll Journal Forms

Third party
PC00_M99_URMA Acknowledgement Report for Third Party Remittance
PC00_M99_URMU Update of Remittance Tables from TemSe-Object
Transfer Activities
PC00_M99_CIPE Posting to Accounting: Create Posting Run
PC00_M99_DKON Posting to Accounting: Wage Type Assignment - Display G/L Accounts
PC00_M99_CIPC Posting to Accounting: Search for Payroll Results not Posted
PC00_M99_URMR Reconciliation of Transfers
PC00_M99_URMW Maintain Wage Types According to Assignment to HR Creditors
PC00_M99_URMD Undo Third-Party Remittance Runs
PC00_M99_URMP Create Third-Party Remittance Posting Run
PC00_M99_CMLI0 Cash Breakdown List (International)
PC00_M99_CDTA Preliminary Program- Data Medium Exchange for Several Payment Runs
Tools
PE04 Editor for Calling Functions and Operations
PE03 Editor for Calling Features
PE02 Editor for Calling Personnel Calculation Rules
PE01 Editor for Calling Personnel Calculation Schemas
PE51 Call the Form Editor
PU12 Interface Toolbox
PDSY HR-Documentation Maintenance

Monday, September 26, 2011

SAP Tables Cheat Sheet

List of SAP Tables (Cheat Sheet / Overview)

source : http://www.smart-words.org/sap-tables-overview.html

List of SAP Transaction Codes (Cheat Sheet / Overview)

http://www.smart-words.org/sap-transaction-codes-overview.html

 Download CheatSheet

GL Account Long Text Number

Refer to table  SKAT - GL account long text number