04-22-2008 11:38 AM
Hi All,
I have a report , for that report i need to the functionality i.e.,
1. when the report is executed and the output is exported to local file it should be password protected.
the password should be the SAP user id of that user(by whom the report is exported).
(in simple words when the user wants the output in local file, while saving the output to local file the system should ask the SAP USER ID AND PASSWORD)
its urgent.
thanks in advance
04-22-2008 11:47 AM
hi this is a simple report with the user id and password..
SELECTION-SCREEN BEGIN OF SCREEN 500 AS WINDOW TITLE title.
.
Parameters: p_name like sy-uname,
p_pas like sy-uname lower case.
SELECTION-SCREEN skip 1.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT 2(70) text-001.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF SCREEN 500.
CALL SELECTION-SCREEN '0500' STARTING AT 10 10 ending at 70 14.
data: begin of it_user occurs 0,
name like sy-uname,
password like sy-uname,
end of it_user.
it_user-name = 'venkat'.
it_user-password = 'venkat'.
append it_user.
it_user-name = 'srinivas'.
it_user-password = 'srinivas'.
append it_user.
it_user-name = 'preethi'.
it_user-password = 'preethi'.
append it_user.
it_user-name = 'vidya'.
it_user-password = 'vidya'.
append it_user.
AT SELECTION-SCREEN OUTPUT.
loop at screen.
check screen-name eq 'P_PAS'.
move: 1 to screen-invisible.
modify screen.
endloop.
start-of-selection.
if p_pas = 'venkat'.
write:/ 'this is working'.
endif.
regards,
venkat.
04-22-2008 11:53 AM
hi venkat,
i dont know which user is going to use that report than how can i give the name and password in report.
it_user-name = 'venkat'.
it_user-password = 'venkat'.
append it_user.
it_user-name = 'srinivas'.
it_user-password = 'srinivas'.
append it_user.
04-22-2008 11:57 AM
hi use the sy-uname like this....
.
Parameters: p_name like sy-uname,
p_pas like sy-uname lower case.
AT SELECTION-SCREEN OUTPUT.
loop at screen.
check screen-name eq 'P_PAS'.
move: 1 to screen-invisible.
modify screen.
endloop.
start-of-selection.
if p_name = sy-uname.
write:/ 'this is working'.
endif.
regards,
venkat.
04-22-2008 12:14 PM
hi venkat
i am getting the screen for asking username and password, but even though if iam not giving the name and password also its showing the output.
could you please help me , compulsory we should give username and password then only it should display the output and download to local file.
thanks
04-22-2008 12:20 PM
Hi Kiran,
Have you tried with function module SUSR_LOGIN_CHECK_RFC ?
First call the fm SSFH_PASSWORD_PROMPT it will give a popup window like sap user and password,and SUSR_LOGIN_CHECK_RFC fm validate the password that the user is valid one or not?
Regards
Kiran Sure
04-22-2008 12:48 PM
hi kiran sure,
actually my problem is
after executing the report the output comes, while downloading to local file it should ask for SAP user id and password.
04-22-2008 1:04 PM
hi
the user has already logge in the system
then why before writing to the local server
it willl again ask for the user pass...
please write your problem clearly