2006 Aug 22 9:32 AM
Hi all,
I have a task - i have to use "SELECT-OPTIONS of one program into select statements of another program, Please solve my problem.
Thanks in advance
Ranjith
2006 Aug 22 9:52 AM
Hi Ranjith,
here an example with two little Reports:
REPORT ZGRO_TEST.
*
TABLES: MARA.
*
SELECT-OPTIONS: S_MATNR FOR MARA-MATNR.
*
START-OF-SELECTION.
*
SUBMIT ZGRO_TESTT
WITH S_MATNR IN S_MATNR
AND RETURN.
*
END-OF-SELECTION.
REPORT ZGRO_TESTT.
*
TABLES: MARA.
*
SELECT-OPTIONS: S_MATNR FOR MARA-MATNR NO-DISPLAY.
*
START-OF-SELECTION.
*
BREAK-POINT.
*
SELECT * FROM MARA WHERE MATNR IN S_MATNR.
*
WRITE: / MARA-MATNR.
*
ENDSELECT.
*
END-OF-SELECTION.
zgro_test calls zgro_testt with the select-options.
Regards, Dieter
Hi all,
I have a task - i have to use "SELECT-OPTIONS of one program into select statements of another program, Please solve my problem.
Thanks in advance
Ranjith
2006 Aug 22 9:33 AM
Hi Ranjit,
Try using SUBMIT option with the addition SELTAB.
You can also pass the select options along with the SUBMIT statement. Take a look at the help.
Code used to populate 'select-options' & execute report
DATA: seltab type table of rsparams,
seltab_wa like line of seltab.
seltab_wa-selname = 'PNPPERNR'.
seltab_wa-sign = 'I'.
seltab_wa-option = 'EQ'.
* load each personnel number accessed from the structure into
* parameters to be used in the report
loop at pnppernr.
seltab_wa-low = pnppernr-low.
append seltab_wa to seltab.
endloop.
SUBMIT zreport with selection-table seltab
via selection-screen.
Cheers
VJ
Message was edited by: Vijayendra Rao
2006 Aug 22 9:33 AM
Hello Ranjith,
Use <b>SUBMIT</b> statement
If useful reward.
Vasanth
2006 Aug 22 9:35 AM
2006 Aug 22 9:44 AM
Hi Ranjit,
Use SUBMIT statement in this way ..
SUBMIT ztab with selection-table selecttab
via selection-screen.Regards,
Santosh
2006 Aug 22 9:52 AM
Hi Ranjith,
here an example with two little Reports:
REPORT ZGRO_TEST.
*
TABLES: MARA.
*
SELECT-OPTIONS: S_MATNR FOR MARA-MATNR.
*
START-OF-SELECTION.
*
SUBMIT ZGRO_TESTT
WITH S_MATNR IN S_MATNR
AND RETURN.
*
END-OF-SELECTION.
REPORT ZGRO_TESTT.
*
TABLES: MARA.
*
SELECT-OPTIONS: S_MATNR FOR MARA-MATNR NO-DISPLAY.
*
START-OF-SELECTION.
*
BREAK-POINT.
*
SELECT * FROM MARA WHERE MATNR IN S_MATNR.
*
WRITE: / MARA-MATNR.
*
ENDSELECT.
*
END-OF-SELECTION.
zgro_test calls zgro_testt with the select-options.
Regards, Dieter
2006 Aug 23 3:05 PM
2006 Aug 23 3:24 PM
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |