topic Re: Rt table in Application Development and Automation Discussions

Rt table

Former Member — Wed, 01 Oct 2008 04:54:00 GMT

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.

Re: Rt table

Former Member — Wed, 01 Oct 2008 05:03:05 GMT

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.

Re: Rt table

Former Member — Wed, 01 Oct 2008 05:12:41 GMT

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.

Re: Rt table

MilindMungaji — Wed, 01 Oct 2008 05:15:05 GMT

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

Re: Rt table

Former Member — Wed, 01 Oct 2008 05:22:27 GMT

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

Re: Rt table

Former Member — Wed, 01 Oct 2008 05:26:05 GMT

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.

Re: Rt table

Former Member — Wed, 01 Oct 2008 05:42:28 GMT

Narender,

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

Re: Rt table

Former Member — Wed, 01 Oct 2008 10:16:21 GMT

thanks