topic Replace a query with a function module in Application Development and Automation Discussions

Replace a query with a function module

Former Member — Mon, 14 May 2007 04:32:00 GMT

Hi Genius;

Please let me know how to replace a statement in HR abap as shown below

select single plans into lv_plans from pa0001 where

pernr = obj_tab-objid and

begda <= sy-datum and

endda >= sy-datum.

with a function module.

I will rewrds good points, please respond.

Former Member — Mon, 14 May 2007 04:35:57 GMT

Hi Rahul,

HR_READ_INFOTYPE suits your requirement.

Regards,

Younus.

Reward Helpful Answers!!!!!

Former Member — Mon, 14 May 2007 06:09:31 GMT

data : itab like table lines of pa0001 .

call function module HR_READ_INFOTYPE,

give

import parameters

pernr ,

begda ,

endda , infotype as 0001, etc .

output will in table format , so

give here in infty_tab = itab .

so that the itab will consist of all fields data from the infotype 0001 you can use your data from the itab.

Regards,

Girish

Former Member — Mon, 14 May 2007 07:07:20 GMT

Hi Rahul

Goto function builder and call function module HR_READ_INFOTYPE,

which has,

report name =' '

import parameters

fieldname = ' '

begin date = ' '

end date = ' '.

execute the query,it wil surely help you out.

REWARD IT PLEASE...!!