SUBMIT <Report Name> TO SAP-SPOOL WITHOUT SPOOL DYNPRO
WITH <Parameter_1> EQ <value> AND RETURN.
If it is a select option use IN instead of EQ (as we do in ranges)
There are many variations with submit program so just Press F1 and see what suits best in your case.
This will submit the output into the spool. The spool name will be - 1st 9 characters of your report name + 1st 3 characters of ur user name (who is executing the program)
This is the convention followed but in ur case I would advice u to go and check in table TSP01 where the spool no. are stored.
From this table u have to select the latest spool created (RQIDENT) and then pass this spool no to FM - RSPO_RETURN_ABAP_SPOOLJOB.
SELECT MAX( RQIDENT ) INTO V_SPOOL_NO FROM TSP01
WHERE RQ2NAME = <SPOOL_NAME>
AND RQOWNER = SY-UNAME.
******
CALL FUNCTION 'RSPO_RETURN_ABAP_SPOOLJOB'
EXPORTING
RQIDENT = V_SPOOL_NO
TABLES
BUFFER = IT_SPOOL
EXCEPTIONS
NO_SUCH_JOB = 1
NOT_ABAP_LIST = 2
JOB_CONTAINS_NO_DATA = 3
SELECTION_EMPTY = 4
NO_PERMISSION = 5
CAN_NOT_ACCESS = 6
READ_ERROR = 7
OTHERS = 8.
******************************************
this will pass u the spool into a internal table.
Bluesky
