hr report

[Former Member]

I am giving complete details about my object so that we can help me.

Tables: PA0000,HRP1000.

they given total 200 fields i have to display using ALV

in the OUTPUT the output should not display on screen instead of screen the total output should display on CSV file format.

This is the report which i need to develop on next 3 days so pls send the programs which allready written.

some of the fields are follow:

Previous Year Base Salary

In Current Position since April 1

Range Minimum

Control Point

Range Maximum

Annual Bonus Eligible

Annual Bonus

Target Annual Bonus - % of Base

LTIP Plan Type

Grant Date

Number of Shares/Units Granted

Exercise/Grant Price/Share Unit Value

[Former Member]

Hi Lakshmi,

U r telling that u need to display the output in ALV fomat as well as .CSV format. Which one do u want exactly.

Regards,

Jay..

[Former Member]

Hi Lakshmi,

U r telling that u need to display the output in ALV fomat as well as .CSV file format. Which one do u want exactly.

Regards,

Jay..

[amit_khare]

Hi Laxmi,

First and the most important thing, the field you have mention comes form almost different Infotypes.

So you have to include many infotypes for that.

Secondly, its no big deal to pass data to ALV & CSV format just need the code for that actually, its an interface and on the selection screen you have to given an option of test display which when ticked should display the data in the ALV format otherwise download to CSV format.

You require a code like this to down load the file to applications server

PARAMETERS: P_XT LIKE RLGRAP-FILENAME.

P_XT = '/interfaces/hr/out/BONMRAEX.txt'.

OPEN DATASET P_XT FOR OUTPUT IN TEXT MODE.

ENDAT.

TRANSFER i_CARMEN TO P_XT.

AT LAST.

CLOSE DATASET P_XT.

ENDAT.

for ALV you may refer to different ALV examples.

Also for getting the data use Logocal Database PNP and then GET PERNR this will fill all the infotypes with the selected employee data.

Trnsfrr it to internal table .

E.g.

Get Pernr.

RP_PROVIDE_FROM_LAST P0001 SPACE PN-BEGDA PN-ENDDA

i_tab-pernr = p0000-pernr.

i_tab-massn = p0000-massn.

Hope this will help you.

Regards,

Amit