Tuesday, October 20, 2015

/551 and /552 GL Posting

Had a long time troubleshooting GL posting imbalance today. Thought I should record this down for future reference.

Wagetype /551 and /552 should always be debited. The Sign in T52EL should be +.



Friday, April 24, 2015

TCODE OKEON - To create Standard Hierarchy

When you want to create a Cost Center via tcode KS01, you may encounter error message when trying to key in the Standard Hierarchy.


This is because the Standard Hierarchy has not been created and linked to a Controlling Area.


To do this, use tcode OKEON to perform this.


Upon doing that, you can go back to KS01 and create your Cost Center and also enter the Standard Hierarchy.

Monday, October 20, 2014

Payroll Korea - Tax Deductions and Tax Credits

In SAP Payroll Korea, there are a number of standard tax deductions and tax credits built in the system before generating the actual taxable income. For the deductions that took place, technical wagetypes that reflect those deductions will be generated such as 
 
/Y2D (Earned income deductions)
/Y2E (Adjusted Income)
/Y3E (Basic Deduction for Employee)
/Y3G (Spouse Deduction)
/Y3S (Old Age Deduction)
/Y3T (Handicap Deduction)
/YSG (Single Parent Deduction)
/Y5T (Donation Deduction)
/Y4C (Insurance Deduction)
/Y70 (Housing Deductions)
/Y7M (Overseas Income)
etc..

This spreadsheet attempts to list out these tax deductions according to category, along with the limits or capping that applies for each deductions. The constants name from T511K or T511P that holds these limits are also listed in the spreadsheet.

Also included in the spreadsheet is a list of cumulation classes and its corresponding technical wagetype that it will generate for non taxable wagetypes.
For example, a non taxable Meal Allowance can be configured by flagged it into /132. After payroll is run, the technical wagetype that is generated is /3N2. This will be reported in the Year End Tax Report as a non taxable income. The constant name and the limit amounts that the system will validate against, is also listed in the spreadsheet.



Korea Payroll : PC00_M41_YEA_LST / Withholding Earned Income Tax List / Page 2 Obligatory or Non Obligatory Non Taxable Allowances

TCODE: PC00_M41_YEA_LST
Report Name: Withholding Earned Income Tax List or The Payment List of Withholding Tax

This spreadsheet list out the non taxable allowances/technical wagetypes from SAP Korea Payroll such as 

/3NV - Overseas non taxable
/3NU - Overseas non taxable
/3N3 - Overtime Allowance
/3NA - Childcare
/3NH - Foreigner Salary
/3NI - Foreigner Bonus
/3NJ - Research Allowance K
/3N6 - Reporter Allowance
/4TR - Medical Insurance
/4UR - Long Term Care Insurance
/3N2 - Meal Allowance
etc..

that needs to be reported in the Year End Tax Reports. Generally non taxable allowance wagetypes are reported on Page 2 in the Withholding Earned Income Tax List report. It is also separated into two categories - Mandatory or Non Mandatory.



This spreadsheet helps to determine which wagetype will appear in which section within that report. Obligatory or Non Obligatory?

https://drive.google.com/file/d/0B7sMa6sUkN0RTm9PWDEwQjFZMkE/view?usp=sharing

Wednesday, September 3, 2014

What is TKAU**

In PCR, we may need to add all Calendar Days into a Wagetype and deduct certain Absence Types from it.


For example, 31 calendar days in January is first loaded into the variable.
Then we deduct the Absences.
Perhaps we only want to deduct Unpaid Absence and not Annual Leave.


Format: TKAU(XX) where XX is the Valuation Rule in table V_T554C


RTE=TKSOLL Set
RTE-TKAU(XX)
RTE-TKAU60
RTE-TKAU70
RTE*KGENAU Multiplication
RTE/TKDIVI Division
ADDWT * OT Output table


In V_T554C
AbsValGrp Valuation Rule Description
-----------------------------------------------------------
01               60                    Sick Leave
01               70                    Unpaid Absence

Wednesday, July 9, 2014

ABAP - Solving the problem of field splitting its contents into two columns in Excel

Have you coded a report program that is supposed to populate a field into 1 specific column of an *.CSV or Excel file output but found that the field has split itself into two different columns?


To make matters worst, all the fields or columns in the Excel file appear to shift to the right from this incorrect column onwards.


For my case, the problem lies in the data where there exist a comma.


For example "Project Manager, Water Industry"


Thus the "Project Manager" stays in the expected column but the "Water Industry" appears in the next column.


To solve this problem, I use the REPLACE keyword and replace the comma with SPACE.


REPLACE ALL OCCURRENCES OF ',' IN ev_pay_area with SPACE.

Sunday, July 6, 2014

Using TARIF to default IT0008 from IT1005 Planned Compensation

Using the Feature TARIF with return value:-
  1. S (for paygrade check), T710
  2. T (for payscale check), T510
  3. D (for direct check).
  4. 1 (for Payscale)
  5. 2 (for paygrade)
  6. 3 (for Payscale)


These are the tabs in IT1005-planned compensation.

An example configuration would be '  /  /S'





Related information regarding the amounts that are defaulted 
The key is the entry in tables T710 and T710A for the pay grade.  The minimum and maximum amounts are set in T710 and default into IT1005 when you enter the Country, Pay Scale Type, Pay Scale Area, Pay Grade and Level on the first tab (Pay Grade).  In T710A, you set the Message Type and Reduction Rule for the Error, Warning or No message if outside the minimum and maximum for the pay grade and level. 

So your settings in T710A control the warnings.  IT1005 only defaults the Pay Scale Type, Pay Scale Area, Pay Grade and Level.  The minimum and maximum salary amount comes from T710. 

If Feature TARIF is returned with P, then this takes the defaulting from T510.