‎2006 Nov 20 1:14 PM
Hi all
I have a report which has several input fields. One among them is ID.
I have to read all values of this field ID from a database table and pass it as a variant to this report.
How do I automate this process ? Will changing variant FM's help ?
Regards
Somnath
‎2006 Nov 20 1:22 PM
I ASSUME THAT THE id FIELD IS A SELECT-OPTION.
build a ranges table with all the id values in it.
ranges: r_id for <table>-<field>.
loop at itab_ids.
r_id-low = itab_ids-id.
r_id-sign = 'I'.
r_id-option = 'EQ'.
append r_id.
clear r_id.
endloop.
submit <called program name> with s_id in r_id. "s_id is the select option in the called program .
Regards,
ravi
‎2006 Nov 20 1:31 PM
yes it indeed is a select option ....... will try this option ....thank you for ur response.
I have one more question though which you might be able to show a pointer and that is the report I am talking above is a generated report through a FM RSDRD_DELETE_FACTS. How do I get this report name ....because it keeps changing , will FM like 'JOB_SUBMIT' help ?
regards
Somnath
‎2006 Nov 20 1:45 PM
Hi Somnath,
If it is a dynamically generated program name, then you can just say:
submit ( prog_name ) with...." where prog_name contains the name of the generated report.
Regards,
ravi
‎2006 Nov 20 1:58 PM
HI,
I think u just need to declare a select-option and then leave it blank and use it in ur select statement to achieve what you are looking for.
santhosh.