clusters in payroll

[Former Member]

hi friends,

could u plz tell me what are the uses of clusters in payroll report????

thanks in advance,

regards,

priya.s

[Former Member]

The HR module utilizes clusters for storing information in a variety of areas. Some of the tables available for storing data clusters are PCL1, PCL2, PCL3, PCL4, and PCL5, as shown below. Clusters provide numerous advantages. For instance, they are best for storing long texts and notes related to infotypes. The monthly payroll results and payroll directory of an employee are also stored in cluster form in table PCL2

PCL1:

TX Infotype texts

TE Travel expenses

TA General data for accounting of travel expenses

PCL2:

ID Interface toolbox – directory of interface results

ZL Time wage types and work schedule

RU Payroll results (US)

PCL3:

TY Applicant data texts

AP Applicant actions

PCL4:

P2 Log for RPCALX0 and RPTIME00

U1 Tax reporter forms for US

PCL5:

PY Payroll data for personnel cost planning

CP Planning run data for personnel cost planning

STXL TX Notes related to infotypes

*************************8

you have to read the cluster like this.

Tables : pcl1, pcl2.

temp.variable to hold the payroll period

DATA : g_f_pper LIKE pc261-fpper .

DATA : g_f_seqnr LIKE pc261-seqnr.

Cluster Definition.

INCLUDE rpc2cd00. "Cluster CD Data-Definition

INCLUDE rpppxd00. "Data-Definition Puffer PCL1/PCL2

INCLUDE rpppxd10. "Common Part Puffer PCL1/PCL2

INCLUDE rpppxm00 .

INCLUDE rpc2rx02 .

INCLUDE rpc2rx39 .

INCLUDE rpc2ca00 .

INCLUDE rpc2rdd1 .

INCLUDE rpc2rx29 .

INCLUDE hdepaymacro .

Get the payroll period

CLEAR : g_f_pper.

CONCATENATE pn-begda0(4) pn-begda4(2) INTO g_f_pper .

fill the keys for the CU cluster

cd-key-pernr = pernr-pernr.

import from the cluster CU

CLEAR: rgdir, g_f_seqnr.

REFRESH rgdir.

rp-imp-c2-cd.

IF rp-imp-cd-subrc = 0 .

IF NOT rgdir[] IS INITIAL.

SORT rgdir BY fpbeg DESCENDING.

LOOP AT rgdir WHERE fpper EQ g_f_pper

AND srtza EQ 'A'. " Active g_f_seqnr = rgdir-seqnr.

ENDLOOP.

ENDIF.

ENDIF.

fill the RX key and then import the cluster

rx-key-pernr = pernr-pernr .

CLEAR : rx-key-seqno.

UNPACK g_f_seqnr TO rx-key-seqno .

CLEAR rt.

REFRESH rt.

rp-imp-c2-rd.

IF rp-imp-rd-subrc = 0.

LOOP AT rt WHERE lgart = '9230'. RT " Result table

• move the values here

Endloop.

ENDIF.

Regards

vasu

[former_member808457]

hi,

Clusters are where the payroll results are stored after a payroll run.

For payroll reporting u read those results either using function module like 'PYXX_READ_PAYROLL_RESULT' or read them using macros

rp-imp-c2-rx(international) , for US rp-imp-c2-ru.Then u can find the required amounts in RT , CRT tables .

In sap r/3 system u can see results using transaction PC_PAYRESULT.

regards,

vinay

[Former Member]

hi priya,

we can use the cluster in payroll where the valuable info.. is stored in cluster we can diffferent cluster like

pcl1, pcl2, plc3, pcl4.........database objects clusters.... with these clusters we can dispaly the payroll data... this cluster can be retrieved in many ways by using f.m, macros, get events,....