Rt table

[Former Member]

hi all,

May i know how can i get data like wagetype for different periods which will be given in selection screen along with employee no. from RT table. i just need to get the employee no and type of wagetype for the given period.

thanks in advance.

[former_member181995]

I think get data for wage type is nothing you just need to fetch data from infortype 8.just use FM RP_FILL_WAGE_TYPE_TABLE for getting wage type.else you can also use macro like RP_PROVIDE_FROM_LAST P0008 SPACE PN-BEGDA PN-ENDDA.

[Former Member]

sorry to disturb again but i am confused that why do we have many wagetypes in pa0008 table like LGA01 LGA2 etc...

please clear my doubt.

thanks.

[milusai]

These wage types are nothing but the various components of our salary................

[Former Member]

Hi Narender,

As Milind said wage types are salary components in the renumeration statement.

like HRA (House rent allowence), Medical, PF(Provident Fund), DA (Daily Allowence), TA (Travel Allowence) etc..

Best regards,

raam

[Former Member]

Hi,

Use LDB PNP in ur attribute section...

Fetch the RT table this way...

TABLES: PCL1, " HR Cluster 1

PCL2, " HR Cluster 2

PERNR. " Standard Selections for HR Master Data Reporting

*INTERNATIONAL INCLUDE

INCLUDE RPC2CD09. "Cluster CD data definition

INCLUDE RPC2CA00. "Cluster CA Data-Definition

INCLUDE RPPPXD00. "Data Definition buffer PCL1/PCL2 Buffer

INCLUDE RPPPXD10. "Common part buffer PCL1/PCL2

INCLUDE RPPPXM00. "Buffer Handling routine

*COUNTRY SPECIFIC INCLUDE

INCLUDE PC2RXIN0. "Cluster IN data definition

INCLUDE RPC2RX09. "Data Definition for Cluster RD in PCL2

START-OF-SELECTION.

GET PERNR.

• IMPORT ALL CLUSTER RESULTS.

CLEAR RGDIR.

*Pernr value

CD-KEY-PERNR = PERNR-PERNR.

• Macro

RP-IMP-C2-CU.

SORT RGDIR BY FPPER DESCENDING.

• Rgdir table contains the different table with period(pn-begda and pn-endda) range

LOOP AT RGDIR WHERE FPBEG EQ PN-BEGDA AND FPEND EQ PN-ENDDA.

RX-KEY-SEQNO = RGDIR-SEQNR.

RX-KEY-PERNR = PERNR-PERNR.

RP-IMP-C2-IN.

LOOP AT RT.

ENDLOOP.

END-OF-SELECTION.

[Former Member]

Narender,

Check report EXAMPLE_PNP_GET_PAYROLL..it will help u to understand using LDB...it also fetches the output you need...

[Former Member]

thanks