Regarding creating a report

[Former Member]

Hi all,

i have a requirement as below :

We need a report that will give EE name, SSN, PER#, Contract Prg 1 & Prg 2, Orig Key, Advance Vacation Pay Vacation Pay Out, and Severance Pay. Will need each option to have Wage Type, Description, HR/Unit, Rate, Current, and YTD data.

Will want to be able to select by WC, Per#, Org Key, and Benefit Plan Option. Will need to have capability to do a date range.

i am new to HR ABAP , can anyone sugest how to go further.

i want to know what infotypes are used?

and fields... from tables?

[Former Member · Accepted solution]

hi

first 4/ 5 field u can get from 0000,0001 infotype just go to pa30

for getting the field name press F1 on required field and click on technical information icon.

advance vacation pay ,pay out ,and severance pay are the wage type those u have to fetch from RT table .

first check the view t512w_d in sm30.

get the wagetypes they will be like /323 ,/123

those wagetype u have to fetch from payroll result .

[Former Member · Accepted solution]

this particular t512w_d is not present.

[Former Member · Accepted solution]

sorry it is V_512w_d and open it via SM30

[Former Member · Accepted solution]

what is this? anyways let me check once i start working on this and then post here.

thanks,

Poonam

[Former Member · Accepted solution]

Poonam,

I hope you have to get the details form Clusters (after payroll run ( Current me If I am wrong))

You will get all the mentioned details in Payroll Cluster Tables (go to Transaction -pc_payresult)

WPBP Work Center/Basic Pay

RT Results Table

RT_ Results Table (Collapsed Display)

CRT Cumulative Results Table

BT Payment(bank) Information

VERSION Information on Creation

PCL2 Update information PCL2

VERSC Payroll Status Information

TAX1 Master Data for Tax Calculation (Infotypes 0461-0463)

TAX2 Exempt Reasons for Tax Calculation (Infotype 0464)

TCRT Federal and Provincial Cumulative Results Table

TCRTI Federal and Provincial Tax Authorities

ROE Record of Employment (ROE) Information

VC1 Vacation Pay Accrual and Balancing

NAME Name of Employee

ADR Address 1

PERM Personal Characteristics

MODIF HR-PAY-99: Modifiers

WCB1 Cluster table for Workers' compensation

Regards

Suresh.KK

Please go thru the below link I hope it will help you.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PYINT/PYINT_REPORTING.pdf

Edited by: Suresh Kalimahanthi on Sep 22, 2008 12:37 PM

[Former Member · Accepted solution]

yes u r right, we need to use PCL2 cluster but in the requirement i have many other tables also,

Like :

Contract Prg 1: V_T5UBT-barea, V_T5UBT-bengr, V_T5UBT-ltext

Contract Prg 2: V_T5UB9-barea, V_T5UB9-bstat, V_T5UB9-ltext

(Execute PDSY transaction and the object as BENGR, and BSTAT)

i dint get what does this statement mean?

by using all these fields from a view how r we going to get contract Prg1

[Former Member]

Hi Poonam,

Do you need coding for all the required information?

Give me your mail iw i will send you the coding for the required information.

thanks,vasu.

[Former Member]

hi,

i am done with the coding, but the problem is the wages what i am using i guess they are not used in pc_payresult transaction.

getting an exception here.