Skip to Content
0
Former Member
Jan 08, 2008 at 07:08 PM

FM extraction -Filtering -Performance issue

20 Views

Hi,

I have FM which givee me history of users who executed t-codes.I don't want to read all data and then filter.Instead I want to it be filtered (Only 3 usernames) in the FM extraction itself.

This because it will take a lot of time and performance is effecting.

Any ideas?

call function 'SAPWL_STATREC_DIRECT_READ'

exporting

read_start_date = fdat

read_start_time = ftim

read_end_date = tdat

read_end_time = ttim

read_client = cli

  • READ_USERNAME = S_UNAME-LOW

importing

normal_records = normal_records_tbl.

if sy-subrc <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

out_data[] = normal_records_tbl[].

append out_data.

Rgds

Praveen