payroll table

[Former Member]

Hi,

Can u tell me important tables in payroll results to be consider?

Also i want to know what & how data gets stored in CRT,RT,GRT,TCRT .

I want to know what is difference between above table too.

Thanks a lot.

Regards.

[ak_upadhyay]

Hi,

Check These Links....

http://help.sap.com/saphelp_46c/helpdata/en/fd/45a2d99d6411d189b60000e829fbbd/content.htm

http://www.sap-img.com/human/finding-the-list-of-hr-module-tables.htm

<REMOVED BY MODERATOR>

Regards

AK

Edited by: Alvaro Tejada Galindo on Apr 10, 2008 1:17 PM

[venkat_o]

Hi Rani, The following are the payroll related Cluster tables . You can see using T.code SE11. PCL1, PCL2, PCL3 and PCL4. 1.File PCL1 is the basis for the HR work area data. It contains information from the time recording, for example, incentive wage time tickets or infotype supplement texts. 2.File PCL2 contains derived information, for example, payroll results. It also contains payroll schemas. 3.File PCL3 contains applicant data. 4.File PCL4 contains the change documents for HR master data and recruitment. When Payroll is run, payroll results are stored in Cluster PCL2. Goto SE11 and give PCL2 and see the field, there RELID, this is used for which area payroll results are imported/ exported. RU->US RR->singapore IN->India. Regarding CRT,RT,GRT,TCRT . When we write programs on Payroll, we import the payroll results using Function modules and Macros into one Deep structure type PAYnn_RESULT. nn = country indicator. example pay99_result = Structure for payroll result: International Check the structure in SE11, you can see three fields.Double click on Second field. you will find all mentioned above. Check the sample programs.

REPORT ythr_pay_net LINE-SIZE 80.
TABLES: pernr.
INFOTYPES: 0002.
DATA: coname(40).
DATA: t_result TYPE TABLE OF payus_result,
w_result TYPE payus_result,
w_rt TYPE pc207.
DATA: g_select TYPE i,
g_proces TYPE i,
g_reject TYPE i.
DATA: error_int TYPE TABLE OF hrerror.
START-OF-SELECTION.
CALL FUNCTION 'HR_REFRESH_ERROR_LIST'.
CALL FUNCTION 'HR_REFRESH_STAT_LIST'.
GET pernr.
rp_provide_from_last p0002 space pn-begda pn-begda.
PERFORM concat_name USING coname.
FORMAT COLOR COL_GROUP INTENSIFIED ON.
WRITE: / pernr-pernr,
coname, 80 space.
FORMAT COLOR OFF.
g_select = g_select + 1.
CALL FUNCTION 'HR_GET_PAYROLL_RESULTS'
EXPORTING
pernr = pernr-pernr
pabrj = pn-begda(4)
pabrp = pn-begda+4(2)
pabrj_end = pn-endda(4)
pabrp_end = pn-endda+4(2)
actual = 'A'
TABLES
result_tab = t_result
EXCEPTIONS
no_results = 1
error_in_currency_conversion = 2
t500l_entry_not_found = 3
period_mismatch_error = 4
t549q_entry_not_found = 5
internal_error = 6
wrong_structure_of_result_tab = 7.

I hope that it helps u . Regards, Venkat.O

[Former Member]

>

> Hi,
> 
> Can u tell me important tables in payroll results to be consider?
> Also i want to know  what & how data gets stored in CRT,RT,GRT,TCRT .
> I want to know what is difference between above table too.
> 
> Thanks a lot.
> Regards.

Check this link

http://help.sap.com/saphelp_47x200/helpdata/en/71/4c45624c4611d1890b0000e8323d3a/content.htm

[Former Member]

I m not using Logical Data base.

can u send me coding for that?

[Former Member]

Hi rani,

1. use this code (just copy paste)

(this does not use any ldb)

use ur own values for

mypernr, fpper, basic wage type (1000 in our case)

2.

REPORT abc.


*----- Data
DATA : myseqnr LIKE hrpy_rgdir-seqnr.
DATA: py_result TYPE payin_result.
DATA : mypernr LIKE p0001-pernr.
DATA : wpbp LIKE TABLE OF pc205 WITH HEADER LINE.
DATA : myrt LIKE TABLE OF pc207 WITH HEADER LINE.

*------- Read Directory


SELECT SINGLE seqnr INTO myseqnr
FROM hrpy_rgdir
WHERE pernr = mypernr
AND fpper = '200601'
AND srtza = 'A'.

CHECK sy-subrc = 0.

*-------- Read Results

CALL FUNCTION 'PYXX_READ_PAYROLL_RESULT'
EXPORTING
clusterid = 'IN'
employeenumber = mypernr
sequencenumber = myseqnr
CHANGING
payroll_result = py_result
EXCEPTIONS
illegal_isocode_or_clusterid = 1
error_generating_import = 2
import_mismatch_error = 3
subpool_dir_full = 4
no_read_authority = 5
no_record_found = 6
versions_do_not_match = 7
error_reading_archive = 8
error_reading_relid = 9
OTHERS = 10.
IF sy-subrc <> 0.
ENDIF.


myrt[] = py_result-inter-rt .

*-------------------
READ TABLE myrt WITH KEY lgart = '1000'.

regards,

amit m.